智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
111
王 垚
2022-12-24 3878611cba9734824ddc9cb205da396efbe2f487 
 WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs


@@ -1,4 +1,6 @@


using Newtonsoft.Json.Linq;


using Model;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using Pub_Class;


using System;


using System.Collections;


@@ -6,6 +8,7 @@


using System.Data;


using System.Data.SqlClient;


using System.Web.Http;


using WebAPI.Controllers.SCGL.日计划管理;


using WebAPI.Models;


namespace WebAPI.Controllers


{


@@ -16,8 +19,6 @@


        private json objJsonResult = new json();


        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


        DataSet ds;






        /// <summary>


        /// 返回仓库列表


        ///参数：string sql。


@@ -25,36 +26,45 @@


        /// </summary>


        [Route("Gy_Warehouse/list")]


        [HttpGet]


        public object list(string sWhere,string Organization)


        public object list(string sWhere,string user,string Organization)


        {


            try


            {


                string sql1 = string.Format(@"select * from h_v_IF_WareHouseList where 组织名称='" + Organization + "'");


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_WareHouseList");


                }


                else


                {


                    string sql = sql1 + sWhere + "order by HItemID desc";


                    ds = oCN.RunProcReturn(sql, "h_v_IF_WareHouseList");


                }


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


                List<object> columnNameList = new List<object>();


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Gy_Warehouse", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "false！";


                    objJsonResult.Message = "无查看权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string sql1 = string.Format(@"select * from h_v_IF_WareHouseList where 组织名称='" + Organization + "'");


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn(sql1 + sWhere + " order by 仓库代码 ", "h_v_IF_WareHouseList");


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                    string sql = sql1 + sWhere + " order by 仓库代码 ";


                    ds = oCN.RunProcReturn(sql, "h_v_IF_WareHouseList");


                }




                //添加列名


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


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


            {


@@ -211,7 +221,7 @@


                long HParentID = list[0].HParentID;


                long HLevel = list[0].HLevel;


                bool HEndFlag = list[0].HEndFlag;


                bool HStopflag = list[0].HStopflag;


                bool HStopflag = list[0].HStopFlag;


                string HRemark = list[0].HRemark;


                string HBarCode = list[0].HBarCode;


                long HEmpID = list[0].HEmpID;


@@ -280,9 +290,8 @@


                string msg1 = _value.ToString();


                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


                string msg2 = sArray[0].ToString();


                //string msg3 = sArray[1].ToString();


                //string msg4 = sArray[2].ToString();


                //string msg5 = sArray[3].ToString();


                string msg3 = sArray[1].ToString();


               


                //反序列化


                msg2 = "[" + msg2.ToString() + "]";


                List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2);


@@ -295,7 +304,7 @@


                long HParentID = list[0].HParentID;


                long HLevel = list[0].HLevel;


                bool HEndFlag = list[0].HEndFlag;


                bool HStopflag = list[0].HStopflag;


                bool HStopflag = list[0].HStopFlag;


                string HRemark = list[0].HRemark;


                string HBarCode = list[0].HBarCode;


                long HEmpID = list[0].HEmpID;


@@ -305,14 +314,14 @@


                string HUpDater = list[0].HUpDater;




                ////判断权限


                //if (!ClsPub.Security_Log(msg5, 1, true, msg4))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "没有找到该功能模块！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有找到该功能模块！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //if (!DBUtility.ClsPub.AllowNumber(HNumber))


                //{


@@ -338,9 +347,9 @@


                    oCN.BeginTran();


                    oCN.RunProc("Insert into Gy_Warehouse  " +


                        " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                        ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone) " +


                        ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID) " +


                        " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +


                        "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "')", ref DBUtility.ClsPub.sExeReturnInfo);


                        "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','"+ HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo);


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


                    oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                    oCN.Commit();


@@ -361,6 +370,7 @@


                        ",HEmpID=" + HEmpID.ToString() +


                        ",HAddress='" + HAddress + "'" +


                        ",HPhone='" + HPhone + "'" +


                        ",HUSEORGID='" + HUSEORGID + "'" +


                        ",HUpdater='" + HUpDater + "'" +


                        ",HUpdateDate= getdate()" +


                        ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


@@ -388,27 +398,90 @@


                return objJsonResult;


            }


        }




        [Route("Gy_Warehouse/SaveGy_WarehouseListApi")]


        [HttpPost]


        public object SaveGy_WarehouseListApi([FromBody] JObject msg)


        {


            try


            {


                var model = msg["model"].ToString();


                var stockplaceModel = msg["model"]["HStockplaceEntry"].ToString();


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                //反序列化


                model = "[" + model.ToString() + "]";


                List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(model);//仓库


                List<Gy_StockPlace> stockplaceList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_StockPlace>>(stockplaceModel);//仓位


                string sql = string.Empty;


                //DataTable dt = DataHelper.ListToDataTable<Warehouse>(list);


                //oCN.SqlBulkCopyByDatatable("Gy_Warehouse", dt);


                //保存


                oCN.BeginTran();


                sql = $"delete Gy_Warehouse where HItemID = {list[0].HItemID}";


                oCN.RunProc(sql);


                sql = "set identity_insert Gy_Warehouse on";


                oCN.RunProc(sql);


                oCN.RunProc("Insert into Gy_Warehouse  " +


                       " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                       ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID,HCREATEORGID,HSPFlag,HSPGroupID,HUnderStock,HSTOCKPROPERTY) " +


                       " Values('" + list[0].HItemID + "','" + list[0].HNumber + "','" +list[0].HName + "','" + list[0].HHelpCode + "','" + list[0].HShortNumber + "'," + list[0].HParentID.ToString() +


                       "," + list[0].HLevel.ToString() + "," + Convert.ToString(list[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(list[0].HStopFlag ? 1 : 0) + ",'" + list[0].HRemark + "'," + list[0].HEmpID.ToString() + ",'" + list[0].HAddress + "','" + list[0].HPhone + "','" + list[0].HUSEORGID + "','" + list[0].HCREATEORGID + "','" + list[0].HSPFlag + "','" + list[0].HSPGroupID + "','" + list[0].HUnderStock + "','" + list[0].HSTOCKPROPERTY + "')", ref DBUtility.ClsPub.sExeReturnInfo);


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


                sql = "set identity_insert Gy_Warehouse off";


                oCN.RunProc(sql);


                sql = $"delete gy_stockplace where HSPGroupID in ({list[0].HItemID})";


                oCN.RunProc(sql);


                sql = "set identity_insert gy_stockplace on";


                oCN.RunProc(sql);


                foreach (var item in stockplaceList)


                {


                    oCN.RunProc("Insert into gy_stockplace  " +


                       " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                       ",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HSPGroupID,HSPType,HSrcSPType,HDesSPType) " +


                       " Values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HHelpCode + "','" + item.HShortNumber + "'," + item.HParentID.ToString() +


                       "," + item.HLevel.ToString() + "," + Convert.ToString(item.HEndFlag ? 1 : 0) + "," + Convert.ToString(item.HStopFlag ? 1 : 0) + ",'" + item.HRemark + "','" + item.HUSEORGID + "','" + item.HCREATEORGID + "','" + item.HSPGroupID + "','" + item.HSPType + "','" + item.HSrcSPType + "','" + item.HDesSPType + "')", ref DBUtility.ClsPub.sExeReturnInfo);


                }


                sql = "set identity_insert gy_stockplace off";


                oCN.RunProc(sql);


                oCN.Commit();




                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


                objJsonResult.data = 1;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "保存失败！" + e.ToString();


                objJsonResult.data = 1;


                return objJsonResult;


            }


        }


        /// <summary>


        /// 仓库列表删除功能


        /// </summary>


        /// <returns></returns>


        [Route("DeltetGy_Warehouse")]


        [HttpGet]


        public object DeltetGy_Warehouse(string HItemID)


        public object DeltetGy_Warehouse(string HItemID,string user)


        {


            DataSet ds;


            DataSet ds1;


            try


            {


                //删除权限


                //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "审核失败！无权限！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                if (!DBUtility.ClsPub.Security_Log("Gy_Warehouse_Delete", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                if (string.IsNullOrWhiteSpace(HItemID))