//更新自定义字段代码 private string GetSaveCustomFieldSQL(string BillTableRecGuid) { string sUpdateSQL = " if not Exists(Select 1 From SysUserExt_Info Where UserID=" + SysClass.SysGlobal.GetCurrentUserID().ToString() + " and UserID > 0) "; sUpdateSQL += " begin"; sUpdateSQL += " Insert Into SysUserExt_Info (UserID, " + GetSaveNewFields() + ") (Select ID, " + GetSaveNewFieldValues() + " From SysUser_Info Where Guid='" + BillTableRecGuid + "');"; sUpdateSQL += " end else begin"; sUpdateSQL += " Update SysUserExt_Info Set "; for (int i = 0; i < dlList.Items.Count; i++) { SalaryControl.CustomExtEdit da = (SalaryControl.CustomExtEdit)dlList.Items[i].FindControl("WorklogExtEdit1"); if (da.UserFieldName.Length > 0) { if (i > 0) { sUpdateSQL += ","; } sUpdateSQL += da.GetUpdateSQL; } } sUpdateSQL += " Where UserID=" + SysClass.SysGlobal.GetCurrentUserID().ToString() + ";"; sUpdateSQL += " end;"; return(sUpdateSQL); }
private void BindPageData() { //自定义字段 DataSet ds = SysClass.SysCustomField.GetCustomFieldLstByDataset(" And TableNo='UserInfo' And IsReadOnly=0"); if (ds.Tables[0].Rows.Count % 2 == 1) { DataRow OldRow = ds.Tables[0].NewRow(); ds.Tables[0].Rows.Add(OldRow); } CyxPack.CommonOperation.DataBinder.BindDataListData(dlList, ds); SqlDataReader sdr = SysClass.SysUser.GetUserInfoByReader(SysClass.SysGlobal.GetCurrentUserID()); if (sdr.Read()) { ltUserName.Text = sdr["OpCode"].ToString(); txtOpName.Text = sdr["OpName"].ToString(); for (int i = 0; i < dlList.Items.Count; i++) { SalaryControl.CustomExtEdit da = (SalaryControl.CustomExtEdit)dlList.Items[i].FindControl("WorklogExtEdit1"); if (da.UserFieldName.Length > 0) { da.UserFieldValue = sdr[da.UserFieldName].ToString(); } } } sdr.Close(); }
//新增自定义字段值列表 private string GetSaveNewFieldValues() { string sUpdateSQL = ""; for (int i = 0; i < dlList.Items.Count; i++) { SalaryControl.CustomExtEdit da = (SalaryControl.CustomExtEdit)dlList.Items[i].FindControl("WorklogExtEdit1"); if (i > 0) { sUpdateSQL += ","; } sUpdateSQL += da.GetNewFieldValue; } return(sUpdateSQL); }
private void BindPageData() { //自定义字段 CyxPack.CommonOperation.DataBinder.BindDataListData(dlList, SysClass.SysCustomField.GetCustomFieldLstByReader(" And TableNo='UserInfo'")); // LoadChildNodes(0, 0); SysClass.SysRole.FullToRoleLst(ddcRole); if (_UserID > 0) { rvfPassword.Enabled = false; rfvConfirmPassword.Enabled = false; cvNewPasswordCompare.Enabled = false; trPassword.Style.Add("display", "none"); SqlDataReader sdr = SysClass.SysUser.GetSingleUserByReader(_UserID); if (sdr.Read()) { if (ddlOrganID.Items.FindByValue(sdr["OrganID"].ToString()) != null) { ddlOrganID.SelectedValue = sdr["OrganID"].ToString(); } txtOpCode.Text = sdr["OpCode"].ToString(); txtOpName.Text = sdr["OpName"].ToString(); txtPosition.Text = sdr["Position"].ToString(); txtPlace.Text = sdr["Place"].ToString(); rblSex.SelectedValue = sdr["Sex"].ToString(); txtPhone.Text = sdr["Phone"].ToString(); txtTelNo.Text = sdr["TelNo"].ToString(); txtAddress.Text = sdr["Address"].ToString(); txtZipCode.Text = sdr["ZipCode"].ToString(); txtUserDesc.Text = sdr["UserDesc"].ToString(); txtIDNumber.Text = sdr["IDNumber"].ToString(); if (rbIsCanLogin.Items.FindByValue(sdr["IsCanLogin"].ToString()) != null) { rbIsCanLogin.SelectedValue = sdr["IsCanLogin"].ToString(); } } for (int i = 0; i < dlList.Items.Count; i++) { SalaryControl.CustomExtEdit da = (SalaryControl.CustomExtEdit)dlList.Items[i].FindControl("WorklogExtEdit1"); da.UserFieldValue = sdr[da.UserFieldName].ToString(); } sdr.Close(); LoadUserRoles(); } else { if (ddlOrganID.Items.FindByValue(_OrganID.ToString()) != null) { ddlOrganID.SelectedValue = _OrganID.ToString(); } txtOpCode.Text = ""; txtOpName.Text = ""; txtPassword.Text = ""; txtConfirmPassword.Text = ""; } }