MES-WEB-API.git

			@@ -9,8 +9,11 @@
			using System.Data.SqlClient;
			using System.Web.Http;
			using System.Windows.Forms;
			using System.Web;
			using WebAPI.Models;

			using WebAPI.Controllers.SCGL.æ¥è®¡åç®¡ç;
			using System.IO;
			using SyntacticSugar.constant;
			namespace WebAPI.Controllers
			{
			public class Gy_ScrapReasonController : ApiController
			@@ -433,5 +436,341 @@
			}
			#endregion

			#region æ¥åºåå æä»¶å¯¼å¥ä¿å
			#region æ¥åºåå æä»¶ä¸ä¼
			[Route("Gy_ScrapReason/Gy_ScrapReason_Excel")]
			[HttpPost]
			public object Gy_ScrapReason_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("HDeptID", typeof(Int32));//é¨é¨ID
			tb2.Columns.Add("HProcID", 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 (!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 HName = "";
			string HNum = "";
			string HORGNumber = "";
			string HORGName = "";
			string HDeptNumber = "";
			string HDeptName = "";
			string HProcNumber = "";
			string HProcName = "";

			HName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["æ¥åºåå "].ToString());
			HNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["æ¥åºåå ä»£ç "].ToString());
			HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»ä»£ç "].ToString());
			HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["ç»ç»åç§°"].ToString());
			HDeptNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["é»è®¤é¨é¨ä»£ç "].ToString());
			HDeptName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["é»è®¤é¨é¨"].ToString());
			HProcNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["é»è®¤å·¥åºä»£ç "].ToString());
			HProcName = 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();
			}
			if (HDeptNumber != "")
			{
			//æ¥è¯¢é¨é¨
			ds = oCN.RunProcReturn("select * from Gy_Department where HNumber='" + HDeptNumber + "' and Hname='" + HDeptName + "'", "Gy_Department");

			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]["HDeptID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			}
			else
			{
			tb2.Rows[i]["HDeptID"] = 0;
			}
			if (HProcNumber != "")
			{
			//æ¥è¯¢é¨é¨
			ds = oCN.RunProcReturn("select * from Gy_Process where HNumber='" + HProcNumber + "' and Hname='" + HProcName + "'", "Gy_Process");

			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]["HProcID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			}
			else
			{
			tb2.Rows[i]["HProcID"] = 0;
			}

			//æ¥åºåå åç§°
			if (HName == "")
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "ç¬¬" + index + "è¡,æ¥åºåå åç§°ä¸è½ä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//æ¥åºåå ä»£ç
			if (HNum == "")
			{
			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_ScrapReason/Gy_ScrapReason_btnSave")]
			[HttpPost]
			public object Gy_ScrapReason_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_ScrapReason_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 HDeptID = item["HDeptID"].ToString();//é¨é¨ID
			string HProcID = item["HProcID"].ToString();//å·¥åºID
			string HName = item["æ¥åºåå "].ToString();
			string HDeptNumber = item["é»è®¤é¨é¨ä»£ç "].ToString();
			string HNumber = item["æ¥åºåå ä»£ç "].ToString();
			string HRemark = item["å¤æ³¨"].ToString();
			string HHelpCode = item["å©è®°ç "].ToString();
			string sShortNumber;
			sShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber);//çä»£ç
			if (sShortNumber.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_ScrapReason where HNumber='" + HNumber + "'", "Gy_ScrapReason");

			if (ds.Tables[0].Rows.Count == 0)
			{
			oCN.RunProc("Insert into Gy_ScrapReason" + " " +
			" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HDeptID,HDeptNumber,HProcID,HBarCode" +
			",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + sShortNumber + "'," + 0 +
			"," + HDeptID.ToString() + ",'" + HDeptNumber + "'," + HProcID.ToString() + ",'" + "" + "'" +
			"," + HLevel.ToString() + "," + HEndFlag + "," + 0 + ",'" + HRemark + "'," + HOrgID + "," + HOrgID + ",'" + user + "',GETDATE()" + ")", ref DBUtility.ClsPub.sExeReturnInfo);
			}
			else
			{
			oCN.RunProc("Update Gy_ScrapReason" + " set " +
			"HName='" + HName + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HLevel=" + HLevel.ToString() +
			",HDeptID=" + HDeptID.ToString() +
			",HProcID=" + HProcID.ToString() +
			",HRemark= '" + HRemark + "' Where HNumber='" + HNumber + "'", ref DBUtility.ClsPub.sExeReturnInfo);
			}

			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


			}
			}