public int AddOverTime(OverTimeVoucher overtime, ref string errMsg)
{
ccode = voucherService.GetNewCode("TM03", "JB");
int record = Convert.ToInt32(overTimeService.GetNewRecord());
List <OverTimeVoucherBody> bodyList = overtime.body;
overtime.head.VoucherID = ccode;
overtime.head.VoucherCode = ccode;
overtime.head.cExamineApproveType = 2;
overtime.head.bAuditFlag = 0;
overtime.head.cStatus = 0;
overtime.head.iRecordId = record + 1;
if (overtime.head.iComputeType == "3")
{
overtime.head.dJbDate = Convert.ToDateTime(bodyList[0].dBeginTime).ToString("yyyy-MM-dd");
overtime.head.dBeginTime = Convert.ToDateTime(bodyList[0].dBeginTime).TimeOfDay.ToString();
overtime.head.dEndTime = Convert.ToDateTime(bodyList[0].dEndTime).TimeOfDay.ToString();
overtime.head.dDutyTime = Convert.ToDateTime(bodyList[0].dBeginTime).TimeOfDay.ToString();
overtime.head.dOffTime = Convert.ToDateTime(bodyList[0].dEndTime).TimeOfDay.ToString();
overtime.head.iBeginCardAhead = 150;
overtime.head.iEndCardForward = 150;
overtime.head.nManHours = (Convert.ToDateTime(bodyList[0].dEndTime) - Convert.ToDateTime(bodyList[0].dBeginTime)).Hours.ToString();
}
else if (overtime.head.iComputeType == "1")
{
overtime.head.dJbDate = bodyList[0].dJbDate;
overtime.head.dBeginTime = "";
overtime.head.dEndTime = "";
overtime.head.dDutyTime = "";
overtime.head.dOffTime = "";
overtime.head.iBeginCardAhead = 0;
overtime.head.iEndCardForward = 0;
overtime.head.nManHours = bodyList[0].nManHours;
}
overtime.head.dCreatTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd");
overtime.head.vReason = bodyList[0].vReason;
overtime.head.vRemark = bodyList[0].vRemark;
for (int q = 0; q < bodyList.Count; q++)
{
string person = bodyList[q].cPsn_Num;
HRPersonInfo info = voucherService.getPersonInfo(person, ref errMsg);
overtime.head.cDept_num = info.depCode;
bodyList[q].cCreator = overtime.head.cCreator;
bodyList[q].cCreatorNum = overtime.head.cCreatorNum;
bodyList[q].JobNumber = info.jobNum;
bodyList[q].VoucherID = ccode;
bodyList[q].uRecordId = Guid.NewGuid().ToString();
bodyList[q].iComputeType = overtime.head.iComputeType;
if (overtime.head.iComputeType == "3")
{
bodyList[q].dDutyTime = Convert.ToDateTime(bodyList[q].dBeginTime).TimeOfDay.ToString();
bodyList[q].dOffTime = Convert.ToDateTime(bodyList[q].dEndTime).TimeOfDay.ToString();
bodyList[q].dJbDate = Convert.ToDateTime(bodyList[q].dBeginTime).ToString("yyy-MM-dd");
bodyList[q].nOvertimeHours = (Convert.ToDateTime(bodyList[q].dEndTime) - Convert.ToDateTime(bodyList[q].dBeginTime)).TotalHours.ToString();
bodyList[q].nManHours = (Convert.ToDateTime(bodyList[q].dEndTime) - Convert.ToDateTime(bodyList[q].dBeginTime)).TotalHours.ToString();
bodyList[q].nSubOVTime = "0";
bodyList[q].dBeginTime = Convert.ToDateTime(bodyList[q].dBeginTime).AddMinutes(-150).TimeOfDay.ToString();
bodyList[q].dEndTime = Convert.ToDateTime(bodyList[q].dEndTime).AddMinutes(150).TimeOfDay.ToString();
bodyList[q].cTimeUseless1 = overtime.head.cTimeUseless1;
bodyList[q].cTimeUseless2 = overtime.head.cTimeUseless2;
}
else if (overtime.head.iComputeType == "1")
{
bodyList[q].dJbDate = bodyList[q].dJbDate;
bodyList[q].dBeginTime = "";
bodyList[q].dEndTime = "";
bodyList[q].dDutyTime = "";
bodyList[q].dOffTime = "";
bodyList[q].nSubOVTime = "0";
bodyList[q].nManHours = bodyList[q].nManHours;
bodyList[q].nOvertimeHours = bodyList[q].nManHours;
}
bodyList[q].dCreatTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd");
bodyList[q].uOverTimeCode = Guid.NewGuid().ToString();
bodyList[q].cExamineApproveType = 2;
bodyList[q].bAuditFlag = 0;
bodyList[q].cStatus = 0;
bodyList[q].iRowNo = q;
bodyList[q].vJbCode = overtime.head.vJbCode;
bodyList[q].rFreeCardMode = overtime.head.rFreeCardMode;
bodyList[q].rDealType = overtime.head.rDealType;
}
string headSql = overTimeService.getHeadSql(overtime.head);
string bodySql = overTimeService.getBodySql(overtime.body);
int a = voucherService.excuteSql(headSql);
int b = 0;
int c = 0;
if (a == 1)
{
b = voucherService.excuteSql(bodySql);
}
if (b >= 1)
{
c = voucherService.UpdateMaxCode("TM03");
}
int i = a + b + c;
return(i);
}
public HttpResponseMessage AddOverTime(string token, string json)
{
string errMsg = "";
ReturnMessage msg = new ReturnMessage();
ReceiveLog receive = new ReceiveLog();
receive.uuid = Guid.NewGuid();
receive.receiveData = json;
receive.interfaceCode = "OverTime";
receive.interfaceDesc = "加班单新增";
receive.op = "add";
try
{
vouMag = (VoucherManager)HttpContext.Current.Application.Get(token);
if (vouMag == null)
{
msg.Success = false;
msg.Msg = "参数token无效或已过期";
msg.Code = 500;
}
else
{
ReceiveLogManager logManager = new ReceiveLogManager(vouMag.UFDataConnstringForNet);
logManager.AddReceiveLog(receive, ref errMsg);
OverTimeManager overTimeMag = new OverTimeManager(vouMag.UFDataConnstringForNet);
OverTimeVoucher overTime = (OverTimeVoucher)JsonConvert.DeserializeObject(json, typeof(OverTimeVoucher));
int i = overTimeMag.AddOverTime(overTime, ref errMsg);
if (i >= 3)
{
//msg.Success = true;
//dynamic c = new { code = overTimeMag.ccode };
//msg.Data = JsonConvert.SerializeObject(c);
//msg.Code = 200;
//msg.Msg = "新增成功";
int q = overTimeMag.auditOverTime(overTimeMag.ccode, overTime.head, ref errMsg);
if (q >= 2)
{
msg.Success = true;
msg.Code = 200;
dynamic c = new { code = overTimeMag.ccode };
msg.Data = JsonConvert.SerializeObject(c);
msg.Msg = "审核成功";
}
else
{
msg.Success = false;
msg.Code = 500;
msg.Msg = "审核失败:" + errMsg;
}
}
else
{
msg.Success = false;
msg.Code = 500;
msg.Msg = "新增失败" + errMsg;
}
receive = logManager.getReturnDesc(receive, msg);
logManager.UpdateReceiveLog(receive, ref errMsg);
}
HttpContext.Current.Application.Remove(vouMag.GetGUID);
string str = msg.ToJson();
return(new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
});
}
catch (Exception ex)
{
msg.Success = false;
msg.Code = 500;
msg.Msg = ex.Message.ToString();
string str = msg.ToJson();
return(new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
});
}
}
