//新增自定义字段值列表
private string GetSaveNewFieldValues()
{
string sUpdateSQL = "";
for (int i = 0; i < dlList.Items.Count; i++)
{
SalaryControl.CustomExtView da = (SalaryControl.CustomExtView)dlList.Items[i].FindControl("WorklogExtEdit1");
if (i > 0)
{
sUpdateSQL += ",";
}
sUpdateSQL += da.GetNewFieldValue;
}
return(sUpdateSQL);
}
//更新自定义字段代码
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.CustomExtView da = (SalaryControl.CustomExtView)dlList.Items[i].FindControl("WorklogExtEdit1");
if (i > 0)
{
sUpdateSQL += ",";
}
sUpdateSQL += da.GetUpdateSQL;
}
sUpdateSQL += " Where UserID=" + SysClass.SysGlobal.GetCurrentUserID().ToString() + ";";
sUpdateSQL += " end;";
return(sUpdateSQL);
}
private void BindPageData()
{
if (!CyxPack.UserCommonOperation.UserCommonOperation.PurviewByID(724, ""))
{
ulNav.Attributes.Add("style", "display:none");
}
DataSet ds = SysClass.SysCustomField.GetCustomFieldLstByDataset(" And TableNo='UserInfo' And IsReadOnly=1");
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.CustomExtView da = (SalaryControl.CustomExtView)dlList.Items[i].FindControl("WorklogExtEdit1");
if (da.UserFieldName.Length > 0)
{
da.UserFieldValue = sdr[da.UserFieldName].ToString();
}
}
}
sdr.Close();
}
