From 224715c790bb0c8c95426585b2b4e5c21b9dc9f4 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 20 八月 2021 19:20:25 +0800 Subject: [PATCH] nothing --- DBUtility/obj/Release/DBUtility.Xt_CheckFlowList.resources | 0 DBUtility/obj/Release/build.force | 0 WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 150 +++++----- WebAPI/WebAPI.csproj.user | 2 DBUtility/obj/Release/DBUtility.Xt_BillCheckFlowStatusNow.resources | 0 DBUtility/obj/Release/DBUtility.frmBillQueryCondition_New.resources | 0 WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs | 50 --- DBUtility/obj/Release/DBUtility.Xt_CheckItem.resources | 0 DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache | 0 WarM/条码打印/Gy_BarCodeBill.cs | 61 +++ DAL/基础资料/InterFace基础资料/ClsIF_Property_View.cs | 73 ++++ DBUtility/obj/Release/DBUtility.Gy_UserSelect.resources | 0 DBUtility/obj/Release/DBUtility.frm_B_BillQueryCondition_New.resources | 0 DBUtility/obj/Release/DBUtility.pdb | 0 DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache | 0 DBUtility/obj/Release/DBUtility.Xt_Wait.resources | 0 DBUtility/obj/Release/DBUtility.dll | 0 WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs | 68 ++-- WebAPI/Models/基础资料/Gy_Process.cs | 40 ++ DBUtility/obj/Release/DBUtility.Xt_CheckFlow.resources | 0 DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache | 0 DBUtility/obj/Release/.NETFramework,Version=v4.0.AssemblyAttributes.cs | 4 WebAPI/Controllers/BaseSet/Gy_GroupController.cs | 70 ++-- DBUtility/obj/Release/DBUtility.Xt_BillType.resources | 0 WebAPI/Controllers/CJGL/Cj_StationInBillController.cs | 136 ++++++-- DBUtility/obj/Release/DBUtility.Xt_CheckUserRight.resources | 0 WebAPI/Controllers/BaseSet/Gy_ProcessController.cs | 175 +++++++++++ DBUtility/obj/Release/DBUtility.FrmSelectDate.resources | 0 DBUtility/obj/Release/DBUtility.Xt_ProcessWait.resources | 0 DBUtility/obj/Release/ResolveAssemblyReference.cache | 0 WebAPI/WebAPI.csproj | 1 LMES/bin/x86/HXERP.ini | 37 ++ 32 files changed, 620 insertions(+), 247 deletions(-) diff --git "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs" "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs" index 261d7c2..c713d91 100644 --- "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs" +++ "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs" @@ -2,6 +2,7 @@ using System.Collections.Generic; using System.Text; using System.Data; +using DBUtility; namespace DAL { @@ -17,8 +18,10 @@ public ClsIF_Property_View() { base.MvarReportTitle = "杈呭姪灞炴�ц缃�"; - base.MvarItemKey = "h_v_IF_Property"; - base.SQLName = "Select HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_Property where HStopflag=0 "; + base.MvarItemKey = "h_v_IF_PropertyByMaterID"; + base.SQLName = "Select HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_PropertyByMaterID "; + base.SQLWhere = " where HStopflag=0 "; + base.SQLOrder = " "; //涓嬫媺SQL base.SQLNameForDown = " Select top 30 HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_Property "; base.SQLOrderForDown = " Order by HNumber "; @@ -94,5 +97,71 @@ throw (e); } } + + /// <summary> + /// 鍩虹璧勬枡甯姪-鍏ㄩ儴鍨� + /// </summary> + /// <returns></returns> + public override bool RefreshView(string sLike) + { + try + {// + Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View(); + // + string sSQL = SQLName + SQLWhere + sLike + SQLOrder; + //缂栬緫ofrm + ofrm.sTitle = MvarReportTitle; + ofrm.sBill = MvarItemKey; + ofrm.txtFindInfo.Text = WherePart; + + // + DataSet Ds; + Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); + Ds = oCn.RunProcReturn(sSQL, MvarItemKey); + if (Ds == null || Ds.Tables[0].Rows.Count == 0) + { + return false; + } + + //缁戝畾 + ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView; + Ds.Dispose(); + Ds = null; + ofrm.grdShow.SuspendLayout(); + ofrm.grdShow.Columns[0].Visible = false; + ofrm.ShowDialog(); + //寰楀埌瀵瑰簲鍒� + int HItemIDCol = 0; + int HNumberCol = 1; + int HNameCol = 2; + // + if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) + { + if (ofrm.grdShow.CurrentRow == null) + { + return false; + } + oModel = new ClsGy_Base_Model(); + oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value); + oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value); + oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value); + } + else + { + return false; + } + // + ofrm.Dispose(); + ofrm = null; + // + return true; + } + catch (Exception e) + { + throw (e); + } + } + + } } diff --git a/DBUtility/obj/Release/.NETFramework,Version=v4.0.AssemblyAttributes.cs b/DBUtility/obj/Release/.NETFramework,Version=v4.0.AssemblyAttributes.cs new file mode 100644 index 0000000..5d01041 --- /dev/null +++ b/DBUtility/obj/Release/.NETFramework,Version=v4.0.AssemblyAttributes.cs @@ -0,0 +1,4 @@ +// <autogenerated /> +using System; +using System.Reflection; +[assembly: global::System.Runtime.Versioning.TargetFrameworkAttribute(".NETFramework,Version=v4.0", FrameworkDisplayName = ".NET Framework 4")] diff --git a/DBUtility/obj/Release/DBUtility.FrmSelectDate.resources b/DBUtility/obj/Release/DBUtility.FrmSelectDate.resources new file mode 100644 index 0000000..06c24d0 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.FrmSelectDate.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Gy_UserSelect.resources b/DBUtility/obj/Release/DBUtility.Gy_UserSelect.resources new file mode 100644 index 0000000..a123754 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Gy_UserSelect.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_BillCheckFlowStatusNow.resources b/DBUtility/obj/Release/DBUtility.Xt_BillCheckFlowStatusNow.resources new file mode 100644 index 0000000..06c24d0 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_BillCheckFlowStatusNow.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_BillType.resources b/DBUtility/obj/Release/DBUtility.Xt_BillType.resources new file mode 100644 index 0000000..4e0d7a1 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_BillType.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_CheckFlow.resources b/DBUtility/obj/Release/DBUtility.Xt_CheckFlow.resources new file mode 100644 index 0000000..eed8fed --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_CheckFlow.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_CheckFlowList.resources b/DBUtility/obj/Release/DBUtility.Xt_CheckFlowList.resources new file mode 100644 index 0000000..bd0c9a1 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_CheckFlowList.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_CheckItem.resources b/DBUtility/obj/Release/DBUtility.Xt_CheckItem.resources new file mode 100644 index 0000000..3054b1f --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_CheckItem.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_CheckUserRight.resources b/DBUtility/obj/Release/DBUtility.Xt_CheckUserRight.resources new file mode 100644 index 0000000..7f747dc --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_CheckUserRight.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_ProcessWait.resources b/DBUtility/obj/Release/DBUtility.Xt_ProcessWait.resources new file mode 100644 index 0000000..6555d82 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_ProcessWait.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.Xt_Wait.resources b/DBUtility/obj/Release/DBUtility.Xt_Wait.resources new file mode 100644 index 0000000..06c24d0 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.Xt_Wait.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache b/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache new file mode 100644 index 0000000..873f3b5 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache new file mode 100644 index 0000000..ebee6a3 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache b/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache new file mode 100644 index 0000000..089d37c --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.dll b/DBUtility/obj/Release/DBUtility.dll new file mode 100644 index 0000000..cefc8d8 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.dll Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.frmBillQueryCondition_New.resources b/DBUtility/obj/Release/DBUtility.frmBillQueryCondition_New.resources new file mode 100644 index 0000000..06c24d0 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.frmBillQueryCondition_New.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.frm_B_BillQueryCondition_New.resources b/DBUtility/obj/Release/DBUtility.frm_B_BillQueryCondition_New.resources new file mode 100644 index 0000000..06c24d0 --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.frm_B_BillQueryCondition_New.resources Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.pdb b/DBUtility/obj/Release/DBUtility.pdb new file mode 100644 index 0000000..f43463e --- /dev/null +++ b/DBUtility/obj/Release/DBUtility.pdb Binary files differ diff --git a/DBUtility/obj/Release/ResolveAssemblyReference.cache b/DBUtility/obj/Release/ResolveAssemblyReference.cache new file mode 100644 index 0000000..77f56cc --- /dev/null +++ b/DBUtility/obj/Release/ResolveAssemblyReference.cache Binary files differ diff --git a/DBUtility/obj/Release/build.force b/DBUtility/obj/Release/build.force new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/DBUtility/obj/Release/build.force diff --git a/LMES/bin/x86/HXERP.ini b/LMES/bin/x86/HXERP.ini new file mode 100644 index 0000000..4b0d5e2 --- /dev/null +++ b/LMES/bin/x86/HXERP.ini @@ -0,0 +1,37 @@ +[po] +Server=47.96.97.237,15127 +[Erp] +Server=47.96.97.237,15127 +DataBase=HX_LMESsys +DataBaseNumber=001-智云LMES管理系统 +UserName=HX_USER +PassWord=lc@841022 +UserPsd= +Remember= +[K3Erp] +Server=47.96.97.237,15127 +DataBase= +UserName=HX_USER +PassWord=lc@841022 +[K32Erp] +Server=47.96.97.237,15127 +DataBase=HX_LMESsys +UserName=HX_USER +PassWord=lc@841022 +[SRM] +Server=.\sql2008 +DataBase=hx_lims_SRM +UserName=HX_USER +PassWord=lc@841022 +[UserInfo] +UserName=admin,景焕章,生管员,条码,测试用户 +UserPsd= +Remember=1 +HOrgName=手机事业部 +[CLOUDINFO] +sCLOUDUrl=ddddd +sCLOUDAcc=4455xddd +sCLOUDUseName=顾问1 +sCLOUDPsd=123456 + + diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" index 164b9d3..5a95409 100644 --- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" +++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" @@ -156,6 +156,7 @@ public Int64 HInterID = 0; //鍐呯爜 public Int64 HOrgID = -1; public string HOrgNumber = ""; + public string ERPMode = ""; //ERP妯″紡锛圵ISE銆丆LOUD锛� public string CampanyName = ""; //瀹㈡埛瀹氬埗鍖栧悕绉� public string SourceQtyCtl = ""; //瓒呮簮鍗曟暟閲忔帶鍒� //------------------------------------------------------------------------- @@ -373,6 +374,7 @@ } else { + ERPMode = oSystemParameter.omodel.WMS_WMSStockCtl_ERPMode; CampanyName = oSystemParameter.omodel.WMS_CampanyName; SourceQtyCtl = oSystemParameter.omodel.BarCode_SourceQtyCtl; } @@ -975,6 +977,7 @@ grdSub.RowCount = 0; grdMain.ColumnCount = 60; //鎬诲垪鏁� DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); + grdMain.Columns[HSnoCol].HeaderText = "搴忓彿"; grdMain.Columns[HMainIDCol].HeaderText = "婧愬崟涓籌D"; grdMain.Columns[HSubIDCol].HeaderText = "婧愬崟瀛怚D"; grdMain.Columns[HBillNoCol].HeaderText = "婧愬崟鍗曞彿"; @@ -1027,7 +1030,6 @@ grdMain.Columns[HInnerBillNoCol].HeaderText = "鍐呴儴閲囪喘璁㈠崟鍙�"; grdMain.Columns[HMakerCol].HeaderText = "鍒跺崟浜�"; //// - grdMain.Columns[HSnoCol].HeaderText = "搴忓彿"; //鏍煎紡鍖� grdMain.Columns[HTagCol].Visible = false; //闅愯棌鍒� grdMain.Columns[HMainIDCol].Visible = false; @@ -1037,8 +1039,8 @@ grdMain.Columns[HModelCol].Visible = false; //grdMain.Columns[HBatchNoCol].Visible = false; grdMain.Columns[HAuxPropIDCol].Visible = false; - grdMain.Columns[HAuxPropNumberCol].Visible = false; - grdMain.Columns[HAuxPropNameCol].Visible = false; + //grdMain.Columns[HAuxPropNumberCol].Visible = false; + //grdMain.Columns[HAuxPropNameCol].Visible = false; grdMain.Columns[HUnitIDCol].Visible = false; grdMain.Columns[HinitQtyCol].Visible = false; grdMain.Columns[HSupIDCol].Visible = false; @@ -1153,8 +1155,8 @@ grdSub.Columns[HMaterID2Col].Visible = false; grdSub.Columns[HModel2Col].Visible = false; grdSub.Columns[HAuxPropID2Col].Visible = false; - grdSub.Columns[HAuxPropNumber2Col].Visible = false; - grdSub.Columns[HAuxPropName2Col].Visible = false; + //grdSub.Columns[HAuxPropNumber2Col].Visible = false; + //grdSub.Columns[HAuxPropName2Col].Visible = false; grdSub.Columns[HUnitID2Col].Visible = false; grdSub.Columns[HPrintCol].Visible = false; grdSub.Columns[HSourceInterID2Col].Visible = false; @@ -1336,6 +1338,7 @@ } DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();//鐗╂枡 DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();//璁¢噺鍗曚綅 + DAL.ClsIF_Property_View oProperty = new DAL.ClsIF_Property_View();//杈呭姪灞炴�� if (!grdStatus) { return; @@ -1368,6 +1371,9 @@ grdMain.Rows[sRow].Cells[HMinQtyCol].Value = oMater.omodel.HQtyMin; grdMain.Rows[sRow].Cells[HDateCol].Value = dtpHDate.Value.ToShortDateString(); grdMain.Rows[sRow].Cells[HShowDateCol].Value = dtpHDate.Value.ToShortDateString(); + grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; + grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; if (oUnit.GetInfoByID(oMater.omodel.HUnitID)) { grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString(); @@ -1392,6 +1398,9 @@ grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; + grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; } } else @@ -1402,6 +1411,11 @@ grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; grdMain.Rows[sRow].Cells[HMinQtyCol].Value = 0; grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; + grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; + grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; + grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; } break; @@ -1435,6 +1449,31 @@ case HDateCol: BLL.ClsPub_BLL.Sub_SelectDate(grdMain, sRow, HDateCol); oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HDateCol].Value); + break; + + case HAuxPropNumberCol: + oProperty.WherePart = ""; + if (ERPMode == "CLOUD") + { + sWhere = " and HMaterNumber = '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[HMaterNumberCol].Value) + "'"; + } + else + { + sWhere = ""; + } + if (oProperty.RefreshView(sWhere)) + { + grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = oProperty.oModel.HItemID.ToString(); + grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = oProperty.oModel.HNumber; + grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = oProperty.oModel.HName; + oEdit.Text = oProperty.oModel.HNumber; + } + else + { + grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; + grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; + grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; + } break; @@ -1793,13 +1832,14 @@ //grdMain.Rows[i].Cells[HSourceNumberCol].Value = oTable.Rows[0]["鐢熶骇绾夸唬鐮�"].ToString(); grdMain.Rows[i].Cells[HSourceNameCol].Value = oTable.Rows[0]["鐢熶骇绾�"].ToString(); grdMain.Rows[i].Cells[HEndDateCol].Value = oTable.Rows[0]["璁″垝瀹屽伐鏃ユ湡"].ToString(); - grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["鏈�灏忓寘瑁呮暟"].ToString(); + grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["鏈�灏忓寘瑁呮暟"].ToString(); //-- //璁剧疆鍙紪杈戝垪 string sAllowCol = HQtyCol.ToString() + + "," + HMinQtyCol.ToString() + + "," + HAuxPropNumberCol.ToString() + "," + HBatchNoCol.ToString() + - "," + HRemarkCol.ToString() + - "," + HMinQtyCol.ToString(); + "," + HRemarkCol.ToString(); grdMain.Columns[HBillNoCol].ReadOnly = true; //璁剧疆鍚堣鍒� string sTotalCol = HQtyCol.ToString(); @@ -1870,9 +1910,10 @@ //-- //璁剧疆鍙紪杈戝垪 string sAllowCol = HQtyCol.ToString() + + "," + HMinQtyCol.ToString() + + "," + HAuxPropNumberCol.ToString() + "," + HBatchNoCol.ToString() + - "," + HRemarkCol.ToString() + - "," + HMinQtyCol.ToString(); + "," + HRemarkCol.ToString(); grdMain.Columns[HBillNoCol].ReadOnly = true; //璁剧疆鍚堣鍒� string sTotalCol = HQtyCol.ToString(); diff --git a/WebAPI/Controllers/BaseSet/Gy_GroupController.cs b/WebAPI/Controllers/BaseSet/Gy_GroupController.cs index 197e03e..cc9fafc 100644 --- a/WebAPI/Controllers/BaseSet/Gy_GroupController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_GroupController.cs @@ -20,7 +20,7 @@ /// <summary> - /// 杩斿洖宸ヤ綔涓績鍒楄〃 + /// 杩斿洖鐝粍鍒楄〃 ///鍙傛暟锛歴tring sql銆� ///杩斿洖鍊硷細object銆� /// </summary> @@ -79,7 +79,7 @@ try { - ds = oCN.RunProcReturn("select * from h_v_GroupList where HitemID=" + HInterID, "h_v_GroupList"); + ds = oCN.RunProcReturn("select * from h_v_GroupListDetail where HitemID=" + HInterID, "h_v_GroupListDetail"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -220,22 +220,18 @@ { try { - DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl(); var _value = oMain["oMain"].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(); //鍙嶅簭鍒楀寲 - msg2 = "[" + msg2.ToString() + "]"; - List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg2); - long HItemID = int.Parse(msg3); + msg1 = "[" + msg1.ToString() + "]"; + DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl(); + List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1); + + long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HShortNumber = list[0].HNumber; - long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID; + long HParentID = list[0].HParentID; string HHelpCode = list[0].HHelpCode; string HRemark = list[0].HRemark; string HStopflag = list[0].HStopflag; @@ -246,30 +242,30 @@ var HProcID = list[0].HProcID; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log(msg5, 1, true, msg4)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (!DBUtility.ClsPub.AllowNumber(HNumber)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "浠g爜涓笉鑳藉嚭鐜拌繛缁��.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (oDept.HavSameNumber(HItemID, HNumber)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "浠g爜閲嶅锛�"; - objJsonResult.data = null; - return objJsonResult; - } + //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (!DBUtility.ClsPub.AllowNumber(HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜涓笉鑳藉嚭鐜拌繛缁��.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (oDept.HavSameNumber(HItemID, HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜閲嶅锛�"; + // objJsonResult.data = null; + // return objJsonResult; + //} //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); //涓昏〃 @@ -288,7 +284,7 @@ //淇敼瀛愰」鐩唬鐮� //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Group,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //灏嗕笂绾� 涓洪潪鏈骇 - oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); + //oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCN.Commit(); objJsonResult.code = "1"; diff --git a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs index 2cbe2cc..c6baa4b 100644 --- a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs @@ -17,7 +17,143 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; + /// <summary> + /// 淇敼鍗曟嵁-淇濆瓨鎸夐挳 + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Gy_Process/EditBill")] + [HttpPost] + //鍘熶唬鐮� 鐢ㄤ簬 鏇挎崲瀛愰」鐩� + public object EditBill([FromBody] JObject oMain) + { + try + { + var _value = oMain["oMain"].ToString(); + string msg1 = _value.ToString(); + //鍙嶅簭鍒楀寲 + msg1 = "[" + msg1.ToString() + "]"; + DAL.ClsGy_Process_Ctl oDept = new DAL.ClsGy_Process_Ctl(); + List<Gy_Process> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Process>>(msg1); + long HItemID = list[0].HItemID; + string HNumber = list[0].HNumber; + string HName = list[0].HName; + string HShortNumber = list[0].HNumber; + long HParentID = list[0].HParentID; + string HHelpCode = list[0].HHelpCode; + bool HTypeFlow = list[0].HTypeFlow; + bool HTypeCount = list[0].HTypeCount; + string HDeptNumber = ""; + long HLevel = ClsPub.GetLevel(list[0].HNumber.Trim()); + bool HEndFlag = false; + long HProcessID_K3 = list[0].HProcessID_K3; + string HBillSubType = list[0].HType; + bool HAutoTrunFlag = list[0].HAutoTrunFlag; + string HFixPrice = list[0].HFixPrice; + string HOverFixPrice = list[0].HOverFixPrice; + string HSNo = list[0].HSNo; + string HBarCode = list[0].HBarCode; + string HProcMulID = list[0].HProcMulID; + string HProcCheckNote = list[0].HProcCheckNote; + string HRemark = list[0].HRemark; + bool HStopflag = list[0].HStopflag; + string HUseFlag = list[0].HUseFlag; + long HEmpQty = list[0].HEmpQty; + string HBarCodeForBase = list[0].HBarCodeForBase; + long HDeptID = list[0].HDeptID; + long HProcID = list[0].HProcID; + + //鍒ゆ柇鏉冮檺 + //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (!DBUtility.ClsPub.AllowNumber(HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜涓笉鑳藉嚭鐜拌繛缁��.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (oDept.HavSameNumber(HItemID, HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜閲嶅锛�"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� + + //涓昏〃 + + //oCN.RunProc("Update Gy_Process set " + + // " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + + // ",HTypeFlow,HTypeCount,HDeptNumber,HSNo" + + // ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase,HProcessID_K3,HBillSubType,HAutoTrunFlag" + + // ",HFixPrice,HOverFixPrice,HProcMulID,HProcCheckNote) " + + // " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + + // "," + Convert.ToString(HTypeFlow ? 1 : 0) + "," + Convert.ToString(HTypeCount ? 1 : 0) + ",'" + HDeptNumber + "'," + HSNo.ToString() + + // "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID + + // ",'" + HBarCode + "'," + HProcessID_K3 + ",'" + HBillSubType + "'," + Convert.ToString(HAutoTrunFlag ? 1 : 0) + + // "," + HFixPrice.ToString() + "," +HOverFixPrice.ToString() + "," + HProcMulID.ToString() + ",'" + HProcCheckNote.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); + + oCN.BeginTran(); + oCN.RunProc("Update Gy_Process set " + + " HNumber='" + HNumber + "'" + + ",HName='" + HName + "'" + + ",HHelpCode='" + HHelpCode + "'" + + ",HShortNumber='" + HShortNumber + "'" + + ",HParentID= " + HParentID + + ",HTypeFlow= '" + HTypeFlow + "'" + + ",HTypeCount= '" + HTypeCount + "'" + + ",HDeptNumber='" + HDeptNumber + "'" + + ",HSNo= " + HSNo + + ",HLevel= " + HLevel + + ",HEndFlag= '" + HEndFlag + "'" + + ",HStopflag= '" + HStopflag + "'" + + ",HRemark='" + HRemark + "'" + + ",HDeptID= " + HDeptID + + ",HBarCodeForBase='" + HBarCodeForBase + "'" + + ",HProcessID_K3= " + HProcessID_K3 + + ",HBillSubType='" + HBillSubType + "'" + + ",HAutoTrunFlag= '" + HAutoTrunFlag + "'" + + ",HFixPrice= " + HFixPrice + + ",HOverFixPrice= " + HOverFixPrice + + ",HProcMulID= " + HProcMulID + + ",HProcCheckNote='" + HProcCheckNote + "'" + + " Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); + //淇敼涓婄骇涓洪潪鏈骇浠g爜 + oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); + //return true; + //淇敼瀛愰」鐩唬鐮� + //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Group,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); + //灏嗕笂绾� 涓洪潪鏈骇 + //oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); + // + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "淇敼鍗曟嵁鎴愬姛锛�"; + //objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.Message; + objJsonResult.data = null; + return objJsonResult; + } + } /// <summary> /// 杩斿洖宸ュ簭鍒楄〃 ///鍙傛暟锛歴tring sql銆� @@ -67,6 +203,45 @@ } + /// <summary> + /// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍 + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Gy_Process/cx")] + [HttpGet] + public object cx(long HInterID) + { + try + { + + ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessListDetail where HitemID=" + HInterID, "h_v_Gy_ProcessListDetail"); + 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 e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } // } diff --git a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs index 770ff1e..9606b19 100644 --- a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs @@ -17,56 +17,6 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; - - /// <summary> - /// 杩斿洖閮ㄩ棬鍒楄〃 - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> - [Route("Gy_Department/list")] - [HttpGet] - public object list(string sWhere) - { - try - { - if (sWhere == null || sWhere.Equals("")) - { - ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentList " + sWhere, "h_v_IF_DepartmentList"); - } - else - { - string sql1 = "select * from h_v_IF_DepartmentList where 1 = 1 "; - string sql = sql1 + sWhere; - ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList"); - } - 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 e) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "Exception锛�" + e.ToString(); - objJsonResult.data = null; - return objJsonResult; - } - } - - /// <summary> /// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍 ///鍙傛暟锛歴tring sql銆� diff --git a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs index 67d491b..e74f2f0 100644 --- a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs @@ -222,22 +222,18 @@ { try { - DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); var _value = oMain["oMain"].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(); //鍙嶅簭鍒楀寲 - msg2 = "[" + msg2.ToString() + "]"; - List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg2); - long HItemID = int.Parse(msg3); + msg1 = "[" + msg1.ToString() + "]"; + DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); + List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg1); + + long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HShortNumber = list[0].HNumber; - long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID; + long HParentID = list[0].HParentID; string HHelpCode = list[0].HHelpCode; string HRemark = list[0].HRemark; string HStopflag = list[0].HStopflag; @@ -249,30 +245,30 @@ var HWorkTimes = list[0].HWorkTimes; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log(msg5, 1, true, msg4)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (!DBUtility.ClsPub.AllowNumber(HNumber)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "浠g爜涓笉鑳藉嚭鐜拌繛缁��.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (oDept.HavSameNumber(HItemID, HNumber)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "浠g爜閲嶅锛�"; - objJsonResult.data = null; - return objJsonResult; - } + //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (!DBUtility.ClsPub.AllowNumber(HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜涓笉鑳藉嚭鐜拌繛缁��.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //if (oDept.HavSameNumber(HItemID, HNumber)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "浠g爜閲嶅锛�"; + // objJsonResult.data = null; + // return objJsonResult; + //} //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); //涓昏〃 @@ -311,7 +307,7 @@ } } /// <summary> - /// 缁翠慨鍒楄〃淇敼鎸夐挳鏂规硶 + /// 宸ヤ綔涓績鍒楄〃淇敼鎸夐挳鏂规硶 ///鍙傛暟锛歴tring sql銆� ///杩斿洖鍊硷細object銆� /// </summary> @@ -321,7 +317,7 @@ { try { - ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HItemID=" + HInterID, "Gy_WorkCenter"); + ds = oCN.RunProcReturn("select a.*,b.HName HDeptName from Gy_WorkCenter a left join Gy_Department b on a.HDeptID = b.HItemID where a.HItemID=" + HInterID, "Gy_WorkCenter"); objJsonResult.code = "1"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs index e86a26d..5269994 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs @@ -20,12 +20,7 @@ DataSet ds; DataSet ds1; - - /// <summary> - /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳 - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> + #region 鏂板鍗曟嵁-淇濆瓨鎸夐挳 [Route("Cj_StationInBill/AddBill")] [HttpPost] public object AddBill([FromBody] JObject oMain) @@ -149,8 +144,6 @@ objJsonResult.data = null; return objJsonResult; } - - //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); @@ -235,10 +228,6 @@ return objJsonResult; } - - - - ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl"); if (ds == null) { @@ -306,12 +295,9 @@ } return false; } + #endregion - /// <summary> - /// 宸ュ簭杩涚珯鎺ユ敹鍗曟祦姘村彿鍥炶溅鑾峰彇宸ュ簭淇℃伅 - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> + #region 宸ュ簭杩涚珯鎺ユ敹鍗曟祦姘村彿鍥炶溅鑾峰彇宸ュ簭淇℃伅 [Route("Cj_StationInBill/txtHProcNo_KeyDown")] [HttpGet] public object txtHProcNo_KeyDown(string sBillNo,string sProcNo) @@ -354,12 +340,9 @@ return objJsonResult; } } + #endregion - /// <summary> - /// 杩斿洖濮斿宸ュ簭鎺ユ敹鍗曞垪琛� - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> + #region 杩斿洖濮斿宸ュ簭鎺ユ敹鍗曞垪琛� [Route("Cj_StationInBill/get_Display")] [HttpGet] public object get_Display(string sWhere) @@ -402,12 +385,53 @@ return objJsonResult; } } + #endregion - /// <summary> - /// 缂栬緫椤甸潰鏍规嵁id鑾峰彇宸ュ簭杩涚珯鎺ユ敹鍗曚俊鎭� - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> + #region 缂栬緫鍓嶅垽鏂� + [Route("Cj_StationInBill/set_ShowBillJudge")] + [HttpGet] + public object set_ShowBillJudge(string HBillNo) + { + try + { + ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_DelCtrl '" + HBillNo + "'", "h_p_MES_StationInBill_DelCtrl"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒ゆ柇鍏宠仈澶辫触锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else if(ds.Tables[0].Rows.Count > 0 && Pub_Class.ClsPub.isInt(ds.Tables[0].Rows[0][0]) == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]); + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + 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 缂栬緫椤甸潰鏍规嵁id鑾峰彇宸ュ簭杩涚珯鎺ユ敹鍗曚俊鎭� [Route("Cj_StationInBill/GetStationInBill")] [HttpGet] public object GetStationOutBill(int HInterID) @@ -441,8 +465,9 @@ return objJsonResult; } } + #endregion - #region [瀹℃牳] + #region 瀹℃牳 [Route("Cj_StationInBill/set_CheckBill")] [HttpGet] public object set_CheckBill(int HInterID,string CurUserName) @@ -459,19 +484,17 @@ objJsonResult.data = null; return objJsonResult; } - Int64 lngBillKey = 0; - lngBillKey = HInterID; - if (lngBillKey == 0) + if (HInterID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "HInterID涓�0锛�"; + objJsonResult.Message = "鍗曟嵁ID涓�0锛屼笉鑳藉鏍革紒"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_StationInBill oBill = new DAL.ClsSc_StationInBill(); //鏌ョ湅鏄惁宸插鏍�,鍏抽棴,浣滃簾 - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HChecker.Trim() != "") { @@ -491,10 +514,10 @@ return objJsonResult; } //瀹℃牳 - if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + if (Cj_StationInBillCheckBill(HInterID,CurUserName, ref DBUtility.ClsPub.sExeReturnInfo)) { - objJsonResult.code = "0"; - objJsonResult.count = 0; + objJsonResult.code = "1"; + objJsonResult.count = 1; objJsonResult.Message = "瀹℃牳鎴愬姛!"; objJsonResult.data = null; return objJsonResult; @@ -518,6 +541,47 @@ return objJsonResult; } } + + //瀹℃牳 + public bool Cj_StationInBillCheckBill(Int64 lngBillKey, string CurUserName, ref string sReturn) + { + try + { + string HChecker = CurUserName; + string HCheckDate = DBUtility.ClsPub.GetServerDate(-1); + oCN.BeginTran(); + ds = oCN.RunProcReturn("Select * from Sc_StationInBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_StationInBillMain"); + if (ds.Tables[0].Rows.Count == 0) + { + sReturn = "鍗曟嵁鏈壘鍒帮紒"; + return false; + } + oCN.RunProc(" Update Sc_StationInBillMain set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString()); + oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Check_In " + lngBillKey.ToString() + ",1"); + //鍒ゆ柇鏄惁鏄� 棣栭亾宸ュ簭 + DataSet ds1; + ds1 = oCN.RunProcReturn("select HLastProc,HFstProc " + + " from Sc_ProcessExchangeBillMain a " + + " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + + " Where a.HInterID=(Select HProcExchInterID from Sc_StationInBillMain Where HInterID=55) " + + " and b.HEntryID=(Select HProcExchEntryID from Sc_StationInBillMain Where HInterID=55)", "Sc_ProcessExchangeBillMain"); + if (ds1 == null || ds1.Tables[0].Rows.Count == 0) + { + } + else if (Pub_Class.ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "鏄�") + { + } + sReturn = sReturn + " 瀹℃牳鍔熻兘锛�"; + oCN.Commit(); + return true; + } + catch (Exception e) + { + sReturn = e.Message; + oCN.RollBack(); + return false; ; + } + } #endregion diff --git "a/WebAPI/Models/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Process.cs" "b/WebAPI/Models/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Process.cs" new file mode 100644 index 0000000..0999cf8 --- /dev/null +++ "b/WebAPI/Models/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Process.cs" @@ -0,0 +1,40 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Linq; +using System.Web; + +namespace WebAPI.Models +{ + public class Gy_Process + { + public long HItemID { get; set; } + public string HNumber { get; set; } // 浠g爜 + public string HName { get; set; } // + public string HHelpCode { get; set; } //鍔╄鐮� + public string HShortNumber { get; set; } //鐭唬鐮� + public bool HEndFlag { get; set; } //鏈骇鏍囧織 + public bool HStopflag { get; set; } //绂佺敤鏍囧織 + public string HRemark { get; set; } //澶囨敞 + public string HUseFlag { get; set; } //浣跨敤鏍囧織 + public long HParentID { get; set; } //鐖剁骇ID + public bool HTypeFlow { get; set; } + public bool HTypeCount { get; set; } + public string HDeptNumber { get; set; } + public string HBarCode { get; set; } + public string HLevel { get; set; } + public long HProcessID_K3 { get; set; } + public string HType { get; set; } + public bool HAutoTrunFlag { get; set; } + public string HFixPrice { get; set; } + public string HOverFixPrice { get; set; } + public string HSNo { get; set; } + public string HProcMulID { get; set; } + public string HProcCheckNote { get; set; } + public long HDeptID { get; set; } + public long HEmpQty { get; set; } + public long HProcID { get; set; } + + public string HBarCodeForBase { get; set; } + + } +} \ No newline at end of file diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user index 9de84a7..96553ac 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user @@ -9,7 +9,7 @@ </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 08:43:40</publishTime> @@ -18,31 +18,31 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>08/20/2021 19:17:14</publishTime> + <publishTime>08/20/2021 14:25:34</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>08/20/2021 19:17:14</publishTime> + <publishTime>08/20/2021 14:25:34</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>08/20/2021 19:17:11</publishTime> + <publishTime>08/20/2021 14:25:30</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>08/20/2021 19:17:11</publishTime> + <publishTime>08/20/2021 14:25:30</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>08/20/2021 11:01:15</publishTime> + <publishTime>08/20/2021 14:25:24</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>08/20/2021 11:01:15</publishTime> + <publishTime>08/20/2021 14:25:24</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> - <publishTime>08/17/2021 09:09:33</publishTime> + <publishTime>08/20/2021 14:25:31</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/16/2021 17:23:13</publishTime> + <publishTime>09/20/2018 19:08:18</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -60,37 +60,37 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>08/20/2021 11:01:15</publishTime> + <publishTime>08/20/2021 14:25:25</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>08/20/2021 11:01:15</publishTime> + <publishTime>08/20/2021 14:25:25</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:20</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:20</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:22</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:22</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:23</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>08/20/2021 10:44:25</publishTime> + <publishTime>08/20/2021 14:25:23</publishTime> </File> <File Include="bin/stdole.dll"> - <publishTime>08/15/2021 14:25:35</publishTime> + <publishTime>01/13/2021 17:00:05</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/15/2015 17:57:08</publishTime> @@ -156,7 +156,7 @@ <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 04:02:18</publishTime> @@ -189,10 +189,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>08/20/2021 19:16:51</publishTime> + <publishTime>08/20/2021 14:25:39</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>08/20/2021 19:16:51</publishTime> + <publishTime>08/20/2021 14:25:39</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -204,166 +204,166 @@ <publishTime>11/29/2018 13:26:30</publishTime> </File> <File Include="Content/bootstrap.css"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:27</publishTime> </File> <File Include="Content/bootstrap.min.css"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:27</publishTime> </File> <File Include="Content/Site.css"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:27</publishTime> </File> <File Include="DLL/BLL.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/DAL.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/DBUtility.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/Model.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/Pub_Class.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/Pub_Control.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="DLL/SQLHelper.dll"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Global.asax"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Index.html"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="packages.config"> - <publishTime>08/16/2021 17:23:16</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/web.config"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> - <publishTime>08/16/2021 17:23:15</publishTime> + <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> - <publishTime>08/20/2021 11:01:21</publishTime> + <publishTime>08/20/2021 14:25:53</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj index 97c99c8..0859ce4 100644 --- a/WebAPI/WebAPI.csproj +++ b/WebAPI/WebAPI.csproj @@ -461,6 +461,7 @@ <Compile Include="Models\WWSendOutBillViewModel.cs" /> <Compile Include="Models\WW_EntrustProcSendWorkViewModel.cs" /> <Compile Include="Models\WW_EntrustWorkOrderViewModel.cs" /> + <Compile Include="Models\鍩虹璧勬枡\Gy_Process.cs" /> <Compile Include="Models\鍩虹璧勬枡\Warehouse.cs" /> <Compile Include="Properties\Resources.Designer.cs"> <AutoGen>True</AutoGen> diff --git a/WebAPI/WebAPI.csproj.user b/WebAPI/WebAPI.csproj.user index c934955..e034e8d 100644 --- a/WebAPI/WebAPI.csproj.user +++ b/WebAPI/WebAPI.csproj.user @@ -7,7 +7,7 @@ <WebStackScaffolding_IsReferencingScriptLibrariesSelected>True</WebStackScaffolding_IsReferencingScriptLibrariesSelected> <WebStackScaffolding_LayoutPageFile /> <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> - <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> + <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> <UseIISExpress>false</UseIISExpress> <Use64BitIISExpress /> -- Gitblit v1.9.1