Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | ",HMaterID,HMaterNumber,HMouldType,HUnitID" + |
| | | ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" + |
| | | ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" + |
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
| | |
| | | "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID + |
| | | ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" + |
| | | "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID +","+ HCaveQty+ |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + |
| | | "','" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID+"','"+ HMouldMaintainRuleInterID+"'"+ |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID+"','"+ HNowSupTypeID+"'"+ |
| | | ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID+"','"+ HMouldMaintainRuleInterID+"'"+ |
| | | ") "); |
| | | |
| | | |
| | |
| | | ",HMouldDotCheckRuleInterID="+ HMouldDotCheckRuleInterID.ToString()+ |
| | | ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() + |
| | | ",HMouldOWNER='" + HMouldOWNER + "'" + |
| | | ",HNowSupID="+HNowSupID.ToString()+ |
| | | ",HNowSupTypeID="+HNowSupTypeID.ToString()+ |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_PurchaseReturnList " + sWhere, "h_v_Kf_PurchaseReturnList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_PurchaseReturnList " , "h_v_Kf_PurchaseReturnList"); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = Sc_GetProductInBill(sWhere); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ProductionReturnList where 1=1 order by æ¥æ desc", "h_v_IF_ProductionReturnList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_IF_ProductionReturnList where 1 = 1 " + sWhere + " order by æ¥æ desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ProductionReturnList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #region sqlè¯å¥ |
| | | |
| | | |
| | | public static DataSet Sc_GetProductInBill(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProductionReturnList order by æ¥æ desc", "h_v_IF_ProductionReturnList"); |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_OtherOutBillList where 1=1 order by æ¥æ desc", "h_v_Kf_OtherOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_Kf_OtherOutBillList where 1 = 1 " + sWhere+ " order by æ¥æ desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherOutBillList"); |
| | | } |
| | | |
| | | ds = Sc_GetOtherOutBillList(sWhere); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #region sqlè¯å¥ |
| | | |
| | | |
| | | public static DataSet Sc_GetOtherOutBillList(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_OtherOutBillList order by æ¥æ desc", "h_v_Kf_OtherOutBillList"); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | /// <summary> |
| | |
| | | try |
| | | { |
| | | |
| | | ds = Sc_GetProductInBill(sWhere); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where 1=1 order by æ¥æ desc", "h_v_IF_ProductInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_IF_ProductInBillList where 1 = 1 " + sWhere + " order by æ¥æ desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ProductInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | ///产åå
¥åºåå é¤åè½ |
| | | /// </summary> |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #region sqlè¯å¥ |
| | | |
| | | |
| | | public static DataSet Sc_GetProductInBill(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProductInBillList order by æ¥æ desc", "h_v_IF_ProductInBillList"); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | |
| | | try |
| | | { |
| | | |
| | | ds = Sc_GetOtherInBill(sWhere); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_OtherInBillList where 1=1 order by æ¥æ desc", "h_v_Kf_OtherInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_Kf_OtherInBillList where 1 = 1 " + sWhere+ " order by æ¥æ desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #region sqlè¯å¥ |
| | | |
| | | |
| | | public static DataSet Sc_GetOtherInBill(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_OtherInBillList order by æ¥æ desc ", "h_v_Kf_OtherInBillList"); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | /// <summary> |
| | | /// å§å¤å
¥åºåå表 |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = Sc_GetEntrustInBill(sWhere); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustInBillList where 1=1", "h_v_Kf_EntrustInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_Kf_EntrustInBillList where 1 = 1 " + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Kf_EntrustInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #region sqlè¯å¥ |
| | | |
| | | |
| | | public static DataSet Sc_GetEntrustInBill(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Kf_EntrustInBillList ", "h_v_Kf_EntrustInBillList"); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | //æµè¯ä¸ç¨æ¥å£ |
| | | [Route("LookingFor/Test")] |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBackBillList order by æ¥æ desc", "h_v_IF_MateOutBackBillList"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBackBillList order by æ¥æ desc", "h_v_IF_MateOutBackBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_IF_MateOutBackBillList " + sWhere+ " order by æ¥æ desc"; |
| | | ds = oCn.RunProcReturn(sql, "h_v_IF_MateOutBackBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Web; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers.ä»å管ç.éªæ¶å
¥åº |
| | | { |
| | | public class Kf_StepFoldinBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus;//åæ®ç¶æï¼æ°å¢ï¼ä¿®æ¹ï¼æµè§ï¼æ´æ°åä»·ï¼åæ´ï¼ |
| | | private json objJsonResult = new json(); |
| | | public DataSet ds = new DataSet(); |
| | | public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | #region å§å¤å å·¥åºåºå |
| | | |
| | | [Route("Kf_StepFoldinBill/GetStepFoldinBillList")] |
| | | [HttpGet] |
| | | public object GetStepFoldinBillList(string sWhere, string user, string Organization) |
| | | { |
| | | try |
| | | { |
| | | //夿æé(ç¥) |
| | | |
| | | string sql1 = string.Format("select * from h_v_Kf_MoveStockStepInBillList where (è°å
¥ç»ç»='" + Organization + "')"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCn.RunProcReturn(sql1 + " order by æ¥æ desc", "h_v_Kf_MoveStockStepInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by æ¥æ desc"; |
| | | ds = oCn.RunProcReturn(sql, "h_v_Kf_MoveStockStepInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + ex.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | ScanLineCode list = js.Deserialize<ScanLineCode>(msg.ToString()); //å°jsonæ°æ®è½¬å为对象类åå¹¶èµå¼ç»list |
| | | if (list.billno != "" && list.billno != null) //ä»»å¡åå·ï¼éå¿
é¡»ï¼éç©ºåæ ¡éªbarcodesébarcodeæ¯å¦ç±æ¤ä»»å¡åå¶ä½çæç |
| | | { |
| | | ds = oCN.RunProcReturn("Select HBarCode barcode from Gy_BarCodeBill where HSourceBillNo='" + list.billno.ToString().Trim()+"' Order by HItemID ", "Gy_BarCodeBill"); |
| | | ds = oCN.RunProcReturn("Select HBarCode barcode,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType from Gy_BarCodeBill where HSourceBillNo='" + list.billno.ToString().Trim()+"' Order by HItemID ", "Gy_BarCodeBill"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.status = -1; |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select * from Gy_BarCodeBill where HBarCode='" + packagebarcode.ToString().Trim() + "'", "Gy_BarCodeBill"); |
| | | //夿æ¯å¦å
¥åº |
| | | ds = oCN.RunProcReturn("select * from Sc_ScanLineInStock where HBarCode_Pack='" + packagebarcode + "'", "Sc_ScanLineInStock"); |
| | | if (ds!= null && ds.Tables[0].Rows.Count>0) |
| | | { |
| | | objJsonResult.status = -1; |
| | | objJsonResult.msg = "该箱æ¡ç å·²å
¥åºä¸å
è®¸åæ¶!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("Select 1 from Gy_BarCodeBill where HBarCode='" + packagebarcode.ToString().Trim() + "'", "Gy_BarCodeBill"); |
| | | if (ds == null && ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.status = -1; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("Select * from Gy_BarCodeBill where HBarCode='" + packagebarcode.ToString().Trim() + "' and HStopflag='1'", "Gy_BarCodeBill"); |
| | | ds = oCN.RunProcReturn("Select 1 from Gy_BarCodeBill where HBarCode='" + packagebarcode.ToString().Trim() + "' and HStopflag='1'", "Gy_BarCodeBill"); |
| | | if (ds != null && ds.Tables[0].Rows.Count>0) |
| | | { |
| | | objJsonResult.status = -1; |
| | |
| | | |
| | | // |
| | | oCN.BeginTran(); |
| | | //å é¤SUM主表 |
| | | oCN.RunProc("Delete From Sc_PackUnionBillSub_Sum where HBarCode_Pack='" + packagebarcode.ToString() + "'"); |
| | | //å é¤å表 |
| | | oCN.RunProc("Delete From Sc_PackUnionBillSub where HBarCode_Pack='"+ packagebarcode.ToString() + "'"); |
| | | //å é¤ä¸»è¡¨ |
| | | oCN.RunProc("Delete From Sc_PackUnionBillMain where HBarCode_Pack='" + packagebarcode.ToString() + "'"); |
| | | //ä½åºæ¡ç æ¡£æ¡è¡¨ |
| | | oCN.RunProc("Update Gy_BarCodeBill set HStopflag='1' where HBarCode='"+ packagebarcode .ToString()+ "'"); |
| | | oCN.RunProc("Update Gy_BarCodeBill set HStopflag='1' where HBarCode='"+ packagebarcode.ToString()+ "'"); |
| | | |
| | | oCN.Commit(); |
| | | |
| | |
| | | left join Gy_Customer c1 on m.HNowSupID=c1.HItemID |
| | | left join Gy_Warehouse w on k.HCorrespondentID=w.HItemID |
| | | left join Gy_Warehouse w1 on m.HNowSupID=w1.HItemID |
| | | where k.HBillType='3822' and " + sWhere); |
| | | where " + sWhere); |
| | | } |
| | | else |
| | | { |
| | |
| | | left join Gy_Customer c1 on m.HNowSupID=c1.HItemID |
| | | left join Gy_Warehouse w on k.HCorrespondentID=w.HItemID |
| | | left join Gy_Warehouse w1 on m.HNowSupID=w1.HItemID |
| | | where k.HBillType='3822' and " + sWhere + " and k.HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and k.HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ")"); |
| | | where " + sWhere + " and k.HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and k.HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ")"); |
| | | } |
| | | ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain_Temp"); |
| | | list.Add(ds.Tables[0]); |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region çç¹è®°å½å表 |
| | | [Route("Gy_StockCheckItemBill/Get_MouldStockBillMainTemp")] |
| | | [HttpGet] |
| | | public object Get_MouldStockBillMainTemp(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = MouldStockBillMainTemp(sWhere); |
| | | if (ds == null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | public static DataSet MouldStockBillMainTemp(string sWhere) |
| | | { |
| | | string sql1 = string.Format(@"select * from h_v_Gy_MouldStockBillMainTempList where 1=1 "); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by å¶åæ¥æ desc", "h_v_Gy_MouldStockBillMainTempList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by å¶åæ¥æ desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_MouldStockBillMainTempList"); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region [çç¹æ¹æ¡å é¤åè½] |
| | | [Route("Gy_StockCheckItemBill/set_DeleteBill_Temp")] |
| | | [HttpGet] |
| | | public object set_DeleteBill_Temp(string HItemID) |
| | | { |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(HItemID); |
| | | if (lngBillKey == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCn.RunProcReturn("select * from Sc_MouldStockBillMain_Temp where HItemID=" + lngBillKey, "Sc_MouldStockBillMain_Temp"); |
| | | if (ds != null) |
| | | { |
| | | oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HItemID=" + lngBillKey); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤åæ®ä¸åå¨ï¼è¯·æ¥çæ¯å¦éå¤å é¤"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region çç¹åæå®¡æ ¸ |
| | | #region è°æ¨âç´æ¥è°æ¨ |
| | | [Route("Gy_StockCheckItemBill/MakeProdMove")] |
| | | [Route("Gy_StockCheckItemBill/MakeProdMove")] |
| | | [HttpGet] |
| | | public object MakeProdMove(string HBarCode, string user, string userID) |
| | | { |
| | |
| | | //æ°å¢åæ® |
| | | public override bool AddBill(ref string sReturn) |
| | | { |
| | | string ww = ""; |
| | | try |
| | | { |
| | | //å¾å°mainid |
| | |
| | | " values(" + omodel.HYear + "," + omodel.HPeriod + ",'" + this.BillType + "'," + omodel.HInterID + "" + |
| | | ",'" + omodel.HDate + "','" + omodel.HBillNo.ToString() + "'," + omodel.HBillStatus + ",'" + omodel.HRemark + "'," + omodel.HICMOInterID + "" + |
| | | ",'" + omodel.HICMOBillNo.ToString() + "','" + omodel.HBarCode_Pack.ToString() + "'," + omodel.HMaterID + "," + omodel.HUnitID + "" + |
| | | ",'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.GetServerDate(-1) + "'" + |
| | | ",'Admin','" + DBUtility.ClsPub.GetServerDate(-1) + "'" + |
| | | ") "); |
| | | ////æå
¥å表 |
| | | string HSourceInterID = "0"; |
| | |
| | | //Int64 ZHInterID = DBUtility.ClsPub.CreateBillID_Prod("85", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.RunProc("insert into Gy_BarCodeBill(HInterID,HEntryID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HBatchNo,HMakeDate " + |
| | | ",HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HUseFlag, HStopflag, HSupID, HGroupID, HPrintQty)" + |
| | | "values('" + HSourceInterID + "', 1, '" + omodel.HBarCode_Pack + "', 'ç®±å·æ¡ç ', '" + HMaterID + "', '" + HUnitID + "','" + HQty + "', '', getdate()" + |
| | | "values('" + HSourceInterID + "', 1, '" + omodel.HBarCode_Pack + "', 'æçæ¡ç ', '" + HMaterID + "', '" + HUnitID + "','" + HQty + "', '', getdate()" + |
| | | ", '" + HSourceInterID + "', '" + HSourceEntryID + "', '" + HSourceBillNo + "', '" + HSourceBillType + "', 1, 0, 0, 0, 0)"); |
| | | oCn.RunProcReturn("exec h_p_Sc_PackUnionBill_SumSubBill2 " + omodel.HInterID + ",'"+ omodel.HBillNo.ToString() + "','"+ this.BillType + "','Admin'", "h_p_JIT_MESBeginWorkBill_SaveCtrl"); |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | |
| | | <Compile Include="Controllers\SCGL\Sc_ProductionReturnBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_PackUnionBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_ProcessMangementController.cs" /> |
| | | <Compile Include="Controllers\ä»å管ç\éªæ¶å
¥åº\Kf_StepFoldinBillController.cs" /> |
| | | <Compile Include="Controllers\忥èªå¨æ«ç 线\ScanlineAPIController.cs" /> |
| | | <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_StockCheckItemBillController.cs" /> |
| | | <Compile Include="Controllers\å·¥èµç®¡ç\Gy_ClassTimePrjBillController.cs" /> |
| | |
| | | <Folder Include="Views\Cg_PurchaseReturn\" /> |
| | | <Folder Include="Views\Gy_EquipType\" /> |
| | | <Folder Include="Views\Kf_ICStockBillMain\" /> |
| | | <Folder Include="Views\kf_StepFoldinBill\" /> |
| | | <Folder Include="Views\MoveStockBill\" /> |
| | | <Folder Include="Views\ProductionReturnBill\" /> |
| | | <Folder Include="Views\QC_Management\" /> |