智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2024-12-25 e40117346bd24dc9d888480a52e97ce651121b6e 
 WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs


@@ -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


@@ -320,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" +


@@ -331,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;


@@ -510,7 +557,7 @@


                    oCN.RunProc("delete from Gy_EquipFileBillSub_DotCheckRule where HInterID = " + HInterID );


                }


                int i = 0;


                //保存保养规格


                //保存保养规程


                foreach (ClsGy_EquipFileBillSub_MaintainRule oSub in MaintainRuleColl)


                {


                    i++;


@@ -518,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;


@@ -586,7 +633,7 @@


                //修改上级为非末级代码


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "保存子表成功！";


                objJsonResult.Message = "保存成功！";


                //objJsonResult.data = null;


                return objJsonResult;


        }


@@ -1206,23 +1253,25 @@


                    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");




                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");


                ds = oCN.RunProcReturn("exec h_p_Gy_EquipFileReport '" + HInterID + "'", "h_p_Gy_EquipFileReport");




                //添加动态列信息


                foreach (DataColumn col in ds.Tables[0].Columns)


@@ -1268,25 +1317,27 @@


                    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");




                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");


                ds = oCN.RunProcReturn("exec h_p_Gy_MouldFileReport '" + HInterID + "'", "h_p_Gy_MouldFileReport");




                //添加动态列信息


                foreach (DataColumn col in ds.Tables[0].Columns)


@@ -1315,5 +1366,530 @@




        #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




    }


}