public int GetWagePersonCount(WageRegisterModel model) { //2:判断是否需要更新WGJG01表 var query = (from s in db.Set <WGJG02>() join o in db.Set <WGJG02>() on s.WGJG01RowID equals o.WGJG01RowID where !s.WGJG0211.Equals("1") && o.PersonID.Equals(model.personid) && o.PersonSalaryID.Equals(model.personsalaryid) select s). ToList(); return((query != null) ? query.Count : 0); }
public WGJG02 GetFirstCheckInUser(WageRegisterModel model) { StringBuilder sb = new StringBuilder(); sb.Append( string.Format( @"SELECT TOP 1 * FROM dbo.WGJG02 WHERE PersonID IN (SELECT PersonID FROM dbo.A01) AND WGJG01RowID IN(SELECT WGJG01RowID FROM dbo.WGJG02 WHERE PersonID=@PersonID AND PersonSalaryID=@PersonSalaryID) AND WGJG0211='1' ORDER BY dbo.WGJG02.WGJG0212 ASC ")); Dictionary <string, object> dis = new Dictionary <string, object>(); dis.Add("@PersonID", model.personid); dis.Add("@PersonSalaryID", model.personsalaryid); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(dis)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <WGJG02>(dt).FirstOrDefault()); }
public object WageRegister(WageRegisterModel model) { if (!ModelState.IsValid) { return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.参数异常.ToString(), null)); } string mark = operateContext.bllSession.WGJG02.EditAffirmWageByPerson(model); if (!string.IsNullOrEmpty(mark)) { Dictionary <string, string> result = new Dictionary <string, string>(); result.Add("salarysignid", mark); return(operateContext.RedirectWebApi(WebResultCode.Ok, GlobalConstant.操作成功.ToString(), result)); } return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.操作失败.ToString(), null)); }
public bool EditAffirmWageByPerson(WageRegisterModel model) { DateTime de; if (!DateTime.TryParse(model.signtime, out de)) { return(false); } WGJG02 wg1 = Select(s => s.PersonID == model.personid && s.PersonSalaryID == model.personsalaryid && s.WGJG0211 == "1").FirstOrDefault(); if (null != wg1) { return(true); } //1:更新是否发放,签到时间,发放时间 int mark = Modify(new WGJG02() { WGJG0211 = "1", WGJG0201 = de, WGJG0212 = de }, s => s.PersonID == model.personid && s.PersonSalaryID == model.personsalaryid, "WGJG0211", "WGJG0201", "WGJG0212"); return(mark > 0 ? true : false); }