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