MES-WEB-API.git

			@@ -9,7 +9,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.SBGL
			{
			public class Gy_EquipFileMainController : ApiController
			@@ -82,7 +85,7 @@
			return objJsonResult;
			}

			string s = "";
			//string s = "";
			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HItemID);
			if (lngBillKey == 0)
			@@ -153,6 +156,51 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			# region 设备保养规程编辑时获取表体数据新(保养规程列表、点检规程列表)
			[Route("Gy_EquipFileMain/Gy_EquipFileMainSubAndSubItem")]
			[HttpGet]
			public object Gy_EquipFileMainSubAndSubItem(string HInterID)
			{

			DataSet ds, ds1;
			List<object> list = new List<object>();
			string Swhere = "";
			try
			{
			if (HInterID != "" \|\| HInterID != null)
			{
			Swhere = " and hmainid='" + HInterID + "'";
			}
			else
			{
			Swhere = HInterID;
			}
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			//获取保养项目编辑数据
			string sql = "select 保养项目ID HMaintainItemID,保养项目代码 HMaintainItemNumber,保养项目 HMaintainItem,保养部位 HMaintainPart,具体要求 HClaim,负责人ID HManagerID,负责人代码 HManagerNumber,负责人名称 HManagerName,子备注2 HRemark from h_v_Sb_EquipMaintainRuleSub_Item where 1 = 1 " + Swhere + "";
			ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainRuleSub_Item");
			//获取配件项目编辑数据
			string sql1 = "select 配件ID HMaterID,配件代码 HMaterNumber,配件名称 HMaterName,单位ID HUnitID,计量单位代码 HUnitNumber,计量单位名称 HUnitName,用量 HQty,子备注1 HRemark from h_v_Sb_EquipMaintainRuleSub where 1 = 1 " + Swhere + "";
			ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipMaintainRuleSub");

			list.Add(ds.Tables[0]);
			list.Add(ds1.Tables[0]);
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.list = list;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何记录！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion

			@@ -275,6 +323,27 @@
			}
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//保存前控制=========================================
			string HBillNote = "";
			ds = oCN.RunProcReturn("Exec h_p_Gy_EquipFileBillMain_BeforeSaveCtrl " + HInterID.ToString() + ", '" + hbillno + "','" + HBillNote + "',1 ", "h_p_Gy_EquipFileBillMain_BeforeSaveCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存失败!原因:保存前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存失败!原因:" + ds.Tables[0].Rows[0]["HBackRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			//主表
			oCN.RunProc("Insert into Gy_EquipFileBillMain " +
			" (HInterID,hbillno,HEquipFileNumber,HEquipFileNo,HName,HModel,HModel2,HMaterID,HUnitID,HOutComDate" +
			@@ -286,6 +355,29 @@
			"','" + HBarCode + "','" + HWorkArea + "','" + HLogo + "'," + HSellSupID + "," + HMakeSupID + ",'3308','" + HDate + "','" + HYear + "','" + HMaker + "','" + HMakeDate + "','" + HEquipMaintainRuleInterID + "','" + HEquipDotCheckRuleInterID +"'," + HSourceID + ",'" + HMainSourceFlag + "','" + HMacAddress + "','" + HMainSourceID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			objJsonResult = AddBillSub(msg3, msg4, HInterID, hbillno, 1);

			//保存后控制=========================================
			ds = oCN.RunProcReturn("Exec h_p_Gy_EquipFileBillMain_AfterSaveCtrl " + HInterID.ToString() + ", '" + hbillno + "','" + HBillNote + "',1 ", "h_p_Gy_EquipFileBillMain_AfterSaveCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存失败!原因:保存前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存失败!原因:" + ds.Tables[0].Rows[0]["HBackRemark"].ToString(); ;
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}
			//=========================================================

			oCN.Commit();
			//objJsonResult.data = null;
			return objJsonResult;
			@@ -465,7 +557,7 @@
			oCN.RunProc("delete from Gy_EquipFileBillSub_DotCheckRule where HInterID = " + HInterID );
			}
			int i = 0;
			//保存保养规格
			//保存保养规程
			foreach (ClsGy_EquipFileBillSub_MaintainRule oSub in MaintainRuleColl)
			{
			i++;
			@@ -473,9 +565,9 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + i + "行,保养规格不能为空";
			objJsonResult.Message = "第" + i + "行,保养规程不能为空";
			objJsonResult.data = null;
			throw new Exception("保养规格不能为空");
			throw new Exception("保养规程不能为空");
			}
			DataSet Cs;
			Int64 NewHEntryID = 1;
			@@ -541,7 +633,7 @@
			//修改上级为非末级代码
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存子表成功！";
			objJsonResult.Message = "保存成功！";
			//objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1144,5 +1236,656 @@
			}
			#endregion

			#region 设备履历列表

			[Route("Gy_EquipFileMain/GetResumeList")]
			[HttpGet]
			public object GetResumeList(string HInterID, string user)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			if (!DBUtility.ClsPub.Security_Log("Gy_EquipFileList", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有查看权限";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn($@"select a.HInterID,a.HDate '日期',a.HBillType,x.HName 单据类型,a.HBillNo as '单据号',
			CASE WHEN a.HBillStatus <= 1 THEN '创建' WHEN a.HBillStatus = 2 THEN '已审核' WHEN a.HBillStatus = 3 AND
			a.HCloseType = 0 THEN '自动关闭' WHEN a.HBillStatus = 3 AND
			a.HCloseType = 1 THEN '手动关闭' WHEN a.HBillStatus = 4 THEN '已作废' ELSE '其它状态' END AS 单据状态,
			a.HMaker AS 制单人, a.HMakeDate AS 制单日期,a.HChecker AS 审核人, a.HCheckDate AS 审核日期, a.HUpDater AS 修改人, a.HUpDateDate AS 修改日期,
			a.HCloseMan AS 关闭人, a.HCloseDate AS 关闭日期, a.HDeleteMan AS 作废人, a.HDeleteDate AS 作废日期
			from (
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Gy_EquipFileBillMain where HInterID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sb_EquipStockInCheckBillMain where HEquipID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sb_EquipDotCheckBillMain where HEquipID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sb_EquipMaintainBillMain where HEquipID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sb_EquipRepairWorkBillMain where HEquipID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sb_EquipConkBookBillMain where HEquipID = {HInterID}
			)as a,Xt_BillType as x
			where a.HBillType = x.HNumber
			ORDER BY '日期' ASC;", "h_v_Gy_EquipFileMainList");

			//添加动态列信息
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			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_MouldFileMain/GetMouldResumeList")]
			[HttpGet]
			public object GetMouldResumeList(string HInterID, string user)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			if (!DBUtility.ClsPub.Security_Log("Gy_MouldFileList", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有查看权限";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn($@"select a.HInterID,a.HDate '日期',a.HBillType,x.HName 单据类型,a.HBillNo as '单据号',
			CASE WHEN a.HBillStatus <= 1 THEN '创建' WHEN a.HBillStatus = 2 THEN '已审核' WHEN a.HBillStatus = 3 AND
			a.HCloseType = 0 THEN '自动关闭' WHEN a.HBillStatus = 3 AND
			a.HCloseType = 1 THEN '手动关闭' WHEN a.HBillStatus = 4 THEN '已作废' ELSE '其它状态' END AS 单据状态,
			a.HMaker AS 制单人, a.HMakeDate AS 制单日期,a.HChecker AS 审核人, a.HCheckDate AS 审核日期, a.HUpDater AS 修改人, a.HUpDateDate AS 修改日期,
			a.HCloseMan AS 关闭人, a.HCloseDate AS 关闭日期, a.HDeleteMan AS 作废人, a.HDeleteDate AS 作废日期
			from (
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Gy_MouldFileMain where HInterID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sc_MouldDotCheckBillMain where HMouldID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sc_MouldMaintainBillMain where HMouldID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sc_MouldRepairWorkBillMain where HMouldID = {HInterID} UNION ALL
			select HInterID,HDate,HBillType,HBillNo,HBillStatus,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HDeleteMan,HDeleteDate,HCloseType from Sc_MouldConkBookBillMain where HMouldID = {HInterID} UNION ALL
			select a.HInterID,a.HDate,a.HBillType,a.HBillNo,a.HBillStatus,a.HMaker,a.HMakeDate,a.HChecker,a.HCheckDate,a.HUpDater,a.HUpDateDate,a.HCloseMan,a.HCloseDate,a.HDeleteMan,a.HDeleteDate,a.HCloseType
			from Sc_MouldStockBillMain as a,Sc_MouldStockBillSub as b
			where a.HInterID = b.HInterID and b.HMaterID = {HInterID} and HBillType in ('3801','3829','3826','3831','3827')
			)as a,Xt_BillType as x
			where a.HBillType = x.HNumber
			ORDER BY '日期' ASC;", "Gy_MouldFileResume");

			//添加动态列信息
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			#endregion

			#region 设备档案文件导入保存
			#region 设备档案文件上传
			[Route("Gy_EquipFileMain/Gy_EquipFileMain_Excel")]
			[HttpPost]
			public object Gy_EquipFile_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("HMaterID", typeof(Int32));//物料ID
			tb2.Columns.Add("HEquipTypeID", typeof(Int32));//分类ID
			tb2.Columns.Add("HUnitID", typeof(Int32));//单位ID
			tb2.Columns.Add("HDeptID", typeof(Int32));//部门ID
			tb2.Columns.Add("HUseEmpID", typeof(Int32));//使用负责人ID
			tb2.Columns.Add("HRepairEmpID", typeof(Int32));//维护负责人ID
			tb2.Columns.Add("HSupID", typeof(Int32));//供应商ID
			tb2.Columns.Add("HMadeSupID", 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("对应ERP物料代码"))
			error += "没有找到【对应ERP物料代码】的标题,";

			if (!tb2.Columns.Contains("对应ERP物料"))
			error += "没有找到【对应ERP物料】的标题,";

			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 (!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 HEquipName = "";
			string HEquipNo = "";
			string HORGNumber = "";
			string HORGName = "";
			string HMaterNumber = "";
			string HMaterName = "";
			string HUnitName = "";
			string HDeptName = "";
			string HUseEmpName = "";
			string HRepairEmpName = "";
			string HSupName = "";
			string HMadeSupName = "";
			string HEquipTypeName = "";

			HEquipName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["设备名称"].ToString());
			HEquipNo = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["设备编号"].ToString());
			HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织代码"].ToString());
			HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织名称"].ToString());
			HMaterNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["对应ERP物料代码"].ToString());
			HMaterName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["对应ERP物料"].ToString());
			HUnitName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["计量单位"].ToString());
			HDeptName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["使用部门"].ToString());
			HUseEmpName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["使用负责人"].ToString());
			HRepairEmpName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["维护负责人"].ToString());
			HSupName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["供应商"].ToString());;
			HMadeSupName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["制造商"].ToString());
			HEquipTypeName = 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_EquipFileType where HName='" + HEquipTypeName + "' ", "EquipFileType");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,分类:" + HEquipTypeName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HEquipTypeID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询物料
			ds = oCN.RunProcReturn("select * from Gy_Material where HNumber='" + HMaterNumber + "' and HUSEORGID=" + HORGid + "", "Gy_Department");

			if (ds.Tables[0].Rows.Count == 0 && HMaterNumber != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,物料:" + HMaterName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else if (HMaterNumber == "")
			{
			tb2.Rows[i]["HMaterID"] = 0;
			}
			else
			{
			tb2.Rows[i]["HMaterID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询单位
			ds = oCN.RunProcReturn("select * from Gy_Unit where HName='" + HUnitName + "' and HUSEORGID=" + HORGid + "", "Gy_Unit");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,单位:" + HUnitName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HUnitID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询部门
			ds = oCN.RunProcReturn("select * from Gy_Department where HName='" + HDeptName + "' and HUSEORGID=" + HORGid + "", "Gy_Department");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,部门:" + HDeptName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HDeptID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询使用负责人
			ds = oCN.RunProcReturn("select * from Gy_Employee where HName='" + HUseEmpName + "' and HUSEORGID=" + HORGid + "", "Gy_Employee");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,使用负责人:" + HUseEmpName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HUseEmpID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询维护负责人
			ds = oCN.RunProcReturn("select * from Gy_Employee where HName='" + HRepairEmpName + "' and HUSEORGID=" + HORGid + "", "Gy_Employee");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,维护负责人人:" + HRepairEmpName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HRepairEmpID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询供应商
			ds = oCN.RunProcReturn("select * from Gy_Supplier where HName='" + HSupName + "' and HUSEORGID=" + HORGid + "", "Gy_Supplier");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,供应商:" + HSupName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HSupID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}
			//查询制造商
			ds = oCN.RunProcReturn("select * from Gy_Supplier where HName='" + HMadeSupName + "' and HUSEORGID=" + HORGid + "", "Gy_Supplier");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,制造商:" + HMadeSupName + ",不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			tb2.Rows[i]["HMadeSupID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
			}

			//设备档案名称
			if (HEquipName == "")
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "第" + index + "行,设备档案名称不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//设备档案代码
			if (HEquipNo == "")
			{
			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_EquipFileMain/Gy_EquipFileMain_btnSave")]
			[HttpPost]
			public object Gy_EquipFile_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_EquipFile_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 BillType = "3308";
			//得到mainid
			long HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			string HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); ;//递入type得到的单据号
			DateTime HDate = DateTime.Now;//日期
			string HYear = DateTime.Now.Year.ToString();
			string HEquipFileNumber = "";
			string HEquipFileNo = item["设备编号"].ToString(); // varchar(50) //设备编码(唯一)
			string HName = item["设备名称"].ToString(); // √ varchar(100) //设备名称
			string HModel = item["设备规格"].ToString(); // √ varchar(100) //设备规格
			string HModel2 = item["设备型号"].ToString(); // √ varchar(100) //设备型号
			int HMaterID = int.Parse(item["HMaterID"].ToString()); // √ int //对应物料
			int HUnitID = int.Parse(item["HUnitID"].ToString()); // √ int //单位
			string HOutComDate = item["设备出厂日期"].ToString() == "" ? DateTime.Now.ToString() : item["设备出厂日期"].ToString(); // √ datetime //设备出厂日期
			string HOutComNo = item["设备出厂编号"].ToString(); // √ varchar(100) //设备出厂编号
			int HDeptID = int.Parse(item["HDeptID"].ToString()); // √ int //使用部门（gy_Department）
			int HUseEmpID = int.Parse(item["HUseEmpID"].ToString()); //√ int //使用负责人（gy_Employee）
			int HRepairEmpID = int.Parse(item["HRepairEmpID"].ToString()); //√ int //维护负责人（gy_Employee）
			string HAddress = item["安装地点"].ToString(); // √ varchar(500) //安装地点
			string HSetupDate = item["安装日期"].ToString() == "" ? DateTime.Now.ToString() : item["安装日期"].ToString(); //√ datetime //安装日期
			string HStartupDate = item["运行开始日期"].ToString() == "" ? DateTime.Now.ToString() : item["运行开始日期"].ToString(); //√ datetime //运行开始日期
			string HStatus = "空闲"; // √ varchar(20) //当前状态（空闲、占用、加工、关机、异常停机）
			int HEquipFileTypeID = int.Parse(item["HEquipTypeID"].ToString()); //√ int //设备类别（Gy_EquipFileType)
			string HProNum = item["工程编码"].ToString(); // √ varchar(100) //工程编码
			string HBarCode = item["条形码"].ToString(); //√ varchar(100) //条形码(暂时保存此字段)
			string HWorkArea = item["产地"].ToString(); //√ varchar(50) //产地
			string HLogo = item["品牌"].ToString(); //√ varchar(50) //品牌
			int HSellSupID = int.Parse(item["HSupID"].ToString()); // √ int //供应商(Gy_Supplier)
			int HMakeSupID = int.Parse(item["HMadeSupID"].ToString()); // int //制造商 (Gy_Supplier)
			string HMainSourceFlag = "否"; //varchar(10) //是否主生产设备(否，是)
			string HMacAddress = ""; // varchar(50) //数采物理地址
			int HMainSourceID = 0; //int //所属主生产设备（Gy_EquipFileBillMain）
			string HMaker = user;
			string HMakeDate = DateTime.Now.Date.ToString();
			int HEquipDotCheckRuleInterID = 0;
			int HEquipMaintainRuleInterID = 0;
			int HSourceID = 0;


			if (!DBUtility.ClsPub.AllowNumber(HEquipFileNo.Trim()))
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain where HEquipFileNo='" + HEquipFileNo + "'", "Gy_EquipFileBillMain");

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

			oCN.RunProc("Insert into Gy_EquipFileBillMain " +
			" (HInterID,hbillno,HEquipFileNumber,HEquipFileNo,HName,HModel,HModel2,HMaterID,HUnitID,HOutComDate" +
			",HOutComNo,HDeptID,HUseEmpID,HRepairEmpID,HAddress,HSetupDate,HStartupDate,HStatus," +
			"HEquipFileTypeID,HProNum,HBarCode,HWorkArea,HLogo,HSellSupID,HMakeSupID,hbilltype,HDate,HYear,HMaker,HMakeDate,HEquipMaintainRuleInterID,HEquipDotCheckRuleInterID,HSourceID,HMainSourceFlag,HMacAddress,HMainSourceID) " +
			" Values(" + HInterID + ",'" + HBillNo + "','" + HEquipFileNumber + "','" + HEquipFileNo + "','" + HName + "','" + HModel + "','" + HModel2 + "'," + HMaterID + "," + HUnitID +
			",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HUseEmpID + "," + HRepairEmpID + ",'" + HAddress +
			"','" + HSetupDate + "','" + HStartupDate + "','" + HStatus + "'," + HEquipFileTypeID + ",'" + HProNum +
			"','" + HBarCode + "','" + HWorkArea + "','" + HLogo + "'," + HSellSupID + "," + HMakeSupID + ",'3308','" + HDate + "','" + HYear + "','" + HMaker + "','" + HMakeDate + "','" + HEquipMaintainRuleInterID + "','" + HEquipDotCheckRuleInterID + "'," + HSourceID + ",'" + HMainSourceFlag + "','" + HMacAddress + "','" + HMainSourceID + "')");
			}
			else
			{
			oCN.RunProc("Update Gy_EquipFileBillMain set " +
			" HEquipFileNumber='" + HEquipFileNumber + "'" +
			//",HEquipFileNo='" + HEquipFileNo + "'" +
			",HName='" + HName + "'" +
			",HModel='" + HModel + "'" +
			",HModel2='" + HModel2 + "'" +
			",HMaterID=" + HMaterID +
			",HUnitID=" + HUnitID +
			",HOutComDate='" + HOutComDate + "'" +
			",HOutComNo='" + HOutComNo + "'" +
			",HDeptID=" + HDeptID +
			",HUseEmpID=" + HUseEmpID +
			",HRepairEmpID=" + HRepairEmpID +
			",HAddress='" + HAddress + "'" +
			",HSetupDate='" + HSetupDate + "'" +
			",HStartupDate='" + HStartupDate + "'" +
			",HStatus='" + HStatus + "'" +
			",HEquipFileTypeID=" + HEquipFileTypeID +
			",HProNum='" + HProNum + "'" +
			",HBarCode='" + HBarCode + "'" +
			",HWorkArea='" + HWorkArea + "'" +
			",HLogo='" + HLogo + "'" +
			",HSellSupID=" + HSellSupID +
			",HMakeSupID= " + HMakeSupID +
			",HUpDater= '" + user + "'" +
			",HUpDateDate= getdate()" + "" +
			",HEquipDotCheckRuleInterID='" + HEquipDotCheckRuleInterID + "'" +
			",HEquipMaintainRuleInterID='" + HEquipMaintainRuleInterID + "'" +
			",HSourceID='" + HSourceID + "'" +
			",HMainSourceFlag= '" + HMainSourceFlag + "'" +
			",HMacAddress= '" + HMacAddress + "'" +
			",HMainSourceID = '" + HMainSourceID + "'" +
			" Where HEquipFileNo='" + HEquipFileNo + "'");
			}

			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

			}
			}