public static string GetSalary(string OpCode, string SalaryYears, bool isReadSign)
{
string sWhereSQL = " And a.OpCode='" + OpCode;
if (isReadSign)
{
sWhereSQL += "' And SignStatus=1";
}
else
{
sWhereSQL += "' And SignStatus=0";
}
sWhereSQL += " And a.SalaryYears='" + SalaryYears + "'";
sWhereSQL +=
" And a.SalaryRecGuid in (Select SalaryRecGuid From UserUserImportRec_Info where ApprovalStatus=1)";
DataSet ds = SysUserSalary.GetUserSalaryLstByDataSet(sWhereSQL);
DataToJson(ds.Tables[0]);
return(DataToJson(ds.Tables[0]));
}
public static string GetSalaryDetail(string SalaryID, string SalaryYears)
{
string DetailKey = "";
string DetailValue = "";
string SalaryRecGuid = "";
string result = "";
dictionaryToJson.Clear();
SqlDataReader sdrValue = SysUserSalary.GetSingleUserSalaryByReader(Convert.ToInt32(SalaryID));
if (sdrValue.Read())
{
SalaryRecGuid = sdrValue["SalaryRecGuid"].ToString();
SqlDataReader sdrKey = SysUserSalary.GetUserSalaryFieldsLstByReader(SalaryYears, SalaryRecGuid, "");
result = "{\"DetailResult\": [";
while (sdrKey.Read())
{
string FieldName = sdrKey["FieldName"].ToString();
DetailKey = sdrKey["UserFieldTitle"].ToString();
DetailValue = sdrValue[FieldName].ToString();
dictionaryToJson.Add(DetailKey, DetailValue);
result += DataToJson(dictionaryToJson) + ",";
dictionaryToJson.Clear();
}
if (result.EndsWith("["))
{
result = "";
}
if (result.EndsWith(","))
{
result = result.Substring(0, result.Length - 1);
}
result += "]}";
}
return(result);
}
protected void Button2_Click(object sender, EventArgs e)
{
SysUserSalary.GetWarmingLstByDataSet(" OrganID = 37 And DateDiff(Day, SalaryDate, GetDate()) >= 10");
}
