From f4e89066f9119fac831b64f388516aeb01c7dd60 Mon Sep 17 00:00:00 2001 From: 沈泽 <211959439@qq.com> Date: 星期三, 03 十一月 2021 16:59:04 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WorkM/报表分析/MES_WIPProcReport.designer.cs | 326 +++---- WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs | 83 ++ WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 146 +- WorkM/流转卡管理/MES_StationOutBillList_Bad.resx | 28 WorkM/报表分析/MES_WIPProcReport.resx | 60 - WorkM/流转卡管理/MES_StationOutBillList_Bad.designer.cs | 116 +- WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs | 85 ++ WebAPI/Controllers/WebAPIController.cs | 43 WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs | 268 +----- WorkM/流转卡管理/MES_StationOutBillList_Bad.cs | 31 WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs | 84 ++ WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs | 84 ++ WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs | 85 ++ WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs | 85 ++ WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 85 ++ WorkM/报表分析/MES_WIPProcReport.cs | 30 WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs | 84 ++ WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs | 453 +++++++++-- 18 files changed, 1,463 insertions(+), 713 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs index de02065..aa454f4 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs @@ -17,6 +17,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -422,6 +423,89 @@ } #endregion + #region 鍣ㄥ叿鍒嗗竷寮忚皟鍏ュ崟瀹℃牳/鍙嶅鏍� + [Route("Sc_MouldMoveStockStepInBill/AuditMouldMoveStockStepInBill")] + [HttpGet] + public object AuditMouldMoveStockStepInBill(string HInterID, string user,int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldMoveStockStepInBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag==1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3841' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3841' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs index f4895c0..25c5568 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs @@ -17,6 +17,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -343,7 +344,7 @@ } #endregion - #region [鍣ㄥ叿鍒嗗竷寮忚皟鍏ュ崟鍒犻櫎鍔熻兘] + #region [鍣ㄥ叿鍒嗗竷寮忚皟鍑哄崟鍒犻櫎鍔熻兘] /// <summary> /// 妯″叿澶勭悊棰嗙敤鍗曞垹闄ゅ姛鑳� /// </summary> @@ -423,7 +424,89 @@ } #endregion + #region 鍣ㄥ叿鍒嗗竷寮忚皟鍑哄崟瀹℃牳/鍙嶅鏍� + [Route("Sc_MouldMoveStockStepOutBill/AuditMouldMoveStockStepOutBill")] + [HttpGet] + public object AuditMouldMoveStockStepOutBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldMoveStockStepOutBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3840' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3840' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs index 9e3ef9c..1d1b015 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs @@ -17,6 +17,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -341,7 +342,7 @@ } #endregion - #region [鍣ㄥ叿鍏朵粬鍏ュ簱鍗曞垹闄ゅ姛鑳絔 + #region [鍣ㄥ叿鍏朵粬鍑哄簱鍗曞垹闄ゅ姛鑳絔 /// <summary> /// 妯″叿澶勭悊棰嗙敤鍗曞垹闄ゅ姛鑳� /// </summary> @@ -421,7 +422,89 @@ } #endregion + #region 鍣ㄥ叿鍏朵粬鍑哄簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldOtherOutBill/AuditMouldOtherOutBill")] + [HttpGet] + public object AuditMouldOtherOutBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldOtherOutBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3828' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3828' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 6dd7a94..a05f5e8 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs @@ -16,6 +16,7 @@ public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛� private json objJsonResult = new json(); public DataSet ds = new DataSet(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DLL.ClsSc_MouldProdInBill BillNew0 = new DLL.ClsSc_MouldProdInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DLL.ClsSc_MouldProdInBill BillOld0 = new DLL.ClsSc_MouldProdInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -655,5 +656,89 @@ } } #endregion + + #region 鍣ㄥ叿閲囪喘鍏ュ簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldProdInHouseBill/AuditMouldProdInHouseBill")] + [HttpGet] + public object AuditMouldProdInHouseBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3801' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3801' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs index 4e2781c..0a2d205 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs @@ -17,6 +17,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -423,7 +424,89 @@ } #endregion + #region 鍣ㄥ叿鐩存帴璋冩嫧鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldProdMoveBill/AuditMouldProdMoveBill")] + [HttpGet] + public object AuditMouldProdMoveBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdMoveBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3814' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3814' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs index 2bd0218..1e23516 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs @@ -16,6 +16,7 @@ public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛� private json objJsonResult = new json(); public DataSet ds = new DataSet(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DLL.ClsSc_MouldRepairChangeBill BillNew0 = new DLL.ClsSc_MouldRepairChangeBill(); //妯″叿鏀瑰埗鍑哄簱瀵瑰簲鍗曟嵁绫� public DLL.ClsSc_MouldRepairChangeBill BillOld0 = new DLL.ClsSc_MouldRepairChangeBill(); //妯″叿鏀瑰埗鍑哄簱瀵瑰簲鍗曟嵁绫� @@ -562,5 +563,89 @@ } } #endregion + + #region 鍣ㄥ叿鏀瑰埗鐢宠鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldRepairChangeHouseBill/AuditMouldRepairChangeBill")] + [HttpGet] + public object AuditMouldRepairChangeBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairChangeBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldRepairChangeBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3842' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldRepairChangeBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3842' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs index f98d851..faa81d8 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs @@ -16,6 +16,7 @@ public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛� private json objJsonResult = new json(); public DataSet ds = new DataSet(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DLL.ClsSc_MouldRepairOutBill BillNew0 = new DLL.ClsSc_MouldRepairOutBill(); //妯″叿鏀瑰埗鍑哄簱瀵瑰簲鍗曟嵁绫� public DLL.ClsSc_MouldRepairOutBill BillOld0 = new DLL.ClsSc_MouldRepairOutBill(); //妯″叿鏀瑰埗鍑哄簱瀵瑰簲鍗曟嵁绫� @@ -363,217 +364,84 @@ } #endregion - #region [妯″叿鏀瑰埗鍑哄崟瀹℃牳銆佸弽瀹℃牳] - /// <summary> - /// 瀹℃牳 - /// </summary> - /// <param name="HInterID">鍗曟嵁ID</param> - /// <param name="CurUserName">瀹℃牳浜�</param> - /// <returns></returns> - [Route("Sc_MouldRepairOutBill/set_CheckBill")] + #region 鍣ㄥ叿鏀瑰埗鍑哄簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldRepairOutBill/AuditMouldRepairOutBill")] [HttpGet] - public object set_CheckBill(int HInterID, string CurUserName) + public object AuditMouldRepairOutBill(string HInterID, string user, int flag) { - string ModRightNameCheck = "Sc_MouldRepairOut_SingleBill_Check"; - DBUtility.ClsPub.CurUserName = CurUserName; - DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); - try - { - //瀹℃牳鏉冮檺 - if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - objJsonResult.data = null; - return objJsonResult; - } - //瀹℃牳鍓嶅垽鏂槸鍚﹀厑璁� - string s = ""; - if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = s + "锛屼笉鍏佽瀹℃牳"; - objJsonResult.data = null; - return objJsonResult; - } - if (HInterID <= 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "HInterID灏忎簬0锛�"; - objJsonResult.data = null; - return objJsonResult; - } - Int64 lngBillKey = 0; - lngBillKey = DBUtility.ClsPub.isLong(HInterID); - //鏌ョ湅鏄惁宸插鏍�,鍏抽棴,浣滃簾 - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) - { - if (oBill.omodel.HCloseMan.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; - objJsonResult.data = null; - return objJsonResult; - } - if (oBill.omodel.HDeleteMan.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; - objJsonResult.data = null; - return objJsonResult; - } - if (oBill.omodel.HChecker.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�"; - objJsonResult.data = null; - return objJsonResult; - } - } - else - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - //瀹℃牳鎻愪氦 - if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "瀹℃牳鎴愬姛"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - } - catch (Exception e) + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairOut_SingleBill_Check", 1, true, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "瀹℃牳澶辫触锛�" + e.ToString(); + objJsonResult.Message = "鏃犲鏍告潈闄愶紒"; objJsonResult.data = null; return objJsonResult; } - } - /// <summary> - /// 鍙嶅鏍� - /// </summary> - /// <param name="HInterID">鍗曟嵁ID</param> - /// <param name="CurUserName">瀹℃牳浜�</param> - /// <returns></returns> - [Route("Sc_MouldRepairOutBill/set_AbandonCheck")] - [HttpGet] - public object set_AbandonCheck(int HInterID, string CurUserName) - { - string ModRightNameCheck = "Sc_MouldRepairOut_SingleBill_Check"; - DBUtility.ClsPub.CurUserName = CurUserName; - DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); - try - { - //瀹℃牳鏉冮檺 - if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍙嶅鏍稿け璐ワ紒鏃犳潈闄愶紒"; - objJsonResult.data = null; - return objJsonResult; - } - //鍙嶅鏍稿墠鍒ゆ柇 - string s = ""; - if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = s + "锛屼笉鍏佽鍙嶅鏍�"; - objJsonResult.data = null; - return objJsonResult; - } - if (HInterID <= 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "HInterID灏忎簬0锛�"; - objJsonResult.data = null; - return objJsonResult; - } - Int64 lngBillKey = 0; - lngBillKey = DBUtility.ClsPub.isLong(HInterID); - //鏌ョ湅鏄惁宸插鏍�,鍏抽棴,浣滃簾 - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) - { - if (oBill.omodel.HCloseMan.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍙嶅鏍革紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (oBill.omodel.HDeleteMan.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆鍙嶅鏍革紒"; - objJsonResult.data = null; - return objJsonResult; - } - if (oBill.omodel.HChecker.Trim() == "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!"; - objJsonResult.data = null; - return objJsonResult; - } - } - else - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - //鍙嶅鏍告彁浜bandonCheck - if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "鍙嶅鏍告垚鍔�"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - } - catch (Exception e) + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); + if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "鍙嶅鏍稿け璐ワ紒" + e.ToString(); + objJsonResult.Message = "鍗曟嵁ID涓虹┖锛�"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3825' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3825' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; objJsonResult.data = null; return objJsonResult; } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs index 0e0cfac..a7baf96 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs @@ -10,6 +10,7 @@ { private json objJsonResult = new json(); public DataSet ds = new DataSet(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); #region [妯″叿鎶ュ簾鍏ュ簱鍗曞鏍搞�佸弽瀹℃牳] /// <summary> @@ -314,6 +315,89 @@ } #endregion + #region 鍣ㄥ叿鎶ュ簾鍏ュ簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldScrapInBill/AuditMouldScrapInBill")] + [HttpGet] + public object AuditMouldScrapInBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldScrapInBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3831' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3831' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion #region 妯″叿鎶ュ簾鍏ュ簱鍗曞垪琛� diff --git a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs index 71883bf..278d345 100644 --- a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs +++ b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs @@ -16,6 +16,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public WebServer webserver = new WebServer(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -4819,6 +4820,89 @@ } #endregion + #region 鍣ㄥ叿鏀瑰埗鍏ュ簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldRepairInBill/AuditMouldRepairInBill")] + [HttpGet] + public object AuditMouldRepairInBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairIn_SingleBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3826' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3826' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion #endregion //#region 妯″叿棰嗙敤鍗� diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs index cef2724..3c0c023 100644 --- a/WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs +++ b/WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs @@ -17,6 +17,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); + public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //妯″叿鎶ュ簾鍏ュ簱瀵瑰簲鍗曟嵁绫� @@ -4089,139 +4090,223 @@ } #endregion - #region [妯″叿澶勭悊鍑哄簱鍗曞鏍搞�佸弽瀹℃牳] - /// <summary> - /// - /// </summary> - /// <param name="HInterID">鍗曟嵁ID</param> - /// <param name="IsAudit">瀹℃牳(0),鍙嶅鏍�(1)</param> - /// <param name="CurUserName">瀹℃牳浜�</param> - /// <returns></returns> - [Route("Sc_MouldScrapOutHouseBill/AuditMouldScrapOutList")] + //#region [妯″叿澶勭悊鍑哄簱鍗曞鏍搞�佸弽瀹℃牳] + ///// <summary> + ///// + ///// </summary> + ///// <param name="HInterID">鍗曟嵁ID</param> + ///// <param name="IsAudit">瀹℃牳(0),鍙嶅鏍�(1)</param> + ///// <param name="CurUserName">瀹℃牳浜�</param> + ///// <returns></returns> + //[Route("Sc_MouldScrapOutHouseBill/AuditMouldScrapOutList")] + //[HttpGet] + //public object AuditMouldScrapOutList(int HInterID, int IsAudit, string CurUserName) + //{ + // string ModRightNameCheck = "Sc_MouldScrapOutBill_Check"; + // DBUtility.ClsPub.CurUserName = CurUserName; + // try + // { + // //瀹℃牳鏉冮檺 + // if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, 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 = "HInterID灏忎簬0锛�"; + // objJsonResult.data = null; + // return objJsonResult; + // } + // Int64 lngBillKey = 0; + // lngBillKey = DBUtility.ClsPub.isLong(HInterID); + // DLL.ClsSc_MouldScrapOutBill oBill = new DLL.ClsSc_MouldScrapOutBill(); + // //鏌ョ湅鏄惁宸插鏍�,鍏抽棴,浣滃簾 + // if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + // { + // if (oBill.omodel.HCloseMan.Trim() != "") + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + // objJsonResult.data = null; + // return objJsonResult; + // } + // if (oBill.omodel.HDeleteMan.Trim() != "") + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + // objJsonResult.data = null; + // return objJsonResult; + // } + // if (IsAudit == 0) //瀹℃牳鍒ゆ柇 + // { + // if (oBill.omodel.HChecker.Trim() != "") + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�"; + // objJsonResult.data = null; + // return objJsonResult; + // } + // } + // if (IsAudit == 1) //鍙嶅鏍稿垽鏂� + // { + // if (oBill.omodel.HChecker.Trim() == "") + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!"; + // objJsonResult.data = null; + // return objJsonResult; + // } + // } + // } + // else + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + // objJsonResult.data = null; + // return objJsonResult; + // } + // if (IsAudit == 0) //瀹℃牳鎻愪氦 + // { + // //瀹℃牳鎻愪氦 + // if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + // { + // 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; + // } + // } + // if (IsAudit == 1) //鍙嶅鏍告彁浜� + // { + // //鍙嶅鏍告彁浜bandonCheck + // if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + // { + // 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; + // } + // } + // return objJsonResult; + // } + // catch (Exception e) + // { + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "瀹℃牳澶辫触鎴栬�呭弽瀹℃牳澶辫触锛�" + e.ToString(); + // objJsonResult.data = null; + // return objJsonResult; + // } + //} + //#endregion + + #region 鍣ㄥ叿澶勭悊鍑哄簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldScrapOutHouseBill/AuditMouldScrapOutHouseBill")] [HttpGet] - public object AuditMouldScrapOutList(int HInterID, int IsAudit, string CurUserName) + public object AuditMouldScrapOutHouseBill(string HInterID, string user, int flag) { - string ModRightNameCheck = "Sc_MouldScrapOutBill_Check"; - DBUtility.ClsPub.CurUserName = CurUserName; - try + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldScrapOutBill_Check", 1, true, user)) { - //瀹℃牳鏉冮檺 - if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) + 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - objJsonResult.data = null; - return objJsonResult; - } - if (HInterID <= 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "HInterID灏忎簬0锛�"; - objJsonResult.data = null; - return objJsonResult; - } - Int64 lngBillKey = 0; - lngBillKey = DBUtility.ClsPub.isLong(HInterID); - DLL.ClsSc_MouldScrapOutBill oBill = new DLL.ClsSc_MouldScrapOutBill(); - //鏌ョ湅鏄惁宸插鏍�,鍏抽棴,浣滃簾 - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) - { - if (oBill.omodel.HCloseMan.Trim() != "") + if (oBill.omodel.HBillStatus == 2) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; objJsonResult.data = null; return objJsonResult; } - if (oBill.omodel.HDeleteMan.Trim() != "") + else { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3832' and HInterID=" + HInterID); objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; - objJsonResult.data = null; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; return objJsonResult; - } - if (IsAudit == 0) //瀹℃牳鍒ゆ柇 - { - if (oBill.omodel.HChecker.Trim() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�"; - objJsonResult.data = null; - return objJsonResult; - } - } - if (IsAudit == 1) //鍙嶅鏍稿垽鏂� - { - if (oBill.omodel.HChecker.Trim() == "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!"; - objJsonResult.data = null; - return objJsonResult; - } } } else { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - if (IsAudit == 0) //瀹℃牳鎻愪氦 - { - //瀹℃牳鎻愪氦 - if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + if (oBill.omodel.HBillStatus == 1) { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "瀹℃牳鎴愬姛"; + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; objJsonResult.data = null; return objJsonResult; } else { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3832' and HInterID=" + HInterID); objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - } - if (IsAudit == 1) //鍙嶅鏍告彁浜� - { - //鍙嶅鏍告彁浜bandonCheck - if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) - { - 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; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; return objJsonResult; } } - return objJsonResult; + } - catch (Exception e) + else { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "瀹℃牳澶辫触鎴栬�呭弽瀹℃牳澶辫触锛�" + e.ToString(); + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; objJsonResult.data = null; return objJsonResult; } @@ -4573,6 +4658,89 @@ } #endregion + #region 鍣ㄥ叿鐢熶骇閫�搴撳崟瀹℃牳/鍙嶅鏍� + [Route("Sc_MouldProdBackBill/AuditMouldProdBackBill")] + [HttpGet] + public object AuditMouldProdBackBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdBackBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3803' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3803' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion #endregion #region 妯″叿棰嗙敤鍗� @@ -4918,6 +5086,89 @@ } #endregion + #region 鍣ㄥ叿棰嗙敤鍑哄簱鍗曞鏍�/鍙嶅鏍� + [Route("Sc_MouldProdOutBill/AuditMouldProdOutBill")] + [HttpGet] + public object AuditMouldProdOutBill(string HInterID, string user, int flag) + { + //flag=1 瀹℃牳锛� flag=2 鍙嶅鏍� + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdOutBill_Check", 1, true, 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; + } + DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + if (flag == 1) + { + if (oBill.omodel.HBillStatus == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁宸插鏍革紝鏃犻渶鍐嶆瀹℃牳"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3802' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + } + else + { + if (oBill.omodel.HBillStatus == 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠鍗曟嵁鏈鏍革紝鏃犻渶鍙嶅鏍�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + string HCheckDate = DateTime.Now.Date.ToString(); + oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3802' and HInterID=" + HInterID); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔燂紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion #endregion #region 妯″叿瀵垮懡璋冩暣鍗� diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index e783b85..ab01574 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -83,10 +83,11 @@ /// </summary> /// <param name="UserName">鐢ㄦ埛鍚�</param> /// <param name="PassWord">瀵嗙爜</param> + /// <param name="PassWord">缁勭粐</param> /// <returns></returns> [Route("Web/GetUser")] [HttpGet] - public object GetUser(string UserName, string PassWord) + public object GetUser(string UserName, string PassWord, string HOrgName) { try { @@ -102,14 +103,24 @@ objjson.data = null; return objjson; } - else + string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a + where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName); + DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check"); + if (_ds == null || _ds.Tables[0].Rows.Count == 0) { objjson.code = "0"; - objjson.count = 1; - objjson.Message = "鐧诲綍鎴愬姛锛�"; - objjson.data = ds.Tables[0]; + objjson.count = 0; + objjson.Message = "鐢ㄦ埛" + UserName + "娌℃湁璇ョ粍缁囨潈闄�"; + objjson.data = null; return objjson; } + + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "鐧诲綍鎴愬姛锛�"; + objjson.data = ds.Tables[0]; + return objjson; + } catch (Exception) { @@ -1281,7 +1292,7 @@ { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); - if (BadReason != ""&& BadReason != null) + if (BadReason != "" && BadReason != null) { sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) "; } @@ -1737,9 +1748,9 @@ sWhere = " Where HStopFlag=0 and HEndFlag=1"; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); - if (CheckItem != ""&& CheckItem!=null) + if (CheckItem != "" && CheckItem != null) { - sWhere = sWhere + " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) "; + sWhere = sWhere + " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) "; ds = oCN.RunProcReturn("Select HItemID,HNumber,HName from Gy_DotCheck " + sWhere + " Order by HItemID ", "Gy_DotCheck"); } else @@ -1782,7 +1793,7 @@ /// <returns></returns> [Route("Web/GetSc_ICMOBillListView")] [HttpGet] - public object GetSc_ICMOBillListView(string ICMOBill,int OrganizationID) + public object GetSc_ICMOBillListView(string ICMOBill, int OrganizationID) { if (ICMOBill != "") { @@ -1797,7 +1808,7 @@ } else { - string sql = "select * from h_v_IF_ICMOBillList "+ sWhere+ " and isnull(瀹℃牳浜�,'')<>'' and isnull(鍏抽棴浜�,'')='' and isnull(琛屽叧闂汉,'')='' order by 鍗曟嵁鍙� desc,hsubid "; + string sql = "select * from h_v_IF_ICMOBillList " + sWhere + " and isnull(瀹℃牳浜�,'')<>'' and isnull(鍏抽棴浜�,'')='' and isnull(琛屽叧闂汉,'')='' order by 鍗曟嵁鍙� desc,hsubid "; ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) @@ -1937,7 +1948,7 @@ /// <returns></returns> [Route("Web/GetGy_QCCheckItem")] [HttpGet] - public object GetGy_QCCheckItem(string CheckItem,int OrganizationID) + public object GetGy_QCCheckItem(string CheckItem, int OrganizationID) { if (CheckItem != "") { @@ -2132,7 +2143,7 @@ /// <returns></returns> [Route("Web/GetWMSBarCodeDetailsList")] [HttpGet] - public object GetWMSBarCodeDetailsList(int HInterID,string HBillType) + public object GetWMSBarCodeDetailsList(int HInterID, string HBillType) { try { @@ -2214,25 +2225,25 @@ //string json = JsonConvert.SerializeObject(dd); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //杩欓噷鏄惊鐜墍鏈� { - if (ds.Tables[0].Rows[i]["HPartentID"].ToString()=="0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //鍒ゆ柇鏄惁鏈�澶栧眰鏍硅妭鐐� + if (ds.Tables[0].Rows[i]["HPartentID"].ToString() == "0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //鍒ゆ柇鏄惁鏈�澶栧眰鏍硅妭鐐� { Menu tbj = new Menu(); tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString(); tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString(); - tbj.HPartentID =ds.Tables[0].Rows[i]["HPartentID"].ToString(); + tbj.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString(); tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); mu.Add(tbj); } } ToHierarchy.digui(ds.Tables[0], mu); - + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鍒犻櫎鎴愬姛锛�"; - objJsonResult.data =Newtonsoft.Json.JsonConvert.SerializeObject(mu); + objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(mu); return objJsonResult; } catch (Exception e) diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user index 1e5bac6..c710f74 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>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</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>11/01/2021 10:28:49</publishTime> + <publishTime>11/02/2021 16:45:08</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>11/01/2021 10:28:49</publishTime> + <publishTime>11/02/2021 16:45:08</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>11/01/2021 10:28:47</publishTime> + <publishTime>11/02/2021 16:45:06</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>11/01/2021 10:28:47</publishTime> + <publishTime>11/02/2021 16:45:06</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:02</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:02</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>10/14/2021 09:42:44</publishTime> + <publishTime>08/16/2021 17:23:13</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -60,34 +60,34 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>11/01/2021 10:28:44</publishTime> + <publishTime>11/02/2021 16:45:02</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>11/01/2021 10:28:44</publishTime> + <publishTime>11/02/2021 16:45:02</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>10/25/2021 09:28:37</publishTime> + <publishTime>11/02/2021 16:44:59</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>10/25/2021 09:28:37</publishTime> + <publishTime>11/02/2021 16:44:59</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:00</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:00</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:01</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>10/25/2021 09:28:38</publishTime> + <publishTime>11/02/2021 16:45:01</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -156,7 +156,7 @@ <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</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>10/29/2021 09:40:54</publishTime> + <publishTime>11/02/2021 16:45:11</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>10/29/2021 09:40:54</publishTime> + <publishTime>11/02/2021 16:45:11</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>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/bootstrap.min.css"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/Site.css"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/BLL.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/DAL.dll"> - <publishTime>10/27/2021 13:49:58</publishTime> + <publishTime>10/29/2021 19:50:53</publishTime> </File> <File Include="DLL/DBUtility.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Model.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Class.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Control.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/SQLHelper.dll"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Global.asax"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Index.html"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="packages.config"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/web.config"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> - <publishTime>10/14/2021 09:42:47</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> - <publishTime>10/25/2021 09:28:44</publishTime> + <publishTime>11/02/2021 16:45:28</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.cs" index ccb2971..18b3838 100644 --- "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.cs" +++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.cs" @@ -132,6 +132,7 @@ { dtpHFDate.Value = DateTime.Today; dtpHEDate.Value = DateTime.Today; + cmbHType.Text = "鍏ㄩ儴"; } private bool Fun_AllowQuery()//瀹℃牳鏌ヨ鏉′欢 @@ -162,11 +163,11 @@ //杩囨护鏉′欢Dlg string sDlgWhere = ""; sDlgWhere = sDlgWhere + ",'" + dtpHFDate.Value.ToShortDateString() + "'"; - sDlgWhere = sDlgWhere + ",'" + txtHWorkCenter.Text.Trim() + "'"; - sDlgWhere = sDlgWhere + ",'" + txtHSupName.Text.Trim() + "'"; - sDlgWhere = sDlgWhere + ",'" + txtHExProcNo.Text.Trim() + "'"; - sDlgWhere = sDlgWhere + ",'" + txtHOrderProcNo.Text.Trim() + "'"; + sDlgWhere = sDlgWhere + ",'" + cmbHType.Text.Trim() + "'"; + sDlgWhere = sDlgWhere + ",'" + txtHProcName.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + txtHMaterNumber.Text.Trim() + "'"; + sDlgWhere = sDlgWhere + ",'" + txtHMaterName.Text.Trim() + "'"; + sDlgWhere = sDlgWhere + ",'" + txtHMaterModel.Text.Trim() + "'"; if (sDlgWhere.Trim().Length > 0) { @@ -335,15 +336,6 @@ } } - private void cmdHWorkCenter_Click(object sender, EventArgs e) - { - BLL.ClsBaseSelect.SetTextByWorkCenter(txtHWorkCenter); - } - - private void cmdHSupName_Click(object sender, EventArgs e) - { - BLL.ClsBaseSelect.SetTextBySupplier(txtHSupName); - } private void grdMain_Scroll(object sender, ScrollEventArgs e) { @@ -370,8 +362,16 @@ DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text); } - - + //娓呯┖鎸夐挳 + private void btnClear_Click(object sender, EventArgs e) + { + dtpHFDate.Value = DateTime.Today; + cmbHType.Text = "鍏ㄩ儴"; + txtHProcName.Text = ""; + txtHMaterNumber.Text = ""; + txtHMaterName.Text = ""; + txtHMaterModel.Text = ""; + } diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.designer.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.designer.cs" index 08738af..41f44e4 100644 --- "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.designer.cs" +++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.designer.cs" @@ -50,15 +50,13 @@ this.bclk = new System.Windows.Forms.ToolStripButton(); this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator(); this.pPic = new System.Windows.Forms.Panel(); + this.txtHMaterModel = new System.Windows.Forms.TextBox(); + this.label9 = new System.Windows.Forms.Label(); this.lbljl = new System.Windows.Forms.Label(); this.lbldj = new System.Windows.Forms.Label(); - this.cmdHWorkCenter = new System.Windows.Forms.Button(); - this.cmdHSupName = new System.Windows.Forms.Button(); - this.txtHExProcNo = new System.Windows.Forms.TextBox(); - this.txtHWorkCenter = new System.Windows.Forms.TextBox(); - this.txtHSupName = new System.Windows.Forms.TextBox(); - this.txtHOrderProcNo = new System.Windows.Forms.TextBox(); - this.label8 = new System.Windows.Forms.Label(); + this.txtHProcName = new System.Windows.Forms.TextBox(); + this.txtHMaterNumber = new System.Windows.Forms.TextBox(); + this.txtHMaterName = new System.Windows.Forms.TextBox(); this.label7 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); @@ -77,8 +75,9 @@ this.timer2 = new System.Windows.Forms.Timer(this.components); this.grdMain = new System.Windows.Forms.DataGridView(); this.grdSum = new System.Windows.Forms.DataGridView(); - this.txtHMaterNumber = new System.Windows.Forms.TextBox(); - this.label9 = new System.Windows.Forms.Label(); + this.cmbHType = new System.Windows.Forms.ComboBox(); + this.label10 = new System.Windows.Forms.Label(); + this.btnClear = new System.Windows.Forms.Button(); this.Tool.SuspendLayout(); this.pPic.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); @@ -116,7 +115,7 @@ this.Tool.Location = new System.Drawing.Point(0, 0); this.Tool.Name = "Tool"; this.Tool.Padding = new System.Windows.Forms.Padding(0); - this.Tool.Size = new System.Drawing.Size(1400, 59); + this.Tool.Size = new System.Drawing.Size(1050, 47); this.Tool.Stretch = true; this.Tool.TabIndex = 16; this.Tool.Text = "toolStrip1"; @@ -130,7 +129,7 @@ this.toolStripDropDownButton1.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.toolStripDropDownButton1.ImageTransparentColor = System.Drawing.Color.Magenta; this.toolStripDropDownButton1.Name = "toolStripDropDownButton1"; - this.toolStripDropDownButton1.Size = new System.Drawing.Size(52, 56); + this.toolStripDropDownButton1.Size = new System.Drawing.Size(45, 44); this.toolStripDropDownButton1.Text = "寮曞嚭"; this.toolStripDropDownButton1.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.toolStripDropDownButton1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -138,14 +137,14 @@ // eXCELToolStripMenuItem // this.eXCELToolStripMenuItem.Name = "eXCELToolStripMenuItem"; - this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(122, 24); + this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(112, 22); this.eXCELToolStripMenuItem.Text = "EXCEL"; this.eXCELToolStripMenuItem.Click += new System.EventHandler(this.eXCELToolStripMenuItem_Click); // // cSVToolStripMenuItem // this.cSVToolStripMenuItem.Name = "cSVToolStripMenuItem"; - this.cSVToolStripMenuItem.Size = new System.Drawing.Size(122, 24); + this.cSVToolStripMenuItem.Size = new System.Drawing.Size(112, 22); this.cSVToolStripMenuItem.Text = "CSV"; this.cSVToolStripMenuItem.Click += new System.EventHandler(this.cSVToolStripMenuItem_Click); // @@ -167,7 +166,7 @@ // toolStripSeparator4 // this.toolStripSeparator4.Name = "toolStripSeparator4"; - this.toolStripSeparator4.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator4.Size = new System.Drawing.Size(6, 47); this.toolStripSeparator4.Visible = false; // // dy @@ -203,7 +202,7 @@ // toolStripSeparator2 // this.toolStripSeparator2.Name = "toolStripSeparator2"; - this.toolStripSeparator2.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator2.Size = new System.Drawing.Size(6, 47); // // cx // @@ -222,7 +221,7 @@ // toolStripSeparator1 // this.toolStripSeparator1.Name = "toolStripSeparator1"; - this.toolStripSeparator1.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator1.Size = new System.Drawing.Size(6, 47); // // tc // @@ -241,13 +240,13 @@ // toolStripSeparator3 // this.toolStripSeparator3.Name = "toolStripSeparator3"; - this.toolStripSeparator3.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator3.Size = new System.Drawing.Size(6, 47); // // toolStripSeparator8 // this.toolStripSeparator8.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator8.Name = "toolStripSeparator8"; - this.toolStripSeparator8.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator8.Size = new System.Drawing.Size(6, 47); // // mrlk // @@ -257,7 +256,7 @@ this.mrlk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.mrlk.ImageTransparentColor = System.Drawing.Color.White; this.mrlk.Name = "mrlk"; - this.mrlk.Size = new System.Drawing.Size(73, 56); + this.mrlk.Size = new System.Drawing.Size(60, 44); this.mrlk.Text = "榛樿鍒楀"; this.mrlk.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.mrlk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -267,7 +266,7 @@ // this.toolStripSeparator7.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator7.Name = "toolStripSeparator7"; - this.toolStripSeparator7.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator7.Size = new System.Drawing.Size(6, 47); // // bclk // @@ -277,7 +276,7 @@ this.bclk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.bclk.ImageTransparentColor = System.Drawing.Color.White; this.bclk.Name = "bclk"; - this.bclk.Size = new System.Drawing.Size(73, 56); + this.bclk.Size = new System.Drawing.Size(60, 44); this.bclk.Text = "淇濆瓨鍒楀"; this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -287,24 +286,23 @@ // this.toolStripSeparator9.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator9.Name = "toolStripSeparator9"; - this.toolStripSeparator9.Size = new System.Drawing.Size(6, 59); + this.toolStripSeparator9.Size = new System.Drawing.Size(6, 47); // // pPic // this.pPic.BackColor = System.Drawing.Color.White; this.pPic.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pPic.BackgroundImage"))); this.pPic.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None; - this.pPic.Controls.Add(this.txtHMaterNumber); + this.pPic.Controls.Add(this.btnClear); + this.pPic.Controls.Add(this.cmbHType); + this.pPic.Controls.Add(this.label10); + this.pPic.Controls.Add(this.txtHMaterModel); this.pPic.Controls.Add(this.label9); this.pPic.Controls.Add(this.lbljl); this.pPic.Controls.Add(this.lbldj); - this.pPic.Controls.Add(this.cmdHWorkCenter); - this.pPic.Controls.Add(this.cmdHSupName); - this.pPic.Controls.Add(this.txtHExProcNo); - this.pPic.Controls.Add(this.txtHWorkCenter); - this.pPic.Controls.Add(this.txtHSupName); - this.pPic.Controls.Add(this.txtHOrderProcNo); - this.pPic.Controls.Add(this.label8); + this.pPic.Controls.Add(this.txtHProcName); + this.pPic.Controls.Add(this.txtHMaterNumber); + this.pPic.Controls.Add(this.txtHMaterName); this.pPic.Controls.Add(this.label7); this.pPic.Controls.Add(this.label5); this.pPic.Controls.Add(this.label2); @@ -313,159 +311,121 @@ this.pPic.Controls.Add(this.label4); this.pPic.Controls.Add(this.lblCaption); this.pPic.Dock = System.Windows.Forms.DockStyle.Top; - this.pPic.Location = new System.Drawing.Point(0, 59); - this.pPic.Margin = new System.Windows.Forms.Padding(4); + this.pPic.Location = new System.Drawing.Point(0, 47); this.pPic.Name = "pPic"; - this.pPic.Size = new System.Drawing.Size(1400, 69); + this.pPic.Size = new System.Drawing.Size(1050, 55); this.pPic.TabIndex = 17; + // + // txtHMaterModel + // + this.txtHMaterModel.Location = new System.Drawing.Point(680, 27); + this.txtHMaterModel.Name = "txtHMaterModel"; + this.txtHMaterModel.Size = new System.Drawing.Size(111, 21); + this.txtHMaterModel.TabIndex = 82; + // + // label9 + // + this.label9.AutoSize = true; + this.label9.BackColor = System.Drawing.Color.Transparent; + this.label9.Location = new System.Drawing.Point(625, 31); + this.label9.Name = "label9"; + this.label9.Size = new System.Drawing.Size(53, 12); + this.label9.TabIndex = 81; + this.label9.Text = "瑙勬牸鍨嬪彿"; // // lbljl // this.lbljl.AutoSize = true; - this.lbljl.Location = new System.Drawing.Point(1063, 39); - this.lbljl.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lbljl.Location = new System.Drawing.Point(797, 31); this.lbljl.Name = "lbljl"; - this.lbljl.Size = new System.Drawing.Size(15, 15); + this.lbljl.Size = new System.Drawing.Size(11, 12); this.lbljl.TabIndex = 80; this.lbljl.Text = " "; // // lbldj // this.lbldj.AutoSize = true; - this.lbldj.Location = new System.Drawing.Point(1063, 16); - this.lbldj.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lbldj.Location = new System.Drawing.Point(797, 13); this.lbldj.Name = "lbldj"; - this.lbldj.Size = new System.Drawing.Size(0, 15); + this.lbldj.Size = new System.Drawing.Size(0, 12); this.lbldj.TabIndex = 79; // - // cmdHWorkCenter + // txtHProcName // - this.cmdHWorkCenter.Image = ((System.Drawing.Image)(resources.GetObject("cmdHWorkCenter.Image"))); - this.cmdHWorkCenter.ImageAlign = System.Drawing.ContentAlignment.TopRight; - this.cmdHWorkCenter.Location = new System.Drawing.Point(529, 35); - this.cmdHWorkCenter.Margin = new System.Windows.Forms.Padding(4); - this.cmdHWorkCenter.Name = "cmdHWorkCenter"; - this.cmdHWorkCenter.Size = new System.Drawing.Size(29, 28); - this.cmdHWorkCenter.TabIndex = 78; - this.cmdHWorkCenter.UseVisualStyleBackColor = true; - this.cmdHWorkCenter.Click += new System.EventHandler(this.cmdHWorkCenter_Click); + this.txtHProcName.Location = new System.Drawing.Point(680, 3); + this.txtHProcName.Name = "txtHProcName"; + this.txtHProcName.Size = new System.Drawing.Size(111, 21); + this.txtHProcName.TabIndex = 76; // - // cmdHSupName + // txtHMaterNumber // - this.cmdHSupName.Image = ((System.Drawing.Image)(resources.GetObject("cmdHSupName.Image"))); - this.cmdHSupName.ImageAlign = System.Drawing.ContentAlignment.TopRight; - this.cmdHSupName.Location = new System.Drawing.Point(870, 35); - this.cmdHSupName.Margin = new System.Windows.Forms.Padding(4); - this.cmdHSupName.Name = "cmdHSupName"; - this.cmdHSupName.Size = new System.Drawing.Size(29, 28); - this.cmdHSupName.TabIndex = 77; - this.cmdHSupName.UseVisualStyleBackColor = true; - this.cmdHSupName.Click += new System.EventHandler(this.cmdHSupName_Click); + this.txtHMaterNumber.Location = new System.Drawing.Point(330, 27); + this.txtHMaterNumber.Name = "txtHMaterNumber"; + this.txtHMaterNumber.Size = new System.Drawing.Size(111, 21); + this.txtHMaterNumber.TabIndex = 75; // - // txtHExProcNo + // txtHMaterName // - this.txtHExProcNo.Location = new System.Drawing.Point(535, 6); - this.txtHExProcNo.Margin = new System.Windows.Forms.Padding(4); - this.txtHExProcNo.Name = "txtHExProcNo"; - this.txtHExProcNo.Size = new System.Drawing.Size(160, 25); - this.txtHExProcNo.TabIndex = 76; - // - // txtHWorkCenter - // - this.txtHWorkCenter.Location = new System.Drawing.Point(294, 36); - this.txtHWorkCenter.Margin = new System.Windows.Forms.Padding(4); - this.txtHWorkCenter.Name = "txtHWorkCenter"; - this.txtHWorkCenter.Size = new System.Drawing.Size(232, 25); - this.txtHWorkCenter.TabIndex = 75; - // - // txtHSupName - // - this.txtHSupName.Location = new System.Drawing.Point(656, 36); - this.txtHSupName.Margin = new System.Windows.Forms.Padding(4); - this.txtHSupName.Name = "txtHSupName"; - this.txtHSupName.Size = new System.Drawing.Size(211, 25); - this.txtHSupName.TabIndex = 74; - // - // txtHOrderProcNo - // - this.txtHOrderProcNo.Location = new System.Drawing.Point(294, 8); - this.txtHOrderProcNo.Margin = new System.Windows.Forms.Padding(4); - this.txtHOrderProcNo.Name = "txtHOrderProcNo"; - this.txtHOrderProcNo.Size = new System.Drawing.Size(160, 25); - this.txtHOrderProcNo.TabIndex = 73; - // - // label8 - // - this.label8.AutoSize = true; - this.label8.BackColor = System.Drawing.Color.Transparent; - this.label8.Location = new System.Drawing.Point(205, 12); - this.label8.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); - this.label8.Name = "label8"; - this.label8.Size = new System.Drawing.Size(82, 15); - this.label8.TabIndex = 72; - this.label8.Text = "璁㈠崟璺熻釜鍙�"; + this.txtHMaterName.Location = new System.Drawing.Point(505, 27); + this.txtHMaterName.Name = "txtHMaterName"; + this.txtHMaterName.Size = new System.Drawing.Size(111, 21); + this.txtHMaterName.TabIndex = 74; // // label7 // this.label7.AutoSize = true; this.label7.BackColor = System.Drawing.Color.Transparent; - this.label7.Location = new System.Drawing.Point(463, 11); - this.label7.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label7.Location = new System.Drawing.Point(625, 7); this.label7.Name = "label7"; - this.label7.Size = new System.Drawing.Size(67, 15); + this.label7.Size = new System.Drawing.Size(53, 12); this.label7.TabIndex = 71; - this.label7.Text = "娴佽浆鍗″彿"; + this.label7.Text = "宸ュ簭鍚嶇О"; // // label5 // this.label5.AutoSize = true; this.label5.BackColor = System.Drawing.Color.Transparent; - this.label5.Location = new System.Drawing.Point(596, 39); - this.label5.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label5.Location = new System.Drawing.Point(450, 31); this.label5.Name = "label5"; - this.label5.Size = new System.Drawing.Size(52, 15); + this.label5.Size = new System.Drawing.Size(53, 12); this.label5.TabIndex = 70; - this.label5.Text = "渚涘簲鍟�"; + this.label5.Text = "鐗╂枡鍚嶇О"; // // label2 // this.label2.AutoSize = true; this.label2.BackColor = System.Drawing.Color.Transparent; - this.label2.Location = new System.Drawing.Point(212, 39); - this.label2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label2.Location = new System.Drawing.Point(275, 31); this.label2.Name = "label2"; - this.label2.Size = new System.Drawing.Size(67, 15); + this.label2.Size = new System.Drawing.Size(53, 12); this.label2.TabIndex = 69; - this.label2.Text = "宸ヤ綔涓績"; + this.label2.Text = "鐗╂枡浠g爜"; // // dataGridView1 // this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; - this.dataGridView1.Location = new System.Drawing.Point(906, 8); - this.dataGridView1.Margin = new System.Windows.Forms.Padding(4); + this.dataGridView1.Location = new System.Drawing.Point(995, 10); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.RowTemplate.Height = 23; - this.dataGridView1.Size = new System.Drawing.Size(36, 19); + this.dataGridView1.Size = new System.Drawing.Size(27, 15); this.dataGridView1.TabIndex = 68; this.dataGridView1.Visible = false; // // dtpHFDate // this.dtpHFDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; - this.dtpHFDate.Location = new System.Drawing.Point(751, 6); - this.dtpHFDate.Margin = new System.Windows.Forms.Padding(4); + this.dtpHFDate.Location = new System.Drawing.Point(330, 3); this.dtpHFDate.Name = "dtpHFDate"; - this.dtpHFDate.Size = new System.Drawing.Size(147, 25); + this.dtpHFDate.Size = new System.Drawing.Size(111, 21); this.dtpHFDate.TabIndex = 59; // // label4 // this.label4.AutoSize = true; this.label4.BackColor = System.Drawing.Color.Transparent; - this.label4.Location = new System.Drawing.Point(704, 11); - this.label4.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label4.Location = new System.Drawing.Point(299, 7); this.label4.Name = "label4"; - this.label4.Size = new System.Drawing.Size(37, 15); + this.label4.Size = new System.Drawing.Size(29, 12); this.label4.TabIndex = 58; this.label4.Text = "鏃堕棿"; // @@ -475,10 +435,9 @@ this.lblCaption.BackColor = System.Drawing.Color.Transparent; this.lblCaption.Cursor = System.Windows.Forms.Cursors.No; this.lblCaption.Font = new System.Drawing.Font("瀹嬩綋", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); - this.lblCaption.Location = new System.Drawing.Point(16, 20); - this.lblCaption.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lblCaption.Location = new System.Drawing.Point(12, 16); this.lblCaption.Name = "lblCaption"; - this.lblCaption.Size = new System.Drawing.Size(179, 24); + this.lblCaption.Size = new System.Drawing.Size(152, 19); this.lblCaption.TabIndex = 4; this.lblCaption.Text = "ReportTemplet"; // @@ -486,10 +445,9 @@ // this.cmdHEDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHEDeptID.Image"))); this.cmdHEDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight; - this.cmdHEDeptID.Location = new System.Drawing.Point(967, 189); - this.cmdHEDeptID.Margin = new System.Windows.Forms.Padding(4); + this.cmdHEDeptID.Location = new System.Drawing.Point(725, 151); this.cmdHEDeptID.Name = "cmdHEDeptID"; - this.cmdHEDeptID.Size = new System.Drawing.Size(29, 28); + this.cmdHEDeptID.Size = new System.Drawing.Size(22, 22); this.cmdHEDeptID.TabIndex = 67; this.cmdHEDeptID.UseVisualStyleBackColor = true; this.cmdHEDeptID.Visible = false; @@ -499,10 +457,9 @@ // this.cmdHBDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHBDeptID.Image"))); this.cmdHBDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight; - this.cmdHBDeptID.Location = new System.Drawing.Point(1026, 230); - this.cmdHBDeptID.Margin = new System.Windows.Forms.Padding(4); + this.cmdHBDeptID.Location = new System.Drawing.Point(770, 184); this.cmdHBDeptID.Name = "cmdHBDeptID"; - this.cmdHBDeptID.Size = new System.Drawing.Size(29, 28); + this.cmdHBDeptID.Size = new System.Drawing.Size(22, 22); this.cmdHBDeptID.TabIndex = 66; this.cmdHBDeptID.UseVisualStyleBackColor = true; this.cmdHBDeptID.Visible = false; @@ -512,29 +469,26 @@ // this.label6.AutoSize = true; this.label6.BackColor = System.Drawing.Color.Transparent; - this.label6.Location = new System.Drawing.Point(877, 202); - this.label6.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label6.Location = new System.Drawing.Point(658, 162); this.label6.Name = "label6"; - this.label6.Size = new System.Drawing.Size(22, 15); + this.label6.Size = new System.Drawing.Size(17, 12); this.label6.TabIndex = 65; this.label6.Text = "鑷�"; this.label6.Visible = false; // // txtHEDeptID // - this.txtHEDeptID.Location = new System.Drawing.Point(857, 199); - this.txtHEDeptID.Margin = new System.Windows.Forms.Padding(4); + this.txtHEDeptID.Location = new System.Drawing.Point(643, 159); this.txtHEDeptID.Name = "txtHEDeptID"; - this.txtHEDeptID.Size = new System.Drawing.Size(160, 25); + this.txtHEDeptID.Size = new System.Drawing.Size(121, 21); this.txtHEDeptID.TabIndex = 64; this.txtHEDeptID.Visible = false; // // txtHBDeptID // - this.txtHBDeptID.Location = new System.Drawing.Point(820, 199); - this.txtHBDeptID.Margin = new System.Windows.Forms.Padding(4); + this.txtHBDeptID.Location = new System.Drawing.Point(615, 159); this.txtHBDeptID.Name = "txtHBDeptID"; - this.txtHBDeptID.Size = new System.Drawing.Size(160, 25); + this.txtHBDeptID.Size = new System.Drawing.Size(121, 21); this.txtHBDeptID.TabIndex = 63; this.txtHBDeptID.Visible = false; // @@ -542,10 +496,9 @@ // this.label1.AutoSize = true; this.label1.BackColor = System.Drawing.Color.Transparent; - this.label1.Location = new System.Drawing.Point(854, 180); - this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label1.Location = new System.Drawing.Point(640, 144); this.label1.Name = "label1"; - this.label1.Size = new System.Drawing.Size(61, 15); + this.label1.Size = new System.Drawing.Size(47, 12); this.label1.TabIndex = 62; this.label1.Text = "閮� 闂�"; this.label1.Visible = false; @@ -553,10 +506,9 @@ // dtpHEDate // this.dtpHEDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; - this.dtpHEDate.Location = new System.Drawing.Point(782, 221); - this.dtpHEDate.Margin = new System.Windows.Forms.Padding(4); + this.dtpHEDate.Location = new System.Drawing.Point(586, 177); this.dtpHEDate.Name = "dtpHEDate"; - this.dtpHEDate.Size = new System.Drawing.Size(147, 25); + this.dtpHEDate.Size = new System.Drawing.Size(111, 21); this.dtpHEDate.TabIndex = 61; this.dtpHEDate.Visible = false; // @@ -564,10 +516,9 @@ // this.label3.AutoSize = true; this.label3.BackColor = System.Drawing.Color.Transparent; - this.label3.Location = new System.Drawing.Point(800, 266); - this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label3.Location = new System.Drawing.Point(600, 213); this.label3.Name = "label3"; - this.label3.Size = new System.Drawing.Size(67, 15); + this.label3.Size = new System.Drawing.Size(53, 12); this.label3.TabIndex = 60; this.label3.Text = "缁撴潫鏃ユ湡"; this.label3.Visible = false; @@ -583,17 +534,16 @@ this.grdMain.BackgroundColor = System.Drawing.Color.White; this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill; - this.grdMain.Location = new System.Drawing.Point(0, 128); - this.grdMain.Margin = new System.Windows.Forms.Padding(4); + this.grdMain.Location = new System.Drawing.Point(0, 102); this.grdMain.Name = "grdMain"; this.grdMain.ReadOnly = true; this.grdMain.RowTemplate.Height = 23; - this.grdMain.Size = new System.Drawing.Size(1400, 520); + this.grdMain.Size = new System.Drawing.Size(1050, 417); this.grdMain.TabIndex = 54; this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp); + this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged); this.grdMain.Scroll += new System.Windows.Forms.ScrollEventHandler(this.grdMain_Scroll); this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint); - this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged); // // grdSum // @@ -602,39 +552,53 @@ this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control; this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom; - this.grdSum.Location = new System.Drawing.Point(0, 648); - this.grdSum.Margin = new System.Windows.Forms.Padding(4); + this.grdSum.Location = new System.Drawing.Point(0, 519); this.grdSum.Name = "grdSum"; this.grdSum.ReadOnly = true; this.grdSum.RowTemplate.Height = 23; this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None; - this.grdSum.Size = new System.Drawing.Size(1400, 24); + this.grdSum.Size = new System.Drawing.Size(1050, 19); this.grdSum.TabIndex = 55; // - // txtHMaterNumber + // cmbHType // - this.txtHMaterNumber.Location = new System.Drawing.Point(980, 36); - this.txtHMaterNumber.Margin = new System.Windows.Forms.Padding(4); - this.txtHMaterNumber.Name = "txtHMaterNumber"; - this.txtHMaterNumber.Size = new System.Drawing.Size(222, 25); - this.txtHMaterNumber.TabIndex = 82; + this.cmbHType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; + this.cmbHType.FormattingEnabled = true; + this.cmbHType.Items.AddRange(new object[] { + "鍏ㄩ儴", + "寰呮帴鏀�", + "鍦ㄥ埗鍝�"}); + this.cmbHType.Location = new System.Drawing.Point(505, 3); + this.cmbHType.Name = "cmbHType"; + this.cmbHType.Size = new System.Drawing.Size(111, 20); + this.cmbHType.TabIndex = 84; // - // label9 + // label10 // - this.label9.AutoSize = true; - this.label9.BackColor = System.Drawing.Color.Transparent; - this.label9.Location = new System.Drawing.Point(910, 39); - this.label9.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); - this.label9.Name = "label9"; - this.label9.Size = new System.Drawing.Size(67, 15); - this.label9.TabIndex = 81; - this.label9.Text = "鐗╂枡浠g爜"; + this.label10.AutoSize = true; + this.label10.BackColor = System.Drawing.Color.Transparent; + this.label10.ForeColor = System.Drawing.Color.Black; + this.label10.Location = new System.Drawing.Point(474, 7); + this.label10.Name = "label10"; + this.label10.Size = new System.Drawing.Size(29, 12); + this.label10.TabIndex = 83; + this.label10.Text = "鐘舵��"; + // + // btnClear + // + this.btnClear.Location = new System.Drawing.Point(799, 2); + this.btnClear.Name = "btnClear"; + this.btnClear.Size = new System.Drawing.Size(75, 23); + this.btnClear.TabIndex = 85; + this.btnClear.Text = "娓呯┖"; + this.btnClear.UseVisualStyleBackColor = true; + this.btnClear.Click += new System.EventHandler(this.btnClear_Click); // // MES_WIPProcReport // - this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F); + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; - this.ClientSize = new System.Drawing.Size(1400, 672); + this.ClientSize = new System.Drawing.Size(1050, 538); this.Controls.Add(this.grdMain); this.Controls.Add(this.grdSum); this.Controls.Add(this.pPic); @@ -648,13 +612,12 @@ this.Controls.Add(this.dtpHEDate); this.Controls.Add(this.label3); this.KeyPreview = true; - this.Margin = new System.Windows.Forms.Padding(4); this.Name = "MES_WIPProcReport"; this.Text = "ReportTemplet"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.Frm_EasyReport_Load); - this.KeyUp += new System.Windows.Forms.KeyEventHandler(this.MES_WIPProcReport_KeyUp); this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.MES_WIPProcReport_KeyDown); + this.KeyUp += new System.Windows.Forms.KeyEventHandler(this.MES_WIPProcReport_KeyUp); this.Tool.ResumeLayout(false); this.Tool.PerformLayout(); this.pPic.ResumeLayout(false); @@ -701,22 +664,21 @@ public System.Windows.Forms.TextBox txtHBDeptID; private System.Windows.Forms.Label label1; private System.Windows.Forms.DataGridView dataGridView1; - private System.Windows.Forms.Label label8; private System.Windows.Forms.Label label7; private System.Windows.Forms.Label label5; private System.Windows.Forms.Label label2; - public System.Windows.Forms.TextBox txtHExProcNo; - public System.Windows.Forms.TextBox txtHWorkCenter; - public System.Windows.Forms.TextBox txtHSupName; - public System.Windows.Forms.TextBox txtHOrderProcNo; - private System.Windows.Forms.Button cmdHWorkCenter; - private System.Windows.Forms.Button cmdHSupName; + public System.Windows.Forms.TextBox txtHProcName; + public System.Windows.Forms.TextBox txtHMaterNumber; + public System.Windows.Forms.TextBox txtHMaterName; private System.Windows.Forms.ToolStripDropDownButton toolStripDropDownButton1; private System.Windows.Forms.ToolStripMenuItem eXCELToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem cSVToolStripMenuItem; private System.Windows.Forms.Label lbljl; private System.Windows.Forms.Label lbldj; - public System.Windows.Forms.TextBox txtHMaterNumber; + public System.Windows.Forms.TextBox txtHMaterModel; private System.Windows.Forms.Label label9; + private System.Windows.Forms.ComboBox cmbHType; + private System.Windows.Forms.Label label10; + private System.Windows.Forms.Button btnClear; } } \ No newline at end of file diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.resx" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.resx" index bb388fd..90ed23c 100644 --- "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.resx" +++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/MES_WIPProcReport.resx" @@ -112,18 +112,18 @@ <value>2.0</value> </resheader> <resheader name="reader"> - <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> + <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> </resheader> <resheader name="writer"> - <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> + <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> </resheader> - <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> + <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> <value>98, 21</value> </metadata> - <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> + <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> <value>188, 21</value> </metadata> - <assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> + <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> <data name="Tool.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> /9j/4AAQSkZJRgABAQEASABIAAD/4QR8RXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAAB @@ -256,7 +256,7 @@ <data name="toolStripDropDownButton1.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAE6SURBVDhPY0hOnvOfEgw2AAY6OjqA5Jn/v78f+P/tzYb/ + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAE6SURBVDhPY0hOnvOfEgw2AAY6OjqA5Jn/v78f+P/tzYb/ 7+/P+f/iUsf/x8fK/t/Zmfz/2hr//xcW2v9PS0v7f+DAgf8MDAwIA2aeAWqdaYxiwDuoAY9gBqwFGWD3 v9AbqBGkGZ8BX1+vh7sAZMDdXSAXBIBdADIgNWMh8QY8PlYO9QLCgDR8BvwBewFiwMtLnfAwuAoNA4IG QMIAZMBsoAGIMLhKrAvAXkByAaoBkEBMzcRiwPTjv8CShHBmwYr/abgMmHzgy//+7W/+d657/L91ya3/ @@ -268,7 +268,7 @@ <data name="yl.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAHXSURBVDhPjZJNSBtRFIUH3Ke4aiHVTRd2V7B7EXGhriyu + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAHXSURBVDhPjZJNSBtRFIUH3Ke4aiHVTRd2V7B7EXGhriyu ao0ImqppU39qSFVMtVZLrfQXFMlKFy4KbaXQTao7Cd1U3VSyFFQIqNXYZDKZTHJ8976ZTEZD6AcnL+/e e857A08p5uX7MEgv3i4h9GYRE3MLJUW9sdlPMG0SKhCvP4Z5/R8cIVYA0dk/AkOsKT1fUmpWzvkCz+2A 4PQ7WRW0tnvR5unFvQ7vFVH9fvdjdPYNoccftANGJufZbOTyvJZjdOaD8/uJ4dAcNzO6ga3dPezEbNFe @@ -282,7 +282,7 @@ <data name="dy.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAGYSURBVDhPjYzPK8NxHMY//4uUyxycODhxkIOaRSiSA3Eg + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAGYSURBVDhPjYzPK8NxHMY//4uUyxycODhxkIOaRSiSA3Eg sbY1hi22Iptt5ecmuQgXxcWvFGojuXDy66AUyo9p9t2wx/f5pC9l+/LU06dP79frET/jCc7B5QvB6Z3R 6vLNwB0IIzi7hC8se/pHJpAp/rFD+f45Ynf7JfiRTmtlvN6IfBndEYtzVEKpt3etnAiFt2Gsa0J1Qwt6 PcHsA10Ojxx4VVJaE8kU3j/SuHuIIXp8Crc/nH3AbOuTA89xBbF48ruvSbyoZcw2x++BqdA8xDTQbemR @@ -295,7 +295,7 @@ <data name="view.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAF/SURBVDhPnZFNSwJBAIbnX1Q/IOoYeAzqHh3C6JAgJEgU + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAF/SURBVDhPnZFNSwJBAIbnX1Q/IOoYeAzqHh3C6JAgJEgU UQgaeQgxKZQwtBRC7YsiOnQPISISKyEPUrcgKqIipNQ11/XzbWfQdf1IxQceZnaYeVhmiNV9AIvDB/OG V3JF/F5z7cK9fwrSCtP6NhrhdNyxsWXEuOpkGwvFoiTFbg+xkdI0YjDb2aZsLi9J8fouMDqhhlKlhcm2 9X9At2xlB1JCFnzJdCaHAl3jBeSyWWZpez3zSxYW4FIZJPmKQqZ0cDpcbS0zehML/HA8Ysk0k09npMNK @@ -308,7 +308,7 @@ <data name="cx.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAFOSURBVDhPnZBPK0RRGIfvxkL5Dha+gLK0tsRGkY3dkK2w + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAFOSURBVDhPnZBPK0RRGIfvxkL5Dha+gLK0tsRGkY3dkK2w UjJbCzQWk5EFRslEiUwZFNLo+lMaxWCIIUXIQhYzj/edc28NHUzzq1/v7Z7zPOee6/ybgMu3lhwP6NrO F9q6blqaSDaETnOs3UIiCx2bUBuDmjmojpr5t0QWZ9KQfJSNkll5roxAxQRUTZn+LvBOH0vBQgbidzB0 KF+wCA1xaEyYqbVLPEG/CwMC9iShbQu69yEo0uFzM7V2QV2Y2E2e4Al07kGL3L/3CEKXsCRXSryaOZ3J @@ -320,7 +320,7 @@ <data name="tc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAADCSURBVDhPpZJdCoMwEIRzpxxJ6Ak2z/ZZnysIBXuUHMA7 + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADCSURBVDhPpZJdCoMwEIRzpxxJ6Ak2z/ZZnysIBXuUHMA7 bXeWrGBMYkoHh+gk8xl/XEneP7jXqXIWJkIgHscnT/PEy2vhz7ZhMQ/Dm5l3ObRcB1ACzAKQ6FTcV69G rgWTbUl3QFQtFgGpfAAoAVDOi2ZbrwW5hwY4N+P6FmDlkrsBq6zOy3AXIEkhGHMbIMaorgGgI8Cu7CsY wOZbAEgDBch/gOveRzgJAKLwH0CGJsDmxU1dAMiSu3R5iZr+oJuic1+SJ5jRbOqnmgAAAABJRU5ErkJg @@ -330,7 +330,7 @@ <data name="mrlk.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAH/SURBVDhPfZHfS1NhGMefkCLQu/A/6MK6SbMQFlg3dudN + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAH/SURBVDhPfZHfS1NhGMefkCLQu/A/6MK6SbMQFlg3dudN oBFDY9BF05XMMAoLL3bhxGB4zjzoVCKim4iCgkCMSam1cqP9aO4YJlpIDmqh00IRv73Pe87OWuV54Mt7 znm/n895z0aF8Stj6FdGoARDUAf/H97jTp96FyZmjC8QwuRUBB0zACkiwT0i9rxvgBcvX4MZEye65Vex vp6HJ7yJ+1nYpmNyE3nRZcbEiW74AljL5UB3gOk84J8HnFPA0UfirZqIaoZPMQDZZcbEibp6+vE9mwUF @@ -345,7 +345,7 @@ <data name="bclk.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAH4SURBVDhPjZPNS1RRGMZfI2jRLlqUEKLUQgsl3EauEoRW + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAH4SURBVDhPjZPNS1RRGMZfI2jRLlqUEKLUQgsl3EauEoRW /QN+phG4CQXTNrPLbzFrpZAuBIfEqChctFRndHI0YzKnxkHFYQgH50NH5+o8Pm/HwQ/s4oGHc++5z/O7 77nnvSKPPZDyKYSfA8tN55N6NfMvK1XT+LIBxAH8PqfUqxnNitR+g1x/yQuRlJWCZVm2Uo965RozmpXq aRR/Io1jYgJwTdlLPeqt92QqqHLj7phZTCST2Nqxl3rUWzrOTKX7JGBykm9x2Us96r3p1ApOAf5G49iI @@ -3914,36 +3914,6 @@ //////////////////////////////////////////////////////////////////////8A </value> </data> - <data name="cmdHWorkCenter.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> - <value> - R0lGODlhEAAQAIYAAAAzmQBmzP///1o7AJlmAOazAMTz/9mmAEW5//nNT+W5ToPV/5TW/cyZAAyf/7Dp - /yOn/2jD/q3h/le8/sz3/5zg/7bt/73l/7Xs/2fH/4DT///bnZXb/97//2rK/wWb/8np/6zf/1S//77x - /73w/8Xv/1+//wmc/1jA/5Db/5LV/6rn/6Xb/zCt/33O/9X3/4LO/7jj/4PT/x+m/7nk/3XP/3PJ/3bQ - /6Tb/5Td/zCv/3fM/029/4za/6Pf/ZHc/6Pk/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEBAAAh+QQB - AABBACwAAAAAEAAQAAAIqACDCBwoMIDBAAQTBjEYIcKECQYVLmQQ44KJFhBmQECYMAAOEAJYnPjgwAHH - gQEYqAhBA4YOBDwQIDg5cYcLGyg8LOixYAFNABJkZBBRI8cDEg98ACAIlIOGGylWGOhgwMBSphUq/ACC - wQAFClcFEiAAQICAEhZGvDAbloCCDQUAlDUrQO5AtwkKHBgQRK7duwryHmjAV2IQAoIJGxY4QK/ixYwH - FIYcEAA7 -</value> - </data> - <data name="cmdHSupName.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> - <value> - R0lGODlhEAAQAIYAAAAzmQBmzP///1o7AJlmAOazAMTz/9mmAEW5//nNT+W5ToPV/5TW/cyZAAyf/7Dp - /yOn/2jD/q3h/le8/sz3/5zg/7bt/73l/7Xs/2fH/4DT///bnZXb/97//2rK/wWb/8np/6zf/1S//77x - /73w/8Xv/1+//wmc/1jA/5Db/5LV/6rn/6Xb/zCt/33O/9X3/4LO/7jj/4PT/x+m/7nk/3XP/3PJ/3bQ - /6Tb/5Td/zCv/3fM/029/4za/6Pf/ZHc/6Pk/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA - AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEBAAAh+QQB - AABBACwAAAAAEAAQAAAIqACDCBwoMIDBAAQTBjEYIcKECQYVLmQQ44KJFhBmQECYMAAOEAJYnPjgwAHH - gQEYqAhBA4YOBDwQIDg5cYcLGyg8LOixYAFNABJkZBBRI8cDEg98ACAIlIOGGylWGOhgwMBSphUq/ACC - wQAFClcFEiAAQICAEhZGvDAbloCCDQUAlDUrQO5AtwkKHBgQRK7duwryHmjAV2IQAoIJGxY4QK/ixYwH - FIYcEAA7 -</value> - </data> <data name="cmdHEDeptID.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> R0lGODlhEAAQAIYAAAAzmQBmzP///1o7AJlmAOazAMTz/9mmAEW5//nNT+W5ToPV/5TW/cyZAAyf/7Dp @@ -3974,10 +3944,10 @@ FIYcEAA7 </value> </data> - <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> + <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> <value>266, 21</value> </metadata> - <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> + <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <value>42</value> </metadata> </root> \ No newline at end of file diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs" index 1912471..189f440 100644 --- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs" +++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs" @@ -622,7 +622,8 @@ int HKeepCol = Fun_GetCol("K3淇濈"); int HSecManagerCol = Fun_GetCol("K3楠屾敹"); int HDeptCol = Fun_GetCol("K3閮ㄩ棬"); - DAL.ClsKf_ProductInBill oClsKf_ProductInBill ; + DAL.ClsKf_ProductInBill oClsKf_ProductInBill; + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //鑾峰彇绯荤粺鍙傛暟 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); if (oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo) == false) @@ -639,6 +640,34 @@ MessageBox.Show("浼氳鏈熼棿鏈夐敊璇紒 " + DBUtility.ClsPub.sExeReturnInfo); return; } + string sHInterID = ""; + for (int i = 0; i < grdMain.SelectedRows.Count; i++) + { + sHInterID = sHInterID + "," + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value); + } + if (sHInterID=="") + { + MessageBox.Show("娌℃湁閫変腑鐨勫崟鎹槑缁嗚锛岃鍏堥�夋嫨瑕佸叆搴撶殑鍗曟嵁锛�", "鎻愮ず"); + return; + } + else + { + DataSet DS = oCn.RunProcReturn("exec h_p_MES_StationOutBillList_Bad_PreProductIn '" + sHInterID + "'", "h_p_MES_StationOutBillList_Bad_PreProductIn", ref DBUtility.ClsPub.sExeReturnInfo); + if (DS == null || DS.Tables[0].Rows.Count == 0) + { + MessageBox.Show("鍏ュ簱鍓嶅垽鏂け璐ワ紒", "鎻愮ず"); + return; + } + else + { + if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1") + { + MessageBox.Show(DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"])); + return; + } + } + } + Int64 n = 0; //寰幆 閫変腑琛� for (int i = 0; i < grdMain.SelectedRows.Count; i++) diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.designer.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.designer.cs" index e016a63..d8cd49b 100644 --- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.designer.cs" +++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.designer.cs" @@ -98,10 +98,9 @@ this.pPic.Controls.Add(this.panel1); this.pPic.Controls.Add(this.lblCaption); this.pPic.Dock = System.Windows.Forms.DockStyle.Top; - this.pPic.Location = new System.Drawing.Point(0, 62); - this.pPic.Margin = new System.Windows.Forms.Padding(4); + this.pPic.Location = new System.Drawing.Point(0, 50); this.pPic.Name = "pPic"; - this.pPic.Size = new System.Drawing.Size(1661, 66); + this.pPic.Size = new System.Drawing.Size(1246, 53); this.pPic.TabIndex = 15; // // cmbHStatus @@ -112,9 +111,10 @@ "鏈悓姝�", "宸插悓姝�", "鍏ㄩ儴"}); - this.cmbHStatus.Location = new System.Drawing.Point(461, 15); + this.cmbHStatus.Location = new System.Drawing.Point(346, 12); + this.cmbHStatus.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); this.cmbHStatus.Name = "cmbHStatus"; - this.cmbHStatus.Size = new System.Drawing.Size(121, 23); + this.cmbHStatus.Size = new System.Drawing.Size(92, 20); this.cmbHStatus.TabIndex = 20; this.cmbHStatus.SelectedIndexChanged += new System.EventHandler(this.cmbHStatus_SelectedIndexChanged); // @@ -122,9 +122,10 @@ // this.label4.AutoSize = true; this.label4.BackColor = System.Drawing.Color.Transparent; - this.label4.Location = new System.Drawing.Point(374, 19); + this.label4.Location = new System.Drawing.Point(280, 15); + this.label4.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); this.label4.Name = "label4"; - this.label4.Size = new System.Drawing.Size(67, 15); + this.label4.Size = new System.Drawing.Size(53, 12); this.label4.TabIndex = 19; this.label4.Text = "鍚屾鐘舵��"; // @@ -132,20 +133,18 @@ // this.label3.AutoSize = true; this.label3.BackColor = System.Drawing.Color.Transparent; - this.label3.Location = new System.Drawing.Point(759, 53); - this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label3.Location = new System.Drawing.Point(569, 42); this.label3.Name = "label3"; - this.label3.Size = new System.Drawing.Size(97, 15); + this.label3.Size = new System.Drawing.Size(77, 12); this.label3.TabIndex = 18; this.label3.Text = "璁㈠崟璺熻釜鍙凤細"; this.label3.Visible = false; // // txtHOrderProcNO // - this.txtHOrderProcNO.Location = new System.Drawing.Point(865, 48); - this.txtHOrderProcNO.Margin = new System.Windows.Forms.Padding(4); + this.txtHOrderProcNO.Location = new System.Drawing.Point(649, 38); this.txtHOrderProcNO.Name = "txtHOrderProcNO"; - this.txtHOrderProcNO.Size = new System.Drawing.Size(215, 25); + this.txtHOrderProcNO.Size = new System.Drawing.Size(162, 21); this.txtHOrderProcNO.TabIndex = 17; this.txtHOrderProcNO.Visible = false; this.txtHOrderProcNO.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHOrderProcNO_KeyDown); @@ -154,38 +153,34 @@ // this.label2.AutoSize = true; this.label2.BackColor = System.Drawing.Color.Transparent; - this.label2.Location = new System.Drawing.Point(630, 19); - this.label2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label2.Location = new System.Drawing.Point(472, 15); this.label2.Name = "label2"; - this.label2.Size = new System.Drawing.Size(82, 15); + this.label2.Size = new System.Drawing.Size(65, 12); this.label2.TabIndex = 14; this.label2.Text = "宸ヤ綔涓績锛�"; // // txtHCenterID // - this.txtHCenterID.Location = new System.Drawing.Point(720, 15); - this.txtHCenterID.Margin = new System.Windows.Forms.Padding(4); + this.txtHCenterID.Location = new System.Drawing.Point(540, 12); this.txtHCenterID.Name = "txtHCenterID"; - this.txtHCenterID.Size = new System.Drawing.Size(215, 25); + this.txtHCenterID.Size = new System.Drawing.Size(162, 21); this.txtHCenterID.TabIndex = 15; this.txtHCenterID.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHCenterID_KeyDown); // // label1 // this.label1.AutoSize = true; - this.label1.Location = new System.Drawing.Point(944, 19); - this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.label1.Location = new System.Drawing.Point(708, 15); this.label1.Name = "label1"; - this.label1.Size = new System.Drawing.Size(82, 15); + this.label1.Size = new System.Drawing.Size(65, 12); this.label1.TabIndex = 8; this.label1.Text = "娴佽浆鍗″彿锛�"; // // txtHBillNo // - this.txtHBillNo.Location = new System.Drawing.Point(1034, 15); - this.txtHBillNo.Margin = new System.Windows.Forms.Padding(4); + this.txtHBillNo.Location = new System.Drawing.Point(776, 12); this.txtHBillNo.Name = "txtHBillNo"; - this.txtHBillNo.Size = new System.Drawing.Size(215, 25); + this.txtHBillNo.Size = new System.Drawing.Size(162, 21); this.txtHBillNo.TabIndex = 9; this.txtHBillNo.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHBillNo_KeyDown); // @@ -194,29 +189,26 @@ this.panel1.Controls.Add(this.lbljl); this.panel1.Controls.Add(this.lbldj); this.panel1.Dock = System.Windows.Forms.DockStyle.Right; - this.panel1.Location = new System.Drawing.Point(1398, 0); - this.panel1.Margin = new System.Windows.Forms.Padding(4); + this.panel1.Location = new System.Drawing.Point(1049, 0); this.panel1.Name = "panel1"; - this.panel1.Size = new System.Drawing.Size(263, 66); + this.panel1.Size = new System.Drawing.Size(197, 53); this.panel1.TabIndex = 7; // // lbljl // this.lbljl.AutoSize = true; - this.lbljl.Location = new System.Drawing.Point(32, 38); - this.lbljl.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lbljl.Location = new System.Drawing.Point(24, 30); this.lbljl.Name = "lbljl"; - this.lbljl.Size = new System.Drawing.Size(15, 15); + this.lbljl.Size = new System.Drawing.Size(11, 12); this.lbljl.TabIndex = 1; this.lbljl.Text = " "; // // lbldj // this.lbldj.AutoSize = true; - this.lbldj.Location = new System.Drawing.Point(32, 15); - this.lbldj.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lbldj.Location = new System.Drawing.Point(24, 12); this.lbldj.Name = "lbldj"; - this.lbldj.Size = new System.Drawing.Size(0, 15); + this.lbldj.Size = new System.Drawing.Size(0, 12); this.lbldj.TabIndex = 0; // // lblCaption @@ -225,10 +217,9 @@ this.lblCaption.BackColor = System.Drawing.Color.Transparent; this.lblCaption.Cursor = System.Windows.Forms.Cursors.No; this.lblCaption.Font = new System.Drawing.Font("瀹嬩綋", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); - this.lblCaption.Location = new System.Drawing.Point(16, 19); - this.lblCaption.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); + this.lblCaption.Location = new System.Drawing.Point(12, 15); this.lblCaption.Name = "lblCaption"; - this.lblCaption.Size = new System.Drawing.Size(264, 27); + this.lblCaption.Size = new System.Drawing.Size(208, 21); this.lblCaption.TabIndex = 4; this.lblCaption.Text = "宸ュ簭姹囨姤涓嶈壇鍝佸垪琛�"; this.lblCaption.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; @@ -266,7 +257,7 @@ this.Tool.Location = new System.Drawing.Point(0, 0); this.Tool.Name = "Tool"; this.Tool.Padding = new System.Windows.Forms.Padding(0); - this.Tool.Size = new System.Drawing.Size(1661, 62); + this.Tool.Size = new System.Drawing.Size(1246, 50); this.Tool.Stretch = true; this.Tool.TabIndex = 16; this.Tool.Text = "toolStrip1"; @@ -280,7 +271,7 @@ this.toolStripDropDownButton1.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.toolStripDropDownButton1.ImageTransparentColor = System.Drawing.Color.Magenta; this.toolStripDropDownButton1.Name = "toolStripDropDownButton1"; - this.toolStripDropDownButton1.Size = new System.Drawing.Size(53, 59); + this.toolStripDropDownButton1.Size = new System.Drawing.Size(45, 47); this.toolStripDropDownButton1.Text = "寮曞嚭"; this.toolStripDropDownButton1.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.toolStripDropDownButton1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -288,14 +279,14 @@ // eXCELToolStripMenuItem // this.eXCELToolStripMenuItem.Name = "eXCELToolStripMenuItem"; - this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(136, 26); + this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(180, 22); this.eXCELToolStripMenuItem.Text = "EXCEL"; this.eXCELToolStripMenuItem.Click += new System.EventHandler(this.eXCELToolStripMenuItem_Click); // // cSVToolStripMenuItem // this.cSVToolStripMenuItem.Name = "cSVToolStripMenuItem"; - this.cSVToolStripMenuItem.Size = new System.Drawing.Size(136, 26); + this.cSVToolStripMenuItem.Size = new System.Drawing.Size(180, 22); this.cSVToolStripMenuItem.Text = "CSV"; this.cSVToolStripMenuItem.Click += new System.EventHandler(this.cSVToolStripMenuItem_Click); // @@ -330,7 +321,7 @@ // toolStripSeparator2 // this.toolStripSeparator2.Name = "toolStripSeparator2"; - this.toolStripSeparator2.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator2.Size = new System.Drawing.Size(6, 50); // // cx // @@ -363,7 +354,8 @@ // toolStripSeparator1 // this.toolStripSeparator1.Name = "toolStripSeparator1"; - this.toolStripSeparator1.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator1.Size = new System.Drawing.Size(6, 50); + this.toolStripSeparator1.Visible = false; // // xz // @@ -413,7 +405,7 @@ // toolStripSeparator5 // this.toolStripSeparator5.Name = "toolStripSeparator5"; - this.toolStripSeparator5.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator5.Size = new System.Drawing.Size(6, 50); this.toolStripSeparator5.Visible = false; // // sh @@ -449,7 +441,7 @@ // toolStripSeparator6 // this.toolStripSeparator6.Name = "toolStripSeparator6"; - this.toolStripSeparator6.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator6.Size = new System.Drawing.Size(6, 50); // // bzd // @@ -469,7 +461,7 @@ // toolStripSeparator4 // this.toolStripSeparator4.Name = "toolStripSeparator4"; - this.toolStripSeparator4.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator4.Size = new System.Drawing.Size(6, 50); // // tc // @@ -488,13 +480,13 @@ // toolStripSeparator3 // this.toolStripSeparator3.Name = "toolStripSeparator3"; - this.toolStripSeparator3.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator3.Size = new System.Drawing.Size(6, 50); // // toolStripSeparator9 // this.toolStripSeparator9.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator9.Name = "toolStripSeparator9"; - this.toolStripSeparator9.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator9.Size = new System.Drawing.Size(6, 50); // // mrlk // @@ -504,7 +496,7 @@ this.mrlk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.mrlk.ImageTransparentColor = System.Drawing.Color.White; this.mrlk.Name = "mrlk"; - this.mrlk.Size = new System.Drawing.Size(73, 59); + this.mrlk.Size = new System.Drawing.Size(60, 47); this.mrlk.Text = "榛樿鍒楀"; this.mrlk.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.mrlk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -514,7 +506,7 @@ // this.toolStripSeparator7.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator7.Name = "toolStripSeparator7"; - this.toolStripSeparator7.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator7.Size = new System.Drawing.Size(6, 50); // // bclk // @@ -524,7 +516,7 @@ this.bclk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.bclk.ImageTransparentColor = System.Drawing.Color.White; this.bclk.Name = "bclk"; - this.bclk.Size = new System.Drawing.Size(73, 59); + this.bclk.Size = new System.Drawing.Size(60, 47); this.bclk.Text = "淇濆瓨鍒楀"; this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; @@ -534,7 +526,7 @@ // this.toolStripSeparator8.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right; this.toolStripSeparator8.Name = "toolStripSeparator8"; - this.toolStripSeparator8.Size = new System.Drawing.Size(6, 62); + this.toolStripSeparator8.Size = new System.Drawing.Size(6, 50); // // timer1 // @@ -552,13 +544,12 @@ this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption; this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill; - this.grdMain.Location = new System.Drawing.Point(0, 128); - this.grdMain.Margin = new System.Windows.Forms.Padding(4); + this.grdMain.Location = new System.Drawing.Point(0, 103); this.grdMain.Name = "grdMain"; this.grdMain.ReadOnly = true; this.grdMain.RowHeadersWidth = 51; this.grdMain.RowTemplate.Height = 23; - this.grdMain.Size = new System.Drawing.Size(1661, 512); + this.grdMain.Size = new System.Drawing.Size(1246, 409); this.grdMain.TabIndex = 19; this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp); this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged); @@ -569,12 +560,11 @@ // grdPrint // this.grdPrint.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; - this.grdPrint.Location = new System.Drawing.Point(1029, 182); - this.grdPrint.Margin = new System.Windows.Forms.Padding(4); + this.grdPrint.Location = new System.Drawing.Point(772, 146); this.grdPrint.Name = "grdPrint"; this.grdPrint.RowHeadersWidth = 51; this.grdPrint.RowTemplate.Height = 23; - this.grdPrint.Size = new System.Drawing.Size(33, 30); + this.grdPrint.Size = new System.Drawing.Size(25, 24); this.grdPrint.TabIndex = 8; this.grdPrint.Visible = false; // @@ -585,27 +575,25 @@ this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control; this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom; - this.grdSum.Location = new System.Drawing.Point(0, 640); - this.grdSum.Margin = new System.Windows.Forms.Padding(4); + this.grdSum.Location = new System.Drawing.Point(0, 512); this.grdSum.Name = "grdSum"; this.grdSum.ReadOnly = true; this.grdSum.RowHeadersWidth = 51; this.grdSum.RowTemplate.Height = 23; this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None; - this.grdSum.Size = new System.Drawing.Size(1661, 24); + this.grdSum.Size = new System.Drawing.Size(1246, 19); this.grdSum.TabIndex = 47; // // MES_StationOutBillList_Bad // - this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F); + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; - this.ClientSize = new System.Drawing.Size(1661, 664); + this.ClientSize = new System.Drawing.Size(1246, 531); this.Controls.Add(this.grdMain); this.Controls.Add(this.grdSum); this.Controls.Add(this.pPic); this.Controls.Add(this.Tool); this.Controls.Add(this.grdPrint); - this.Margin = new System.Windows.Forms.Padding(4); this.Name = "MES_StationOutBillList_Bad"; this.Text = "宸ュ簭姹囨姤涓嶈壇鍝佸垪琛�"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.resx" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.resx" index df0c72c..bc1bb78 100644 --- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.resx" +++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.resx" @@ -3917,7 +3917,7 @@ <data name="toolStripDropDownButton1.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAE6SURBVDhPY0hOnvOfEgw2AAY6OjqA5Jn/v78f+P/tzYb/ + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAE6SURBVDhPY0hOnvOfEgw2AAY6OjqA5Jn/v78f+P/tzYb/ 7+/P+f/iUsf/x8fK/t/Zmfz/2hr//xcW2v9PS0v7f+DAgf8MDAwIA2aeAWqdaYxiwDuoAY9gBqwFGWD3 v9AbqBGkGZ8BX1+vh7sAZMDdXSAXBIBdADIgNWMh8QY8PlYO9QLCgDR8BvwBewFiwMtLnfAwuAoNA4IG QMIAZMBsoAGIMLhKrAvAXkByAaoBkEBMzcRiwPTjv8CShHBmwYr/abgMmHzgy//+7W/+d657/L91ya3/ @@ -3929,7 +3929,7 @@ <data name="dc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAADoSURBVDhPrZMvD4MwEMXvm6Jn5uaWtGIGMUXmKHKgJvBo + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADoSURBVDhPrZMvD4MwEMXvm6Jn5uaWtGIGMUXmKHKgJvBo asEiqeQ73O4glHb8C9uaPNFr+su7dy0EQYBHBQCsYXGh6zpsjcGmabCqKixLjUVRYJ7nmKUZKqUwiiIM wxCFlD0gjuMBMgKMBygnQOYDpNgB1AzQEyAlwIUuWMCWgycdJKQH6U66ka4kBpxJm4AXFccWtOOAW3Ad iLUWLKCet+BnIJYBNsS/AJwppFlqASe6KOQOQNGhP0Yf8PMUVkM07eCAAbMWkgMP6TNEHmPihLjrgAHa @@ -3939,7 +3939,7 @@ <data name="yl.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAF/SURBVDhPnZFNSwJBAIbnX1Q/IOoYeAzqHh3C6JAgJEgU + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAF/SURBVDhPnZFNSwJBAIbnX1Q/IOoYeAzqHh3C6JAgJEgU UQgaeQgxKZQwtBRC7YsiOnQPISISKyEPUrcgKqIipNQ11/XzbWfQdf1IxQceZnaYeVhmiNV9AIvDB/OG V3JF/F5z7cK9fwrSCtP6NhrhdNyxsWXEuOpkGwvFoiTFbg+xkdI0YjDb2aZsLi9J8fouMDqhhlKlhcm2 9X9At2xlB1JCFnzJdCaHAl3jBeSyWWZpez3zSxYW4FIZJPmKQqZ0cDpcbS0zehML/HA8Ysk0k09npMNK @@ -3952,7 +3952,7 @@ <data name="cx.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAFOSURBVDhPnZBPK0RRGIfvxkL5Dha+gLK0tsRGkY3dkK2w + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAFOSURBVDhPnZBPK0RRGIfvxkL5Dha+gLK0tsRGkY3dkK2w UjJbCzQWk5EFRslEiUwZFNLo+lMaxWCIIUXIQhYzj/edc28NHUzzq1/v7Z7zPOee6/ybgMu3lhwP6NrO F9q6blqaSDaETnOs3UIiCx2bUBuDmjmojpr5t0QWZ9KQfJSNkll5roxAxQRUTZn+LvBOH0vBQgbidzB0 KF+wCA1xaEyYqbVLPEG/CwMC9iShbQu69yEo0uFzM7V2QV2Y2E2e4Al07kGL3L/3CEKXsCRXSryaOZ3J @@ -3964,7 +3964,7 @@ <data name="sx.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAHXSURBVDhPjZJNSBtRFIUH3Ke4aiHVTRd2V7B7EXGhriyu + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAHXSURBVDhPjZJNSBtRFIUH3Ke4aiHVTRd2V7B7EXGhriyu ao0ImqppU39qSFVMtVZLrfQXFMlKFy4KbaXQTao7Cd1U3VSyFFQIqNXYZDKZTHJ8976ZTEZD6AcnL+/e e857A08p5uX7MEgv3i4h9GYRE3MLJUW9sdlPMG0SKhCvP4Z5/R8cIVYA0dk/AkOsKT1fUmpWzvkCz+2A 4PQ7WRW0tnvR5unFvQ7vFVH9fvdjdPYNoccftANGJufZbOTyvJZjdOaD8/uJ4dAcNzO6ga3dPezEbNFe @@ -3978,7 +3978,7 @@ <data name="xz.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAGySURBVDhPhZLNKwRxGMefUlLc5D9wUE5eolyUo5PkomhJ + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAGySURBVDhPhZLNKwRxGMefUlLc5D9wUE5eolyUo5PkomhJ ybZE5D2ippYty7Ic1NgclOLiqhAlym44yF3JuzW7s2tedvcxzzO7jbWDT337PfN7nu935vdrYH51EwXf BgpLor18Is75A+gP7CDYMetdx/9Y9l3wahsy7VnjZiqVshXh9Z7xSuSETLpXuJFIJm1FLC6e85ohK2Rc WOJNTU/Yir5B3DjEptZObGnrxv2DY57PACOzC1woqm4rVdMxaaRIchzfwhLPhioL8bQYuIbBaQ8XcUX7 @@ -3992,7 +3992,7 @@ <data name="dj.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAD3SURBVDhPnZC9FYIwFEaZiQFkAB1ADzULZACGoJLKSio7 + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAD3SURBVDhPnZC9FYIwFEaZiQFkAB1ADzULZACGoJLKSio7 BqCzorNiABgABnjme+GFBPlR3znfSUJy7yMJdorG0S2KY1r6/lE0PBMcdA8z3NZEd9VtSmiolU7iSjwY CcNyUUL0UhzMIcK4An8IPFjGr2F0s3CTmrFOLbgN67vK79LQsOCqQhaIxIE9AfXVxT4Wwzp1NsGYQ4b9 tjhSe4smiVKma19NL+4KBEQA85hH1OQH+T6T6MgagaArThys0V3g8ZwpgbryzBuIXAfB3iosZSUP3VEH @@ -4002,7 +4002,7 @@ <data name="sc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAG5SURBVDhPlZDrK4NhGMafP8BHf4BPwkfmq8NnvhKlUHxw + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAG5SURBVDhPlZDrK4NhGMafP8BHf4BPwkfmq8NnvhKlUHxw iEgSIsQKqcVyPjQ2Z9mS0ooSlqElQ07RaGRib6zmeHmf27O3zSZcdbXnfp77+r33PRZKZdXN8Le4/pt4 wO15g0vykvn5V4j/1/5iEfsSv/iPbPbjQAgvHp5ecXrlwv6ZE7bDC1h2j7BitWNpzYZ5swUG0zL6Jxag GZxCe68+GFBe14rjkzOMjs9iSD+DPt0ktAN6dHQPQ63pR0N7N+pbtdBNL6KmRRNijVo1jWexHcLjfcbN @@ -4016,7 +4016,7 @@ <data name="sh.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAGgSURBVDhPlZPPK8NhHMc/5T7tRM0cOCAHJXGbxQ7c/AEc + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAGgSURBVDhPlZPPK8NhHMc/5T7tRM0cOCAHJXGbxQ7c/AEc d1EcjEwytSiH4SZcRHLQ7FemtlJDOPiZml8XSzMWMz9mK7Xevs/z7DvDzLzr9X2253k+r8+nvn0pM10t hGykjnMndRE1ZWJlVKvF+qdErytIF/1G6k72sMPTBULIRcCF4H2bcOMknC8SNsb/IXheJ8R8hAfPPwUH M4Qz6fKVlXBtJwRWxP99aX/NnKfgcJZwMkfwS9OwdW86TwFLc6MGmxPE2Zok+CwCzwjB5XDkLpbDJHYj @@ -4029,7 +4029,7 @@ <data name="qsh.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAGPSURBVDhPlZLLK0RhGMbfsrVRtkp2k4UFsUOxsPAn2NoI + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAGPSURBVDhPlZLLK0RhGMbfsrVRtkp2k4UFsUOxsPAn2NoI C0MzEmpQFi4LpWEjUhaGMYqyUINQjEtqGEqkcZkY4zLO1CGP73vPN2cujdtTv97vPd/7PL2ncyhZTTWE TKjrn6UGUVRgVElhnlF/DamvzjJN36FmMkteHk8RbhYJODXQNwnXHkJgmrA2+I+A51VC1Et4WPlnwN4Y 4UQMX7gIV27C5ZzR+8TzZccfA/bHCUcTBL/YRtZd5x8DpKoqyrE+RMzGMME7YHDlG4WUGvtZMsRtJ8bV @@ -4042,7 +4042,7 @@ <data name="bzd.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAADmSURBVDhPlY6xDYMwFES9U3bKCmzACEh0FJmACRiAnoqK + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADmSURBVDhPlY6xDYMwFES9U3bKCmzACEh0FJmACRiAnoqK jo6OzvH7yVk/OFHg0MnC/vfuhzOq6zrK76vzIrRtm3nf92sgBpdlieu6ZgCe5xmAXEot0zTZMABBXLiU grRUVRWHYTATYpOfYR9kiGbMnQelUTu5wzmsoDWk796GOI6jGRDDzH0BxAyQ1Z5e4xhuGUSQWbkAaE2B FMRN05h9uAD4JoHato1d9yjCOjOAH9Y+QggDOW5gwZdfEgR7iAf4YG53yq0eBADzjlWk/+QP2WXf9xmk @@ -4052,7 +4052,7 @@ <data name="tc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAADCSURBVDhPpZJdCoMwEIRzpxxJ6Ak2z/ZZnysIBXuUHMA7 + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADCSURBVDhPpZJdCoMwEIRzpxxJ6Ak2z/ZZnysIBXuUHMA7 bXeWrGBMYkoHh+gk8xl/XEneP7jXqXIWJkIgHscnT/PEy2vhz7ZhMQ/Dm5l3ObRcB1ACzAKQ6FTcV69G rgWTbUl3QFQtFgGpfAAoAVDOi2ZbrwW5hwY4N+P6FmDlkrsBq6zOy3AXIEkhGHMbIMaorgGgI8Cu7CsY wOZbAEgDBch/gOveRzgJAKLwH0CGJsDmxU1dAMiSu3R5iZr+oJuic1+SJ5jRbOqnmgAAAABJRU5ErkJg @@ -4062,7 +4062,7 @@ <data name="mrlk.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAH/SURBVDhPfZHfS1NhGMefkCLQu/A/6MK6SbMQFlg3dudN + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAH/SURBVDhPfZHfS1NhGMefkCLQu/A/6MK6SbMQFlg3dudN oBFDY9BF05XMMAoLL3bhxGB4zjzoVCKim4iCgkCMSam1cqP9aO4YJlpIDmqh00IRv73Pe87OWuV54Mt7 znm/n895z0aF8Stj6FdGoARDUAf/H97jTp96FyZmjC8QwuRUBB0zACkiwT0i9rxvgBcvX4MZEye65Vex vp6HJ7yJ+1nYpmNyE3nRZcbEiW74AljL5UB3gOk84J8HnFPA0UfirZqIaoZPMQDZZcbEibp6+vE9mwUF @@ -4077,7 +4077,7 @@ <data name="bclk.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAH4SURBVDhPjZPNS1RRGMZfI2jRLlqUEKLUQgsl3EauEoRW + YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAH4SURBVDhPjZPNS1RRGMZfI2jRLlqUEKLUQgsl3EauEoRW /QN+phG4CQXTNrPLbzFrpZAuBIfEqChctFRndHI0YzKnxkHFYQgH50NH5+o8Pm/HwQ/s4oGHc++5z/O7 77nnvSKPPZDyKYSfA8tN55N6NfMvK1XT+LIBxAH8PqfUqxnNitR+g1x/yQuRlJWCZVm2Uo965RozmpXq aRR/Io1jYgJwTdlLPeqt92QqqHLj7phZTCST2Nqxl3rUWzrOTKX7JGBykm9x2Us96r3p1ApOAf5G49iI -- Gitblit v1.9.1