public int AddErrand(ErrandVoucher errand, ref string errMsg)
{
ccode = voucherService.GetNewCode("TM02", "CC");
List <ErrandVoucherBody> bodyList = errand.body;
errand.head.cVoucherId = ccode;
errand.head.cVoucherCode = ccode;
errand.head.cCode = "TM140";
errand.head.cExamineApproveType = 2;
errand.head.cStatus = "0";
errand.head.pk_hr_tm_ErrandMain = Guid.NewGuid().ToString();
errand.head.dCreateOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd");
errand.head.vReason = bodyList[0].vReason;
errand.head.dBeginDate = bodyList[0].dBeginDate;
errand.head.dEndDate = bodyList[0].dEndDate;
for (int q = 0; q < bodyList.Count; q++)
{
string person = bodyList[q].cPsn_Num;
HRPersonInfo info = voucherService.getPersonInfo(person, ref errMsg);
bodyList[q].cDepCode = info.depCode;
bodyList[q].cDepName = info.depName;
errand.head.cDepName = info.depName;
errand.head.cDepCode = info.depCode;
bodyList[q].cCreator = errand.head.cCreateBy;
//bodyList[q].pk_hr_tm_Errand = Guid.NewGuid().ToString();
bodyList[q].cVoucherId = ccode;
bodyList[q].cExamineApproveType = "2";
bodyList[q].cSysBarCode = "|" + q.ToString();
bodyList[q].bAuditFlag = false;
bodyList[q].cStatus = "0";
bodyList[q].cErrandType = errand.head.cErrandType;
}
string headSql = errandService.getHeadSql(errand.head);
int a = voucherService.excuteSql(headSql);
string bodySql = errandService.getBodySql(errand.body);
int b = 0;
if (a == 1)
{
b = voucherService.excuteSql(bodySql);
}
if (b >= 1)
{
voucherService.UpdateMaxCode("TM02");
}
int i = a + b;
return(i);
}
public int AddTransfer(TransferRegister transfer, ref string errMsg)
{
ccode = voucherService.GetNewCode("HM701", "DD");
transfer.cVoucherId = ccode;
transfer.bAuditFlag = 0;
transfer.cstate = "0";
transfer.PK_HR_HI_TransferRegister = Guid.NewGuid().ToString();
transfer.csysbarcode = "||HM701|" + ccode;
transfer.dCreateOn = DateTime.Now;
string headSql = transferService.getSql(transfer);
int a = voucherService.excuteSql(headSql);
if (a >= 1)
{
voucherService.UpdateMaxCode("HM701");
}
return(a);
}
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);
}