1.修改仓位信息列表接口 2.新增仓库库位基础资料接口 3.修改模具出入库提交接口(增加库位) 、模具清单增加库位 4.新增模具上下机记录报表、模具借...

yl

2023-10-26 9445c4660740dc8a544b5c2440fe365a218bab12

 VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs

@@ -5,6 +5,7 @@
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.Models;
using VueWebCoreApi.Models.UnitMaterial;
using VueWebCoreApi.Tools;

@@ -363,6 +364,76 @@
        }
        #endregion

        #region[仓库库位基础资料]
        public static ToMessage WareHouseLocation()
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            List<WareHouseLocation> list = new List<WareHouseLocation>();
            try
            {
                //获取仓库数据
                sql = @"select code,name from TSecStck where status='0'";
                var data = DapperHelper.selecttable(sql);
                for (int i = 0; i < data.Rows.Count; i++)
                {
                    WareHouseLocation warhouse = new WareHouseLocation();
                    warhouse.value = data.Rows[i]["code"].ToString();
                    warhouse.text = data.Rows[i]["name"].ToString();
                    warhouse.children = new List<LocationData>();
                    //获取库位
                    sql = @"select code,name from TSecLoca where status='0' and idwarehouse=@idwarehouse";
                    dynamicParams.Add("@idwarehouse", data.Rows[i]["code"].ToString());
                    var data0 = DapperHelper.selectdata(sql, dynamicParams);
                    for (int j = 0; j < data0.Rows.Count; j++)
                    {
                        LocationData  locat = new LocationData();
                        locat.value = data0.Rows[j]["code"].ToString();
                        locat.text = data0.Rows[j]["name"].ToString();
                        warhouse.children.Add(locat);
                    }
                    list.Add(warhouse);
                }
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = list;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓库查找仓位信息]
        public static ToMessage WareHouseSelectLocation(string warhousecode)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select code,name from TSecLoca where status='0' and idwarehouse=@idwarehouse";
                dynamicParams.Add("@idwarehouse", warhousecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[工序基础资料]
        public static ToMessage StepData()
        {