MES-WEB-API.git

			@@ -1,4 +1,5 @@
			ï»¿using DBUtility;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using System;
			using System.Collections.Generic;
			@@ -8,6 +9,9 @@
			using System.Net.Http;
			using System.Web.Http;
			using WebAPI.Models;
			using System.Web;
			using WebAPI.Controllers.SCGL.æ¥è®¡åç®¡ç;
			using System.IO;

			namespace WebAPI.Controllers.åºç¡èµæ.åºç¡èµæ
			{
			@@ -28,7 +32,8 @@
			{
			try
			{
			if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheck", 1, true, user))
			List<object> columnNameList = new List<object>();
			if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheck", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -36,23 +41,34 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_RepairCheck where 1=1 " + sWhere, "Gy_RepairCheck");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			ds = oCN.RunProcReturn("select * from h_v_Gy_RepairCheckList where 1=1 " + sWhere+ " order by hitemid", "h_v_Gy_RepairCheckList");

			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ ä¿å»é¡¹ç®æ°æ®ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ¥æ¾æåï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}


			//if (ds.Tables[0].Rows.Count != 0 \|\| ds != null)
			//{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			//}
			//else
			//{
			//objJsonResult.code = "0";
			//objJsonResult.count = 0;
			//objJsonResult.Message = "æ æ°æ®";
			//objJsonResult.data = null;
			//return objJsonResult;
			//}
			}
			catch (Exception e)
			{
			@@ -73,7 +89,7 @@

			try
			{
			if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheck_Delete", 1, true, User))
			if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheck_Delete", 1, false, User))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -166,7 +182,7 @@
			string HUseFlag = list[0].HUseFlag;

			//å¤ææé
			if (!ClsPub.Security_Log("Gy_RepairCheck_Edit", 1, true, msg4))
			if (!ClsPub.Security_Log("Gy_RepairCheck_Edit", 1, false, msg4))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -256,7 +272,7 @@
			bool HEndFlag = list[0].HEndFlag;

			//å¤ææé
			if (!ClsPub.Security_Log("Gy_RepairCheck_Edit", 1, true, msg3))
			if (!ClsPub.Security_Log("Gy_RepairCheck_Edit", 1, false, msg3))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -283,7 +299,7 @@
			" (HNumber,HName,HHelpCode,HShortNumber" +
			",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," +
			+HLevel + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo);
			+HLevel + ",1," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo);
			//ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç
			//oCN.RunProc("Update Gy_MouldType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			@@ -304,5 +320,258 @@
			}
			}
			#endregion

			#region ç»´ä¿®éªæ¶æä»¶ä¸ä¼
			[Route("Gy_RepairCheck/Gy_RepairCheck_Excel")]
			[HttpPost]
			public object Gy_RepairCheck_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 (error.Length > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"Excelæ¨¡æ¿åå¨éè¯¯,{error}\r\n";
			objJsonResult.data = null;
			return objJsonResult;
			}

			for (int i = 0; i <= tb2.Rows.Count - 1; i++)
			{

			string HORGNumber = "";
			string HORGName = "";
			string HRepairCheckNum = "";
			string HRepairCheckName = "";

			HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString());
			HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString());
			HRepairCheckNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»´ä¿®éªæ¶é¡¹ç®ä»£ç "].ToString());
			HRepairCheckName = 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 = "0";
			objJsonResult.count = 0;
			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 (HRepairCheckName == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¬¬" + index + "è¡,ç»´ä¿®éªæ¶åç§°ä¸è½ä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//ç»´ä¿®éªæ¶ä»£ç
			if (HRepairCheckNum == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¬¬" + index + "è¡,ç»´ä¿®éªæ¶ä»£ç ä¸è½ä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "ç¬¬" + index + "è¡,ç»ç»ä»£ç ä¸ºç©º";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = error;
			objJsonResult.data = tb2;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region ç»´ä¿®éªæ¶ å¯¼å¥(ä¿å)
			[Route("Gy_RepairCheck/Gy_RepairCheck_btnSave")]
			[HttpPost]
			public object Gy_RepairCheck_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_RepairCheck_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			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 HRepairCheckName = item["ç»´ä¿®éªæ¶é¡¹ç®åç§°"].ToString();
			string HRepairCheckNum = item["ç»´ä¿®éªæ¶é¡¹ç®ä»£ç "].ToString();
			string sShortNumber;
			sShortNumber = DBUtility.ClsPub.GetShortNumber(HRepairCheckNum);//çä»£ç
			if (sShortNumber.Trim() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼çä»£ç ä¸ºç©ºï¼";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			int HEndFlag = 1;//æ«çº§æ å¿
			int HLevel = DBUtility.ClsPub.GetLevel(HRepairCheckNum); //ççº§


			if (!DBUtility.ClsPub.AllowNumber(HRepairCheckNum.Trim()))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select * from Gy_RepairCheck where HNumber='" + HRepairCheckNum + "'", "Gy_RepairCheck");

			if (ds.Tables[0].Rows.Count == 0)
			{

			string sql = "insert into Gy_RepairCheck(HName,HNumber,HUSEORGID,HCREATEORGID,HShortNumber,HEndFlag,HLevel,HParentID,HStopflag,HRemark,HHelpCode)" +
			$"values('{HRepairCheckName}', '{HRepairCheckNum}',{HOrgID},{HOrgID}, '{sShortNumber}', {HEndFlag},{HLevel},0,0,'','')";
			oCN.RunProc(sql);
			}
			else
			{
			oCN.RunProc(" update Gy_RepairCheck set HName='" + HRepairCheckName + "' where HNumber='" + HRepairCheckNum + "'");
			}

			i++;
			}

			oCN.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "å¯¼å¥æå!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			LogService.Write(e);
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}