File was renamed from WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/Cg_PODemandPlanBillController.cs |
| | |
| | | |
| | | namespace WebAPI.Controllers.SCGL |
| | | { |
| | | public class Cg_PODemandPlanBillController : ApiController |
| | | public class JIT_Cg_PODemandPlanBillController : ApiController |
| | | { |
| | | private json objJsonResult = new json(); |
| | | public DataSet ds = new DataSet(); |
| | | public WebServer webserver = new WebServer(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | Cg_PODemandPlanBillMain omdelMian = new Cg_PODemandPlanBillMain(); |
| | | List<Cg_PODemandPlanBillSub> omodelsub = new List<Cg_PODemandPlanBillSub>(); |
| | | JIT_Cg_PODemandPlanBillMain omdelMian = new JIT_Cg_PODemandPlanBillMain(); |
| | | List<JIT_Cg_PODemandPlanBillSub> omodelsub = new List<JIT_Cg_PODemandPlanBillSub>(); |
| | | |
| | | #region ææè®¡åå å表 |
| | | [Route("Cg_PODemandPlanBill/Cg_PODemandPlanBillList")] |
| | | [Route("JIT_Cg_PODemandPlanBill/JIT_Cg_PODemandPlanBillList")] |
| | | [HttpGet] |
| | | public object Cg_PODemandPlanBillList(string sWhere, string user) |
| | | { |
| | |
| | | #endregion |
| | | |
| | | #region ææè®¡åå æ·»å /ä¿®æ¹ |
| | | [Route("Cg_PODemandPlanBill/AddPODemandPlanBillList")] |
| | | [Route("JIT_Cg_PODemandPlanBill/AddPODemandPlanBillList")] |
| | | [HttpPost] |
| | | public object AddPODemandPlanBillList([FromBody] JObject sMainSub) |
| | | { |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Cg_PODemandPlanBillMain>(msg2); |
| | | omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<JIT_Cg_PODemandPlanBillMain>(msg2); |
| | | string BillType = "4608"; |
| | | |
| | | |
| | | if (OperationType == 1)//æ°å¢ |
| | | { |
| | | //主表 |
| | | oCN.RunProc("insert into Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" + |
| | | oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" + |
| | | ",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" + |
| | | ",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" + |
| | | ",HRemark,HExplanation)" + |
| | |
| | | else if (OperationType == 3) |
| | | { |
| | | //ä¿®æ¹ |
| | | oCN.RunProc($"update Cg_PODemandPlanBillMain set HUpDater='{omdelMian.HMaker}',HUpDateDate=GETDATE()" + |
| | | oCN.RunProc($"update JIT_Cg_PODemandPlanBillMain set HDate='{omdelMian.HDate}',HUpDater='{omdelMian.HMaker}',HUpDateDate=GETDATE()" + |
| | | $",HSubORGID={omdelMian.HSubORGID},HAddress='{omdelMian.HAddress}',HPURCHASEORGID={omdelMian.HPURCHASEORGID}" + |
| | | $",HSupplierID={omdelMian.HSupplierID},HSettleCurrId={omdelMian.HSettleCurrId}" + |
| | | $",HRemark='{omdelMian.HRemark}',HExplanation='{omdelMian.HExplanation}' where HInterID={omdelMian.HInterID}"); |
| | |
| | | //è·åè¡¨æ ¼æ°æ® |
| | | ds = oCN.RunProcReturn($"select * from h_v_JIT_Cg_PODemandPlanBillList where åæ®å·='{omdelMian.HBillNo}'", "h_v_JIT_Cg_PODemandPlanBillList"); |
| | | //å é¤å表 |
| | | oCN.RunProc("delete from Cg_PODemandPlanBillSub where HInterID='" + omdelMian.HInterID.ToString() + "' and HEntryID='" + hentryid + "'"); |
| | | oCN.RunProc("delete from JIT_Cg_PODemandPlanBillSub where HInterID='" + omdelMian.HInterID.ToString() + "' and HEntryID='" + hentryid + "'"); |
| | | } |
| | | |
| | | |
| | | omodelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Cg_PODemandPlanBillSub>>(msg3); |
| | | omodelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<JIT_Cg_PODemandPlanBillSub>>(msg3); |
| | | int i = 1; |
| | | //æå
¥å表 |
| | | foreach (Models.Cg_PODemandPlanBillSub oSub in omodelsub) |
| | | foreach (Models.JIT_Cg_PODemandPlanBillSub oSub in omodelsub) |
| | | { |
| | | oCN.RunProc("insert into Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" + |
| | | oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" + |
| | | ", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" + |
| | | ", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" + |
| | | ", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" + |
| | |
| | | #endregion |
| | | |
| | | #region ææè®¡åå å é¤ |
| | | [Route("Cg_PODemandPlanBill/DelPODemandPlanBillList")] |
| | | [Route("JIT_Cg_PODemandPlanBill/DelPODemandPlanBillList")] |
| | | [HttpGet] |
| | | public object DelPODemandPlanBillList(string HInterID, string HEntryID, string User) |
| | | { |
| | |
| | | |
| | | if (ds.Tables[0].Rows.Count == 1) |
| | | { |
| | | oCN.RunProc($"delete from Cg_PODemandPlanBillMain where HInterID={HInterID}"); |
| | | oCN.RunProc($"delete from JIT_Cg_PODemandPlanBillMain where HInterID={HInterID}"); |
| | | } |
| | | oCN.RunProc($"delete from Cg_PODemandPlanBillSub where HInterID={HInterID} and HEntryID={HEntryID}"); |
| | | oCN.RunProc($"delete from JIT_Cg_PODemandPlanBillSub where HInterID={HInterID} and HEntryID={HEntryID}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | |
| | |
| | | #endregion |
| | | |
| | | #region ææè®¡åå å
³é |
| | | [Route("Cg_PODemandPlanBill/ClosePODemandPlanBillList")] |
| | | [Route("JIT_Cg_PODemandPlanBill/ClosePODemandPlanBillList")] |
| | | [HttpGet] |
| | | public object ClosePODemandPlanBillList(string HInterID, string User) |
| | | { |
| | |
| | | |
| | | oCN.BeginTran();//å¼å¯äºå¡ |
| | | |
| | | oCN.RunProc($"update Cg_PODemandPlanBillMain set HBillStatus=3,HCloseMan='{User}',HCloseDate=getdate() where HInterID={HInterID}"); |
| | | oCN.RunProc($"update JIT_Cg_PODemandPlanBillMain set HBillStatus=3,HCloseMan='{User}',HCloseDate=getdate() where HInterID={HInterID}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | |