public int auditOverTime(string ccode, OverTimeVoucherHead head, ref string errMsg)
{
int i = overTimeService.auditHead(ccode, head, ref errMsg);
if (i == 1)
{
int q = overTimeService.auditBody(ccode, head, ref errMsg);
i = i + q;
}
return(i);
}
public int auditBody(string ccode, OverTimeVoucherHead head, ref string errMsg)
{
try
{
string sql = "update hr_tm_OverTimeresult set bAuditFlag=1,cStatus='2',cAuditor = '" + head.cAuditor + "', cAuditorNum = '" + head.cAuditorNum + "', dAuditTime = convert(nvarchar(19), GETDATE(), 120) where VoucherID = '" + ccode + "' and (bAuditFlag<>1 or bAuditFlag is null)";
return(db.ExecuteSql(sql));
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
throw;
}
}
public string getHeadSql(OverTimeVoucherHead head)
{
string sql = db.InsertSql <OverTimeVoucherHead>(head, " HR_TM_OverTimeVoucher ");
return(sql);
}
