private string GetSavePackToolMemberSQL(string BillTableRecGuid)
{
string sUpdateSQL = "";
for (int i = 0; i < dlList.Items.Count; i++)
{
SalaryControl.SalaryEdit da = (SalaryControl.SalaryEdit)dlList.Items[i].FindControl("SalaryEdit2");
sUpdateSQL += da.GetUpdateSQL;
}
return(sUpdateSQL);
}
private string GetSaveNewFieldValues(string BillTableRecGuid)
{
string sUpdateSQL = "";
for (int i = 0; i < dlList.Items.Count; i++)
{
SalaryControl.SalaryEdit da = (SalaryControl.SalaryEdit)dlList.Items[i].FindControl("SalaryEdit2");
sUpdateSQL += "," + da.GetNewFieldValue;
}
return(sUpdateSQL);
}
protected void BindPageData()
{
string _Years = "";
if (_UserSalaryID > 0)
{
SqlDataReader sdr = SysClass.SysUserSalary.GetSingleUserSalaryByReader(_UserSalaryID);
if (sdr.Read())
{
_Years = sdr["SalaryYears"].ToString();
txtUserSalaryYears.Text = sdr["SalaryYears"].ToString();
txtUserSalaryOpCode.Text = sdr["OpCode"].ToString();
txtUserSalaryOpName.Text = sdr["OpName"].ToString();
string sSQLWhere = "";
CyxPack.CommonOperation.DataBinder.BindDataListData(dlList, SysClass.SysUserSalary.GetUserSalaryFieldsLstByReader(txtUserSalaryYears.Text));
for (int i = 0; i < dlList.Items.Count; i++)
{
SalaryControl.SalaryEdit da = (SalaryControl.SalaryEdit)dlList.Items[i].FindControl("SalaryEdit2");
da.UserFieldValue = sdr[da.UserFieldName].ToString();
if (sdr[da.UserFieldName].ToString().Length == 0)
{
sSQLWhere += " And a.FieldName<>'" + da.UserFieldName + "'";
}
else if (sdr[da.UserFieldName].ToString() == "0.00")
{
sSQLWhere += " And a.FieldName<>'" + da.UserFieldName + "'";
}
}
CyxPack.CommonOperation.DataBinder.BindDataListData(dlList, SysClass.SysUserSalary.GetUserSalaryFieldsLstByReader(txtUserSalaryYears.Text, sdr["SalaryRecGuid"].ToString(), sSQLWhere));
for (int i = 0; i < dlList.Items.Count; i++)
{
SalaryControl.SalaryEdit da = (SalaryControl.SalaryEdit)dlList.Items[i].FindControl("SalaryEdit2");
da.UserFieldValue = sdr[da.UserFieldName].ToString();
}
}
sdr.Close();
}
else
{
}
txtUserSalaryYears.Enabled = _UserSalaryID <= 0;
}
