Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | <Compile Include="è´¨æ£ç®¡ç\ClsQC_POStockInCheckBill.cs" /> |
| | | <Compile Include="è´¨æ£ç®¡ç\ClsQC_ProcessCheckBill.cs" /> |
| | | <Compile Include="è´¨æ£ç®¡ç\ClsQC_ProdReportCheckBill.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_ProcExchWorkBackBill.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_CutMaterProcExchBill.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_MaterBackBill.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_MaterDownBill.cs" /> |
| | |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | } |
| | | //æ ¹æ®ä»£ç è¿å项ç®ä¿¡æ¯ |
| | | public override bool GetInfoByName(string sNumber) |
| | | { |
| | | DataSet DS; |
| | | try |
| | | { |
| | | DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HName='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count == 0) |
| | | return false; |
| | | else |
| | | { |
| | | return GetInfo(DS); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | //è¿å项ç®ä¿¡æ¯ |
| | | public override bool GetInfo(DataSet Ds) |
| | | { |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace DAL |
| | | { |
| | | public class ClsSc_ProcExchWorkBackBill : DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsSc_ProcExchWorkBackBillMain omodel = new Model.ClsSc_ProcExchWorkBackBillMain(); |
| | | public List<Model.ClsSc_ProcExchWorkBackBillSub> DetailColl = new List<Model.ClsSc_ProcExchWorkBackBillSub>(); |
| | | |
| | | public ClsSc_ProcExchWorkBackBill() |
| | | { |
| | | base.MvarItemKeySub = "Sc_ProcExchWorkBackBillSub"; |
| | | base.MvarItemKeySub2 = ""; |
| | | base.MvarItemKeySub3 = ""; |
| | | base.MvarItemKeySub4 = ""; |
| | | base.MvarItemKey= "Sc_ProcExchWorkBackBillMain"; |
| | | base.MvarReportTitle= "å·¥åºè¿å·¥ç³è¯·å"; |
| | | base.BillType = "3796"; |
| | | base.HBillSubType = "3796"; |
| | | |
| | | } |
| | | |
| | | #region åºå®ä»£ç |
| | | |
| | | ~ClsSc_ProcExchWorkBackBill() |
| | | { |
| | | DetailColl = null; |
| | | } |
| | | |
| | | #endregion èªå®ä¹æ¹æ³ |
| | | //ä¿®æ¹åæ® |
| | | public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | // |
| | | oCn.BeginTran(); |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc("UpDate Sc_ProcExchWorkBackBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== |
| | | //",HDate='" + omodel.HDate + "'" + |
| | | //",HYear='" + omodel.HYear.ToString() + "'" + |
| | | //",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | | ",HUpDater='" + omodel.HMaker + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | //======================================== |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo.ToString() +"'"+ |
| | | ",HEmpID=" + omodel.HEmpID.ToString() + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //å é¤å表 |
| | | DeleteBillSub(lngBillKey); |
| | | //æå
¥å表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsSc_ProcExchWorkBackBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_ProcExchWorkBackBillSub (HInterID, HEntryID, HCloseMan, HEntryCloseDate, HCloseType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag == true ? 1 : 0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | } |
| | | |
| | | sReturn = "ä¿®æ¹åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | //æ°å¢åæ® |
| | | public override bool AddBill(ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | //å¾å°mainid |
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCn.BeginTran(); |
| | | //主表 |
| | | oCn.RunProc("insert Into Sc_ProcExchWorkBackBillMain(HBillType, HBillSubType, HInterID, HBillNo, HDate,HBillStatus" + |
| | | ", HMaker, HMakeDate, HYear, HPeriod, HRemark" + |
| | | ", HICMOInterID, HICMOBillNo, HICMOEntryID, HProcExchInterID, HProcExchEntryID" + |
| | | ", HProcExchBillNo, HProcExchBegNO, HProcExchEndNO, HProcBegID, HProcEndID" + |
| | | ", HMaterID, HUnitID, HEmpID, HPlanQty, HQty" + |
| | | ", HExplanation, HInnerBillNo, HWorkShopID, HOrderProcNo, HPRDORGID) values(" + |
| | | $"'{omodel.HBillType}','{omodel.HBillSubType}',{omodel.HInterID},'{omodel.HBillNo}','{omodel.HDate}',1" + |
| | | $",'{omodel.HMaker}','{omodel.HMakeDate}',{omodel.HYear},{omodel.HPeriod},'{omodel.HRemark}'" + |
| | | $",{omodel.HICMOInterID},'{omodel.HICMOBillNo}',{omodel.HICMOEntryID},{omodel.HProcExchInterID},{omodel.HProcExchEntryID}" + |
| | | $",'{omodel.HProcExchBillNo}',{omodel.HProcExchBegNO},{omodel.HProcExchEndNO},{omodel.HProcBegID},{omodel.HProcEndID}" + |
| | | $",{omodel.HMaterID},{omodel.HUnitID},{omodel.HEmpID},{omodel.HPlanQty},{omodel.HQty}" + |
| | | $",'{omodel.HExplanation}','{omodel.HInnerBillNo}',{omodel.HWorkShopID},'{omodel.HOrderProcNo}',{omodel.HPRDORGID})"); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_ProcExchWorkBackBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_ProcExchWorkBackBillSub (HInterID, HEntryID, HCloseMan, HEntryCloseDate, HCloseType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType== true ? 1:0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag== true?1:0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | } |
| | | |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | ",HProdMaterCode,HSeOrderBillNo,HCusShortName,HCusNeedMaterial,HPlanSendGoodsDate" + |
| | | ",HProdMaterName,HCusName,HWorkRemark,HImportNote,HMaterNumber_A" + |
| | | ",HMaterNumber_B,HMaterNumber_C,HMaterNumber_D,HProdType,HMaterShortName" + |
| | | ",HMaterIDA,HMaterIDB,HMaterIDC,HMaterIDD,HICMOEntryID" + |
| | | ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HPRDORGID,HBLFlag,HCusNumber,HPickLabel,HPickLabelNumber,HXTNumber,HXTModel,HWorkBillSortNo" + |
| | | ") " + |
| | | ",HMaterIDA,HMaterIDB,HMaterIDC,HMaterIDD,HICMOEntryID" + ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HPRDORGID,HBLFlag,HCusNumber,HPickLabel,HPickLabelNumber,HXTNumber,HXTModel,HWorkBillSortNo" + |
| | | ", HRoutingBillID) " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()," + "" + (omodel.HPrevMainSourceInterID == 0 ? omodel.HInterID : omodel.HPrevMainSourceInterID) + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HBatchNo + "'," + omodel.HMainMaterID.ToString() + "," + omodel.HKeyMaterID.ToString() + "," + omodel.HNo.ToString() + ",'" + omodel.HOrderProcNO + "'" + |
| | | "," + omodel.HWWOrderInterID.ToString() + "," + omodel.HWWOrderEntryID.ToString() + ",'" + omodel.HWWOrderBillNo + "'," + omodel.HICMOInterID.ToString() + "," + omodel.HEquipMentID.ToString() + |
| | |
| | | ",'" + omodel.HMaterNumber_B + "','" + omodel.HMaterNumber_C + "','" + omodel.HMaterNumber_D + "','" + omodel.HProdType + "','" + omodel.HMaterShortName + "'" + |
| | | ",'" + omodel.HMaterIDA + "','" + omodel.HMaterIDB + "','" + omodel.HMaterIDC + "','" + omodel.HMaterIDD + "'," + omodel.HICMOEntryID + |
| | | ",'" + omodel.HPicNumVer + "','" + omodel.HPicNumAssemble + "','" + omodel.HMaterTexture + "','" + omodel.HProductNum + "','" + omodel.HVerNum + "','"+ omodel.HPRDORGID+ "','"+omodel.HBLFlag+ "','" + omodel.HCusNumber + "','" + omodel.HPickLabel + "','" + omodel.HPickLabelNumber + "','" + omodel.HXTNumber + "','" + omodel.HXTModel + "','" + omodel.HWorkBillSortNo + |
| | | "') "); |
| | | "',"+ omodel.HRoutingBillID + ") "); |
| | | sErr = sErr + "1;"; |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oSub in DetailColl) |
| | |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldStockBillSub.cs" /> |
| | | <Compile Include="ç产管ç\设å¤ç®¡ç\ClsSb_EquipConkBookBillMain.cs" /> |
| | | <Compile Include="ç产管ç\设å¤ç®¡ç\ClsSb_EquipConkBookBillSub.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_ProcExchWorkBackBillSub.cs" /> |
| | | <Compile Include="车é´ç®¡ç\ClsSc_ProcExchWorkBackBillMain.cs" /> |
| | | <Compile Include="ç产管ç\设å¤ç®¡ç\ClsSb_EquipWorkBeforeCheckBillMain.cs" /> |
| | | <Compile Include="ç产管ç\设å¤ç®¡ç\ClsSb_EquipWorkBeforeCheckBillSub.cs" /> |
| | | <Compile Include="ç产管ç\设å¤ç®¡ç\ClsSb_EquipStockInCheckBillSub.cs" /> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_ProcExchWorkBackBillMain : DBUtility.ClsXt_BaseBillMain |
| | | { |
| | | public Int64 HPrintQty { get; set; } //æå°æ¬¡æ° |
| | | public Int64 HICMOInterID { get; set; } |
| | | public Int64 HICMOEntryID { get; set; } |
| | | public Int64 HProcExchInterID { get; set; } |
| | | public Int64 HProcExchEntryID { get; set; } |
| | | public Int64 HProcExchBegNO { get; set; } |
| | | public Int64 HProcExchEndNO { get; set; } |
| | | public Int64 HProcBegID { get; set; } |
| | | public Int64 HProcEndID { get; set; } |
| | | public Int64 HMaterID { get; set; } |
| | | public Int64 HUnitID { get; set; } |
| | | public Int64 HEmpID { get; set; } |
| | | public Int64 HWorkShopID { get; set; } |
| | | public Int64 HPRDORGID { get; set; } |
| | | public string HICMOBillNo { get; set; } |
| | | public string HProcExchBillNo { get; set; } |
| | | public string HExplanation { get; set; } |
| | | public string HBatchNo { get; set; } |
| | | public string HOrderProcNo { get; set; } |
| | | public string HInnerBillNo { get; set; } |
| | | public double HPlanQty { get; set; } |
| | | public double HQty { get; set; } |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_ProcExchWorkBackBillSub : DBUtility.ClsXt_BaseBillSub |
| | | { |
| | | public string HBillNo_bak; //åæ®å·ï¼å¤ä»½ï¼ä»¥å
å
ç ä¸¢å¤±ï¼æ¾ä¸å°å¯¹åºä¸»è¡¨ï¼ |
| | | public Int64 HItemSubID; //èªå¢å(GUID) |
| | | public Int64 HProcNo { get; set; } |
| | | public Int64 HProcID { get; set; } |
| | | public Int64 HCenterID { get; set; } |
| | | public Int64 HSupID { get; set; } |
| | | public Int64 HDeptID { get; set; } |
| | | public Int64 HICMOInterID { get; set; } |
| | | public Int64 HSeOrderInterID { get; set; } |
| | | public Int64 HSeOrderEntryID { get; set; } |
| | | public Int64 HICMOEntryID { get; set; } |
| | | public Int64 HWWOrderInterID { get; set; } |
| | | public Int64 HWWOrderEntryID { get; set; } |
| | | public bool HSupFlag { get; set; } |
| | | public string HWorkRemark { get; set; } |
| | | public string HMouldNo { get; set; } |
| | | public string HWWOrderBillNo { get; set; } |
| | | public string HProcWorkNum { get; set; } |
| | | public string HICMOBillNo { get; set; } |
| | | public string HSeOrderBillNo { get; set; } |
| | | public string HTimeUnit { get; set; } |
| | | public string HProcType { get; set; } |
| | | public double HQty { get; set; } |
| | | public double HPlanWorkTimes { get; set; } |
| | | public double HStdWorkTime { get; set; } |
| | | public DateTime HPlanBeginDate { get; set; } |
| | | public DateTime HPlanEndDate { get; set; } |
| | | } |
| | | } |
| | |
| | | public string HPickLabelNumber; |
| | | public string HXTNumber; |
| | | public string HXTModel; |
| | | public string HRoutingBillID;//å·¥èºè·¯çº¿ID |
| | | } |
| | | } |
| | |
| | | omodel.MES_StationOutBill_InStockType = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //===========å·¥èºè·¯çº¿ |
| | | //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_SaveAutoLastProc") |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //=======JIT |
| | | |
| | |
| | | omodel.MES_StationEntrustOutBill_SaveAutoAddnew = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //=========å·¥èºè·¯çº¿ |
| | | //èªå¨æ°å¢ ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_SaveAutoLastProc") |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //æ¥å·¥å°ï¼å·¥åºæ±æ¥èªå¨å®¡æ ¸åæ° |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_MESProceReportWorkBill_AutoCheck") |
| | | { |
| | |
| | | public string Sc_MouldProdOutBill_MouldLifeCtrlType; //ä¿åæ¶å¨å
·å¯¿å½æ§å¶ç±»å ï¼Y å¼ºå¶æ§å¶ï¼ N ä»
æç¤ºï¼ |
| | | |
| | | |
| | | //å·¥èºè·¯çº¿ |
| | | public string Gy_RoutingBill_SaveAutoLastProc; //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | |
| | | } |
| | | |
New file |
| | |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers.CJGL |
| | | { |
| | | public class Sc_ProcExchWorkBackBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | #region å·¥åºè¿å·¥ç³è¯·åå表 |
| | | [Route("Sc_ProcExchWorkBackBill/Sc_ProcExchWorkBackBillList")] |
| | | [HttpGet] |
| | | public object Sc_ProcExchWorkBackBillList(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcExchWorkBackBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = "select * from h_v_Sc_ProcExchWorkBackBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcExchWorkBackBillList"); |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ¥è¯¢å·¥åºæµè½¬å¡æ°æ® æ¥è¯¢ å½å å ä¸ä¸æ¡æ°æ® |
| | | [Route("Sc_ProcExchWorkBackBill/GetProcessExchangeBillSub")] |
| | | [HttpGet] |
| | | public object GetProcessExchangeBillSub_cf(string sWhere) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql = string.Format(@"select top 2 * from h_v_Sc_ProcessExchangeBillQuerySub"); |
| | | ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_ProcessExchangeBillQuerySub"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºè¿å·¥ç³è¯·å æ°å¢/ç¼è¾ |
| | | /// <summary> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Sc_ProcExchWorkBackBill/Sc_ProcExchWorkBackBillAddBill")] |
| | | [HttpPost] |
| | | public object Sc_ProcExchWorkBackBillAddBill([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString();//主表 |
| | | string msg3 = sArray[1].ToString();//å表 |
| | | int msg5 = int.Parse(sArray[2].ToString());//ç±»å |
| | | string msg6 = sArray[3].ToString();//ç¨æ· |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, msg6)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //主表 |
| | | DAL.ClsSc_ProcExchWorkBackBill oBill = new DAL.ClsSc_ProcExchWorkBackBill(); |
| | | List<Model.ClsSc_ProcExchWorkBackBillMain> lsmain = new List<Model.ClsSc_ProcExchWorkBackBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_ClsSc_ProcExchWorkBackBillMain(msg2); |
| | | foreach (Model.ClsSc_ProcExchWorkBackBillMain oItem in lsmain) |
| | | { |
| | | oItem.HBillType = "3796"; |
| | | oItem.HBillSubType = "3796"; |
| | | oItem.HBillStatus = 1; |
| | | oItem.HMaker = msg6; |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | |
| | | //è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | List<Model.ClsSc_ProcExchWorkBackBillSub> ls = new List<Model.ClsSc_ProcExchWorkBackBillSub>(); |
| | | ls = oListModels.getObjectByJson_ClsSc_ProcExchWorkBackBillSub(msg3); |
| | | int i = 0; |
| | | foreach (Model.ClsSc_ProcExchWorkBackBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | | oItemSub.HEntryID = i; |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oItemSub.HCloseType = false; //å
³éç±»å |
| | | oItemSub.HSourceInterID = 0; // æºå主å
ç |
| | | oItemSub.HSourceEntryID = 0; //æºååå
ç |
| | | oItemSub.HRelationQty = 0; //å
³èæ°é |
| | | oItemSub.HBillNo_bak = oBill.omodel.HBillNo; //å¤ä»½åæ®å· |
| | | oItemSub.HCloseMan = ""; |
| | | oItemSub.HSourceBillNo = ""; |
| | | oItemSub.HSourceBillType = ""; |
| | | oBill.DetailColl.Add(oItemSub); |
| | | } |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | if (msg5==1) |
| | | { |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region å·¥åºè¿å·¥ç³è¯·å å é¤ |
| | | /// <summary> |
| | | /// å·¥åºè¿å·¥ç³è¯·å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcExchWorkBackBill/DelProcExchWorkBackBill")] |
| | | [HttpGet] |
| | | public object DelProcExchWorkBackBill(string HInterID, string user) |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcExchWorkBackBill_Drop", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(HInterID); |
| | | if (lngBillKey == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | DAL.ClsSc_ProcExchWorkBackBill oBill = new DAL.ClsSc_ProcExchWorkBackBill(); |
| | | ds = oCN.RunProcReturn("select * from Sc_ProcExchWorkBackBillMain where HInterID=" + lngBillKey, "Sc_ProcExchWorkBackBillMain"); |
| | | |
| | | if (ds.Tables[0].Rows.Count>0) |
| | | { |
| | | |
| | | if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å½åå¤äºä¸è½å é¤ç¶æ,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "忮已ç»å®¡æ ¸,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | if (IsDete) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æªæ¾å°"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºè¿å·¥ç³è¯·å å®¡æ ¸ |
| | | [Route("Sc_ProcExchWorkBackBill/set_CheckBill")] |
| | | [HttpGet] |
| | | public object set_CheckBill(int HInterID, string CurUserName) |
| | | { |
| | | try |
| | | { |
| | | //å®¡æ ¸æé |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcExchWorkBackBill_Check", 1, false, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (HInterID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ID为0ï¼ä¸è½å®¡æ ¸ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DataSet Ds = oCN.RunProcReturn("Select * from Sc_ProcExchWorkBackBillMain Where HInterID=" + HInterID, "Sc_ProcExchWorkBackBillMain"); |
| | | if (Ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | //æ¥çæ¯å¦å·²å®¡æ ¸,å
³é,ä½åº |
| | | if (Ds.Tables[0].Rows[0]["HChecker"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸è½åæ¬¡å®¡æ ¸"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | //å®¡æ ¸ |
| | | if (Cj_StationInBillCheckBill(HInterID, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸æå!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æªæ¾å°!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //å®¡æ ¸ |
| | | public bool Cj_StationInBillCheckBill(Int64 HInterID, string CurUserName, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | oCN.BeginTran(); |
| | | oCN.RunProc(" Update Sc_ProcExchWorkBackBillMain set HChecker='" + CurUserName + "',HBillStatus=2,HCheckDate='getdate()' Where HInterID=" + HInterID.ToString()); |
| | | oCN.RunProc("exec h_p_ProcExchWorkBackBill_Check_In " + HInterID.ToString()); |
| | | oCN.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCN.RollBack(); |
| | | return false; ; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | //} |
| | | #endregion |
| | | |
| | | #region[æ¹éæ°å¢åæ®-ä¿åæé®] |
| | | /// <summary> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Sc_ProcessExchangeBill/AddBill_pl")] |
| | | [HttpPost] |
| | | public object AddBill_pl([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString();//主表 |
| | | string msg3 = sArray[1].ToString();//åæ®å·åæ°é |
| | | string msg4 = sArray[2].ToString();//å·¥èºè·¯çº¿ |
| | | string msg5 = sArray[3].ToString();//ç±»å |
| | | string msg6 = sArray[4].ToString();//ç¨æ· |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, msg6)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //åæ®å· åæ°é |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | List<Model.ClsSc_ProcessExchangeBillMain> ListHbillNo = new List<Model.ClsSc_ProcessExchangeBillMain>(); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | ListHbillNo = JsonConvert.DeserializeObject<List<Model.ClsSc_ProcessExchangeBillMain>>(msg3); |
| | | |
| | | //ä¸»è¡¨ä¿¡æ¯ |
| | | Model.ClsSc_ProcessExchangeBillMain Main = new Model.ClsSc_ProcessExchangeBillMain(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | Main = JsonConvert.DeserializeObject<Model.ClsSc_ProcessExchangeBillMain>(msg2); |
| | | |
| | | DBUtility.ClsPub.CurUserName = msg6; |
| | | Main.HMaker = msg6; //å¶å人 |
| | | Main.HBillType = "3772"; |
| | | Main.HBillSubType = "3772"; |
| | | Main.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | Main.HMaterID = Main.HMaterID2; |
| | | if (DBUtility.ClsPub.isStrNull(Main.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg4 = msg4.Substring(1, msg4.Length - 2); |
| | | msg4 = msg4.Replace("\\", ""); |
| | | msg4 = msg4.Replace("\n", ""); //\n |
| | | List<Model.ClsSc_ProcessExchangeBillSub> ls = new List<Model.ClsSc_ProcessExchangeBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sc_ProcessExchangeBillSub(msg4); |
| | | |
| | | //å¾ªç¯æ°å¢åæ® |
| | | for (int i = 0; i < ListHbillNo.Count; i++) |
| | | { |
| | | Main.HBillNo = ListHbillNo[i].HBillNo; |
| | | Main.HQty = ListHbillNo[i].HQty; |
| | | oBill.omodel = Main; |
| | | |
| | | int j = 0; |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oItemSub in ls) |
| | | { |
| | | j++; |
| | | oItemSub.HEntryID = j; |
| | | oItemSub.HQty = Main.HQty; |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oBill.DetailColl.Add(oItemSub); |
| | | } |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult=false; |
| | | if (msg5 == "2") |
| | | { |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | oBill.DetailColl.Clear(); |
| | | if (!bResult) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region å·¥åºæµè½¬å¡å表æ¾ç¤ºå¨å
·æ¸
åä¿¡æ¯ |
| | | [Route("Sc_ProcessExchangeBillList/QJQD")] |
| | | [HttpGet] |
| | |
| | | DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View(); |
| | | public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View(); |
| | | DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View(); |
| | | DAL.ClsGy_Warehouse_View oCenWare = new DAL.ClsGy_Warehouse_View(); |
| | | Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary(); |
| | | public string BillType = "3301"; |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | #region æªç¥ |
| | | /// <summary> |
| | |
| | | double HStdSourceQty = mainList[0].HStdSourceQty;//æ åèµæºæ° |
| | | double HAddSourceRate = mainList[0].HAddSourceRate;//å èµæºå¢é |
| | | double HDelSourceRate = mainList[0].HDelSourceRate;//åèµæºåé |
| | | int HPRDORGID = mainList[0].HOrgID; //ç产ç»ç» |
| | | int HPRDORGID = mainList[0].HPRDORGID; //ç产ç»ç» |
| | | int HOrgID = mainList[0].HOrgID; //ç»ç» |
| | | string HPicNumVer = mainList[0].HPicNumVer;//å¾å·çæ¬ |
| | | string HPicNumAssemble = mainList[0].HPicNumAssemble;//æ»è£
å¾å· |
| | |
| | | string HProductNum = mainList[0].HProductNum;//æåç¼å· |
| | | string HVerNum = mainList[0].HVerNum;//çæ¬ |
| | | int IsProNo = mainList[0].IsProNo;//æ¯å¦è½¬å·¥åº |
| | | |
| | | |
| | | if (OperationType == 2) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where åæ®å·='" + HBillNo + "'", "h_v_Gy_RoutingBillList"); |
| | |
| | | { //ä¿®æ¹ |
| | | oCN.RunProc("update Gy_RoutingBillMain set " + |
| | | "HDate='" + HDate + |
| | | "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',HMaker='" + HMaker + |
| | | "',Hmakedate=getdate(),HMaterID='" + HMaterID + "',HName='" + HName + "',HMaterTypeID='" + HMaterTypeID + |
| | | "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',hupdater='" + HMaker + |
| | | "',hupdatedate=getdate(),HMaterID='" + HMaterID + "',HName='" + HName + "',HMaterTypeID='" + HMaterTypeID + |
| | | "',HRoutingGroupID='" + HRoutingGroupID + "',HUnitID='" + HUnitID + "',HMaterNumber='" + HMaterNumber + "',HUnitNumber='" + HUnitNumber + |
| | | "',HStandard='" + Convert.ToString(HStandard ? 1 : 0) + "',HMainGroupID='" + HMainGroupID + "',HMainProcID='" + HMainProcID + "',HMainCenterID='" + HMainCenterID + |
| | | "',HMainTimeUnit='" + HMainTimeUnit + "',HMainUnitTime='" + HMainUnitTime + "',HMainWorkQty='" + HMainWorkQty + "',HMainPrice='" + HMainPrice + |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (IsProNo == 1 && OperationType == 1) |
| | | string sErrMsg = ""; |
| | | if (oSystemParameter.ShowBill(ref sErrMsg)) |
| | | { |
| | | //è®¾ç½®è½¬å·¥åº |
| | | oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_SaveAutoLastProc == "Y" && OperationType == 1) |
| | | { |
| | | //è®¾ç½®è½¬å·¥åº |
| | | oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); |
| | | } |
| | | } |
| | | else if (IsProNo == 1 && OperationType == 1) |
| | | { |
| | | //è®¾ç½®è½¬å·¥åº |
| | | oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); |
| | | } |
| | | } |
| | | |
| | | //设置é»è®¤å·¥èºè·¯çº¿ |
| | | oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID); //设置é»è®¤å·¥èºè·¯çº¿ |
| | | |
| | | //æ¯å¦å¾éé»è®¤å·¥èºè·¯çº¿ |
| | | if (HStandard) |
| | | { |
| | | //设置é»è®¤å·¥èºè·¯çº¿ |
| | | oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID); //设置é»è®¤å·¥èºè·¯çº¿ |
| | | } |
| | | |
| | | //夿æ¯å¦éå¤å·¥åºå· |
| | | ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl"); |
| | | |
| | |
| | | ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + |
| | | ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + |
| | | ",HTechnologyParameter,HPicNum,HProcCheckNote" + |
| | | ",HOverRate,HProcWorkNum" + |
| | | ",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID " + |
| | | ") values(" |
| | | + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + |
| | | "," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() + |
| | |
| | | "," + oSub.HProcID_S.ToString() + "," + oSub.HCenterID_S.ToString() + "," + oSub.HWorkQty_S.ToString() + ", " + oSub.HSubStdEmpQty_S.ToString() + ",'" + oSub.HMouldNo + "'," + oSub.HChangeMould.ToString() + |
| | | ",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() + |
| | | ",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() + |
| | | "', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'" + |
| | | "', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString()+"," + oSub.HWasterWHID.ToString()+"," + oSub.HWHID.ToString() + |
| | | ") "); |
| | | } |
| | | } |
| | |
| | | if (!tb2.Columns.Contains("è¯ç")) |
| | | error += "æ²¡ææ¾å°ãè¯çãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("ä¸è¯åä»")) |
| | | error += "æ²¡ææ¾å°ãä¸è¯åä»ãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("æ¥åºåä»")) |
| | | error += "æ²¡ææ¾å°ãæ¥åºåä»ãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("è¯åä»")) |
| | | error += "æ²¡ææ¾å°ãè¯åä»ãçæ é¢"; |
| | | |
| | | if (error.Length > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | , è¯ç, å·¥åºå·¥ä»·, ä¸åæ ¼åä»·, æ¥åºåä»·, æ¬éåºå®å¼å·¥å¤©æ°, æ¬éå¼å·¥ä½é, ä¸éçå¾
å¤©æ° |
| | | , ä¸é循ç¯å¨æ, èªå¨è½¬ç§», å¤åæ è®°, ä¾åºå代ç , ä¾åºå, å·¥èºåæ°, å¾çº¸ç¼å· |
| | | , æ¬å·¥åºç¡®è®¤è®°å½, 夿³¨, å¾å·çæ¬, æ»è£
å¾å·, æè´¨, æåç¼å·, çæ¬ |
| | | , 模å
·ç¼å·, ç¨åºå·, ç产å®é¢, å·¥èºè·¯çº¿åç§°, æ¶é´åä½,å·¥èºè·¯çº¿ä»£ç )values |
| | | , 模å
·ç¼å·, ç¨åºå·, ç产å®é¢, å·¥èºè·¯çº¿åç§°, æ¶é´åä½,å·¥èºè·¯çº¿ä»£ç ,ä¸è¯åä»,æ¥åºåä»,è¯åä»)values |
| | | ('" + tb2.Rows[i]["产å代ç "].ToString() + "','" + tb2.Rows[i]["产ååç§°"].ToString() + "','" + tb2.Rows[i]["å·¥åºåºå·"].ToString() + "','" + tb2.Rows[i]["å·¥åºä»£ç "].ToString() + "','" + tb2.Rows[i]["å·¥åº"].ToString() + "','" + tb2.Rows[i]["å·¥ä½ä¸å¿"].ToString() + "','" + tb2.Rows[i]["å å·¥æ°é"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["è¯ç"].ToString() + "','" + (tb2.Rows[i]["å·¥åºå·¥ä»·"].ToString() == "" ? "0" : tb2.Rows[i]["å·¥åºå·¥ä»·"].ToString()) + "','" + tb2.Rows[i]["ä¸åæ ¼åä»·"].ToString() + "','" + tb2.Rows[i]["æ¥åºåä»·"].ToString() + "','" + tb2.Rows[i]["æ¬éåºå®å¼å·¥å¤©æ°"].ToString() + "','" + tb2.Rows[i]["æ¬éå¼å·¥ä½é"].ToString() + "','" + tb2.Rows[i]["ä¸éçå¾
天æ°"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["ä¸é循ç¯å¨æ"].ToString() + "','" + tb2.Rows[i]["èªå¨è½¬ç§»"].ToString() + "','" + tb2.Rows[i]["å¤åæ è®°"].ToString() + "','" + tb2.Rows[i]["ä¾åºå代ç "].ToString() + "','" + tb2.Rows[i]["ä¾åºå"].ToString() + "','" + tb2.Rows[i]["å·¥èºåæ°"].ToString() + "','" + tb2.Rows[i]["å¾çº¸ç¼å·"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["æ¬å·¥åºç¡®è®¤è®°å½"].ToString() + "','" + tb2.Rows[i]["夿³¨"].ToString() + "','" + tb2.Rows[i]["å¾å·çæ¬"].ToString() + "','" + tb2.Rows[i]["æ»è£
å¾å·"].ToString() + "','" + tb2.Rows[i]["æè´¨"].ToString() + "','" + tb2.Rows[i]["æåç¼å·"].ToString() + "','" + tb2.Rows[i]["çæ¬"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["模å
·ç¼å·"].ToString() + "','" + tb2.Rows[i]["ç¨åºå·"].ToString() + "','" + tb2.Rows[i]["ç产å®é¢"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿åç§°"].ToString() + "','" + tb2.Rows[i]["æ¶é´åä½"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿ä»£ç "].ToString() + "')"); |
| | | ",'" + tb2.Rows[i]["模å
·ç¼å·"].ToString() + "','" + tb2.Rows[i]["ç¨åºå·"].ToString() + "','" + tb2.Rows[i]["ç产å®é¢"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿åç§°"].ToString() + "','" + tb2.Rows[i]["æ¶é´åä½"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿ä»£ç "].ToString() + "','" + tb2.Rows[i]["ä¸è¯åä»"].ToString() + "','" + tb2.Rows[i]["æ¥åºåä»"].ToString() + "','" + tb2.Rows[i]["è¯åä»"].ToString() + "')"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | Single sWorkQty = 0; |
| | | Single sHPassRate = 0; |
| | | |
| | | // |
| | | sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产å代ç "].ToString()); |
| | | sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["å·¥ä½ä¸å¿"].ToString()); |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["å·¥åº"].ToString()); |
| | | sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["å å·¥æ°é"].ToString()); |
| | | sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["è¯ç"].ToString()); |
| | | |
| | | if (sHNumber != "") |
| | | { |
| | | // |
| | |
| | | sErrMsg = sErrMsg + "[" + sHNumberCen + "]å·¥ä½ä¸å¿ä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | |
| | | } |
| | | |
| | | |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | string HBadWHName = ""; //ä¸è¯åä» |
| | | string HWasterWHName = ""; //æ¥åºåä» |
| | | string HWHName = ""; //è¯åä» |
| | | |
| | | HBadWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["ä¸è¯åä»"].ToString()); |
| | | HWasterWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["æ¥åºåä»"].ToString()); |
| | | HWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["è¯åä»"].ToString()); |
| | | |
| | | //夿æ¯å¦ä¸ºç©º |
| | | if (HBadWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :ä¸è¯åä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWasterWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :æ¥åºåä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :è¯åä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | //夿ä»åºæ¯å¦éå¤ |
| | | if (HBadWHName == HWasterWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "ä¸è¯åä»åæ¥åºåä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWasterWHName == HWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "æ¥åºåä»åè¯åä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HBadWHName == HWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "ä¸è¯åä»åè¯åä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | //å¾å°ä»åºå
ç |
| | | if (!oCenWare.GetInfoByName(HBadWHName)) |
| | | { |
| | | sMsg = "[" + HBadWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HBadWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | |
| | | if (!oCenWare.GetInfoByName(HWasterWHName)) |
| | | { |
| | | sMsg = "[" + HWasterWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HWasterWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | |
| | | if (!oCenWare.GetInfoByName(HWHName)) |
| | | { |
| | | sMsg = "[" + HWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (b == true) |
| | |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | //} |
| | | //else |
| | | //{ |
| | | //objJsonResult.code = "0"; |
| | | //objJsonResult.count = 0; |
| | | //objJsonResult.Message = "æ æ°æ®"; |
| | | //objJsonResult.data = null; |
| | | //return objJsonResult; |
| | | //} |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | #region ç产æ¥è®¡åå¹³å° çäº§è®¢åæ¥è¯¢ |
| | | [Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")] |
| | | [HttpGet] |
| | | public object JIT_ICMOBillList(string hmainid, string HEntryID) |
| | | public object JIT_ICMOBillList(string hmainid) |
| | | { |
| | | try |
| | | { |
| | | DataSet dt = new DataSet(); |
| | | ds = oCN.RunProcReturn($"exec h_p_ICMOBillList_PrimarySubTable '{hmainid}','{HEntryID}'", "h_p_ICMOBillList_PrimarySubTable"); |
| | | |
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | var list = hmainid.Split(','); |
| | | List<DataTable> listdt = new List<DataTable>(); |
| | | DataTable dtable = new DataTable("dt"); |
| | | for (int i = 0; i < list.Length; i++) |
| | | { |
| | | dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where æºå主å
ç in({ds.Tables[0].Rows[i]["æºå主å
ç "].ToString()}) and æºååå
ç in({ds.Tables[0].Rows[i]["æºååå
ç "].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | var listEvery = list[i].Split('_'); |
| | | |
| | | ds = oCN.RunProcReturn($"exec h_p_ICMOBillList_PrimarySubTable '{listEvery[0]}','{listEvery[1]}'", "h_p_ICMOBillList_PrimarySubTable"); |
| | | |
| | | var dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where æºå主å
ç in({ds.Tables[0].Rows[0]["æºå主å
ç "].ToString()}) and æºååå
ç in({ds.Tables[0].Rows[0]["æºååå
ç "].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | if (dt.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç产æç»è¡éå¤,éå¤çç产订åå·:"+ ds.Tables[0].Rows[i]["ç产订åå·"].ToString()+",æç»è¡å·:"+ ds.Tables[0].Rows[i]["ç产订åæç»è¡å·"].ToString(); |
| | | objJsonResult.Message = "ç产æç»è¡éå¤,éå¤çç产订åå·:" + ds.Tables[0].Rows[i]["ç产订åå·"].ToString() + ",æç»è¡å·:" + ds.Tables[0].Rows[i]["ç产订åæç»è¡å·"].ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (i == 0) |
| | | { |
| | | //æ·»å åå |
| | | for (int j = 0; j < ds.Tables[0].Columns.Count; j++) |
| | | { |
| | | dtable.Columns.Add(ds.Tables[0].Columns[j].ToString()); |
| | | } |
| | | } |
| | | listdt.Add(ds.Tables[0]); |
| | | } |
| | | |
| | | |
| | | //è·åéåæ°æ® |
| | | for (int i = 0; i < listdt.Count; i++) |
| | | { |
| | | DataRow row = dtable.NewRow(); |
| | | for (int j = 0; j < listdt[i].Columns.Count; j++) |
| | | { |
| | | if (listdt[i].Columns[j].ColumnName == "è®¡åæ°é") |
| | | { |
| | | row[j] = double.Parse(listdt[i].Rows[0][j].ToString()).ToString(); |
| | | } |
| | | else |
| | | { |
| | | row[j] = listdt[i].Rows[0][j].ToString(); |
| | | } |
| | | } |
| | | dtable.Rows.Add(row); |
| | | } |
| | | |
| | | //æ·»å å¨ææ¥æ |
| | | for (int j = 1; j <= 31; j++) |
| | | { |
| | | dtable.Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.data = dtable; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | |
| | | tb2.Columns.Add("HSourceID", typeof(Int32));//çäº§èµæºid |
| | | tb2.Columns.Add("ICMOBillHInterID", typeof(Int32));//ç产订å主id |
| | | tb2.Columns.Add("ICMOBillHEntryID", typeof(Int32));//ç产订ååid |
| | | tb2.Columns.Add("HProdORGID", typeof(Int32));//ç»ç»id |
| | | |
| | | //æ·»å æ°æ® |
| | | for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) |
| | |
| | | { |
| | | //åå·¥ |
| | | ds = oCN.RunProcReturn($"select * from Gy_Employee where HNumber='{tb2.Rows[i]["åå·¥ç¼ç "].ToString()}'", "Gy_Employee"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | if (ds.Tables[0].Rows.Count > 0) { |
| | | tb2.Rows[i]["åå·¥ç¼ç "] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"第{i + 1}è¡,åå·¥æ¥æ æ°æ®!"; |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //计éåä½ |
| | | ds = oCN.RunProcReturn($"select * from Gy_Unit where HNumber='{tb2.Rows[i]["计éåä½"].ToString()}'", "Gy_Unit"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HUnitID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"第{i + 1}è¡,计éå使¥æ æ°æ®!"; |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //çäº§èµæº |
| | | ds = oCN.RunProcReturn($"select * from Gy_Source where HNumber='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}'", "Gy_Source"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HSourceID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | else { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"第{i+1}è¡,çäº§èµæºæ¥æ æ°æ®!"; |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //ç»ç» |
| | | ds = oCN.RunProcReturn($"select * from Xt_ORGANIZATIONS where HNumber='{tb2.Rows[i]["ç»ç»ç¼ç *"].ToString()}'", "Xt_ORGANIZATIONS"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HProdORGID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"第{i + 1}è¡,ç»ç»æ¥æ æ°æ®!"; |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | |
| | | HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//è·å¾ä¸ä¸ªæ°çid |
| | | var HICMOBillNo = list[i]["ç产订åå·*"].ToString(); |
| | | var HICMOEntrySEQ = list[i]["ç产订åæç»è¡å·*"].ToString(); |
| | | var HProdORGID = list[i]["ç»ç»ç¼ç *"].ToString(); |
| | | var HProdORGID = list[i]["HProdORGID"].ToString(); |
| | | var HWorkShopID = list[i]["HWorkShopID"].ToString(); |
| | | var HSourceID = list[i]["HSourceID"].ToString(); |
| | | var HYX = list[i]["ä¼å
级"].ToString(); |
| | |
| | | #region æ¥è®¡åå·¥å å é¤ |
| | | [Route("Sc_WorkBillSortBill/DelWorkBillSortBillList")] |
| | | [HttpGet] |
| | | public object DelWorkBillSortBillList(string HInterID, string HEntryID, string User) |
| | | public object DelWorkBillSortBillList(string HInterID,int DataType, string User) |
| | | { |
| | | try |
| | | { |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1 and hmainid=" + HInterID, "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | //DataType 1=æ¥è®¡åå·¥å å¤éå é¤ 2=æ¥è®¡åå¹³å°å¤éå é¤ |
| | | if (DataType == 1) |
| | | { |
| | | if (ds.Tables[0].Rows[0]["åæ®ç¶æ"].ToString() != "1") |
| | | var NumData = HInterID.Split(','); |
| | | |
| | | for (int i = 0; i < NumData.Length; i++) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½ååæ®ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | var NumData_T = NumData[i].Split('_'); |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1 and hmainid=" + NumData_T[0], "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | if (ds.Tables[0].Rows[0]["åæ®ç¶æ"].ToString() != "1") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½ååæ®ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran();//å¼å¯äºå¡ |
| | | |
| | | if (ds.Tables[0].Rows.Count == 1) |
| | | { |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillMain where HInterID={ NumData_T[0]}"); |
| | | } |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID={ NumData_T[0]} and HEntryID={ NumData_T[1]}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | } |
| | | } |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else if (DataType == 2) |
| | | { |
| | | var NumData = HInterID.Split(','); |
| | | |
| | | oCN.BeginTran();//å¼å¯äºå¡ |
| | | |
| | | if (ds.Tables[0].Rows.Count == 1) |
| | | for (int i = 0; i < NumData.Length; i++) |
| | | { |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillMain where HInterID={HInterID}"); |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1 and hmainid=" + NumData[i], "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | if (ds.Tables[0].Rows[0]["åæ®ç¶æ"].ToString() != "1") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½ååæ®ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran();//å¼å¯äºå¡ |
| | | |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID={ NumData[i]}"); |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillMain where HInterID={ NumData[i]}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | } |
| | | } |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID={HInterID} and HEntryID={HEntryID}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿åï¼"; |
| | |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | |
| | | FentityModel.Add("FBaseRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");// |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥èºè·¯çº¿") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumbers"].ToString() }); // ä»åº |
| | | } |
| | | else if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥åº") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | } |
| | | } |
| | | } |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["HBatchNo"].ToString() }); //æ¹å· |
| | | FentityModel.Add("FISBACKFLUSH", "true");// |
| | | FentityModel.Add("FWorkShopId1", new JObject() { ["FNumber"] = item["HWorkShopNumber"].ToString() }); // çäº§è½¦é´ |
| | |
| | | FentityModel.Add("FBaseRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");// |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥èºè·¯çº¿") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumbers"].ToString() }); // ä»åº |
| | | } |
| | | else if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥åº") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | } |
| | | } |
| | | } |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["HBatchNo"].ToString() }); //æ¹å· |
| | | FentityModel.Add("FISBACKFLUSH", "true");// |
| | | FentityModel.Add("FWorkShopId1", new JObject() { ["FNumber"] = item["HWorkShopNumber"].ToString() }); // çäº§è½¦é´ |
| | |
| | | |
| | | //è·åç³»ç»åæ° |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill(); |
| | | |
| | | #region ç产任å¡å ä¿å/ç¼è¾åè½ |
| | | [Route("Sc_ICMOBill/ICMOBillEdit")] |
| | |
| | | string msg2 = sArray[0].ToString(); //ä¸»è¡¨æ°æ® |
| | | int OperationType = int.Parse(sArray[1].ToString()); // æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ |
| | | string user = sArray[2].ToString(); |
| | | int HEntryID = int.Parse(sArray[3].ToString()); |
| | | |
| | | try |
| | | { |
| | |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
| | | "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + |
| | | ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + " where HInterID=" + HInterID); |
| | | |
| | | //å é¤å表 |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "'"); |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'"); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType); |
| | | objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType, HEntryID); |
| | | |
| | | if (objJsonResult.code == "0") |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType) |
| | | public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType,int HEntryID) |
| | | { |
| | | ClsSc_ICMOBillSub oSub = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSc_ICMOBillSub>(msg3); |
| | | if (oSub.HQty <= 0 || oSub.HQty == null) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (oSub.HBomID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //if (oSub.HBomID == 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | oCN.RunProc($@"Insert into Sc_ICMOBillSub |
| | | (HInterID,HENTRYID,HQty |
| | |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HBomID,HEntryCusID |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterID},1,{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | values({HInterID},{HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,'{(oSub.HBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HBeginDate.ToString())}','{(oSub.HEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HEndDate.ToString())}' |
| | | ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åå®¡æ ¸/åå®¡æ ¸åè½ |
| | | [Route("Sc_ICMOBill/CheckSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CheckSc_ICMOReportBill(string HInterID,int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Check", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéå®¡æ ¸!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 å®¡æ ¸ 2 åå®¡æ ¸ |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl"); |
| | | //if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = "该任å¡å已䏿¨æµè½¬å¡ï¼ä¸å
许åå®¡æ ¸" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]); |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åå
³é/åå
³éåè½ |
| | | [Route("Sc_ICMOBill/CloseSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CloseSc_ICMOReportBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Close", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéå
³é!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 å
³é 2 åå
³é |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å
³é失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (!BillOld.CancelClose(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åå
³é失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åä½åº/åä½åºåè½ |
| | | [Route("Sc_ICMOBill/CancellSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CancellSc_ICMOReportBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Delete", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéä½åº!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 ä½åº 2 åä½åº |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.Cancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (!BillOld.AbandonCancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region ç产任å¡åå é¤åè½ |
| | | [Route("Sc_ICMOBill/DeltetSc_ICMOReportBill")] |
| | | [HttpGet] |
| | |
| | | return list; |
| | | } |
| | | |
| | | ///å·¥åºè¿å·¥ç³è¯·å 主表 |
| | | ///ClsSc_ProcExchWorkBackBillMain |
| | | public List<Model.ClsSc_ProcExchWorkBackBillMain> getObjectByJson_ClsSc_ProcExchWorkBackBillMain(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Model.ClsSc_ProcExchWorkBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchWorkBackBillMain>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | ///å·¥åºè¿å·¥ç³è¯·å å表 |
| | | ///ClsSb_EquipStockInCheckBillSub |
| | | public List<Model.ClsSc_ProcExchWorkBackBillSub> getObjectByJson_ClsSc_ProcExchWorkBackBillSub(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Model.ClsSc_ProcExchWorkBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchWorkBackBillSub>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | ///è®¾å¤æäº§æ£éªéªæ¶å å表 |
| | | ///ClsSb_EquipWorkBeforeCheckBillSub |
| | | public List<Model.ClsSb_EquipWorkBeforeCheckBillSub> getObjectByJson_ClsSb_EquipWorkBeforeCheckBillSub(string jsonString) |
| | |
| | | public string HProcCheckNote = ""; // varchar(2000) æ¬å·¥åºç¡®è®¤è®°å½ |
| | | public string HProcWorkNum = ""; // varchar(100) ç¨åºå· |
| | | |
| | | //ççªæ°å åæ®µ |
| | | public int HBadWHID { get; set; } //ä¸è¯åä» |
| | | public int HWasterWHID { get; set; } //æ¥åºä» |
| | | public int HWHID { get; set; } //è¯åä» |
| | | |
| | | } |
| | | } |
| | |
| | | <Compile Include="Controllers\CJGL\Cj_StationOutBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationInBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Sc_ProcExchWorkBackBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Sc_WorkBillAutoSortBillMainController.cs" /> |
| | | <Compile Include="Controllers\Gy_MateMouldController.cs" /> |
| | | <Compile Include="Controllers\Gy_StdMinPickQtyController.cs" /> |
| | |
| | | <Folder Include="Views\Sc_MouldRepairSendWorkBill\" /> |
| | | <Folder Include="Views\Sc_MouldScrapRequestBill\" /> |
| | | <Folder Include="Views\Sc_MouldStatusChangeBill\" /> |
| | | <Folder Include="Views\Sc_ProcessExchangeIssueBill\" /> |
| | | <Folder Include="Views\Sc_WorkBillAutoSortBillMain\" /> |
| | | <Folder Include="Views\Sc_WorkBillSortBill\" /> |
| | | <Folder Include="Views\Sc_WorkDemandPlanBill\" /> |