智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2025-04-08 385da37de94758dfe8befb0635307409869ec68a 
 WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs


@@ -177,37 +177,7 @@


            }




        }


        #endregion






        #region 设备分布 生产资源对应的订单 




        [Route("Sc_OrderStateDistribution/Sc_OrderStateDistribution_Souce")]


        [HttpGet]


        public object Sc_OrderStateDistribution_Souce(string sWhere,string user,int OrganizationID)


        {


            try


            {


                string sql1 = string.Format("exec h_p_sc_HDeptSouceMOList {0},{1}", sWhere, OrganizationID);




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




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


        #endregion    




        /// <summary>


        /// 根据基础资料ID 查找记录


@@ -1166,95 +1136,95 @@


        #endregion




        #region 部门列表 文件上传


        [Route("Gy_Department/Gy_Process_Excel")]


        [HttpPost]


        public json Gy_Department_Excel()


        {


            json res = new json();


            try


            {


                //获取文件名称


                var file = HttpContext.Current.Request.Files[0];


                //获取文件物理路径


                string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);


                //保存文件


                file.SaveAs(ExcelPath);


        //[Route("Gy_Department/Gy_Process_Excel")]


        //[HttpPost]


        //public json Gy_Department_Excel()


        //{


        //    json res = new json();


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


        //        NpoiHelper np = new NpoiHelper();


        //        DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0");




                //删除文件


                File.Delete(ExcelPath);


        //        //删除文件


        //        File.Delete(ExcelPath);




                //创建临时表


                DataTable provisional = new DataTable("dt2");


        //        //创建临时表


        //        DataTable provisional = new DataTable("dt2");




                //添加列名


                for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)


                {


                    provisional.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());


                }


        //        //添加列名


        //        for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)


        //        {


        //            provisional.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());


        //        }




                //添加数据


                for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)


                {


                    DataRow row = provisional.NewRow();


                    for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)


                    {


                        row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();


                    }


                    provisional.Rows.Add(row);


                }


        //        //添加数据


        //        for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)


        //        {


        //            DataRow row = provisional.NewRow();


        //            for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)


        //            {


        //                row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();


        //            }


        //            provisional.Rows.Add(row);


        //        }




                //判断列


                string error = JudgmentColumns(provisional);


                if (error.Length > 0)


                {


                    res.code = "0";


                    res.count = 0;


                    res.Message = $"Excel模板存在错误,{error}\r\n";


                    res.data = null;


                    return res;


                }


        //        //判断列


        //        string error = JudgmentColumns(provisional);


        //        if (error.Length > 0)


        //        {


        //            res.code = "0";


        //            res.count = 0;


        //            res.Message = $"Excel模板存在错误,{error}\r\n";


        //            res.data = null;


        //            return res;


        //        }




                for (int i = 0; i <= provisional.Rows.Count - 1; i++)


                {


                    string HNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["部门代码"].ToString());


                    string HName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["部门名称"].ToString());


                    string HEmpNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["负责人代码"].ToString());


                    string HEmpName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["负责人名称"].ToString());


                    string HBarCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["条形码"].ToString());


                    string HHelpCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["助记码"]);


                    string HRemark = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["备注"].ToString());


        //        for (int i = 0; i <= provisional.Rows.Count - 1; i++)


        //        {


        //            string HNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["部门代码"].ToString());


        //            string HName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["部门名称"].ToString());


        //            string HEmpNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["负责人代码"].ToString());


        //            string HEmpName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["负责人名称"].ToString());


        //            string HBarCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["条形码"].ToString());


        //            string HHelpCode = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["助记码"]);


        //            string HRemark = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["备注"].ToString());




                    //判断负责人是否存在


                    if (JudgeEmp(HEmpNumber, HEmpName))


                    {


                        res.code = CodeConstant.FAIL;


                        res.count = CountConstant.FAIL;


                        res.Message = "当前职员不存在";


                        res.data = null;


                        return res;


                    }


                    //获取真实行数


                    int line = i + 1;


                }


        //            //判断负责人是否存在


        //            if (JudgeEmp(HEmpNumber, HEmpName))


        //            {


        //                res.code = CodeConstant.FAIL;


        //                res.count = CountConstant.FAIL;


        //                res.Message = "当前职员不存在";


        //                res.data = null;


        //                return res;


        //            }


        //            //获取真实行数


        //            int line = i + 1;


        //        }




                res.code = "1";


                res.count = 1;


                res.Message = error;


                res.data = provisional;


                return res;


            }


            catch (Exception e)


            {


                res.code = "0";


                res.count = 0;


                res.Message = "Exception！" + e.ToString();


                res.data = null;


                return res;


            }


        }


        //        res.code = "1";


        //        res.count = 1;


        //        res.Message = error;


        //        res.data = provisional;


        //        return res;


        //    }


        //    catch (Exception e)


        //    {


        //        res.code = "0";


        //        res.count = 0;


        //        res.Message = "Exception！" + e.ToString();


        //        res.data = null;


        //        return res;


        //    }


        //}




        /// <summary>


        /// 判断当前职员是否存在


@@ -1262,15 +1232,15 @@


        /// <param name="HEmpNumber"></param>


        /// <param name="HEmpName"></param>


        /// <returns></returns>


        private bool JudgeEmp(string HEmpNumber, string HEmpName)


        {


            if (!String.IsNullOrEmpty(HEmpNumber) && !String.IsNullOrEmpty(HEmpName))


            {


                DataSet emp = oCN.RunProcReturn("select * from Gy_Employee where HNumber = '" + HEmpNumber + "' and HName = '" + HEmpName + "'", "Gy_Employee");


                return emp.Tables[0].Rows.Count <= EmptyConstant.EMPTY ? true : false;


            }


            return false;


        }


        //private bool JudgeEmp(string HEmpNumber, string HEmpName)


        //{


        //    if (!String.IsNullOrEmpty(HEmpNumber) && !String.IsNullOrEmpty(HEmpName))


        //    {


        //        DataSet emp = oCN.RunProcReturn("select * from Gy_Employee where HNumber = '" + HEmpNumber + "' and HName = '" + HEmpName + "'", "Gy_Employee");


        //        return emp.Tables[0].Rows.Count <= EmptyConstant.EMPTY ? true : false;


        //    }


        //    return false;


        //}




        /// <summary>


        /// 判断列