linq To SQl之多表关联修改

protected void gvUser_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
        {
            //UserId  -- User
            string strUserId = e.Keys["ID"].ToString();
            int endIndex = strUserId.IndexOf("_");
            strUserId = strUserId.Substring(0, endIndex);
            int id = Convert.ToInt32(strUserId);

            //ID -- UserGroupUser
            string strId = e.Keys["ID"].ToString();
            int startIndex = strId.IndexOf("_");
            strId = strId.Substring(startIndex + 1);
            int intUserId = Convert.ToInt32(strId);

            //ASPxGridView中获得的控件
            ASPxTextBox currentText = ((ASPxGridView)sender).FindEditFormTemplateControl("txtUserName") as ASPxTextBox;
            ASPxTextBox UserPWD = ((ASPxGridView)sender).FindEditFormTemplateControl("txtUserPWD") as ASPxTextBox;
            ASPxComboBox currentBox = ((ASPxGridView)sender).FindEditFormTemplateControl("cboUserGroup") as ASPxComboBox;
 
            //查询本条的UserGroupUser表记录 
            Casagroup.Entities.UserGroupUser userGroupUser = eDataContext.UserGroupUser.First(c => c.ID == id);
            //此 Value 为 ASPxComboBox的属性，而非页面绑定的Value='<%# Bind("UserGroupName") %>'， 是专用来显示相应用户组的
            string v = (string)currentBox.Value;
            userGroupUser.UserGroupID = int.Parse(v);
            //查询本条的User表记录
            Casagroup.Entities.User user = eDataContext.User.First(c => c.UserID == intUserId);
            user.UserName = currentText.Text.Trim();          
            user.UserPWD = _common.EncryptToMD5(UserPWD.Text.Trim());          
            //同步修改
            eDataContext.SubmitChanges();
            e.Cancel = true;
            this.gvUser.CancelEdit();
            BindUserInfo();
        }