Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + |
| | | ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID" + |
| | | ",HPersonNums,HMachineNums" + |
| | | ",HPersonNums,HMachineNums,HEmpNum" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",getdate(),'" + DBUtility.ClsPub.CurUserName + "',getdate(),'" + omodel.HMouldNum + "'" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HSourceName + "'," + omodel.HPieceQty.ToString() + "," + omodel.HWasterQty.ToString() + "," + omodel.HPlanPieceQty.ToString() + "," + omodel.HBadPNL.ToString() + |
| | |
| | | "," + omodel.HSupID.ToString() + "," + omodel.HQty.ToString() + "," + omodel.HPrice.ToString() + "," + omodel.HMoney.ToString() + "," + omodel.HBadCount.ToString() + "," + omodel.HCenterID.ToString() + "," + omodel.HProcNo.ToString() + ",'" + omodel.HOrderProcNO + "'" + ",'" + omodel.HSourceNameList + "'" + |
| | | "," + omodel.HMainSourceInterID.ToString() + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + Convert.ToString(omodel.HLastSubProc ? 1 : 0) + |
| | | "," + omodel.HEmpID2.ToString() + "," + omodel.HEmpID3.ToString() + "," + omodel.HEmpID4.ToString() + "," + omodel.HEmpID5.ToString() + "," + omodel.HDSQty.ToString() + "," + omodel.HChongQty.ToString() + "," + omodel.HPriceRate.ToString() + "," + omodel.HWorkTimes.ToString() + "," + omodel.HQCCheckID.ToString() + |
| | | "," + omodel.HPersonNums.ToString() + "," + omodel.HMachineNums.ToString() + |
| | | "," + omodel.HPersonNums.ToString() + "," + omodel.HMachineNums.ToString() + ",'" + omodel.HEmpNum.ToString() + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_StationOutBillSub oSub in DetailColl) |
| | |
| | | public string HSourceNameList;//è®¾å¤æ¸
å |
| | | public Int64 HPersonNums; //äººåæ° |
| | | public Int64 HMachineNums; //æºå¨æ° |
| | | |
| | | public string HEmpNum; //èå代ç |
| | | } |
| | | } |
| | |
| | | ",HUpDater='" + HMaker + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | ",HInnerBillNo='" + HInnerBillNo + "'" + |
| | | ",HWWWorkOrderBillNo='" + HWWWorkOrderBillNo + "'" + |
| | | ",HSupID=" + HSupID + |
| | | ",HEmpID=" + HEmpID + |
| | | ",HQty=" + HQty + |
| | |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | |
| | | List<Model.ClsSc_StationOutBillMain> list = new List<Model.ClsSc_StationOutBillMain>(); |
| | | |
| | |
| | | oBill.omodel.HBillNo = msg3 + "- " + j; |
| | | oBill.omodel.HBillStatus = 0; |
| | | oBill.omodel.HMouldNum = list[i].HMouldNum; |
| | | oBill.omodel.HYear = 2022; |
| | | oBill.omodel.HPeriod = 1; |
| | | oBill.omodel.HYear = DateTime.Now.Year; |
| | | oBill.omodel.HPeriod = DateTime.Now.Month; |
| | | oBill.omodel.HRemark = list[i].HRemark; |
| | | oBill.omodel.HSourceName = list[i].HSourceName; |
| | | oBill.omodel.HPieceQty = list[i].HPieceQty; |
| | |
| | | oBill.omodel.HWorkTimes = list[i].HWorkTimes; |
| | | oBill.omodel.HQCCheckID = list[i].HQCCheckID; |
| | | oBill.omodel.HMaker = msg4; |
| | | oBill.omodel.HEmpNum = msg5; |
| | | |
| | | //string HBillSubType = "3791"; |
| | | //long HInterID = list[0].HInterID;//éå
¥typeå¾å°çåæ®ID |
| | |
| | | <Compile Include="Controllers\MJGL\Sc_MouldScrapRequestBillController.cs" /> |
| | | <Compile Include="Controllers\MJGL\Sc_MouldStatusChangeBillController.cs" /> |
| | | <Compile Include="Controllers\Pay_ReportController.cs" /> |
| | | <Compile Include="Controllers\SBGL\SBTC\Sb_EquipStockInCheckBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\SBTC\Sb_EquipWorkBeforeCheckBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipSparepartsBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipSparepartsChangeBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipStatusChangeBillController.cs" /> |