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()
        {
@@ -444,13 +515,21 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select AA.code,AA.name,isnull(AA.parentid,-1) as parentid   from(
                        select code,name,idparent as parentid   from TMateriel_Class
                        union all
                        select partcode as code,partname as name,idinventoryclass as parentid 
                        from TMateriel_Info 
                        where status='0'
                        ) as AA";
              sql = @"WITH RecursiveCTE AS (
                     SELECT code, name, idparent
                     FROM TMateriel_Class
                     WHERE code in(select distinct idinventoryclass from TMateriel_Info where status='0')
                     UNION ALL
                     SELECT c.code, c.name, c.idparent
                     FROM TMateriel_Class c
                     INNER JOIN RecursiveCTE r ON c.code = r.idparent
                   )
                   SELECT distinct code, name, idparent as parentid
                   FROM RecursiveCTE CTE
                   union all
                   select partcode as code,partname as name,idinventoryclass as parentid 
                   from TMateriel_Info 
                   where status='0'";
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
                mes.Message = "查询成功!";
@@ -466,5 +545,53 @@
            return mes;
        }
        #endregion

        #region[模具检验项目下拉列表]
        public static ToMessage MouldCheckItemSelect()
        {
            string sql = "";
            try
            {
                //获取模具点检项目数据
                sql = @"select code,name,description from TMouldchk_Item";
                var data = DapperHelper.selecttable(sql);
                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 MouldRepairItemSelect()
        {
            string sql = "";
            try
            {
                //获取模具保养项目数据
                sql = @"select code,name,description from TMouldmai_Item";
                var data = DapperHelper.selecttable(sql);
                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
    }
}