//更新自定义字段代码
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 = "";
}
}
