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"); }