public int auditVoucher(string ccode, TransferRegister tr, ref string errMsg)
{
try
{
int i = 0;
string sql1 = "update HR_HI_TransferRegister set cstate='2',dAuditOn=convert(nvarchar(19),GETDATE(),120),cAuditBy='" + tr.cAuditBy + "' where cVoucherId ='" + ccode + "'";
int a = db.ExecuteSql(sql1);
string sql2 = "update UPDATE hr_hi_person SET cDept_num = '" + tr.rLaterDepCode + "' where cPsn_Num='" + tr.cPsn_Num + "'";
int b = db.ExecuteSql(sql2);
string sql3 = " INSERT INTO hr_hi_jobInfo( PK_hr_hi_jobInfo, cjobcode ,cDepCode ,cDeptName ,cJobName ,cJobRankCode ,cJobGradeCode ,cDutycode , cDutyName ,\n" +
" cSupPerson ,dbegindate ,denddate ,rDChgType ,rDutyLev ,rholdpostWay ,rhpreason ,vhpAuthUnit ,vAuthorizeDoc ,\n" +
" dremovDate ,rremovMode ,rremovReason ,vrmAuthUnit ,vrmAuthDoc ,vstatus1 ,nstatus2 ,bMaxJobRankCode ,iRecordID ,\n" +
" blastflag ,cPsn_Num , bPartJob,cVoucherId )\n" +
" SELECT TOP 1 NEWID(), ISNULL(hr_hi_jobInfo.cjobcode, '') ,ISNULL(hr_hi_person.cDept_num, '') ,ISNULL(hr_hi_jobInfo.cDeptName, '') ,ISNULL(hr_hi_jobInfo.cJobName, '') ,ISNULL(hr_hi_jobInfo.cJobRankCode, '') ,\n" +
" ISNULL(hr_hi_jobInfo.cJobGradeCode, '') ,ISNULL(hr_hi_jobInfo.cDutycode, '') ,ISNULL(hr_hi_jobInfo.cDutyName, '') ,ISNULL(hr_hi_jobInfo.cSupPerson, '') ,\n" +
" ISNULL(hr_hi_jobInfo.dbegindate, '') ,ISNULL(hr_hi_jobInfo.denddate, '') ,ISNULL(hr_hi_jobInfo.rDChgType, '') ,ISNULL(hr_hi_jobInfo.rDutyLev, '') ,\n" +
" ISNULL(hr_hi_jobInfo.rholdpostWay, '') ,ISNULL(hr_hi_jobInfo.rhpreason, '') ,ISNULL(hr_hi_jobInfo.vhpAuthUnit, '') ,ISNULL(hr_hi_jobInfo.vAuthorizeDoc, '') ,\n" +
" ISNULL(hr_hi_jobInfo.dremovDate, '') ,ISNULL(hr_hi_jobInfo.rremovMode, '') ,ISNULL(hr_hi_jobInfo.rremovReason, '') ,ISNULL(hr_hi_jobInfo.vrmAuthUnit, '') ,\n" +
" ISNULL(hr_hi_jobInfo.vrmAuthDoc, '') ,ISNULL(hr_hi_jobInfo.vstatus1, '') ,ISNULL(hr_hi_jobInfo.nstatus2, 0) ,ISNULL(hr_hi_jobInfo.bMaxJobRankCode, '') ,\n" +
" ( SELECT ISNULL(MAX(iRecordID), 0) + 1 FROM hr_hi_jobInfo WHERE cPsn_Num='" + tr.cPsn_Num + "') ,\n" +
" 1 , hr_hi_person.cPsn_Num , 0 , '" + ccode + "'\n" +
" FROM hr_hi_person\n" +
" LEFT OUTER JOIN hr_hi_jobInfo ON hr_hi_jobInfo.cPsn_Num = hr_hi_person.cPsn_Num\n" +
" AND hr_hi_jobInfo.blastflag = 1\n" +
" AND hr_hi_jobInfo.bPartJob = 0\n" +
" WHERE hr_hi_person.cPsn_Num = '" + tr.cPsn_Num + "' ;";
int c = db.ExecuteSql(sql3);
string sql4 = "update hr_hi_jobinfo set denddate = '" + tr.dTransferDate + "' , cVoucherId = '" + ccode + "',blastflag = 0 WHERE cPsn_Num = '" + tr.cPsn_Num + "' AND blastflag = 1 AND bPartJob = 0\n" +
" AND ISNULL(iRecordID, 0) <> ( SELECT ISNULL(MAX(iRecordID), 0)\n" +
" FROM hr_hi_jobInfo where cPsn_Num = '" + tr.cPsn_Num + "' ) ; ";
int d = db.ExecuteSql(sql4);
string sql5 = "UPDATE hr_hi_jobinfo SET cDepCode='" + tr.rLaterDepCode + "',beginDate='" + tr.dTransferDate + "',depName=(SELECT cdepname from Department where cdepcode='" + tr.rLaterDepCode + "') where cPsn_Num = '" + tr.cPsn_Num + "' AND blastflag = 1 AND bPartJob = 0 ";
int e = db.ExecuteSql(sql5);
string sql6 = "update HR_TM_PersonDutyClass set dLeaveDutyClassDate = '" + tr.dTransferDate + "' ,blastflag = 0 where PK_hr_tm_personDutyClass = (select top 1 PK_hr_tm_personDutyClass from HR_TM_PersonDutyClass where cpsn_num='" + tr.cPsn_Num + "' and blastflag = 1 order by dEnterDutyClassDate desc)";
int f = db.ExecuteSql(sql6);
string sql7 = "UPDATE hr_tm_DayResult SET cDepCode = '" + tr.rLaterDepCode + "',cDepCode_Num = '" + tr.rLaterDepCode + "' WHERE cPsn_Num = '" + tr.cPsn_Num + "' AND dDutyDate >= '" + tr.dTransferDate + "'";
int g = db.ExecuteSql(sql7);
string sql8 = "UPDATE hr_tm_MonthResult SET vdepcode_num = '" + tr.rLaterDepCode + "',vDepCode = '" + tr.rLaterDepCode + "' WHERE cPsn_Num = '" + tr.cPsn_Num + "' AND ((cYear = " + Convert.ToDateTime(tr.dTransferDate).Year + " AND cMonth >= " + Convert.ToDateTime(tr.dTransferDate).Month + ") OR (cYear > " + Convert.ToDateTime(tr.dTransferDate).Year + "))";
int h = db.ExecuteSql(sql8);
string sql9 = "UPDATE UA_User SET cDept = (SELECT cdepname from Department where cdepcode='" + tr.rLaterDepCode + "') WHERE cUser_id IN (SELECT cUser_Id FROM UserHrPersonContro WHERE UserHrPersonContro.cPsn_Num='" + tr.cPsn_Num + "')";
int k = db.ExecuteSql(sql9);
i = a + b + c + d + e + f + g + h + k;
return(i);
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
throw;
}
}
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 auditTransfer(string ccode, TransferRegister transfer, ref string errMsg)
{
int i = transferService.auditVoucher(ccode, transfer, ref errMsg);
return(i);
}
public string getSql(TransferRegister tr)
{
string sql = db.InsertSql <TransferRegister>(tr, "HR_HI_TransferRegister");
return(sql);
}
public HttpResponseMessage AddTransfer(string token, string json)
{
string errMsg = "";
ReturnMessage msg = new ReturnMessage();
try
{
ReceiveLog receive = new ReceiveLog();
receive.uuid = Guid.NewGuid();
receive.receiveData = json;
receive.interfaceCode = "Transfer";
receive.interfaceDesc = "人事调动单新增";
receive.op = "add";
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);
TransferManager transferManager = new TransferManager(vouMag.UFDataConnstringForNet);
TransferRegister transfer = (TransferRegister)JsonConvert.DeserializeObject(json, typeof(TransferRegister));
int i = transferManager.AddTransfer(transfer, ref errMsg);
if (i >= 1)
{
//msg.Success = true;
//dynamic c = new { code = transferManager.ccode };
//msg.Data = JsonConvert.SerializeObject(c);
//msg.Code = 200;
//msg.Msg = "新增成功";
int q = transferManager.auditTransfer(transferManager.ccode, transfer, ref errMsg);
if (q >= 1)
{
msg.Success = true;
msg.Code = 200;
dynamic c = new { code = transferManager.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")
});
}
}