public int auditErrand(string ccode, ErrandVoucherHead head, ref string errMsg)
{
int i = errandService.auditHead(ccode, head, ref errMsg);
if (i == 1)
{
int q = errandService.auditBody(ccode, head, ref errMsg);
i = i + q;
}
return(i);
}
public int auditBody(string ccode, ErrandVoucherHead head, ref string errMsg)
{
try
{
string sql = "update hr_tm_Errand set bAuditFlag=1,cStatus='2',cAuditor = '" + head.cAuditBy + "', dAuditTime = convert(nvarchar(19), GETDATE(), 120) where cVoucherId = '" + ccode + "' ";
return(db.ExecuteSql(sql));
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
throw;
}
}
public string getHeadSql(ErrandVoucherHead head)
{
string sql = db.InsertSql <ErrandVoucherHead>(head, "hr_tm_ErrandMain");
return(sql);
}
