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)
			{
			@@ -65,6 +81,87 @@
			}
			#endregion

			#region ç»´ä¿®éªæ¶é¡¹ç®åç±» æ å½¢å¾(æ ¹æ®ä»£ç å±å¼æ ç¶å¾)
			public class TreeModel
			{
			public string id { get; set; }
			public string title { get; set; }
			public List<TreeModel> children = new List<TreeModel>();
			}
			[Route("Gy_RepairCheckClass/Gy_RepairCheckClassTreeList")]
			[HttpGet]
			public object Gy_RepairClassTreeList()
			{
			try
			{
			string sql1 = string.Format("select hitemid,hnumber,hname from Gy_RepairCheckClass order by hnumber");

			ds = oCN.RunProcReturn(sql1, "Gy_RepairClass");

			List<TreeModel> treeModels = new List<TreeModel>();
			TreeModel first = new TreeModel();
			first.id = "0";
			first.title = "ç»´ä¿®éªæ¶é¡¹ç®åç±»è®¾ç½®";
			treeModels.Add(first);

			foreach (DataRow row in ds.Tables[0].Rows)
			{
			var strLen = row["hnumber"].ToString().Split('.');
			if (strLen.Length == 1)
			{
			TreeModel tree = new TreeModel();
			tree.id = row["hitemid"].ToString();
			tree.title = row["hname"].ToString();
			treeModels[0].children.Add(tree);
			}
			}
			digui(ds.Tables[0], treeModels[0].children, 2);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(treeModels);
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// éå½å½æ°
			/// </summary>
			public void digui(DataTable dt, List<TreeModel> tree, int num)
			{
			for (int m = 0; m < tree.Count; m++)
			{
			tree[m].children = new List<TreeModel>();
			for (int i = 0; i < dt.Rows.Count; i++)//ç¬¬ä¸æ¬¡å¾ªç¯ï¼å¾å°æææ ¹èç¹çåé
			{
			var strLen = dt.Rows[i]["hnumber"].ToString().Split('.');
			if (strLen.Length == num && dt.Rows[i]["hnumber"].ToString().Contains(tree[m].id + "."))
			{
			TreeModel tbjson = new TreeModel();
			tbjson.id = dt.Rows[i]["hitemid"].ToString();
			tbjson.title = dt.Rows[i]["hname"].ToString();
			tree[m].children.Add(tbjson);
			}
			}
			var strLens = tree[m].id.Split('.');
			for (int i = 0; i < tree[m].children.Count; i++)
			{
			digui(dt, tree[m].children, strLens.Length + 2);//åæ¬¡ç¨åéå»å¾ªç¯ï¼æ¿åºåéçåé
			}
			}

			}
			#endregion

			#region ç»´ä¿®éªæ¶é¡¹ç®å é¤
			[Route("Gy_RepairCheck/DeleteRepairCheck")]
			[HttpGet]
			@@ -73,7 +170,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;
			@@ -81,10 +178,61 @@
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("Select * from Gy_RepairCheck Where HItemID='" + HItemID + "'", "Gy_RepairCheck", ref DBUtility.ClsPub.sExeReturnInfo);

			if (ds.Tables[0].Rows.Count != 0)
			{
			oCN.BeginTran();

			//å é¤åæ§å¶=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_Repair_BeforeDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_Repair_BeforeDelCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å é¤åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å é¤å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			ds = oCN.RunProcReturn("Delete from Gy_RepairCheck Where HItemID='" + HItemID + "'", "Gy_RepairCheck", ref DBUtility.ClsPub.sExeReturnInfo);

			//å é¤åæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_Repair_AfterDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_Repair_AfterDelCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å é¤åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å é¤å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			oCN.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "å é¤æå";
			@@ -118,7 +266,7 @@
			{
			try
			{
			ds = oCN.RunProcReturn("select * from Gy_RepairCheck where HItemID=" + HInterID, "Gy_RepairCheck");
			ds = oCN.RunProcReturn("select * from h_v_Gy_RepairCheck where HItemID=" + HInterID, "h_v_Gy_RepairCheck");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -164,9 +312,13 @@
			string HRemark = list[0].HRemark;
			bool HStopflag = list[0].HStopflag;
			string HUseFlag = list[0].HUseFlag;
			string HModifyEmp = msg4;
			string HRepairCheckType = list[0].HRepairCheckType;
			long HUSEORGID = list[0].HUSEORGID;
			long HRepairCheckClassID = list[0].HRepairCheckClassID;

			//å¤ææé
			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;
			@@ -185,6 +337,7 @@
			return objJsonResult;
			}

			oDept.MvarItemKey = "Gy_RepairCheck";
			if (oDept.HavSameNumber(HItemID, HNumber))
			{
			objJsonResult.code = "0";
			@@ -197,16 +350,67 @@

			//è¥MAINDIéå¤åéæ°è·å
			oCN.BeginTran();

			//ä¿ååæ§å¶=========================================
			DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_RepairCheck_BeforeSaveCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿ååå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			//ä¸»è¡¨
			oCN.RunProc("Update Gy_RepairCheck set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HModifyEmp='" + HModifyEmp + "'" +
			",HRepairCheckType='" + HRepairCheckType + "'" +
			",HModifyTime=getdate()" +
			",HUSEORGID='" + HUSEORGID + "'" +
			",HRepairCheckClassID='" + HRepairCheckClassID + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HStopflag='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//ä¿®æ¹åé¡¹ç®ä»£ç
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);

			//ä¿ååæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterSaveCtrl " + msg3 + ",'1'", "h_p_Gy_RepairCheck_AfterSaveCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿ååå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;

			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			oCN.Commit();
			objJsonResult.code = "1";
			@@ -238,7 +442,8 @@
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();//å½åäºº
			string msg3 = sArray[2].ToString();//å½åäºº
			string msg4 = sArray[1].ToString();

			//ååºåå
			msg2 = "[" + msg2.ToString() + "]";
			@@ -249,14 +454,20 @@
			string HName = list[0].HName;
			string HShortNumber = list[0].HNumber;
			long HLevel = list[0].HLevel;
			long HUSEORGID = list[0].HUSEORGID;
			long HCREATEORGID = list[0].HCREATEORGID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			bool HStopflag = list[0].HStopflag;
			string HUseFlag = list[0].HUseFlag;
			bool HEndFlag = list[0].HEndFlag;
			string HMakeEmp = list[0].HMakeEmp;
			string HRepairCheckType = list[0].HRepairCheckType;
			long HRepairCheckClassID = list[0].HRepairCheckClassID;


			//å¤ææé
			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;
			@@ -278,14 +489,64 @@

			//è¥MAINDIéå¤åéæ°è·å
			oCN.BeginTran();

			//ä¿ååæ§å¶=========================================
			DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_RepairCheck_BeforeSaveCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿ååå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			//ä¸»è¡¨
			oCN.RunProc("Insert into Gy_RepairCheck " +
			" (HNumber,HName,HHelpCode,HShortNumber" +
			",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " +
			",HLevel,HEndFlag,HStopflag,HRemark" +
			",HMakeEmp,HMakeTime,HUSEORGID,HCREATEORGID,HUseFlag,HRepairCheckType,HRepairCheckClassID) " +
			" 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 + "'" +
			",'" + HMakeEmp + "',getdate()," + HUSEORGID + "," + HCREATEORGID + ",'" + HUseFlag + "','" + HRepairCheckType + "',"+ HRepairCheckClassID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
			//ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç
			//oCN.RunProc("Update Gy_MouldType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


			//ä¿ååæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterSaveCtrl " + msg3 + ",'1'", "h_p_Gy_RepairCheck_AfterSaveCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿ååå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;

			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -304,5 +565,638 @@
			}
			}
			#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

			#region ç»´ä¿®éªæ¶é¡¹ç®å®¡æ ¸/åå®¡æ ¸
			[Route("Gy_RepairCheck/AuditGy_RepairCheck")]
			[HttpGet]
			public object AuditGy_RepairCheck(string HInterID, int Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æå®¡æ ¸æé
			if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheck_Check", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æéå®¡æ ¸!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			DAL.ClsGy_RepairCheck_Ctl oBill = new DAL.ClsGy_RepairCheck_Ctl();
			ClsPub.CurUserName = user;
			oCN.BeginTran();//å¼å§äºå¡

			//Type 1 å®¡æ ¸ 2 åå®¡æ ¸
			if (Type == 1)
			{
			//å¤æåæ®æ¯å¦å·²ç»å®¡æ ¸
			DataSet ds;
			string sql = "select * from Gy_RepairCheck where HItemID = " + HInterID;
			ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
			if (ds.Tables[0].Rows[0]["HCheckEmp"] != null && ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸è½åæ¬¡å®¡æ ¸ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//å®¡æ ¸åæ§å¶=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeCheckCtrl " + HInterID + ",'" + user + "'", "h_p_Gy_RepairCheck_BeforeCheckCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			//å®¡æ ¸åæ®
			if (!oBill.AuditByID2(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//å®¡æ ¸åæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterCheckCtrl " + HInterID + ",'" + user + "'", "h_p_Gy_RepairCheck_AfterCheckCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			}

			else
			{
			//å¤æåæ®æ¯å¦å·²ç»åå®¡æ ¸
			DataSet ds;
			string sql = "select * from Gy_RepairCheck where HItemID = " + HInterID;
			ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HCheckEmp"] == null \|\| ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®æªå®¡æ ¸!ä¸éè¦åå®¡æ ¸!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//åå®¡æ ¸åæ§å¶=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeUnCheckCtrl " + HInterID + ",'" + user + "'", "h_p_Gy_RepairCheck_BeforeUnCheckCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			//åå®¡æ ¸åæ®
			if (!oBill.DeAuditByID2(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}


			//åå®¡æ ¸åæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterUnCheckCtrl " + HInterID + ",'" + user + "'", "h_p_Gy_RepairCheck_AfterUnCheckCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			}
			}

			oCN.Commit();//æäº¤äºå¡

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ§è¡æåï¼";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion


			#region ç»´ä¿®éªæ¶é¡¹ç®ç¦ç¨ãåç¦ç¨
			/// <summary>
			///
			/// </summary>
			/// <param name="HInterID">åæ®ID</param>
			/// <param name="IsStop">ç¦ç¨(0),åç¦ç¨(1)</param>
			/// <param name="CurUserName">å®¡æ ¸äºº</param>
			/// <returns></returns>
			[Route("Gy_RepairCheck/StopGy_RepairCheck")]
			[HttpGet]
			public object StopGy_RepairCheck(int HInterID, int IsStop, string CurUserName)
			{
			try
			{
			//ç¦ç¨æé
			if (!DBUtility.ClsPub.Security_Log_second("Gy_RepairCheck_Stop", 1, false, CurUserName))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥ï¼æ æéï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			var ds = oCN.RunProcReturn("select * from Gy_RepairCheck where HItemID=" + HInterID, "Gy_Material");
			if (ds.Tables[0].Rows.Count > 0)
			{
			if (IsStop == 0) //ç¦ç¨å¤æ
			{
			if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²ç¦ç¨!ä¸è½åæ¬¡ç¦ç¨ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsStop == 1) //åç¦ç¨å¤æ
			{
			if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®æªç¦ç¨!ä¸éè¦åç¦ç¨!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®ä¸åå¨!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.BeginTran();

			if (IsStop == 0) //ç¦ç¨å¤æ
			{
			//ç¦ç¨åæ§å¶=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheck_BeforeStopCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			oCN.RunProc("update Gy_RepairCheck set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);

			//ç¦ç¨åæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheck_AfterStopCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "ç¦ç¨æå";
			objJsonResult.data = null;
			}
			if (IsStop == 1) //åç¦ç¨å¤æ
			{
			//åç¦ç¨åæ§å¶=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_BeforeUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheck_BeforeUnStopCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			oCN.RunProc("update Gy_RepairCheck set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);


			//åç¦ç¨åæ§å¶=========================================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheck_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheck_AfterUnStopCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨åå¤æå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "åç¦ç¨æå";
			objJsonResult.data = null;
			}
			oCN.Commit();

			return objJsonResult;
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ç¦ç¨å¤±è´¥æèåç¦ç¨å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}