桌面版工序流转卡单据号获取方法修改,PDA出入库缓存列表删除、撤销,模具缓存列表删除调用方法增加写入日志
| | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string ComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | |
| | | #region å¨å
·æ«ç 模åè°ç¨æ¹æ³ |
| | |
| | | /// <returns></returns> |
| | | [Route("MouldController/set_DeleteMouldBillList_Json")] |
| | | [HttpGet] |
| | | public object set_DeleteMouldBillList_Json(long HInterID, string HBillType) |
| | | public object set_DeleteMouldBillList_Json(long HInterID, string HBillNo, string HBillType, string HMaker, string MvarReportTitle) |
| | | { |
| | | try |
| | | { |
| | | string WorkList = "å é¤ç¼ååæ®ï¼åæ®å·ï¼" + HBillNo; |
| | | string SystemName = "WMS-" + MvarReportTitle + "模å"; |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //åå
¥æ¥å¿ |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + HMaker + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','','å é¤')" |
| | | ); |
| | | oCn.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿å"; |
| | | objJsonResult.Message = "åæ®å·ï¼" + HBillNo + " å 餿å"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¨å
·ç¼ååè¡¨åæ®å¤±è´¥ï¼" + e.ToString(); |
| | |
| | | public WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | public WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string ComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | |
| | | WebS.ClsXt_SystemParameterMain oSystemParameterMain = new WebS.ClsXt_SystemParameterMain(); |
| | |
| | | if (oSystemParameter.ShowBill(ref sErrMsg) == true) |
| | | { |
| | | //夿æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightName, 1, false, HUserName)) |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightName, 3, false, HUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | /// å·²ä¸ä¼ å表çé¢ï¼æ¤éåè½ï¼å é¤WMSè¡¨åæ¬å°åºå
¥åºåè®°å½ï¼å¹¶æ´æ°TEMP表ä¸çä¸ä¼ åæ®µ HRelationInterID=0 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/set_DeleteICStockBillAndWMS_Json")] |
| | | [HttpGet] |
| | | public object set_DeleteICStockBillAndWMS_Json(Int64 HInterID, string HBillNo, string HBillType, string HMaker, string MvarReportTitle) |
| | | { |
| | | try |
| | | { |
| | | string WorkList = "æ¤éå·²ä¸ä¼ åæ®ï¼åæ®å·ï¼" + HBillNo; |
| | | string SystemName = "WMS-" + MvarReportTitle + "模å"; |
| | | oCn.BeginTran(); |
| | | ds = oCn.RunProcReturn("exec h_p_WMS_ICStockBillAndWMS_Delete " + HInterID + ",'" + HBillNo + "','" + HBillType + "'", "h_p_WMS_ICStockBillAndWMS_Delete"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é忮已ä¸ä¼ è®°å½å¤±è´¥ï¼æ¤é忮夿é误ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; //å¤±è´¥ï¼ |
| | | objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | //åå
¥æ¥å¿ |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + HMaker + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','','æ¤é')" |
| | | ); |
| | | oCn.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; //æåï¼ |
| | | objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é忮已ä¸ä¼ è®°å½å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å·²ä¸ä¼ å表çé¢ï¼æ¤éåè½ï¼å é¤WMSè¡¨åæ¬å°åºå
¥åºåè®°å½ï¼å¹¶æ´æ°TEMP表ä¸çä¸ä¼ åæ®µ HRelationInterID=0 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/DeleteICStockBillAndWMS_Json")] |
| | | [HttpGet] |
| | | public object DeleteICStockBillAndWMS_Json(Int64 HInterID, string HBillNo, string HBillType) |
| | |
| | | #region æ¡ç åºå
¥åºç¼åå表模å å é¤ç¼ååè¡¨åæ® |
| | | |
| | | /// <summary> |
| | | /// å é¤ç¼ååè¡¨åæ®ï¼åå
¥æ¥å¿ 20240619 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/set_DelPonderationBillMain_Temp_New_Json")] |
| | | [HttpGet] |
| | | public object set_DelPonderationBillMain_Temp_New_Json(long HInterID, string HBillNo, string HBillType, string HMaker, string MvarReportTitle) |
| | | { |
| | | try |
| | | { |
| | | string WorkList = "å é¤ç¼ååæ®ï¼åæ®å·ï¼" + HBillNo; |
| | | string SystemName = "WMS-" + MvarReportTitle + "模å"; |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //åå
¥æ¥å¿ |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + HMaker + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','','å é¤')" |
| | | ); |
| | | oCn.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åæ®å·ï¼" + HBillNo + " å 餿å"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å 餿¡ç åºå
¥åºç¼ååè¡¨åæ®å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å é¤ç¼ååè¡¨åæ® |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | <!--<add key="FileIP" value="http://localhost:8082/LuBaoAPI"/>--> |
| | | <!--<add key="FileIP" value="http://localhost:8080/" />--> |
| | | <!--<add key="sUrl" value="http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx"/> --> |
| | | <!--<add key="sUrl" value="http://192.168.0.81/WEBS-WMS/WebService1.asmx"/> --><!--é¢å°å¼æº--> |
| | | <add key="sUrl" value="http://192.168.0.81/WEBS-WMS/WebService1.asmx"/> <!--é¢å°å¼æº--> |
| | | <!--<add key="sUrl" value="http://60.190.4.42:9003/WebService/WebService1.asmx" /> å¤å®--> |
| | | <!--<add key="sUrl" value="http://60.190.4.42:9003/WebService/WebService1.asmx" /> --> |
| | | <!--<add key="sUrl" value="http://10.10.130.181/WEBS-WMS/WebService1.asmx"/> åæ¥ç§æ--> |
| | |
| | | </basicHttpBinding> |
| | | </bindings> |
| | | <client> |
| | | <endpoint address="http://61.130.182.102:18181/WEBSCS/WebService1.asmx" binding="basicHttpBinding" |
| | | <endpoint address="http://192.168.0.81/WEBS-WMS/WebService1.asmx" binding="basicHttpBinding" |
| | | bindingConfiguration="WebService1Soap" contract="Webs1.WebService1Soap" |
| | | name="WebService1Soap" /> |
| | | </client> |
| | |
| | | <applicationSettings> |
| | | <WebAPI.Properties.Settings> |
| | | <setting name="WebAPI_WebS_WebService1" serializeAs="String"> |
| | | <value>http://61.130.182.102:18181/WEBSCS/WebService1.asmx</value> |
| | | <value>http://192.168.0.81/WEBS-WMS/WebService1.asmx</value> |
| | | </setting> |
| | | </WebAPI.Properties.Settings> |
| | | </applicationSettings> |
| | |
| | | this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; |
| | | this.Sub_OperStatus();//设置TOOLBAR |
| | | this.Sub_ClearBill();//æ¸
空çé¢ |
| | | this.txtHBillNo.Text = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//å¾å°æ°åå· |
| | | //this.txtHBillNo.Text = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//å¾å°æ°åå· |
| | | this.txtHBillNo.Text = ClsPub.CreateBillCode_Prod(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//å¾å°æ°åå· 20240620è¿å弿¹ååå¨è¿ç¨ |
| | | this.txtHBillNo.Enabled = true; |
| | | this.txtHBillNo.Focus(); |
| | | //ç°åº¦æºåç±»å |
| | |
| | | string sNo = ""; |
| | | int row = oTable.Rows.Count - 1; |
| | | |
| | | //è·åç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | Ds = oCn.RunProcReturn("select HValue from Xt_SystemParameter with(nolock) where HKey='WMS_CampanyName'", "Xt_SystemParameter", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | MessageBox.Show("è·åç³»ç»åæ°å¤±è´¥ï¼åå :" + DBUtility.ClsPub.sExeReturnInfo, "æç¤º"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | CampanyName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HValue"]); |
| | | } |
| | | if (CampanyName == "å¯è´å¥ç¹") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | { |
| | | ////è·åç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | //Ds = oCn.RunProcReturn("select HValue from Xt_SystemParameter with(nolock) where HKey='WMS_CampanyName'", "Xt_SystemParameter", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | //{ |
| | | // MessageBox.Show("è·åç³»ç»åæ°å¤±è´¥ï¼åå :" + DBUtility.ClsPub.sExeReturnInfo, "æç¤º"); |
| | | // return; |
| | | //} |
| | | //else |
| | | //{ |
| | | // CampanyName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HValue"]); |
| | | //} |
| | | //if (CampanyName == "å¯è´å¥ç¹") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | //{ |
| | | |
| | | } |
| | | else |
| | | { |
| | | //è·åå½åæ¹çäº§è®¢å æå¤§æµè½¬å¡å·ï¼å¹¶ç´¯è®¡å¢å 1ã |
| | | //æºè§åå·- å¹´ææ¥20200701+001 |
| | | string sOldNo = ""; |
| | | //Ds = oCn.RunProcReturn("select top 1 HBillNo from Sc_ProcessExchangeBillmain where hicmointerid=" + oTable.Rows[row]["hmainid"].ToString() + " order by LEN(HBillno) desc, HbillNo desc ", "Sc_ProcessExchangeBillmain"); |
| | | //} |
| | | //else |
| | | //{ |
| | | // //è·åå½åæ¹çäº§è®¢å æå¤§æµè½¬å¡å·ï¼å¹¶ç´¯è®¡å¢å 1ã |
| | | // //æºè§åå·- å¹´ææ¥20200701+001 |
| | | // string sOldNo = ""; |
| | | // //Ds = oCn.RunProcReturn("select top 1 HBillNo from Sc_ProcessExchangeBillmain where hicmointerid=" + oTable.Rows[row]["hmainid"].ToString() + " order by LEN(HBillno) desc, HbillNo desc ", "Sc_ProcessExchangeBillmain"); |
| | | |
| | | Ds = oCn.RunProcReturn("select top 1 HBillNo from Sc_ProcessExchangeBillmain where HDate='" + dtpHDate.Value.ToShortDateString() + "' and HBillSubType<>'Split' order by HbillNo desc ", "Sc_ProcessExchangeBillmain"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sNo = "001"; |
| | | } |
| | | else |
| | | { |
| | | sOldNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillNo"]); |
| | | sOldNo = sOldNo.Substring(sOldNo.Length - 3, 3); |
| | | //if (sOldNo.Substring(0, 1) == "0" || sOldNo.Substring(0, 1) == "-") |
| | | //{ |
| | | // sOldNo = sOldNo.Substring(sOldNo.Length - 2, 2); |
| | | // if (sOldNo.Substring(0, 1) == "0") |
| | | // { |
| | | // sOldNo = sOldNo.Substring(sOldNo.Length - 1, 1); |
| | | // } |
| | | //} |
| | | sNo = "0000" + DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isLong(sOldNo) + 1); |
| | | } |
| | | // Ds = oCn.RunProcReturn("select top 1 HBillNo from Sc_ProcessExchangeBillmain where HDate='" + dtpHDate.Value.ToShortDateString() + "' and HBillSubType<>'Split' order by HbillNo desc ", "Sc_ProcessExchangeBillmain"); |
| | | // if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | // { |
| | | // sNo = "001"; |
| | | // } |
| | | // else |
| | | // { |
| | | // sOldNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillNo"]); |
| | | // sOldNo = sOldNo.Substring(sOldNo.Length - 3, 3); |
| | | // //if (sOldNo.Substring(0, 1) == "0" || sOldNo.Substring(0, 1) == "-") |
| | | // //{ |
| | | // // sOldNo = sOldNo.Substring(sOldNo.Length - 2, 2); |
| | | // // if (sOldNo.Substring(0, 1) == "0") |
| | | // // { |
| | | // // sOldNo = sOldNo.Substring(sOldNo.Length - 1, 1); |
| | | // // } |
| | | // //} |
| | | // sNo = "0000" + DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isLong(sOldNo) + 1); |
| | | // } |
| | | |
| | | sNo = sNo.Substring(sNo.Length - 3, 3); |
| | | //initGrid(); |
| | | //initGrid_Sub(); |
| | | //string sBillNo = oTable.Rows[row]["ç产订åå·"].ToString(); |
| | | string sYear = dtpHDate.Value.Year.ToString(); |
| | | string sMonth = "00" + dtpHDate.Value.Month.ToString(); |
| | | string sDay = "00" + dtpHDate.Value.Day.ToString(); |
| | | string sBillNo = sYear + sMonth.Substring(sMonth.Length - 2, 2) + sDay.Substring(sDay.Length - 2, 2); |
| | | //sBillNo = sBillNo.Replace("WORKX", ""); |
| | | //sBillNo = sBillNo.Replace("WORK", ""); |
| | | //sBillNo = sBillNo.Replace("_", "-"); |
| | | sBillNo = sBillNo + "-" + sNo; |
| | | txtHBillNo.Text = sBillNo; |
| | | } |
| | | // sNo = sNo.Substring(sNo.Length - 3, 3); |
| | | // //initGrid(); |
| | | // //initGrid_Sub(); |
| | | // //string sBillNo = oTable.Rows[row]["ç产订åå·"].ToString(); |
| | | // string sYear = dtpHDate.Value.Year.ToString(); |
| | | // string sMonth = "00" + dtpHDate.Value.Month.ToString(); |
| | | // string sDay = "00" + dtpHDate.Value.Day.ToString(); |
| | | // string sBillNo = sYear + sMonth.Substring(sMonth.Length - 2, 2) + sDay.Substring(sDay.Length - 2, 2); |
| | | // //sBillNo = sBillNo.Replace("WORKX", ""); |
| | | // //sBillNo = sBillNo.Replace("WORK", ""); |
| | | // //sBillNo = sBillNo.Replace("_", "-"); |
| | | // sBillNo = sBillNo + "-" + sNo; |
| | | // txtHBillNo.Text = sBillNo; |
| | | //} |
| | | |
| | | |
| | | |