根据班组返回职员信息调用方法修改

yxj

2024-10-07 de6089a2212d3fda05f67ab828aa774b5bd831ce

 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs

@@ -14,6 +14,8 @@
using WebAPI.Models;
using WebAPI.Service;
using System.Text.RegularExpressions;
using WebAPI.Controllers.SCGL.日计划管理;
using SyntacticSugar.constant;

namespace WebAPI.Controllers
{
@@ -22,7 +24,7 @@
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

        public string sWhere = "";
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
@@ -79,7 +81,7 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where 组织名称='" + Organization + "'");
                string sql1 = string.Format(@"select top(500) * from h_v_Gy_MaterialList where 组织名称='" + Organization + "'");
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn(sql1 + sWhere + " order by 物料代码 desc", "h_v_Gy_MaterialList");
@@ -114,6 +116,58 @@
                return objJsonResult;
            }
        }

        #region 物料分页列表
        [Route("Gy_Material/page")]
        [HttpGet]
        public object page(string sWhere, string user, string Organization,int page,int size)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_Material", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("exec h_p_Gy_MaterialList " + page + "," + size + ",'" + Organization +"'," + "''", "h_p_Gy_MaterialList");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Gy_MaterialList " + page + "," + size + ",'" + Organization + "','" + sWhere + "'", "h_p_Gy_MaterialList");
                }

                //添加列名
                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 = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
                objJsonResult.Message = "Sucess！";
                objJsonResult.list = columnNameList;
                objJsonResult.data = ds.Tables[0];
                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_Material/getMaxNum")]
@@ -237,13 +291,93 @@
        #region 获取项目号
        [Route("Gy_Material/Get_HProject")]
        [HttpGet]
        public object Get_HProject(string HOrgID)
        public object Get_HProject()
        {
            try
            {
                DataSet oDs = new DataSet();
                //==========
                oDs = oCN.RunProcReturn("select top(20) HInterID as HItemID,HProName HName from PM_ProjectBillMain", "PM_ProjectBillMain");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取成功！";
                objJsonResult.data = oDs.Tables[0];
                return objJsonResult; ;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        /// <summary>
        /// 获取项目列表
        /// </summary>
        /// <returns></returns>
        [Route("Gy_Material/GetProjectGroupList_Json")]
        [HttpGet]
        public object GetProjectGroupList_Json(string Unit)
            { 
                if (Unit != "" && Unit != null)
                {
                    sWhere = sWhere + " and ( HBillNo like '%" + Unit + "%' or HProName like '%" + Unit + "%' ) ";
                }

                try
                {
                    SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                    if (sWhere == null || sWhere.Equals(""))
                    {
                        ds = oCN.RunProcReturn("Select HInterID,HBillNo 项目代码,HProName 项目组 from PM_ProjectBillMain where HCloseType = 0 Order by HInterID ", "PM_ProjectBillMain");
                    }
                    else
                    {
                        string sql1 = "Select HInterID,HBillNo 项目代码,HProName 项目组 from PM_ProjectBillMain where HCloseType = 0 ";
                        string sql = sql1 + sWhere;
                        ds = oCN.RunProcReturn(sql, "PM_ProjectBillMain");
                    }

                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "获取失败" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #region 获取事业部
        [Route("Gy_Material/Get_Gy_Division")]
        [HttpGet]
        public object Get_Gy_Division(string HOrgID)
        {
            try
            {
                DataSet oDs = new DataSet();
                //==========
                oDs = oCN.RunProcReturn("   select HItemID,HName from Gy_Division", "Gy_Division");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取成功！";
@@ -524,6 +658,458 @@
            }
        }

        #region 物料 文件导入保存
        #region 物料 文件上传
        [Route("Gy_Material/Gy_Material_Excel")]
        [HttpPost]
        public object Gy_Material_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("HMaterClsID", typeof(Int32));//物料属性ID
                tb2.Columns.Add("HUnitGroupID", typeof(Int32));//计量单位组ID
                tb2.Columns.Add("HUnitID", typeof(Int32));//单位ID
                tb2.Columns.Add("HSecUnitID", typeof(Int32));//辅助计量单位ID
                tb2.Columns.Add("HWhID", typeof(Int32));//默认仓库ID
                //添加数据
                for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
                {
                    DataRow row = tb2.NewRow();
                    for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
                    {
                        row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
                    }
                    tb2.Rows.Add(row);
                }


                var error = "";

                //判断导入文件列是否完整
                if (!tb2.Columns.Contains("组织代码"))
                    error += "没有找到【组织代码】的标题,";

                if (!tb2.Columns.Contains("组织名称"))
                    error += "没有找到【组织名称】的标题,";

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

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

                if (!tb2.Columns.Contains("规格型号"))
                    error += "没有找到【规格型号】的标题,";

                if (!tb2.Columns.Contains("助记码"))
                    error += "没有找到【助记码】的标题,";

                if (!tb2.Columns.Contains("版本号"))
                    error += "没有找到【版本号】的标题,";

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

                if (!tb2.Columns.Contains("计量单位组"))
                    error += "没有找到【计量单位组】的标题,";

                if (!tb2.Columns.Contains("计量单位代码"))
                    error += "没有找到【计量单位代码】的标题,";

                if (!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 HMaterName = "";
                    string HMaterNumber = "";
                    string HORGNumber = "";
                    string HORGName = "";
                    string HMaterClsName = "";
                    string HUnitGroupName = "";
                    string HUnitNumber = "";
                    string HUnitName = "";
                    string HSecUnitName = "";
                    string HWhName = "";

                    HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织代码"].ToString());
                    HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织名称"].ToString());
                    HMaterNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["物料代码"].ToString());
                    HMaterName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["物料名称"].ToString());
                    HMaterClsName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["物料属性"].ToString());
                    HUnitGroupName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["计量单位组"].ToString());
                    HUnitNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["计量单位代码"].ToString());
                    HUnitName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["计量单位"].ToString());
                    HSecUnitName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["辅助计量单位"].ToString());
                    HWhName = 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();
                        //查询属性
                        if (HMaterClsName == "外购")
                        {
                            tb2.Rows[i]["HMaterClsID"] = 1;
                        }
                        else if(HMaterClsName == "自制")
                        {
                            tb2.Rows[i]["HMaterClsID"] = 2;
                        }
                        else if (HMaterClsName == "委外")
                        {
                            tb2.Rows[i]["HMaterClsID"] = 3;
                        }
                        else
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,物料属性不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //查询计量单位组
                        ds = oCN.RunProcReturn("select * from Gy_UnitGroup where  HName='" + HUnitGroupName + "'", "Gy_UnitGroup");

                        if (ds.Tables[0].Rows.Count == 0 && HUnitGroupName != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "第" + index + "行,该" +  "计量单位组:" + HUnitGroupName + ",不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else if (HMaterNumber == "")
                        {
                            tb2.Rows[i]["HUnitGroupID"] = 0;
                        }
                        else
                        {
                            tb2.Rows[i]["HUnitGroupID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
                        }
                        //查询单位
                        ds = oCN.RunProcReturn("select * from Gy_Unit where  HNumber='" + HUnitNumber + "'  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_Unit where  HName='" + HSecUnitName + "'  and HUSEORGID=" + HORGid + "", "Gy_Unit");

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

                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,仓库:" + HWhName + ",不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            tb2.Rows[i]["HWHID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
                        }
                        //物料名称
                        if (HMaterName == "")
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,物料名称不能为空！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }

                        //物料代码
                        if (HMaterNumber == "")
                        {
                            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_Material/Gy_Material_btnSave")]
        [HttpPost]
        public object Gy_Material_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_Material_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)
                {
                    DLL.ClsGy_Material_Ctl oBill = new DLL.ClsGy_Material_Ctl();
                    ClsGy_Material_Model oItem = new ClsGy_Material_Model();
                    //赋值前端传入的
                    oItem.HUSEORGID = int.Parse(item["HOrgID"].ToString());
                    oItem.HNumber = item["物料代码"].ToString();
                    oItem.HName = item["物料名称"].ToString();
                    oItem.HModel = item["规格型号"].ToString();
                    oItem.HHelpCode = item["助记码"].ToString();
                    oItem.HVersion = item["版本号"].ToString();
                    oItem.HMaterClsID = int.Parse(item["HMaterClsID"].ToString());
                    oItem.HUnitGroupID = int.Parse(item["HUnitGroupID"].ToString());
                    oItem.HUnitID = int.Parse(item["HUnitID"].ToString());
                    oItem.HSecUnitID = int.Parse(item["HSecUnitID"].ToString());
                    oItem.HSecUnitRate = double.Parse(item["换算率"].ToString()==""?"0": item["换算率"].ToString());
                    oItem.HWhID = int.Parse(item["HWhID"].ToString());
                    oItem.HHighStock = int.Parse(item["最高库存"].ToString() == "" ? "0" : item["最高库存"].ToString());
                    oItem.HLowStock = int.Parse(item["最低库存"].ToString() == "" ? "0" : item["最低库存"].ToString());
                    oItem.HSafeStock = int.Parse(item["安全库存"].ToString() == "" ? "0" : item["安全库存"].ToString());
                    oItem.HOrderPrice = int.Parse(item["采购单价"].ToString() == "" ? "0" : item["采购单价"].ToString());
                    oItem.HSalePrice = int.Parse(item["销售单价"].ToString() == "" ? "0" : item["销售单价"].ToString());
                    oItem.HPlanPrice = int.Parse(item["计划单价"].ToString() == "" ? "0" : item["计划单价"].ToString());
                    oItem.HstdPrice = int.Parse(item["标准成本"].ToString() == "" ? "0" : item["标准成本"].ToString());
                    oItem.HKeepDays = int.Parse(item["保质期"].ToString() == "" ? "0" : item["保质期"].ToString());
                    oItem.HQtyMin = int.Parse(item["最小订货量"].ToString() == "" ? "0" : item["最小订货量"].ToString());
                    oItem.HQtyMin = int.Parse(item["最大订货量"].ToString() == "" ? "0" : item["最大订货量"].ToString());
                    oItem.HEngName = item["英文名称"].ToString();
                    oItem.HEngModel = item["英文规格"].ToString();
                    //常规赋值赋空值防止报错
                    oItem.HMaterTypeID = 0;
                    oItem.HColorRemark = "";
                    oItem.HColorNo = "";
                    oItem.HMaterRuleType = "";
                    string sShortNumber;
                    sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
                    if (sShortNumber.Trim() == "")
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "保存失败！短代码为空！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    oItem.HShortNumber = sShortNumber;//短代码
                    oItem.HEndFlag = true;//末级标志
                    oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
                    oBill.oModel = oItem;
                    if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }

                    ds = oCN.RunProcReturn("select * from  Gy_Material where  HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Material");

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

                        oBill.AddNew();
                    }
                    else
                    {

                        int HItemID = int.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString());
                        oBill.oModel.HItemID = HItemID;
                        oBill.ModifyByID(oBill.oModel.HItemID);

                    }

                    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
        /// <summary>
        /// 物料设置删除功能
        /// </summary>
@@ -1001,7 +1587,7 @@
                    return objJsonResult;
                }

                string sql1 = "select top 5000 * from h_v_IF_BarCodeBillList where 1 = 1 ";
                string sql1 = "select top 15000 * from h_v_IF_BarCodeBillList where 1 = 1 ";
                string sql = sql1 + sWhere + " order by hmainid desc";
                ds = oCN.RunProcReturn(sql, "h_v_IF_BarCodeBillList");

@@ -1450,6 +2036,30 @@
                string HMouldClass = mainList[0].HMouldClass;
                int HNowWHID = mainList[0].HNowWHID;
                int HNowSPID = mainList[0].HNowSPID;
                string HMouldUseStatus = mainList[0].HMouldUseStatus;

                //保存前控制=========================================
                string HBillNote = "";
                ds = oCN.RunProcReturn("Exec h_p_Gy_MouldFileMain_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", "h_p_Gy_MouldFileMain_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_MouldFileMain   " +
@@ -1462,7 +2072,7 @@
                ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" +
                ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" +
                ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID,HBarCode,HMadeSupID" +
                ",HMouldClass,HNowWHID,HNowSPID,HInitLife) " +
                ",HMouldClass,HNowWHID,HNowSPID,HInitLife,HMouldUseStatus) " +
                " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
                "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" +
                ",'" + HMouldNo + "','" + HName + "','" + HModel + "','" + HModel2 + "','" + HDiameter + "'" +
@@ -1472,7 +2082,7 @@
                "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID + "," + HCaveQty +
                "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID + "','" + HNowSupTypeID + "'" +
                ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID + "','" + HMouldMaintainRuleInterID + "','" + HBarCode + "'," + HMadeSupID +
                ",'"+ HMouldClass + "'," + HNowWHID + "," + HNowSPID + ",'" + HInitLife + "') ");
                ",'"+ HMouldClass + "'," + HNowWHID + "," + HNowSPID + ",'" + HInitLife + "','" + HMouldUseStatus + "') ");

                //子表
                oCN.RunProc("Insert into Gy_MouldFileSub " +
@@ -1484,6 +2094,29 @@
                ") ");

                objJsonResult = AddBillSub(msg5,msg6,msg7,HInterID, HBillNo);

                //保存后控制=========================================
                ds = oCN.RunProcReturn("Exec h_p_Gy_MouldFileMain_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", "h_p_Gy_MouldFileMain_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;
                }
                //=========================================================


                if (objJsonResult.code == "0")
                {
@@ -1599,7 +2232,7 @@
                string HMouldClass = mainList[0].HMouldClass;
                int HNowWHID = mainList[0].HNowWHID;
                int HNowSPID = mainList[0].HNowSPID;

                string HMouldUseStatus = mainList[0].HMouldUseStatus;
                //若MAINDI重复则重新获取
                oCN.BeginTran();
                //主表
@@ -1656,6 +2289,7 @@
                ",HNowWHID=" + HNowWHID +
                ",HNowSPID=" + HNowSPID +
                ",HInitLife='" + HInitLife +
                "',HMouldUseStatus='" + HMouldUseStatus +
                "' where HInterID=" + HInterID.ToString());

                //修改子项目代码
@@ -2578,5 +3212,589 @@
        }
        #endregion

        #region 器具档案 文件导入保存
        #region 器具档案 文件上传
        [Route("Gy_MouldFile/Gy_MouldFile_Excel")]
        [HttpPost]
        public object Gy_Mould_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("HMouldTypeID", typeof(Int32));//分类ID
                tb2.Columns.Add("HUnitID", typeof(Int32));//单位ID
                tb2.Columns.Add("HDeptID", typeof(Int32));//部门ID
                tb2.Columns.Add("HWHID", typeof(Int32));//仓库ID
                tb2.Columns.Add("HSupID", typeof(Int32));//供应商ID
                tb2.Columns.Add("HSPID", 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("穴数"))
                    error += "没有找到【穴数】的标题,";

                if (!tb2.Columns.Contains("辅助属性1"))
                    error += "没有找到【辅助属性1】的标题,";

                if (!tb2.Columns.Contains("辅助属性2"))
                    error += "没有找到【辅助属性2】的标题,";

                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 (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 HMouldName = "";
                    string HMouldNum = "";
                    string HORGNumber = "";
                    string HORGName = "";
                    string HMaterNumber = "";
                    string HMaterName = "";
                    string HUnitName = "";
                    string HDeptName = "";
                    string HWHName = "";
                    string HSPName = "";
                    string HSupName = "";
                    string HSupNumber = "";
                    string HMadeSupName = "";
                    string HMouldTypeName = "";

                    HMouldName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["器具名称"].ToString());
                    HMouldNum = 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());
                    HWHName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["默认仓库"].ToString());
                    HSPName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["默认仓位"].ToString());
                    HSupName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["供应商"].ToString());
                    HSupNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["供应商代码"].ToString());
                    HMadeSupName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["制造商"].ToString());
                    HMouldTypeName = 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_MouldType where  HName='" + HMouldTypeName + "' ", "Gy_MouldType");

                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "第" + index + "行,分类:" + HMouldTypeName + ",不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            tb2.Rows[i]["HMouldTypeID"] = 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_Warehouse where  HName='" + HWHName + "'  and HUSEORGID=" + HORGid + "", "Gy_Warehouse");

                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,仓库:" + HWHName + ",不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            tb2.Rows[i]["HWHID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
                        }
                        string HWHID = tb2.Rows[i]["HWHID"].ToString();
                        //查询仓位
                        ds = oCN.RunProcReturn("select * from Gy_StockPlace where  HName='" + HSPName + "'and HSPGroupID=" + HWHID+ "  and HUSEORGID=" + HORGid + "", "Gy_Warehouse");

                        if (ds.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,仓位:" + HSPName + ",不存在！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            tb2.Rows[i]["HSPID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();
                        }
                        //查询供应商
                        ds = oCN.RunProcReturn("select * from Gy_Supplier where  HNumber='" + HSupNumber + "'  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 (HMouldName == "")
                        {
                            objJsonResult.code = CodeConstant.FAIL;
                            objJsonResult.count = CountConstant.FAIL;
                            objJsonResult.Message = "第" + index + "行,器具档案名称不能为空！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }

                        //器具档案代码
                        if (HMouldNum == "")
                        {
                            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_MouldFile/Gy_MouldFile_btnSave")]
        [HttpPost]
        public object Gy_Mould_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_MouldFile_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 = "3899";
                    //得到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;//日期
                    int HYear = DBUtility.ClsPub.isInt(DateTime.Now.Year);
                    double HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
                    string HMouldNo = item["器具编号"].ToString();
                    string HBarCode = item["条形码"].ToString();
                    string HName = item["器具名称"].ToString();
                    string HModel = item["器具规格"].ToString();
                    string HModel2 = item["器具型号"].ToString();
                    string HDiameter = "";//直径
                    string HSubjoin = item["辅助属性1"].ToString();
                    string HSubjoin2 = item["辅助属性2"].ToString();
                    string HPICNo = item["图号"].ToString();
                    string HWorkMaterModel = "";//生产产品型号
                    long HMaterID = int.Parse(item["HMaterID"].ToString());
                    long HMouleTypeID = int.Parse(item["HMouldTypeID"].ToString());
                    long HUnitID = int.Parse(item["HUnitID"].ToString());
                    DateTime HOutComDate = DateTime.Now;
                    string HOutComNo = item["器具出厂编号"].ToString();
                    long HDeptID = int.Parse(item["HDeptID"].ToString());
                    long HSupID = int.Parse(item["HSupID"].ToString());
                    string HMouldStatus = item["状态"].ToString();
                    long HWHID = int.Parse(item["HWHID"].ToString());
                    long HRoutingID = 0;//工艺路线id
                    long HBOMID = 0;
                    string HVersion = "";//版本
                    long HSPGroupID = 0;//默认仓位组
                    long HSPID = int.Parse(item["HSPID"].ToString());//仓位id
                    Double HDesignLife = item["设计寿命"].ToString()=="" ? 0: double.Parse(item["设计寿命"].ToString());
                    Double HUseLife = item["使用寿命"].ToString() == "" ? 0 : double.Parse(item["使用寿命"].ToString());
                    Double HInitLife = 0;//上线初始化寿命
                    Double HLeaveLife = 0;//剩余寿命
                    Double HProdQty = 0;//已生产数量
                    Double HProdWeight = 0;//已生产重量
                    string HRemark = item["备注"].ToString();
                    string HMaker = user;
                    string HMaterNumber = item["对应ERP物料代码"].ToString();
                    string HSupNumber = item["供应商代码"].ToString();
                    long HPrintQty = 0;//已生产数量
                    string HMouldOWNER = "自费";//货主类型
                    string HSaveLife = "";//安全寿命
                    int HCaveQty = item["穴数"].ToString() == "" ? 0 : int.Parse(item["穴数"].ToString());
                    int HMouldDotCheckRuleInterID = 0;
                    int HMouldMaintainRuleInterID = 0;
                    int HNowSupID = 0;//虚拟仓
                    int HNowSupTypeID = 0;
                    int HMadeSupID = 0;
                    string HMouldClass = "模具";//器具类型
                    int HNowWHID = 0;
                    int HNowSPID = 0;


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

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

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

                        oCN.RunProc("Insert Into Gy_MouldFileMain   " +
                        "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                        ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                        ",HMouldNo,HName,HModel,HModel2,HDiameter" +
                        ",HSubjoin,HSubjoin2,HPICNo,HWorkMaterModel" +
                        ",HMaterID,HMaterNumber,HMouldType,HUnitID" +
                        ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" +
                        ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" +
                        ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" +
                        ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID,HBarCode,HMadeSupID" +
                        ",HMouldClass,HNowWHID,HNowSPID,HInitLife) " +
                        " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
                        "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" +
                        ",'" + HMouldNo + "','" + HName + "','" + HModel + "','" + HModel2 + "','" + HDiameter + "'" +
                        ",'" + HSubjoin + "','" + HSubjoin2 + "','" + HPICNo + "','" + HWorkMaterModel + "'" +
                        "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID +
                        ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" +
                        "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID + "," + HCaveQty +
                        "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID + "','" + HNowSupTypeID + "'" +
                        ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID + "','" + HMouldMaintainRuleInterID + "','" + HBarCode + "'," + HMadeSupID +
                        ",'" + HMouldClass + "'," + HNowWHID + "," + HNowSPID + ",'" + HInitLife + "') ");
                    }
                    else
                    {
                        oCN.RunProc("UpDate Gy_MouldFileMain set  " +
                //" HBillNo='" + HBillNo + "'" +  //固定赋值===============
                //",HDate='" + HDate + "'" +
                //",HYear='" + HYear.ToString() + "'" +
                //",HPeriod='" + HPeriod.ToString() + "'" +
                "HRemark='" + HRemark + "'" +
                ",HUpDater='" + user + "'" +
                ",HUpDateDate=getdate()" +
                //========================================
                //",HMouldNo='" + HMouldNo + "'" +
                ",HName='" + HName + "'" +
                ",HModel='" + HModel + "'" +
                ",HModel2='" + HModel2 + "'" +
                ",HDiameter='" + HDiameter + "'" +
                ",HSubjoin='" + HSubjoin + "'" +
                ",HSubjoin2='" + HSubjoin2 + "'" +
                ",HPICNo='" + HPICNo + "'" +
                ",HWorkMaterModel='" + HWorkMaterModel + "'" +
                ",HMaterID=" + HMaterID.ToString() +
                ",HMaterNumber='" + HMaterNumber + "'" +
                ",HMouldClass='" + HMouldClass + "'" +
                ",HMouldType=" + HMouleTypeID.ToString() +
                ",HUnitID=" + HUnitID.ToString() +
                ",HOutComDate='" + HOutComDate + "'" +
                ",HOutComNo='" + HOutComNo + "'" +
                ",HDeptID=" + HDeptID.ToString() +
                ",HSupID=" + HSupID.ToString() +
                ",HSupNumber='" + HSupNumber + "'" +
                ",HPrintQty=" + HPrintQty.ToString() +
                ",HMouldStatus='" + HMouldStatus + "'" +
                ",HSaveLife='" + HSaveLife + "'" +
                ",HWhID=" + HWHID.ToString() +
                ",HRoutingID=" + HRoutingID.ToString() +
                ",HBomID=" + HBOMID.ToString() +
                ",HVersion='" + HVersion + "'" +
                ",HSPGroupID=" + HSPGroupID.ToString() +
                ",HSPID=" + HSPID.ToString() +
                ",HDesignLife=" + HDesignLife.ToString() +
                ",HCaveQty=" + HCaveQty.ToString() +
                ",HUseLife=" + HUseLife.ToString() +
                ",HLeaveLife=" + HLeaveLife.ToString() +
                ",HProdQty=" + HProdQty.ToString() +
                ",HMouldDotCheckRuleInterID=" + HMouldDotCheckRuleInterID.ToString() +
                ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() +
                ",HMouldOWNER='" + HMouldOWNER + "'" +
                ",HNowSupID=" + HNowSupID.ToString() +
                ",HNowSupTypeID=" + HNowSupTypeID.ToString() +
                ",HProdWeight=" + HProdWeight.ToString() +
                ",HBarCode='" + HBarCode.ToString() + "'" +
                ",HMadeSupID=" + HMadeSupID +
                ",HNowWHID=" + HNowWHID +
                ",HNowSPID=" + HNowSPID +
                ",HInitLife='" + HInitLife +
                "' where HMouldNo='" + HMouldNo.ToString()+"'");
                    }

                    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

    }
}