SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/WebAPIController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Gy_ConkReasonBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Gy_DisposeWayController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
sdk_dingding/TopSdk/bin/Debug/TopSdk.dll | 补丁 | 查看 | 原始文档 | blame | 历史 | |
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb | 补丁 | 查看 | 原始文档 | blame | 历史 | |
sdk_dingding/TopSdk/obj/Debug/TopSdk.dll | 补丁 | 查看 | 原始文档 | blame | 历史 | |
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb | 补丁 | 查看 | 原始文档 | blame | 历史 |
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt
@@ -4,14 +4,14 @@ D:\vs\项ç®ä»£ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll D:\vs\项ç®ä»£ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb D:\vs\项ç®ä»£ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs
@@ -643,9 +643,9 @@ #endregion #region æ ¡éªé¡¹ç®å表 æä»¶ä¸ä¼ [Route("Gy_CheckItem/Gy_Process_Excel")] [Route("Gy_CheckItem/Gy_CheckItem_Excel")] [HttpPost] public json Gy_Process_Excel() public json Gy_CheckItem_Excel() { json res = new json(); try @@ -674,7 +674,7 @@ //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ provisional.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID provisional.Columns.Add("HDeptID", typeof(Int32));//é¨é¨ID provisional.Columns.Add("HQCCheckClassID", typeof(Int32));//æ£éªé¡¹ç®åç±»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) @@ -700,22 +700,20 @@ for (int i = 0; i <= provisional.Rows.Count - 1; i++) { string HNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["代ç "].ToString()); string HUSEORGID = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç»ç»ä»£ç "].ToString()); string HQCCheckClassID = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®ç±»å«ä»£ç "].ToString()); string HQCCheckClassName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®ç±»å«åç§°"].ToString()); string HName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åç§°"].ToString()); string HCheckItemName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®"].ToString()); string HCheckItemNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®ä»£ç "].ToString()); string HQCCheckClassName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®åç±»"].ToString()); string HQCCheckClassNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®å类代ç "].ToString()); string HORGNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç»ç»ä»£ç "].ToString()); string HORGName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç»ç»åç§°"].ToString()); string HHelpCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å©è®°ç "]); string HRemark = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["夿³¨"].ToString()); //è·åçå®è¡æ° int line = i + 1; if (HUSEORGID != "") if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HUSEORGID + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { @@ -731,8 +729,8 @@ } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //æ¥è¯¢æ£éªé¡¹ç®æ¯å¦åå¨ DataSet checkClass = oCN.RunProcReturn("select * from Gy_QCCheckClass where HNumber = '" + HQCCheckClassID + "' and HName = '" + HQCCheckClassName + "'", "Gy_QCCheckClass"); //æ¥è¯¢æ£éªé¡¹ç®åç±»æ¯å¦åå¨ DataSet checkClass = oCN.RunProcReturn("select * from Gy_QCCheckClass where HNumber = '" + HQCCheckClassNumber + "' and HName = '" + HQCCheckClassName + "'", "Gy_QCCheckClass"); if (checkClass.Tables[0].Rows.Count == 0) { res.code = CodeConstant.FAIL; @@ -740,6 +738,10 @@ res.Message = "第" + line + "è¡,æ£éªé¡¹ç®ä¸åå¨ï¼"; res.data = null; return res; } else { provisional.Rows[i]["HQCCheckClassID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } } else @@ -781,14 +783,32 @@ if (!provisional.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if(!provisional.Columns.Contains("æ£éªé¡¹ç®ç±»å«åç§°")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®ç±»å«åç§°ãçæ é¢,"; if(!provisional.Columns.Contains("æ£éªé¡¹ç®å类代ç ")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®å类代ç ãçæ é¢,"; if (!provisional.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!provisional.Columns.Contains("æ£éªé¡¹ç®åç±»")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®åç±»ãçæ é¢,"; if (!provisional.Columns.Contains("æ£éªé¡¹ç®")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®ãçæ é¢,"; if (!provisional.Columns.Contains("æ£éªé¡¹ç®ä»£ç ")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®ä»£ç ãçæ é¢,"; if (!provisional.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (!provisional.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; return error; } #endregion #region æ ¡éªé¡¹ç®å表 å¯¼å ¥(ä¿å) [Route("Gy_CheckItem/Gy_Process_btnSave")] [Route("Gy_CheckItem/Gy_CheckItem_btnSave")] [HttpPost] public object Gy_Group_btnSave([FromBody] JObject sMainSub) { @@ -799,7 +819,7 @@ string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_Group_Edit", 1, false, user)) if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckItem_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -825,12 +845,11 @@ int i = 1; foreach (Dictionary<string, string> item in list) { string HNumber = item["代ç "].ToString(); string HUSEORGID = item["ç»ç»ä»£ç "].ToString(); string HName = item["åç§°"].ToString(); string HORGName = item["ç»ç»åç§°"].ToString(); string HNumber = item["æ£éªé¡¹ç®ä»£ç "].ToString(); string HUSEORGID = item["HOrgID"].ToString(); string HName = item["æ£éªé¡¹ç®"].ToString(); string HHelpCode = item["å©è®°ç "]; string HQCCheckClassID = item["æ£éªé¡¹ç®ç±»å«ä»£ç "]; string HQCCheckClassID = item["HQCCheckClassID"]; string HRemark = item["夿³¨"].ToString(); string sShortNumber; WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs
@@ -463,10 +463,10 @@ } #endregion #region æ ¡éªé¡¹ç®å表 æä»¶ä¸ä¼ [Route("Gy_QCCheckClass/Gy_Process_Excel")] #region æ ¡éªé¡¹ç®åç±»å表 æä»¶ä¸ä¼ [Route("Gy_QCCheckClass/Gy_QCCheckClass_Excel")] [HttpPost] public json Gy_Process_Excel() public json Gy_QCCheckClass_Excel() { json res = new json(); try @@ -492,7 +492,8 @@ { provisional.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ provisional.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { @@ -517,12 +518,39 @@ for (int i = 0; i <= provisional.Rows.Count - 1; i++) { string HNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["代ç "].ToString()); string HName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åç§°"].ToString()); string HHelpCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å©è®°ç "]); string HRemark = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["夿³¨"].ToString()); string HQCCheckClassName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®åç±»"].ToString()); string HQCCheckClassNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ£éªé¡¹ç®å类代ç "].ToString()); string HORGNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç»ç»ä»£ç "].ToString()); string HORGName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç»ç»åç§°"].ToString()); //è·åçå®è¡æ° int line = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { res.code = "0"; res.count = 0; res.Message = "第" + line + "è¡,ç»ç»ä¸åå¨ï¼"; res.data = null; return res; } else { provisional.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); } else { res.code = CodeConstant.FAIL; res.count = CountConstant.FAIL; res.Message = "第" + line + "è¡,ç»ç»ä»£ç 为空"; res.data = null; return res; } } res.code = "1"; @@ -551,17 +579,29 @@ var error = ""; //æ¥è¯¢æ²¡æçå if (!provisional.Columns.Contains("代ç ")) error += "æ²¡ææ¾å°ã代ç ãçæ é¢,"; if (!provisional.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!provisional.Columns.Contains("åç§°")) error += "æ²¡ææ¾å°ãåç§°ãçæ é¢,"; if(!provisional.Columns.Contains("æ£éªé¡¹ç®å类代ç ")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®å类代ç ãçæ é¢,"; if (!provisional.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!provisional.Columns.Contains("æ£éªé¡¹ç®åç±»")) error += "æ²¡ææ¾å°ãæ£éªé¡¹ç®åç±»ãçæ é¢,"; if (!provisional.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (!provisional.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; return error; } #endregion #region æ ¡éªé¡¹ç®å表 å¯¼å ¥(ä¿å) [Route("Gy_QCCheckClass/Gy_Process_btnSave")] #region æ ¡éªé¡¹ç®åç±»å表 å¯¼å ¥(ä¿å) [Route("Gy_QCCheckClass/Gy_QCCheckClass_btnSave")] [HttpPost] public object Gy_Group_btnSave([FromBody] JObject sMainSub) { @@ -573,7 +613,7 @@ string organ = sArray[2].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_Group_Edit", 1, false, user)) if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckClass_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -599,8 +639,9 @@ int i = 1; foreach (Dictionary<string, string> item in list) { string HNumber = item["代ç "].ToString(); string HName = item["åç§°"].ToString(); string HNumber = item["æ£éªé¡¹ç®å类代ç "].ToString(); string HUSEORGID = item["HOrgID"].ToString(); string HName = item["æ£éªé¡¹ç®åç±»"].ToString(); string HHelpCode = item["å©è®°ç "]; string HRemark = item["夿³¨"].ToString(); @@ -633,12 +674,12 @@ { string sql = "insert into Gy_QCCheckClass (HName,HNumber,HShortNumber,HLevel,HHelpCode,HParentID,HStopflag,HEndFlag,HRemark,HUseFlag, HUSEORGID, HCREATEORGID, HMakeTime,HMakeEmp)" + $"values('{HName}', '{HNumber}', '{sShortNumber}',{HLevel},'',0,'0','0','{HRemark}', 'æªä½¿ç¨', '{organ}', '{organ}', '{System.DateTime.Now.ToString("G")}', '{user}')"; $"values('{HName}', '{HNumber}', '{sShortNumber}',{HLevel},'',0,'0','0','{HRemark}', 'æªä½¿ç¨', '{HUSEORGID}', '{HUSEORGID}', '{System.DateTime.Now.ToString("G")}', '{user}')"; oCN.RunProc(sql); } else { oCN.RunProc("update Gy_QCCheckClass set HName='" + HName + "', HHelpCode='" + HHelpCode + "', HModifyEmp = '" + user + "', HModifyTime = '" + System.DateTime.Now.ToString("G") + "'where HNumber='" + HNumber + "'"); oCN.RunProc("update Gy_QCCheckClass set HName='" + HName + "', HHelpCode='" + HHelpCode + "', HModifyEmp = '" + user + "', HModifyTime = '" + System.DateTime.Now.ToString("G") + "',HUSEORGID="+ HUSEORGID + ",HRemark='"+HRemark+"' where HNumber='" + HNumber + "'"); } i++; WebAPI/Controllers/WebAPIController.cs
@@ -5747,6 +5747,309 @@ #endregion #region å²ä½æè½ æä»¶å¯¼å ¥ä¿å #region å²ä½æè½ æä»¶ä¸ä¼ [Route("Gy_PostSkill/Gy_PostSkill_Excel")] [HttpPost] public object Gy_PostSkill_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID tb2.Columns.Add("HPostID", typeof(Int32));//å²ä½id //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½æè½")) error += "æ²¡ææ¾å°ãå²ä½æè½ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½æè½ä»£ç ")) error += "æ²¡ææ¾å°ãå²ä½æè½ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½")) error += "æ²¡ææ¾å°ãå²ä½ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½ä»£ç ")) error += "æ²¡ææ¾å°ãå²ä½ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; string HPostName = ""; string HPostNumber = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½æè½"].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½æè½ä»£ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); HPostName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½"].ToString()); HPostNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½ä»£ç "].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //æ¥è¯¢å²ä½ ds = oCN.RunProcReturn("select * from Gy_Post where HNumber='" + HPostNumber + "' and Hname='" + HPostName + "' and HUSEORGID = "+ HORGid, "Gy_Post"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å²ä½ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HPostID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } //å²ä½æè½åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å²ä½æè½ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //å²ä½æè½ä»£ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å²ä½æè½ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å²ä½æè½é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_PostSkill/Gy_PostSkill_btnSave")] [HttpPost] public object Gy_PostSkill_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_PostSkill_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HPostID = item["HPostID"].ToString();//ç»ç»ID string HName = item["å²ä½æè½"].ToString(); string HNumber = item["å²ä½æè½ä»£ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HUseFlag = "æªæ£æµ"; string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_PostSkill where HNumber='" + HNumber + "'", "Gy_PostSkill"); if (ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert into " + "Gy_PostSkill" + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HPostID,HProcID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + DateTime.Now + "','" + HOrgID + "','" + HUseFlag + "','" + user + "','" + HOrgID + "','" + HPostID + "','" + 0 + "')"); } else { oCN.RunProc("Update " + "Gy_PostSkill" + " set " + "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HModifyTime='" + DateTime.Now + "'" + ",HUSEORGID='" + HOrgID + "'" + ",HModifyEmp ='" + user + "'" + ",HPostID ='" + HPostID + "'" + ",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'"); } i++; } oCN.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region å²ä½ 设置å表/ä¿å/ç¼è¾/å 餿¹æ³ /// <summary> /// ä¿åå²ä½ @@ -6025,6 +6328,279 @@ return objJsonResult; } } #endregion #region å²ä½ æä»¶å¯¼å ¥ä¿å #region å²ä½ æä»¶ä¸ä¼ [Route("Gy_Post/Gy_Post_Excel")] [HttpPost] public object Gy_Post_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½")) error += "æ²¡ææ¾å°ãå²ä½åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å²ä½ä»£ç ")) error += "æ²¡ææ¾å°ãå²ä½ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½"].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å²ä½ä»£ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //å²ä½åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å²ä½åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //å²ä½ä»£ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å²ä½ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å²ä½é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_Post/Gy_Post_btnSave")] [HttpPost] public object Gy_Post_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_Post_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HName = item["å²ä½"].ToString(); string HNumber = item["å²ä½ä»£ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HUseFlag = "æªæ£æµ"; string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_Post where HNumber='" + HNumber + "'", "Gy_Post"); if (ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert into " + "Gy_Post" + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + DateTime.Now + "','" + HOrgID + "','" + HUseFlag + "','" + user + "','" + HOrgID + "')"); } else { oCN.RunProc("Update " + "Gy_Post" + " set " + "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HModifyTime='" + DateTime.Now + "'" + ",HUSEORGID='" + HOrgID + "'" + ",HModifyEmp ='" + user + "'" + ",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'"); } i++; } oCN.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region è°æ¨ç±»å 设置å表/ä¿å/ç¼è¾/å 餿¹æ³ @@ -10590,6 +11166,274 @@ } #endregion #region é²éè£ ç½® æä»¶å¯¼å ¥ä¿å #region é²éè£ ç½® æä»¶ä¸ä¼ [Route("Gy_PreventErrMould/Gy_PreventErrMould_Excel")] [HttpPost] public object Gy_PreventErrMould_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("é²éè£ ç½®åç§°")) error += "æ²¡ææ¾å°ãé²éè£ ç½®åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("é²éè£ ç½®ä»£ç ")) error += "æ²¡ææ¾å°ãé²éè£ ç½®ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["é²éè£ ç½®åç§°"].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["é²éè£ ç½®ä»£ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //é²éè£ ç½®åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,é²éè£ ç½®åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //é²éè£ ç½®ä»£ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,é²éè£ ç½®ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region é²éè£ ç½®é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_PreventErrMould/Gy_PreventErrMould_btnSave")] [HttpPost] public object Gy_PreventErrMould_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_PreventErrMould_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HName = item["é²éè£ ç½®åç§°"].ToString(); string HNumber = item["é²éè£ ç½®ä»£ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_PreventErrMould where HNumber='" + HNumber + "'", "Gy_PreventErrMould"); if (ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert into " + "Gy_PreventErrMould" + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + DateTime.Now + "','" + HOrgID + "','" + "æªæ£æµ" + "','" + user + "','" + HOrgID + "')"); } else { oCN.RunProc("Update " + "Gy_PreventErrMould" + " set " + "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HModifyTime='" + DateTime.Now + "'" + ",HUSEORGID='" + HOrgID + "'" + ",HModifyEmp ='" + user + "'" + ",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'"); } i++; } oCN.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region é²éè£ ç½® 设置å表/ä¿å/ç¼è¾/å 餿¹æ³ /// <summary> /// é²éè£ ç½® ä¿å @@ -11361,7 +12205,7 @@ try { //å 餿é if (!DBUtility.ClsPub.Security_Log("Gy_CheckNoteItem_Drop", 1, false, user)) if (!DBUtility.ClsPub.Security_Log("Gy_CheckNoteItem_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -11402,6 +12246,279 @@ } #endregion #region å¯å¨æ£æ¥é¡¹ç® æä»¶å¯¼å ¥ä¿å #region å¯å¨æ£æ¥é¡¹ç® æä»¶ä¸ä¼ [Route("Gy_CheckNoteItem/Gy_CheckNoteItem_Excel")] [HttpPost] public object Gy_CheckNoteItem_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å¯å¨æ£æ¥é¡¹ç®åç§°")) error += "æ²¡ææ¾å°ãå¯å¨æ£æ¥é¡¹ç®åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å¯å¨æ£æ¥é¡¹ç®ä»£ç ")) error += "æ²¡ææ¾å°ãå¯å¨æ£æ¥é¡¹ç®ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å¯å¨æ£æ¥é¡¹ç®åç§°"].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å¯å¨æ£æ¥é¡¹ç®ä»£ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //å¯å¨æ£æ¥é¡¹ç®åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å¯å¨æ£æ¥é¡¹ç®åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //å¯å¨æ£æ¥é¡¹ç®ä»£ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å¯å¨æ£æ¥é¡¹ç®ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å¯å¨æ£æ¥é¡¹ç®é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_CheckNoteItem/Gy_CheckNoteItem_btnSave")] [HttpPost] public object Gy_CheckNoteItem_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_CheckNoteItem_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HName = item["å¯å¨æ£æ¥é¡¹ç®åç§°"].ToString(); string HNumber = item["å¯å¨æ£æ¥é¡¹ç®ä»£ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 string HUseFlag = "æªæ£æµ"; if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_CheckNoteItem where HNumber='" + HNumber + "'", "Gy_CheckNoteItem"); if (ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert into " + "Gy_CheckNoteItem" + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HCheckPostID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + DateTime.Now + "','" + HOrgID + "','" + HUseFlag + "','" + user + "','" + HOrgID + "','" + 0 + "')"); } else { oCN.RunProc("Update " + "Gy_CheckNoteItem" + " set " + "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HModifyTime='" + DateTime.Now + "'" + ",HUSEORGID='" + HOrgID + "'" + ",HModifyEmp ='" + user + "'" + ",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'"); } i++; } oCN.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region 伿¯æ¥ 设置å表/ä¿å/ç¼è¾/å 餿¹æ³ /// <summary> /// 伿¯æ¥ ä¿å WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_ConkReasonBillController.cs
@@ -8,7 +8,10 @@ using System.Net.Http; using System.Web.Http; using WebAPI.Models; using System.Web; using WebAPI.Controllers.SCGL.æ¥è®¡å管ç; using System.IO; using SyntacticSugar.constant; namespace WebAPI.Controllers.åºç¡èµæ.åºç¡èµæ { public class Gy_ConkReasonBillController : ApiController @@ -284,7 +287,6 @@ #endregion #region [æ éåå å é¤åè½] [Route("Gy_ConkReasonBill/set_DeleteBill")] [HttpGet] @@ -487,5 +489,279 @@ } } #endregion #region æ éåå æä»¶å¯¼å ¥ä¿å #region æ éåå æä»¶ä¸ä¼ [Route("Gy_ConkReason/Gy_ConkReason_Excel")] [HttpPost] public object Gy_ConkReason_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("æ éåå ")) error += "æ²¡ææ¾å°ãæ éåå åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("æ éåå 代ç ")) error += "æ²¡ææ¾å°ãæ éåå 代ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["æ éåå "].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["æ éåå 代ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCn.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //æ éåå åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,æ éåå åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //æ éåå 代ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,æ éåå 代ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region æ éåå é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_ConkReason/Gy_ConkReason_btnSave")] [HttpPost] public object Gy_ConkReason_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_ConkReason_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCn.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HName = item["æ éåå "].ToString(); string HNumber = item["æ éåå 代ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HUseFlag = "æªæ£æµ"; string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCn.RunProcReturn("select * from Gy_ConkReason where HNumber='" + HNumber + "'", "Gy_ConkReason"); if (ds.Tables[0].Rows.Count == 0) { oCn.RunProc("Insert into Gy_ConkReason " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HExplanation,HConkTypeID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + HUseFlag + "',getdate(),'" + user + "','" + "" + "',0" + ")", ref DBUtility.ClsPub.sExeReturnInfo); } else { oCn.RunProc("UpDate Gy_ConkReason set " + //åºå®èµå¼=============== "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HRemark='" + HRemark + "'" + ",HModifyTime=getdate()" + ",HModifyEmp='" + user + "'" + " where HNumber='" + HNumber + "'"); } i++; } oCn.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion } } WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_DisposeWayController.cs
@@ -10,7 +10,10 @@ using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; using System.Web; using WebAPI.Controllers.SCGL.æ¥è®¡å管ç; using System.IO; using SyntacticSugar.constant; namespace WebAPI.Controllers { public class Gy_DisposeWayController : ApiController @@ -432,5 +435,279 @@ } #endregion #region å¤çæ¹æ¡ æä»¶å¯¼å ¥ä¿å #region å¤çæ¹æ¡ æä»¶ä¸ä¼ [Route("Gy_DisposeWay/Gy_DisposeWay_Excel")] [HttpPost] public object Gy_DisposeWay_Excel() { try { //è·åæä»¶åç§° var file = HttpContext.Current.Request.Files[0]; //è·åæä»¶ç©çè·¯å¾ string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //ä¿åæä»¶ file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //å 餿件 File.Delete(ExcelPath); //å建临æ¶è¡¨ DataTable tb2 = new DataTable("dt2"); //æ·»å åå for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ tb2.Columns.Add("HOrgID", typeof(Int32));//ç»ç»ID //æ·»å æ°æ® for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //æ¥è¯¢æ²¡æçå if (!tb2.Columns.Contains("ç»ç»ä»£ç ")) error += "æ²¡ææ¾å°ãç»ç»ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("ç»ç»åç§°")) error += "æ²¡ææ¾å°ãç»ç»åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å¤çæ¹æ¡")) error += "æ²¡ææ¾å°ãå¤çæ¹æ¡åç§°ãçæ é¢,"; if (!tb2.Columns.Contains("å¤çæ¹æ¡ä»£ç ")) error += "æ²¡ææ¾å°ãå¤çæ¹æ¡ä»£ç ãçæ é¢,"; if (!tb2.Columns.Contains("夿³¨")) error += "æ²¡ææ¾å°ã夿³¨ãçæ é¢,"; if (!tb2.Columns.Contains("å©è®°ç ")) error += "æ²¡ææ¾å°ãå©è®°ç ãçæ é¢,"; if (error.Length > 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = $"Excel模æ¿åå¨é误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HProcessName = ""; string HProcessNum = ""; string HORGNumber = ""; string HORGName = ""; HProcessName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å¤çæ¹æ¡"].ToString()); HProcessNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["å¤çæ¹æ¡ä»£ç "].ToString()); HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString()); //æ£æ¥ç©æ int index = i + 1; if (HORGNumber != "") { //æ¥è¯¢ç»ç» ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //å¤çæ¹æ¡åç§° if (HProcessName == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å¤çæ¹æ¡åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //å¤çæ¹æ¡ä»£ç if (HProcessNum == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,å¤çæ¹æ¡ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "第" + index + "è¡,ç»ç»ä»£ç 为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å¤çæ¹æ¡é¡¹ç® å¯¼å ¥(ä¿å) [Route("Gy_DisposeWay/Gy_DisposeWay_btnSave")] [HttpPost] public object Gy_DisposeWay_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_DisposeWay_Edit", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (JObject item in Excel) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary<string, string> item in list) { string HOrgID = item["HOrgID"].ToString();//ç»ç»ID string HName = item["å¤çæ¹æ¡"].ToString(); string HNumber = item["å¤çæ¹æ¡ä»£ç "].ToString(); string HRemark = item["夿³¨"].ToString(); string HHelpCode = item["å©è®°ç "].ToString(); string HUseFlag = "æªæ£æµ"; string HShortNumber; HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//ç代ç if (HShortNumber.Trim() == "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//æ«çº§æ å¿ int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //ç级 if (!DBUtility.ClsPub.AllowNumber(HNumber.Trim())) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_DisposeWay where HNumber='" + HNumber + "'", "Gy_DisposeWay"); if (ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert into " + "Gy_DisposeWay" + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + 0 + "," + HLevel + "," + HEndFlag + "," + 0 + ",'" + HRemark + "','" + HUseFlag + "'," + HOrgID + "," + HOrgID + ",'" + user + "',GETDATE()" + ")"); } else { oCN.RunProc("Update " + "Gy_DisposeWay" + " set " + "HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HLevel=" + HLevel + ",HModifyEmp='" + user + "'" + ",HModifyTime=GETDATE()" + ",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'"); } i++; } oCN.Commit(); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å¯¼å ¥æå!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion } } WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user
@@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <History>True|2024-09-20T01:59:12.9943442Z;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <History>True|2024-09-24T12:03:43.9841995Z;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <_PublishTargetUrl>G:\issWeb\ç½ç«åå¸\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>09/20/2024 16:18:49</publishTime> <publishTime>09/24/2024 20:03:11</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>09/20/2024 16:18:49</publishTime> <publishTime>09/24/2024 20:03:11</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>09/20/2024 16:18:47</publishTime> <publishTime>09/24/2024 20:03:08</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>09/20/2024 16:18:47</publishTime> <publishTime>09/24/2024 20:03:08</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>09/20/2024 16:18:41</publishTime> <publishTime>09/24/2024 20:03:02</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>09/20/2024 16:18:41</publishTime> <publishTime>09/24/2024 20:03:02</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>09/20/2024 16:18:42</publishTime> <publishTime>09/24/2024 20:03:04</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>09/20/2024 16:18:42</publishTime> <publishTime>09/24/2024 20:03:04</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/15/2024 12:55:45</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>09/20/2024 16:18:39</publishTime> <publishTime>09/24/2024 20:03:00</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>09/20/2024 16:18:39</publishTime> <publishTime>09/24/2024 20:03:00</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>09/20/2024 16:18:40</publishTime> <publishTime>09/24/2024 20:03:01</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>09/20/2024 16:18:40</publishTime> <publishTime>09/24/2024 20:03:01</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>09/20/2024 16:18:40</publishTime> <publishTime>09/24/2024 20:03:01</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>09/20/2024 16:18:40</publishTime> <publishTime>09/24/2024 20:03:01</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>09/20/2024 16:14:46</publishTime> <publishTime>09/24/2024 20:00:53</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>09/20/2024 16:14:46</publishTime> <publishTime>09/24/2024 20:00:53</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>09/20/2024 16:14:52</publishTime> <publishTime>09/24/2024 20:00:59</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>09/20/2024 16:14:52</publishTime> <publishTime>09/24/2024 20:00:59</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>09/20/2024 16:19:21</publishTime> <publishTime>09/24/2024 20:03:41</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>09/20/2024 16:19:21</publishTime> <publishTime>09/24/2024 20:03:41</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>08/16/2024 16:55:28</publishTime> sdk_dingding/TopSdk/bin/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdbBinary files differ