设备清单查询、新增、编辑、删除接口开发 设备类型(新增、删除)、设备组(新增、删除)接口开发 仓库定义(新增、编辑、删除)、库位定义(新增、编辑、删除...

yl

2022-06-22 7a0d98456b4ecaf1867cd62ecb7c8169ec15d042

设备清单查询、新增、编辑、删除接口开发
设备类型(新增、删除)、设备组(新增、删除)接口开发
仓库定义(新增、编辑、删除)、库位定义(新增、编辑、删除)
存货类型、存货档案接口开发

 .vs/VueWebApi/v16/.suo

Binary files differ

 VueWebApi/Controllers/BasicSettingController.cs

@@ -281,9 +281,9 @@



        #region[角色类型查询]
        #region[角色类型列表查询]
        /// <summary>
        /// è§’色类型查询
        /// è§’色类型列表查询
        /// </summary>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
@@ -327,6 +327,28 @@
        public HttpResponseMessage RoleTypeDelete(string RoleTypeCode)
        {
            mes = BasicSettingBLL.RoleTypeDelete(RoleTypeCode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[角色类型下拉接口]
        /// <summary>
        /// è§’色类型下拉接口
        /// </summary>
        /// <returns></returns>
        [Route(template: "RoleTypeSelect")]
        [HttpGet]
        public HttpResponseMessage RoleTypeSelect()
        {
            try
            {
                mes = BasicSettingBLL.RoleTypeSelect();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion
@@ -461,7 +483,7 @@
        /// <returns></returns>
        [Route(template: "RoleAssociationRight")]
        [HttpGet]
        public HttpResponseMessage RoleAssociationRight(string rolecode,string type)
        public HttpResponseMessage RoleAssociationRight(string rolecode,string type=null)
        {
            mes = BasicSettingBLL.RoleAssociationRight(rolecode,type);
            return TJson.toJson(mes);
@@ -524,13 +546,15 @@
            string unitid = obj["id"].ToString();    //往来单位id(主键)
            string unitcode = obj["unitcode"].ToString(); //往来单位编码编码
            string unitname = obj["unitname"].ToString(); //往来单位名称
            string unitattr = obj["unitattr"].ToString(); //往来单属性
            string mtypecode = obj["mtypecode"].ToString(); //外购供方编码
            string btypecode = obj["btypecode"].ToString(); //外协供方编码
            string htypecode = obj["htypecode"].ToString(); //客户编码
            string person = obj["person"].ToString(); //联系人
            string contact = obj["contact"].ToString(); //联系方式
            string description = obj["description"].ToString(); //补充描述
            var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
            var usercode = "Admin";//HttpContext.Current.Request.Cookies["admin"].Value.ToString();
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = BasicSettingBLL.AddUpdateCurrentUnit(unitid, unitcode, unitname, unitattr, person, contact, description, usercode, OperType);
            mes = BasicSettingBLL.AddUpdateCurrentUnit(unitid, unitcode, unitname, mtypecode, btypecode,htypecode, person, contact, description, usercode, OperType);
            return TJson.toJson(mes);
        }
        #endregion

 VueWebApi/Controllers/DeviceManagerController.cs

@@ -7,6 +7,7 @@
using System.Web;
using System.Web.Http;
using VueWebApi.DLL.BLL;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.Controllers
@@ -43,18 +44,14 @@
        /// <summary>
        /// è®¾å¤‡ç±»åž‹æ–°å¢ž
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <param name="json">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateDeviceType")]
        [HttpPost]
        public HttpResponseMessage AddUpdateDeviceType([FromBody] JObject obj)
        public HttpResponseMessage AddUpdateDeviceType(List<ObjectDataCont> json)
        {
            //string deviceid = obj["id"].ToString();    //设备类型id(主键)
            string devicetypecode = obj["devicetypecode"].ToString(); //设备类型编码
            string devicetypename = obj["devicetypename"].ToString(); //设备类型名称
            string devicetypedescipt = obj["devicetypedescipt"].ToString(); //设备类型描述
            var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
            mes = DeviceManagerBLL.AddUpdateDeviceType(devicetypecode, devicetypename, devicetypedescipt, usercode);
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
            mes = DeviceManagerBLL.AddUpdateDeviceType(json, username);
            return TJson.toJson(mes);
        }
        #endregion
@@ -63,18 +60,129 @@
        /// <summary>
        /// è®¾å¤‡ç±»åž‹åˆ é™¤
        /// </summary>
        /// <param name="devicetypeid">设备类型ID</param>
        /// <param name="devicetypecode">设备类型编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceType")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceType(string devicetypeid)
        public HttpResponseMessage DeleteDeviceType(string devicetypecode)
        {
            mes = DeviceManagerBLL.DeleteDeviceType(devicetypeid);
            mes = DeviceManagerBLL.DeleteDeviceType(devicetypecode);
            return TJson.toJson(mes);
        }
        #endregion


        #region[设备类型下拉框接口]
        /// <summary>
        /// è®¾å¤‡ç±»åž‹ä¸‹æ‹‰æ¡†æŽ¥å£
        /// </summary>
        /// <returns></returns>
        [Route(template: "DeviceTypeSelect")]
        [HttpGet]
        public HttpResponseMessage DeviceTypeSelect()
        {
            try
            {
                mes = DeviceManagerBLL.DeviceTypeSelect();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备组查询]
        /// <summary>
        /// è®¾å¤‡ç»„查询
        /// </summary>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "DeviceGroupSearch")]
        [HttpGet]
        public HttpResponseMessage DeviceGroupSearch(int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = DeviceManagerBLL.DeviceGroupSearch(startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备组新增]
        /// <summary>
        /// è®¾å¤‡ç»„新增
        /// </summary>
        /// <param name="json">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateDeviceGroup")]
        [HttpPost]
        public HttpResponseMessage AddUpdateDeviceGroup(List<ObjectDataCont> json)
        {
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
            mes = DeviceManagerBLL.AddUpdateDeviceGroup(json, username);
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备组删除]
        /// <summary>
        /// è®¾å¤‡ç»„删除
        /// </summary>
        /// <param name="devicegroupcode">设备组编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceGroup")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceGroup(string devicegroupcode)
        {
            mes = DeviceManagerBLL.DeleteDeviceGroup(devicegroupcode);
            return TJson.toJson(mes);
        }
        #endregion


        #region[设备类型查找设备组]
        /// <summary>
        /// è®¾å¤‡ç±»åž‹æŸ¥æ‰¾è®¾å¤‡ç»„
        /// </summary>
        /// <param name="eqptypecode">设备类型编码</param>
        /// <returns></returns>
        [Route(template: "DeviceTypeSelectGroup")]
        [HttpGet]
        public HttpResponseMessage DeviceTypeSelectGroup(string eqptypecode)
        {
            try
            {
                mes = DeviceManagerBLL.DeviceTypeSelectGroup(eqptypecode);
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion

        #region[所属车间下拉接口]
        /// <summary>
        /// æ‰€å±žè½¦é—´ä¸‹æ‹‰æŽ¥å£
        /// </summary>
        /// <returns></returns>

        [Route(template: "WorkShopSelect")]
        [HttpGet]
        public HttpResponseMessage WorkShopSelect()
        {
            mes = DeviceManagerBLL.WorkShopSelect();
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备清单查询]
        /// <summary>
@@ -115,15 +223,16 @@
            string deviceid = obj["id"].ToString();    //设备清单id(主键)
            string devicecode = obj["devicecode"].ToString(); //设备编码
            string devicename = obj["devicename"].ToString(); //设备名称
            string devicetype = obj["devicetype"].ToString(); //设备类型
            string devicegroup = obj["devicegroup"].ToString(); //设备组
            string devicetype = obj["devicetypecode"].ToString(); //设备类型编码
            string devicegroup = obj["devicegroupcode"].ToString(); //设备组编码
            string importdate = obj["importdate"].ToString(); //投入日期
            string workshop = obj["workshop"].ToString(); //所属车间
            string workshop = obj["workshopcode"].ToString(); //所属车间编码
            string linecode = obj["linecode"].ToString(); //所属产线编码
            string status = obj["status"].ToString(); //使用状态
            string ratio = obj["ratio"].ToString(); //稼动率
            var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
            var usercode = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = DeviceManagerBLL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, status, ratio, usercode, OperType);
            mes = DeviceManagerBLL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, linecode, status, ratio, usercode, OperType);
            return TJson.toJson(mes);
        }
        #endregion
@@ -132,15 +241,16 @@
        /// <summary>
        /// è®¾å¤‡æ¸…单删除
        /// </summary>
        /// <param name="deviceid">设备ID</param>
        /// <param name="devicecode">设备编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceManger")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceManger(string deviceid)
        public HttpResponseMessage DeleteDeviceManger(string devicecode)
        {
            mes = DeviceManagerBLL.DeleteDeviceManger(deviceid);
            mes = DeviceManagerBLL.DeleteDeviceManger(devicecode);
            return TJson.toJson(mes);
        }
        #endregion

    }
}

 VueWebApi/Controllers/LoginController.cs

@@ -160,7 +160,7 @@
        /// <param name="username">用户名</param>
        /// <param name="usertype">操作端PC/APP</param>
        /// <returns></returns>
        [ChannelActionFilter, Route(template: "LoginOut")]
        [Route(template: "LoginOut")]
        [HttpPost]
        public HttpResponseMessage LoginOut(int userid, string usercode, string username,string usertype)
        {

 VueWebApi/Controllers/MaterialManagerController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,168 @@
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using VueWebApi.DLL.BLL;
using VueWebApi.Tools;

namespace VueWebApi.Controllers
{
    [RoutePrefix(prefix: "api/BasicSetting")]
    [ControllerGroup("物料管理", "在线接口")]
    public class MaterialManagerController : ApiController
    {
        //定义全局信息返回变量
        ToMessage mes = new ToMessage();
        RedisHelper redis = new RedisHelper();

        #region[仓库定义查询]
        /// <summary>
        /// ä»“库定义查询
        /// </summary>
        /// <param name="warehousecode">仓库编码</param>
        /// <param name="warehousename">仓库名称</param>
        /// <param name="description">仓库描述</param>
        /// <param name="createuser">创建人员</param>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "WareHouseDefSearch")]
        [HttpGet]
        public HttpResponseMessage WareHouseDefSearch(string warehousecode = null, string warehousename = null, string description = null, string createuser = null, int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = MaterialManagerBLL.WareHouseDefSearch(warehousecode, warehousename, description, createuser, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[仓库定义新增编辑]
        /// <summary>
        /// ä»“库定义新增编辑
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateWareHouseDef")]
        [HttpPost]
        public HttpResponseMessage AddUpdateWareHouseDef([FromBody] JObject obj)
        {
            string warehouseid = obj["id"].ToString();    //仓库id(主键)
            string warehousecode = obj["warehousecode"].ToString(); //仓库编码
            string warehousename = obj["warehousename"].ToString(); //仓库名称
            string description = obj["description"].ToString(); //仓库描述
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = MaterialManagerBLL.AddUpdateWareHouseDef(warehouseid, warehousecode, warehousename, description, username,OperType);
            return TJson.toJson(mes);
        }
        #endregion

        #region[仓库删除]
        /// <summary>
        /// ä»“库删除
        /// </summary>
        /// <param name="warehousecode">仓库编码</param>
        /// <returns></returns>
        [Route(template: "DeleteWareHouseDef")]
        [HttpPost]
        public HttpResponseMessage DeleteWareHouseDef(string warehousecode)
        {
            mes = MaterialManagerBLL.DeleteWareHouseDef(warehousecode);
            return TJson.toJson(mes);
        }
        #endregion



        #region[所属仓库接口]
        /// <summary>
        /// æ‰€å±žä»“库接口
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseSelect")]
        [HttpGet]
        public HttpResponseMessage WareHouseSelect()
        {
            try
            {
                mes = MaterialManagerBLL.WareHouseSelect();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion

        #region[库位定义查询]
        /// <summary>
        /// åº“位定义查询
        /// </summary>
        /// <param name="storagecode">库位编码</param>
        /// <param name="storagename">库位名称</param>
        /// <param name="description">仓库描述</param>
        /// <param name="createuser">创建人员</param>
        /// <param name="stockcode">所属仓库编码</param>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "StorageDefSearch")]
        [HttpGet]
        public HttpResponseMessage StorageDefSearch(string storagecode = null, string storagename = null, string description = null, string createuser = null,string stockcode=null,int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = MaterialManagerBLL.StorageDefSearch(storagecode, storagename, description, createuser, stockcode, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[库位定义新增编辑]
        /// <summary>
        /// åº“位定义新增编辑
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateStorageDef")]
        [HttpPost]
        public HttpResponseMessage AddUpdateStorageDef([FromBody] JObject obj)
        {
            string storageid = obj["id"].ToString();    //库位id(主键)
            string storagecode = obj["storagecode"].ToString(); //库位编码
            string storagename = obj["storagename"].ToString(); //库位名称
            string description = obj["description"].ToString(); //仓位描述
            string stockcode = obj["stockcode"].ToString(); //所属仓库编码
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = MaterialManagerBLL.AddUpdateStorageDef(storageid, storagecode, storagename, description, stockcode, username, OperType);
            return TJson.toJson(mes);
        }
        #endregion

        #region[库位删除]
        /// <summary>
        /// åº“位删除
        /// </summary>
        /// <param name="storagecode">库位编码</param>
        /// <returns></returns>
        [Route(template: "DeleteStorageDef")]
        [HttpPost]
        public HttpResponseMessage DeleteStorageDef(string storagecode)
        {
            mes = MaterialManagerBLL.DeleteStorageDef(storagecode);
            return TJson.toJson(mes);
        }
        #endregion
    }
}

 VueWebApi/Controllers/ProductModelController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,271 @@
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using VueWebApi.DLL.BLL;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.Controllers
{

    [RoutePrefix(prefix: "api/BasicSetting")]
    [ControllerGroup("制造模型", "在线接口")]
    public class ProductModelController : ApiController
    {
        //定义全局信息返回变量
        ToMessage mes = new ToMessage();
        RedisHelper redis = new RedisHelper();

        #region[存货类型接口]
        /// <summary>
        /// å­˜è´§ç±»åž‹æŽ¥å£
        /// </summary>
        /// <returns></returns>
        [Route(template: "StockTypeSelect")]
        [HttpGet]
        public HttpResponseMessage StockTypeSelect()
        {
            try
            {
                mes = ProductModelBLL.StockTypeSelect();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion

        #region[物料类型查询]
        /// <summary>
        /// ç‰©æ–™ç±»åž‹æŸ¥è¯¢
        /// </summary>
        /// <param name="materialtypecode">物料类型编码</param>
        /// <param name="materialtypename">物料类型名称</param>
        /// <param name="stocktypecode">存货类型编码</param>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "MaterialTypeSearch")]
        [HttpGet]
        public HttpResponseMessage MaterialTypeSearch(string materialtypecode = null, string materialtypename = null, string stocktypecode = null, int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = ProductModelBLL.MaterialTypeSearch(materialtypecode, materialtypename, stocktypecode, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[物料类型新增编辑]
        /// <summary>
        /// ç‰©æ–™ç±»åž‹æ–°å¢žç¼–辑
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateMaterialType")]
        [HttpPost]
        public HttpResponseMessage AddUpdateMaterialType([FromBody] JObject obj)
        {
            string materialtypeid = obj["id"].ToString();    //物料类型id(主键)
            string materialtypecode = obj["materialtypecode"].ToString(); //物料类型编码
            string materialtypename = obj["materialtypename"].ToString(); //物料类型名称
            string stocktypecode = obj["stocktypecode"].ToString(); //存货类型编码
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = ProductModelBLL.AddUpdateMaterialType(materialtypeid,materialtypecode, materialtypename, stocktypecode, username, OperType);
            return TJson.toJson(mes);
        }
        #endregion

        #region[物料类型删除]
        /// <summary>
        /// ç‰©æ–™ç±»åž‹åˆ é™¤
        /// </summary>
        /// <param name="materialtypecode">物料类型编码</param>
        /// <returns></returns>
        [Route(template: "DeleteMaterialType")]
        [HttpPost]
        public HttpResponseMessage DeleteMaterialType(string materialtypecode)
        {
            mes = ProductModelBLL.DeleteMaterialType(materialtypecode);
            return TJson.toJson(mes);
        }
        #endregion





        #region[单位列表查询]
        /// <summary>
        /// å•ä½åˆ—表查询
        /// </summary>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "UomSearch")]
        [HttpGet]
        public HttpResponseMessage UomSearch(int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = ProductModelBLL.UomSearch(startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[单位新增]
        /// <summary>
        /// å•ä½æ–°å¢ž
        /// </summary>
        /// <param name="json">单位提交数据</param>
        /// <returns></returns>
        [Route(template: "UomAdd")]
        [HttpPost]
        public HttpResponseMessage UomAdd(List<Uom> json)
        {
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            mes = ProductModelBLL.UomAdd(username,json);
            return TJson.toJson(mes);
        }
        #endregion

        #region[单位删除]
        /// <summary>
        /// å•ä½åˆ é™¤
        /// </summary>
        /// <param name="uomcode">单位编码</param>
        /// <returns></returns>
        [Route(template: "UomDelete")]
        [HttpPost]
        public HttpResponseMessage UomDelete(string uomcode)
        {
            mes = ProductModelBLL.UomDelete(uomcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[存类型查找物料类型]
        /// <summary>
        /// å­˜ç±»åž‹æŸ¥æ‰¾ç‰©æ–™ç±»åž‹
        /// </summary>
        /// <param name="stocktypecode">存货类型编码</param>
        /// <returns></returns>
        [Route(template: "StockTypeSelectMaterialType")]
        [HttpGet]
        public HttpResponseMessage StockTypeSelectMaterialType(string stocktypecode)
        {
            try
            {
                mes = ProductModelBLL.StockTypeSelectMaterialType(stocktypecode);
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return TJson.toJson(mes);
        }
        #endregion

        #region[存货档案查询]
        /// <summary>
        /// å­˜è´§æ¡£æ¡ˆæŸ¥è¯¢
        /// </summary>
        /// <param name="partcode"></param>
        /// <param name="partname"></param>
        /// <param name="partspec"></param>
        /// <param name="stocktypecode"></param>
        /// <param name="materialtypecode"></param>
        /// <param name="storehousecode"></param>
        /// <param name="page"></param>
        /// <param name="rows"></param>
        /// <param name="prop"></param>
        /// <param name="order"></param>
        /// <returns></returns>
        [Route(template: "InventoryFileSelect")]
        [HttpGet]
        public HttpResponseMessage InventoryFileSelect(string partcode = null, string partname = null,string partspec=null,string stocktypecode = null,string materialtypecode=null,string storehousecode=null, int page = 0, int rows = 0, string prop = null, string order = null)
        {
            int startNum = rows * (page - 1) + 1;  //起始记录rowNum
            int endNum = rows * page;   //结束记录 rowNum
            mes = ProductModelBLL.InventoryFileSelect(partcode, partname, partspec, stocktypecode, materialtypecode, storehousecode, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[存货档案新增编辑]
        /// <summary>
        /// å­˜è´§æ¡£æ¡ˆæ–°å¢žç¼–辑
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateInventoryFile")]
        [HttpPost]
        public HttpResponseMessage AddUpdateInventoryFile([FromBody] JObject obj)
        {
            string materialid = obj["id"].ToString();    //物料id(主键)
            string materialcode = obj["materialcode"].ToString(); //物料编码
            string materialname = obj["materialname"].ToString(); //物料名称
            string materialspec = obj["materialspec"].ToString(); //物料规格
            string uomcode = obj["uomcode"].ToString();           //单位编码
            string warehousecode = obj["warehousecode"].ToString(); //所属仓库编码
            string stocktypecode = obj["stocktypecode"].ToString(); //存货类型编码
            string materialtypecode = obj["materialtypecode"].ToString(); //物料类型编码
            string minstockqty = obj["minstockqty"].ToString(); //最小库存
            string maxstockqty = obj["maxstockqty"].ToString(); //最大库存
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = ProductModelBLL.AddUpdateInventoryFile(materialid, materialcode, materialname, materialspec, uomcode, warehousecode, stocktypecode, materialtypecode, minstockqty, maxstockqty,username, OperType);
            return TJson.toJson(mes);
        }
        #endregion

        #region[存货档案删除]
        /// <summary>
        /// å­˜è´§æ¡£æ¡ˆåˆ é™¤
        /// </summary>
        /// <param name="materialcode">物料编码</param>
        /// <returns></returns>
        [Route(template: "DeleteInventoryFile")]
        [HttpPost]
        public HttpResponseMessage DeleteInventoryFile(string materialcode)
        {
            mes = ProductModelBLL.DeleteInventoryFile(materialcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[存货档案关联工艺路线查询]
        /// <summary>
        /// å­˜è´§æ¡£æ¡ˆå…³è”工艺路线查询
        /// </summary>
        /// <param name="partcode">物料编码</param>
        /// <returns></returns>
        [Route(template: "InventoryFileAssociationRoute")]
        [HttpGet]
        public HttpResponseMessage InventoryFileAssociationRoute(string partcode)
        {
            mes = ProductModelBLL.InventoryFileAssociationRoute(partcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[存货档案关联工艺路线提交]

        #endregion

    }
}

 VueWebApi/DLL/BLL/BasicSettingBLL.cs

@@ -113,6 +113,13 @@
        }
        #endregion

        #region[角色类型下拉接口]
        public static ToMessage RoleTypeSelect()
        {
            return BasicSettingDAL.RoleTypeSelect();
        }
        #endregion

        #region[角色清单查询]
        public static ToMessage RoleSearch(string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
        {
@@ -179,9 +186,9 @@
        #endregion

        #region[往来单位新增编辑]
        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string unitattr, string person, string contact, string description, string usercode,string OperType)
        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string mtypecode,string btypecode,string htypecode, string person, string contact, string description, string usercode,string OperType)
        {
            return BasicSettingDAL.AddUpdateCurrentUnit(unitid, unitcode, unitname, unitattr, person, contact, description, usercode, OperType);
            return BasicSettingDAL.AddUpdateCurrentUnit(unitid, unitcode, unitname, mtypecode, btypecode, htypecode, person, contact, description, usercode, OperType);
        }
        #endregion


 VueWebApi/DLL/BLL/DeviceManagerBLL.cs

@@ -3,6 +3,7 @@
using System.Linq;
using System.Web;
using VueWebApi.DLL.DAL;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.BLL
@@ -17,20 +18,62 @@
        #endregion

        #region[设备类型新增]
        public static ToMessage AddUpdateDeviceType(string devicetypecode, string devicetypename, string devicetypedescipt, string usercode)
        public static ToMessage AddUpdateDeviceType(List<ObjectDataCont> json,string username)
        {
            return DeviceManagerDAL.AddUpdateDeviceType(devicetypecode, devicetypename, devicetypedescipt, usercode);
            return DeviceManagerDAL.AddUpdateDeviceType(json, username);
        }
        #endregion

        #region[设备类型删除]
        public static ToMessage DeleteDeviceType(string devicetypeid)
        public static ToMessage DeleteDeviceType(string devicetypecode)
        {
            return DeviceManagerDAL.DeleteDeviceType(devicetypeid);
            return DeviceManagerDAL.DeleteDeviceType(devicetypecode);
        }
        #endregion


        #region[设备类型下拉框接口]
        public static ToMessage DeviceTypeSelect()
        {
            return DeviceManagerDAL.DeviceTypeSelect();
        }
        #endregion

        #region[设备组查询]
        public static ToMessage DeviceGroupSearch(int startNum, int endNum, string prop, string order)
        {
            return DeviceManagerDAL.DeviceGroupSearch(startNum, endNum, prop, order);
        }
        #endregion

        #region[设备组新增]
        public static ToMessage AddUpdateDeviceGroup(List<ObjectDataCont> json, string username)
        {
            return DeviceManagerDAL.AddUpdateDeviceGroup(json, username);
        }
        #endregion

        #region[设备组删除]
        public static ToMessage DeleteDeviceGroup(string devicegroupcode)
        {
            return DeviceManagerDAL.DeleteDeviceGroup(devicegroupcode);
        }
        #endregion


        #region[设备类型查找设备组]
        public static ToMessage DeviceTypeSelectGroup(string eqptypecode)
        {
            return DeviceManagerDAL.DeviceTypeSelectGroup(eqptypecode);
        }
        #endregion

        #region[所属车间下拉接口]
        public static ToMessage WorkShopSelect()
        {
            return DeviceManagerDAL.WorkShopSelect();
        }
        #endregion

        #region [设备清单查询]
        public static ToMessage DeviceMangerSearch(string deviceCode, string deviceName, string status, string workShop, string deviceType, string deviceGroup, int startNum, int endNum, string prop, string order)
@@ -40,16 +83,16 @@
        #endregion

        #region[设备清单新增编辑]
        public static ToMessage AddUpdateDeviceManger(string deviceid, string devicecode, string devicename, string devicetype, string devicegroup, string importdate, string workshop, string status, string ratio, string usercode, string operType)
        public static ToMessage AddUpdateDeviceManger(string deviceid, string devicecode, string devicename, string devicetype, string devicegroup, string importdate, string workshop,string linecode, string status, string ratio, string usercode, string operType)
        {
            return DeviceManagerDAL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, status, ratio, usercode, operType);
            return DeviceManagerDAL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, linecode, status, ratio, usercode, operType);
        }
        #endregion

        #region[设备清单删除]
        public static ToMessage DeleteDeviceManger(string deviceid)
        public static ToMessage DeleteDeviceManger(string devicecode)
        {
            return DeviceManagerDAL.DeleteDeviceManger(deviceid);
            return DeviceManagerDAL.DeleteDeviceManger(devicecode);
        }
        #endregion
    }

 VueWebApi/DLL/BLL/MaterialManagerBLL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using VueWebApi.DLL.DAL;
using VueWebApi.Tools;

namespace VueWebApi.DLL.BLL
{
    public class MaterialManagerBLL
    {
        #region[仓库查询]
        public static ToMessage WareHouseDefSearch(string warehousecode, string warehousename, string description, string createuser, int startNum, int endNum, string prop, string order)
        {
          return  MaterialManagerDAL.WareHouseDefSearch(warehousecode, warehousename, description, createuser, startNum, endNum, prop, order);
        }
        #endregion

        #region[仓库新增编辑]
        public static ToMessage AddUpdateWareHouseDef(string warehouseid, string warehousecode, string warehousename, string description, string username, string operType)
        {
            return MaterialManagerDAL.AddUpdateWareHouseDef(warehouseid, warehousecode, warehousename, description, username, operType);
        }
        #endregion

        #region[仓库删除]
        public static ToMessage DeleteWareHouseDef(string warehousecode)
        {
            return MaterialManagerDAL.DeleteWareHouseDef(warehousecode);
        }
        #endregion



        #region[所属仓库接口]
        public static ToMessage WareHouseSelect()
        {
            return MaterialManagerDAL.WareHouseSelect();
        }
        #endregion

        #region[仓库定义查询]
        public static ToMessage StorageDefSearch(string storagecode, string storagename, string description, string createuser, string stockcode, int startNum, int endNum, string prop, string order)
        {
            return MaterialManagerDAL.StorageDefSearch(storagecode, storagename, description, createuser, stockcode, startNum, endNum, prop, order);
        }
        #endregion

        #region[仓库定义新增、修改]
        public static ToMessage AddUpdateStorageDef(string storageid, string storagecode, string storagename, string description, string stockcode, string username, string operType)
        {
            return MaterialManagerDAL.AddUpdateStorageDef(storageid, storagecode, storagename, description, stockcode, username, operType);
        }
        #endregion

        #region[仓库删除]
        public static ToMessage DeleteStorageDef(string storagecode)
        {
            return MaterialManagerDAL.DeleteStorageDef(storagecode);
        }
        #endregion
    }
}

 VueWebApi/DLL/BLL/ProductModelBLL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,100 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using VueWebApi.DLL.DAL;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.BLL
{
    public class ProductModelBLL
    {
        #region [存货类型]
        public static ToMessage StockTypeSelect()
        {
            return ProductModelDAL.StockTypeSelect();
        }
        #endregion

        #region[物料类型查询]
        public static ToMessage MaterialTypeSearch(string materialtypecode, string materialtypename, string stocktypecode, int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.MaterialTypeSearch(materialtypecode, materialtypename, stocktypecode, startNum, endNum, prop, order);
        }
        #endregion

        #region[物料类型新增编辑]
        public static ToMessage AddUpdateMaterialType(string materialtypeid, string materialtypecode, string materialtypename, string stocktypecode, string username, string operType)
        {
            return ProductModelDAL.AddUpdateMaterialType(materialtypeid,materialtypecode, materialtypename, stocktypecode, username, operType);
        }
        #endregion

        #region[物料类型删除]
        public static ToMessage DeleteMaterialType(string materialtypecode)
        {
            return ProductModelDAL.DeleteMaterialType(materialtypecode);
        }
        #endregion




        #region[单位列表查询]
        public static ToMessage UomSearch(int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.UomSearch(startNum,endNum,prop,order);
        }
        #endregion

        #region[单位新增]
        public static ToMessage UomAdd(string username, List<Uom> json)
        {
            return ProductModelDAL.UomAdd(username,json);
        }
        #endregion

        #region[单位删除]
        public static ToMessage UomDelete(string uomcode)
        {
            return ProductModelDAL.UomDelete(uomcode);
        }
        #endregion

        #region[存类型查找物料类型]
        public static ToMessage StockTypeSelectMaterialType(string stocktypecode)
        {
            return ProductModelDAL.StockTypeSelectMaterialType(stocktypecode);
        }
        #endregion

        #region[存货档案查询]
        public static ToMessage InventoryFileSelect(string partcode, string partname, string partspec, string stocktypecode, string materialtypecode, string storehousecode, int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.InventoryFileSelect(partcode, partname, partspec, stocktypecode, materialtypecode, storehousecode, startNum, endNum, prop, order);
        }
        #endregion

        #region[存货档案新增编辑]
        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty, string username, string operType)
        {
            return ProductModelDAL.AddUpdateInventoryFile(materialid, materialcode, materialname, materialspec, uomcode, warehousecode, stocktypecode, materialtypecode, minstockqty, maxstockqty, username, operType);
        }
        #endregion

        #region[存货档案删除]
        public static ToMessage DeleteInventoryFile(string materialcode)
        {
            return ProductModelDAL.DeleteInventoryFile(materialcode);
        }
        #endregion

        #region[存货档案关联工艺路线查询]
        public static ToMessage InventoryFileAssociationRoute(string partcode)
        {
            return ProductModelDAL.InventoryFileAssociationRoute(partcode);
        }
        #endregion
    }
}

 VueWebApi/DLL/DAL/BasicSettingDAL.cs

@@ -807,6 +807,30 @@
        }
        #endregion

        #region[角色类型下拉接口]
        public static ToMessage RoleTypeSelect()
        {
            string sql = "";
            try
            {
                //获取设备类型数据
                sql = @"select roletype_code,roletype_name from TRoleType where is_delete<>'1' ";
                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 RoleSearch(string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
        {
@@ -1041,39 +1065,6 @@
        #region[用户清单关联角色查询1]
        public static ToMessage RoleAssociationUserTwo(string rolecode)
        {
            var dynamicParams = new DynamicParameters();
            string sql = "";
            try
            {
                List<TreeDG> list = new List<TreeDG>();
                sql = @"select id,parent_id,org_code,org_name,description  
                      FROM TOrganization ";
                var dt = DapperHelper.selectdata(sql, dynamicParams);
                for (int i = 0; i < dt.Rows.Count; i++)   //这里是循环所有
                {
                    if (string.IsNullOrEmpty(dt.Rows[i]["PARENT_ID"].ToString()) || dt.Rows[i]["PARENT_ID"].ToString() == "0")  //判断是否最外层根节点
                    {
                        TreeDG tbj = new TreeDG();
                        tbj.id = dt.Rows[i]["ID"].ToString();
                        tbj.code = dt.Rows[i]["ORG_CODE"].ToString();
                        tbj.name = dt.Rows[i]["ORG_NAME"].ToString();
                        list.Add(tbj);
                    }
                }
                digui(dt, list);
                mes.code = "200";
                mes.Message = "加载完成";
                mes.data = list;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.data = e.Message;
                mes.data = null;
            }
            return mes;

            string sql = "";
            var dynamicParams = new DynamicParameters();
            List<TreeObejct> list = new List<TreeObejct>();
@@ -1160,8 +1151,6 @@
        #region[角色清单关联功能查询]
        public static ToMessage RoleAssociationRight(string rolecode,string type)
        {

            Dictionary<object, object> dList = new Dictionary<object, object>();
            List<object> list=new List<object>();
            try
            {
@@ -1178,6 +1167,7 @@
                    list.Add(SeachEncode.RightLocation(rolecode, type));
                }
                mes.code = "200";
                mes.count = list.Count;
                mes.Message = "查询成功!";
                mes.data = list;
            }
@@ -1282,8 +1272,21 @@
                }
                if (unitAttr != "" && unitAttr != null)
                {
                    search += "and unitattribute=@unitAttr ";
                    switch (unitAttr)
                    {
                        case "WG":  //外购
                            search += "and mtype=@unitAttr ";
                    dynamicParams.Add("@unitAttr", unitAttr);
                            break;
                        case "WX":  //外协
                            search += "and btype=@unitAttr ";
                            dynamicParams.Add("@unitAttr", unitAttr);
                            break;
                        default:    //客户
                            search += "and htype=@unitAttr ";
                            dynamicParams.Add("@unitAttr", unitAttr);
                            break;
                    }
                }
                if (createUser != "" && createUser != null)
                {
@@ -1296,7 +1299,7 @@
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select id,code,name,unitattribute,conttacts,addr,lm_user,lm_date from TCustomer
                var sql = @"select id,code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date from TCustomer
                            where  is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
@@ -1316,18 +1319,20 @@
        #endregion

        #region[往来单位新增编辑]
        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string unitattr, string person, string contact, string description, string usercode,string OperType)
        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string mtypecode, string btypecode, string htypecode, string person, string contact, string description, string usercode,string OperType)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                if (OperType == "Add")
                {
                    var sql = @"insert into TCustomer(code,name,unitattribute,conttacts,conttphone,addr,lm_user,lm_date) 
                            values(@unitcode,@unitname,@unitattr,@person,@contact,@description,@usercode,@CreateDate)";
                    var sql = @"insert into TCustomer(code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date) 
                            values(@unitcode,@unitname,@mtypecode,@btypecode,@htypecode,@person,@contact,@description,@usercode,@CreateDate)";
                    dynamicParams.Add("@unitcode", unitcode);
                    dynamicParams.Add("@unitname", unitname);
                    dynamicParams.Add("@unitattr", unitattr);
                    dynamicParams.Add("@mtypecode", mtypecode);
                    dynamicParams.Add("@btypecode", btypecode);
                    dynamicParams.Add("@htypecode", htypecode);
                    dynamicParams.Add("@person", person);
                    dynamicParams.Add("@contact", contact);
                    dynamicParams.Add("@description", description);
@@ -1351,10 +1356,12 @@
                }
                if (OperType == "Update")
                {
                    var sql = @"update TCustomer set name=@unitname,unitattribute=@unitattr,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@RoleId";
                    var sql = @"update TCustomer set name=@unitname,mtype=@mtypecode,btype=@btypecode,htype=@htypecode,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@unitid";
                    dynamicParams.Add("@unitid", unitid);
                    dynamicParams.Add("@unitname", unitname);
                    dynamicParams.Add("@unitattr", unitattr);
                    dynamicParams.Add("@mtypecode", mtypecode);
                    dynamicParams.Add("@btypecode", btypecode);
                    dynamicParams.Add("@htypecode", htypecode);
                    dynamicParams.Add("@person", person);
                    dynamicParams.Add("@contact", contact);
                    dynamicParams.Add("@description", description);

 VueWebApi/DLL/DAL/DeviceManagerDAL.cs

@@ -1,54 +1,619 @@
using System;
using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.DAL
{
    public class DeviceManagerDAL
    {
        public static DataTable dt;    //定义全局变量dt
        public static bool res;       //定义全局变量dt
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
        public static string strProcName = ""; //定义全局sql变量
        public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
        public static SqlParameter[] parameters; //定义全局SqlParameter参数数组

        #region[设备类型查询]
        public static ToMessage DeviceTypeSearch(int startNum, int endNum, string prop, string order)
        {
            throw new NotImplementedException();
            var dynamicParams = new DynamicParameters();
            try
            {
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select id, code,name,remark 
                            from TEqpType 
                            where  is_delete<>'1' ";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备类型新增]
        public static ToMessage AddUpdateDeviceType(string devicetypecode, string devicetypename, string devicetypedescipt, string usercode)
        public static ToMessage AddUpdateDeviceType(List<ObjectDataCont> json, string username)
        {
            throw new NotImplementedException();
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //循环写入设备类型表
                for (int i = 0; i < json.Count; i++)
                {
                    sql = @"insert into TRoleType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            code = json[i].code,
                            name = json[i].name,
                            username = username,
                            createdate = DateTime.Now.ToString(),
                            description = json[i].description
                        }
                    });
                }
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "操作成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "操作失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备类型删除]
        public static ToMessage DeleteDeviceType(string devicetypeid)
        public static ToMessage DeleteDeviceType(string devicetypecode)
        {
            throw new NotImplementedException();
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //判断设备类型下是否关联设备组
                sql = @"select *  from TEqpGroup where eqptype_code=@devicetypecode and is_delete<>'1'";
                dynamicParams.Add("@devicetypecode", devicetypecode);
                var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
                if (data.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前设备类型已有关联设备组,不允许删除!";
                    mes.data = null;
                }
                else
                {
                    //判断设备有无关联设备类型
                    sql = @"select *  from TEqpInfo where eqptype_code=@devicetypecode and is_delete<>'1'";
                    dynamicParams.Add("@devicetypecode", devicetypecode);
                    var data0 = DapperHelper.select<TreeObejct>(sql, dynamicParams);
                    if (data0.Count > 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "当前设备类型已有关联设备组,不允许删除!";
                        mes.data = null;
                    }
                    else
                    {
                        sql = @"delete TEqpType where code=@devicetypecode";
                        list.Add(new { str = sql, parm = new { devicetypecode = devicetypecode } });
                        bool aa = DapperHelper.DoTransaction(list);
                        if (aa)
                        {
                            mes.code = "200";
                            mes.count = 0;
                            mes.Message = "删除成功!";
                            mes.data = null;
                        }
                        else
                        {
                            mes.code = "300";
                            mes.count = 0;
                            mes.Message = "删除失败!";
                            mes.data = null;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion


        #region[设备类型下拉框接口]
        public static ToMessage DeviceTypeSelect()
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            List<TreeObejct> list = new List<TreeObejct>();
            try
            {
                //获取设备类型数据
                sql = @"select code,name from TEqpType where is_delete<>'1'";
                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 DeviceGroupSearch(int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.remark  
                            from TEqpGroup A
                            inner join TEqpType B on A.eqptype_code=B.code 
                            where  A.is_delete<>'1' ";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备组新增]
        public static ToMessage AddUpdateDeviceGroup(List<ObjectDataCont> json, string username)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //循环写入设备类型表
                for (int i = 0; i < json.Count; i++)
                {
                    sql = @"insert into TEqpGroup(code,name,lm_user,lm_date,remark,eqptype_code) values(@code,@name,@username,@createdate,@description,@eqptype_code)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            code = json[i].code,
                            name = json[i].name,
                            username = username,
                            createdate = DateTime.Now.ToString(),
                            description = json[i].description,
                            eqptype_code = json[i].group
                        }
                    });
                }
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "操作成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "操作失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备类型删除]
        public static ToMessage DeleteDeviceGroup(string devicegroupcode)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //判断设备组下是否关联设备
                sql = @"select *  from TEqpInfo where eqpgroup_code=@devicegroupcode and is_delete<>'1'";
                dynamicParams.Add("@devicegroupcode", devicegroupcode);
                var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
                if (data.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前设备组已有关联设备组,不允许删除!";
                    mes.data = null;
                }
                else
                {
                    //删除设备组
                    sql = @"delete TEqpGroup where code=@devicegroupcode";
                    list.Add(new { str = sql, parm = new { devicegroupcode = devicegroupcode } });
                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "删除成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "删除失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion



        #region[设备类型查找设备组]
        public static ToMessage DeviceTypeSelectGroup(string eqptypecode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            List<TreeObejct> list = new List<TreeObejct>();
            try
            {
                //获取设备类型数据
                sql = @"select code,name from TEqpGroup where eqptype_code=@eqptypecode and is_delete<>'1'";
                dynamicParams.Add("@eqptypecode", eqptypecode);
                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 WorkShopSelect()
        {
            string sql = "";
            try
            {
                //获取设备类型数据
                sql = @"select org_code as code,org_name as name from TOrganization where description='W' and is_delete<>'1'";
                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 DeviceMangerSearch(string deviceCode, string deviceName, string status, string workShop, string deviceType, string deviceGroup, int startNum, int endNum, string prop, string order)
        {
            throw new NotImplementedException();
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (deviceCode != "" && deviceCode != null)
                {
                    search += "and A.code like '%'+@deviceCode+'%' ";
                    dynamicParams.Add("@deviceCode", deviceCode);
                }
                if (deviceName != "" && deviceName != null)
                {
                    search += "and A.name like '%'+@deviceName+'%' ";
                    dynamicParams.Add("@deviceName", deviceName);
                }
                if (status != "" && status != null)
                {
                    search += "and A.status=@status ";
                    dynamicParams.Add("@status", status);
                }
                if (workShop != "" && workShop != null)
                {
                    search += "and A.wksp_code=@workShop ";
                    dynamicParams.Add("@workShop", workShop);
                }
                if (deviceType != "" && deviceType != null)
                {
                    search += "and A.eqptype_code=@deviceType ";
                    dynamicParams.Add("@deviceType", deviceType);
                }
                if (deviceGroup != "" && deviceGroup != null)
                {
                    search += "and A.eqpgroup_code=@deviceGroup ";
                    dynamicParams.Add("@deviceGroup", deviceGroup);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                //search = search.Substring(3);//截取索引2后面的字符
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.eqpgroup_code,G.name as eqpgroup_name,A.enable,
                            A.input_date,A.wksp_code,T.org_name as wksp_name,A.Line_code,L.org_name as Line_name,A.opc_uom,A.operation_ration,A.lm_user,A.lm_date
                            from TEqpInfo A
                            left join TEqpType B on A.eqptype_code=B.code
                            left join TEqpGroup G on A.eqpgroup_code=G.code
                            left join TOrganization T on A.wksp_code=T.org_code
                            left join TOrganization L on A.Line_code=L.org_code
                            where A.is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备清单新增编辑]
        public static ToMessage AddUpdateDeviceManger(string deviceid, string devicecode, string devicename, string devicetype, string devicegroup, string importdate, string workshop, string status, string ratio, string usercode, string operType)
        public static ToMessage AddUpdateDeviceManger(string deviceid, string devicecode, string devicename, string devicetype, string devicegroup, string importdate, string workshop, string linecode, string status, string ratio, string usercode, string operType)
        {
            throw new NotImplementedException();
            var dynamicParams = new DynamicParameters();
            try
            {
                if (operType == "Add")
                {
                    var sql = @"insert into TEqpInfo(code,name,eqptype_code,eqpgroup_code,wksp_code,line_code,input_date,operation_ration,enable,opc_uom,lm_user,lm_date) 
                            values(@devicecode,@devicename,@devicetype,@devicegroup,@workshop,@linecode,@importdate,@ratio,@status,@uom,@usercode,@CreateDate)";
                    dynamicParams.Add("@devicecode", devicecode);
                    dynamicParams.Add("@devicename", devicename);
                    dynamicParams.Add("@devicetype", devicetype);
                    dynamicParams.Add("@devicegroup", devicegroup);
                    dynamicParams.Add("@workshop", workshop);
                    dynamicParams.Add("@linecode", linecode);
                    dynamicParams.Add("@importdate", importdate);
                    dynamicParams.Add("@ratio", ratio);
                    dynamicParams.Add("@status", status);
                    dynamicParams.Add("@uom", "台");
                    dynamicParams.Add("@usercode", usercode);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (operType == "Update")
                {
                    var sql = @"update TEqpInfo set name=@devicename,eqptype_code=@devicetype,eqpgroup_code=@devicegroup,input_date=@importdate,
                                wksp_code=@workshop,line_code=@linecode,enable=@status,operation_ration=@ratio,lm_user=@usercode,lm_date=@CreateDate,
                                where id=@deviceid";
                    dynamicParams.Add("@deviceid", deviceid);
                    dynamicParams.Add("@devicename", devicename);
                    dynamicParams.Add("@devicetype", devicetype);
                    dynamicParams.Add("@devicegroup", devicegroup);
                    dynamicParams.Add("@workshop", workshop);
                    dynamicParams.Add("@linecode", linecode);
                    dynamicParams.Add("@importdate", importdate);
                    dynamicParams.Add("@ratio", ratio);
                    dynamicParams.Add("@status", status);
                    dynamicParams.Add("@usercode", usercode);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备清单删除]
        public static ToMessage DeleteDeviceManger(string deviceid)
        public static ToMessage DeleteDeviceManger(string devicecode)
        {
            throw new NotImplementedException();
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //判断设备是否有关联工艺路线的生产订单(未关闭),不允许删除
                sql = @"select A.code,M.wo_code,R.name  from TEqpInfo A
                        inner join TFlw_Rteqp B on A.code=B.eqp_code 
                        inner join TStep C on B.step_code=C.stepcode 
                        inner join TFlw_Rtdt D on C.stepcode=D.step_code
                        inner join TFlw_Rout R on D.rout_code=R.code 
                        inner join TK_Wrk_Man M on R.code=M.route_code 
                        where  A.code=@devicecode";
                dynamicParams.Add("@devicecode", devicecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前设备被工单引用,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //判断设备是否有关联工艺路线工序,不允许删除
                sql = @"select *  from TFlw_Rteqp
                        where eqp_code=@devicecode";
                dynamicParams.Add("@devicecode", devicecode);
                var data0 = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前设备已关联工序,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //判断设备是否指定节拍工价,不允许删除
                sql = @"select *  from TPrteEqp_Stad
                        where eqp_code=@devicecode";
                dynamicParams.Add("@devicecode", devicecode);
                var data1 = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前设备已指定节拍工价,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //删除设备
                sql = @"update TEqpInfo set is_delete='1' where code=@devicecode";
                list.Add(new { str = sql, parm = new { devicecode = devicecode } });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "删除失败!";
                    mes.data = null;
                }

            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }

 VueWebApi/DLL/DAL/MaterialManagerDAL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,394 @@
using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using VueWebApi.Tools;

namespace VueWebApi.DLL.DAL
{
    public class MaterialManagerDAL
    {
        public static DataTable dt;    //定义全局变量dt
        public static bool res;       //定义全局变量dt
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
        public static string strProcName = ""; //定义全局sql变量
        public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
        public static SqlParameter[] parameters; //定义全局SqlParameter参数数组


        #region[仓库查询]
        public static ToMessage WareHouseDefSearch(string warehousecode, string warehousename, string description, string createuser, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (warehousecode != "" && warehousecode != null)
                {
                    search += "and code like '%'+@warehousecode+'%' ";
                    dynamicParams.Add("@warehousecode", warehousecode);
                }
                if (warehousename != "" && warehousename != null)
                {
                    search += "and name like '%'+@warehousename+'%' ";
                    dynamicParams.Add("@warehousename", warehousename);
                }
                if (description != "" && description != null)
                {
                    search += "and description like '%'+@description+'%' ";
                    dynamicParams.Add("@description", description);
                }
                if (createuser != "" && createuser != null)
                {
                    search += "and lm_user like '%'+@createuser+'%' ";
                    dynamicParams.Add("@createuser", createuser);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select id,code,name,description,lm_user,lm_date from T_Sec_Stck
                            where  is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓库新增编辑]
        public static ToMessage AddUpdateWareHouseDef(string warehouseid, string warehousecode, string warehousename, string description, string username, string operType)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                if (operType == "Add")
                {
                    var sql = @"insert into T_Sec_Stck(code,name,description,lm_user,lm_date) 
                            values(@warehousecode,@warehousename,@description,@username,@CreateDate)";
                    dynamicParams.Add("@warehousecode", warehousecode);
                    dynamicParams.Add("@warehousename", warehousename);
                    dynamicParams.Add("@description", description);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (operType == "Update")
                {
                    var sql = @"update T_Sec_Stck set name=@warehousename,description=@description,lm_user=@username,lm_date=@CreateDate where id=@warehouseid";
                    dynamicParams.Add("@warehouseid", warehouseid);
                    dynamicParams.Add("@warehousename", warehousename);
                    dynamicParams.Add("@description", description);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region [仓库删除]
        public static ToMessage DeleteWareHouseDef(string warehousecode)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //判断仓库下是否有关联库位
                sql = @"select B.code,B.name  from T_Sec_Stck A
                        inner join T_Sec_Loca B on A.code=B.stock_code and B.is_delete<>'1'
                        where A.code=@warehousecode and A.is_delete<>'1'";
                dynamicParams.Add("@warehousecode", warehousecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前仓库下有关联库位,不允许删除!";
                    mes.data = null;
                }
                else
                {
                    //删除仓库
                    sql = @"delete T_Sec_Stck where code=@warehousecode";
                    list.Add(new { str = sql, parm = new { warehousecode = warehousecode } });
                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "删除成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "删除失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion




        #region[所属仓库接口]
        public static ToMessage WareHouseSelect()
        {
            string sql = "";
            try
            {
                //获取设备类型数据
                sql = @"select code,name from T_Sec_Stck where is_delete<>'1'";
                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 StorageDefSearch(string storagecode, string storagename, string description, string createuser, string stockcode, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (storagecode != "" && storagecode != null)
                {
                    search += "and A.code like '%'+@storagecode+'%' ";
                    dynamicParams.Add("@storagecode", storagecode);
                }
                if (storagename != "" && storagename != null)
                {
                    search += "and A.name like '%'+@storagename+'%' ";
                    dynamicParams.Add("@storagename", storagename);
                }
                if (description != "" && description != null)
                {
                    search += "and A.description like '%'+@description+'%' ";
                    dynamicParams.Add("@description", description);
                }
                if (createuser != "" && createuser != null)
                {
                    search += "and A.lm_user like '%'+@createuser+'%' ";
                    dynamicParams.Add("@createuser", createuser);
                }
                if (stockcode != "" && stockcode != null)
                {
                    search += "and A.stock_code=@stockcode ";
                    dynamicParams.Add("@stockcode", stockcode);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date  
                            from T_Sec_Loca A
                            left join T_Sec_Stck B on A.stock_code=B.code
                            where A.is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[库位定义新增编辑]
        public static ToMessage AddUpdateStorageDef(string storageid, string storagecode, string storagename, string description, string stockcode, string username, string operType)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                if (operType == "Add")
                {
                    var sql = @"insert into T_Sec_Loca(code,name,description,stock_code,lm_user,lm_date) 
                            values(@storagecode,@storagename,@description,@username,@CreateDate)";
                    dynamicParams.Add("@storagecode", storagecode);
                    dynamicParams.Add("@storagename", storagename);
                    dynamicParams.Add("@description", description);
                    dynamicParams.Add("@stockcode", stockcode);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (operType == "Update")
                {
                    var sql = @"update T_Sec_Loca set name=@storagename,description=@description,stock_code=@stockcode,lm_user=@username,lm_date=@CreateDate where id=@storageid";
                    dynamicParams.Add("@storageid", storageid);
                    dynamicParams.Add("@storagename", storagename);
                    dynamicParams.Add("@description", description);
                    dynamicParams.Add("@stockcode", stockcode);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[库位定义删除]
        public static ToMessage DeleteStorageDef(string storagecode)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //删除仓位
                sql = @"delete T_Sec_Loca where code=@storagecode";
                list.Add(new { str = sql, parm = new { storagecode = storagecode } });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "删除失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion




    }
}

 VueWebApi/DLL/DAL/ProductModelDAL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,668 @@
using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.DAL
{
    public class ProductModelDAL
    {
        public static DataTable dt;    //定义全局变量dt
        public static bool res;       //定义全局变量dt
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
        public static string strProcName = ""; //定义全局sql变量
        public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
        public static SqlParameter[] parameters; //定义全局SqlParameter参数数组


        #region [存货类型]
        public static ToMessage StockTypeSelect()
        {
            string sql = "";
            try
            {
                //获取设备类型数据
                sql = @"select code,name from T_Dict where dict_group='CHLX' ";
                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 MaterialTypeSearch(string materialtypecode, string materialtypename, string stocktypecode, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (materialtypecode != "" && materialtypecode != null)
                {
                    search += "and A.code like '%'+@materialtypecode+'%' ";
                    dynamicParams.Add("@materialtypecode", materialtypecode);
                }
                if (materialtypename != "" && materialtypename != null)
                {
                    search += "and A.name like '%'+@warehousename+'%' ";
                    dynamicParams.Add("@materialtypename", materialtypename);
                }
                if (stocktypecode != "" && stocktypecode != null)
                {
                    search += "and A.dict_code=@stocktypecode ";
                    dynamicParams.Add("@stocktypecode", stocktypecode);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.id,A.code,A.name,A.dict_code as stockcode,B.name as stockname,A.lm_user,A.lm_date  
                            from TMateriel_Type A
                            left join T_Dict B on A.dict_code=B.code and B.dict_group='CHLX'
                            where A.is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region [物料类型新增编辑]
        public static ToMessage AddUpdateMaterialType(string materialtypeid, string materialtypecode, string materialtypename, string stocktypecode, string username, string operType)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                if (operType == "Add")
                {
                    var sql = @"insert into TMateriel_Type(dict_code,code,name,lm_user,lm_date) 
                            values(@stocktypecode,@materialtypecode,@materialtypename,@username,@CreateDate)";
                    dynamicParams.Add("@stocktypecode", stocktypecode);
                    dynamicParams.Add("@materialtypecode", materialtypecode);
                    dynamicParams.Add("@materialtypename", materialtypename);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (operType == "Update")
                {
                    var sql = @"update TMateriel_Type set name=@materialtypename,dict_code=@stocktypecode,lm_user=@username,lm_date=@CreateDate where id=@materialtypeid";
                    dynamicParams.Add("@materialtypeid", materialtypeid);
                    dynamicParams.Add("@materialtypename", materialtypename);
                    dynamicParams.Add("@stocktypecode", stocktypecode);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[物料类型删除]
        public static ToMessage DeleteMaterialType(string materialtypecode)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //判断物料类型是否有关联物料
                sql = @"select B.partcode,B.partname from TMateriel_Type A
                        inner join TMateriel_Info B on A.code=B.materieltype_code and B.is_delete<>'1'
                        where A.is_delete<>'1' and A.code=@materialtypecode";
                dynamicParams.Add("@materialtypecode", materialtypecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "物料类型有关联物料,不允许删除!";
                    mes.data = null;
                }
                else
                {
                    //删除仓库
                    sql = @"delete TMateriel_Type where code=@materialtypecode";
                    list.Add(new { str = sql, parm = new { materialtypecode = materialtypecode } });
                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "删除成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "删除失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion



        #region[单位列表查询]
        public static ToMessage UomSearch(int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select code,name,digdect,r_ule 
                            from TUom 
                            where  is_delete<>'1' ";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[单位新增]
        public static ToMessage UomAdd(string username, List<Uom> json)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //循环写入单位表
                for (int i = 0; i < json.Count; i++)
                {
                    sql = @"insert into TUom(code,name,digdect,r_ule,lm_user,lm_date) values(@code,@name,@digdect,@r_ule,@username,@CreateDate)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            code = json[i].code,
                            name = json[i].name,
                            digdect=json[i].digdect,
                            r_ule=json[i].r_ule,
                            username= username,
                            CreateDate= DateTime.Now.ToString()
                        }
                    });
                }
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "操作成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "操作失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[单位删除]
        public static ToMessage UomDelete(string uomcode)
        {
            var sql = "";
            var cont = 0;
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select * from  TMateriel_Info  where uom_code=@uomcode";
                dynamicParams.Add(@"uomcode", uomcode);
                cont = DapperHelper.selectcount(sql, dynamicParams);
                if (cont <= 0)
                {
                    mes.code = "300";
                    mes.Message = "单位已关联物料,不能删除!";
                }
                else
                {
                    sql = @"update TUom set is_delete='1'  where code=@uomcode";
                    dynamicParams.Add(@"uomcode", uomcode);
                    cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "删除操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "删除操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[存类型查找物料类型]
        public static ToMessage StockTypeSelectMaterialType(string stocktypecode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取设备类型数据
                sql = @"select code,name from TMateriel_Type where dict_code=@stocktypecode and is_delete<>'1'";
                dynamicParams.Add("@stocktypecode", stocktypecode);
                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 InventoryFileSelect(string partcode, string partname, string partspec, string stocktypecode, string materialtypecode, string storehousecode, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (partcode != "" && partcode != null)
                {
                    search += "and A.partcode like '%'+@partcode+'%' ";
                    dynamicParams.Add("@partcode", partcode);
                }
                if (partname != "" && partname != null)
                {
                    search += "and A.partname like '%'+@partname+'%' ";
                    dynamicParams.Add("@partname", partname);
                }
                if (partspec != "" && partspec != null)
                {
                    search += "and A.partspec like '%'+@partspec+'%' ";
                    dynamicParams.Add("@partspec", partspec);
                }
                if (stocktypecode != "" && stocktypecode != null)
                {
                    search += "and D.code=@stocktypecode ";
                    dynamicParams.Add("@stocktypecode", stocktypecode);
                }
                if (materialtypecode != "" && materialtypecode != null)
                {
                    search += "and C.code=@materialtypecode ";
                    dynamicParams.Add("@materialtypecode", materialtypecode);
                }
                if (storehousecode != "" && storehousecode != null)
                {
                    search += "and A.stck_code=@storehousecode ";
                    dynamicParams.Add("@storehousecode", storehousecode);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.partcode,A.partname,A.partspec,A.uom_code,B.name as uom_name,D.code as stocktypecode,D.name as stocktypename,
                            C.code as materialtypecode,C.name as materialtypename,A.stck_code,T.name as stck_name,A.maxqty,A.minqty,A.lm_user,
                            A.lm_date,A.proute_id
                            from TMateriel_Info A
                            left join TUom B on A.uom_code=B.code
                            left join TMateriel_Type C on A.materieltype_code=C.code
                            left join T_Dict D on C.dict_code=D.code and D.dict_type='CHLX'
                            left join T_Sec_Stck T on A.stck_code=T.code 
                            where A.is_delete<>'1' " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[存货档案新增编辑]
        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty, string username, string operType)
        {
            var dynamicParams = new DynamicParameters();
            try
            {
                if (operType == "Add")
                {
                    var sql = @"insert into TMateriel_Info(partcode,partname,partspec,uom_code,materialtypecode,stck_code,proute_id,maxqty,minqty,lm_user,lm_date) 
                            values(@stocktypecode,@materialtypecode,@materialtypename,@username,@CreateDate)";
                    dynamicParams.Add("@materialcode", materialcode);
                    dynamicParams.Add("@materialname", materialname);
                    dynamicParams.Add("@materialspec", materialspec);
                    dynamicParams.Add("@uomcode", uomcode);
                    dynamicParams.Add("@warehousecode", warehousecode);
                    dynamicParams.Add("@materialtypecode", materialtypecode);
                    dynamicParams.Add("@minstockqty", minstockqty);
                    dynamicParams.Add("@maxstockqty", maxstockqty);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (operType == "Update")
                {
                    var sql = @"update TMateriel_Type set partname=@materialname,partspec=@materialspec,uom_code=@uomcode,materialtypecode=@materialtypecode,stck_code=@warehousecode,
                                maxqty=@maxstockqty,minqty=@minstockqty lm_user=@username,lm_date=@CreateDate where id=@materialid";
                    dynamicParams.Add("@materialid", materialid);
                    dynamicParams.Add("@materialname", materialname);
                    dynamicParams.Add("@materialspec", materialspec);
                    dynamicParams.Add("@uomcode", uomcode);
                    dynamicParams.Add("@warehousecode", warehousecode);
                    dynamicParams.Add("@materialtypecode", materialtypecode);
                    dynamicParams.Add("@minstockqty", minstockqty);
                    dynamicParams.Add("@maxstockqty", maxstockqty);
                    dynamicParams.Add("@username", username);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    int cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[存货档案删除]
        public static ToMessage DeleteInventoryFile(string materialcode)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                //当前物料是否关联工艺路线
                sql = @"select B.route_code,C.name as route_name  from TMateriel_Info A
                        inner join TMateriel_Route B on A.partcode=B.materiel_code 
                        inner join TFlw_Rout C on B.route_code=C.code 
                        where A.partcode=@materialcode";
                dynamicParams.Add("@materialcode", materialcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "物料已关联工艺路线,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //当前物料是否关联节拍工价
                sql = @"select *  from TPrteEqp_Stad
                        where materiel_code=@materialcode";
                dynamicParams.Add("@materialcode", materialcode);
                var data0 = DapperHelper.selectdata(sql, dynamicParams);
                if (data0.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "物料已关联节拍工价,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //当前物料是否设置Bom清单
                sql = @"select *  from TBom_Main
                        where materiel_code=@materialcode";
                dynamicParams.Add("@materialcode", materialcode);
                var data1 = DapperHelper.selectdata(sql, dynamicParams);
                if (data1.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "物料已关联BOM清单【主料】,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                sql = @"select *  from TBom_Deta
                        where smateriel_code=@materialcode";
                dynamicParams.Add("@materialcode", materialcode);
                var data2 = DapperHelper.selectdata(sql, dynamicParams);
                if (data2.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "物料已关联BOM清单【子料】,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //当前物料是否生成出入库记录
                //有没有被工单引用

                //删除物料
                sql = @"update TMateriel_Info set is_delete='1' where partcode=@materialcode";
                list.Add(new { str = sql, parm = new { materialcode = materialcode } });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "删除失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[存货档案关联工艺路线查询]
        public static ToMessage InventoryFileAssociationRoute(string partcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            List<MaterialRout> list = new List<MaterialRout>();
            try
            {
                //获取工艺路线集合(包含物料绑定工艺路线标识)
                sql = @"select distinct A.code as routecode,A.name as routename,(case when B.route_code is null then 'N' else 'Y' end) flag  from TFlw_Rout A 
                        left join (
                          select distinct route_code  from TMateriel_Route where  materiel_code=@partcode and is_delete<>'1'
                        ) B
                        on A.code=B.route_code 
                        where  A.is_delete='0'";
                dynamicParams.Add("@partcode", partcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                for (int i = 0; i < data.Rows.Count; i++)
                {
                    MaterialRout rout = new MaterialRout();
                    rout.code = data.Rows[i]["CODE"].ToString();
                    rout.name = data.Rows[i]["NAME"].ToString();
                    rout.flag = data.Rows[i]["FLAG"].ToString();
                   
                    //根据工艺路线编码获取关联的工序信息
                    sql = @"select A.seq,B.stepcode,B.stepname,B.enable from TFlw_Rtdt A
                            inner join TStep B on A.step_code=B.stepcode
                            where A.rout_code=@route_code and B.is_delete<>'1' order by A.seq asc";
                    dynamicParams.Add("@route_code", rout.code);
                    var data0 = DapperHelper.selectdata(sql, dynamicParams);
                    rout.Data = data0;
                    list.Add(rout);

                }
                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

    }
}

 VueWebApi/Global.asax.cs

@@ -23,6 +23,10 @@
            this.PostAuthenticateRequest += (sender, e) => HttpContext.Current.SetSessionStateBehavior(SessionStateBehavior.Required);
            base.Init();
        }
        void Session_Start(object sender, EventArgs e)
        {
            string sessionId = Session.SessionID;
        }
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();

 VueWebApi/Logs/2022-06-21.TXT

 VueWebApi/Logs/2022-06-22.TXT

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,50 @@
 ã€æ—¶é—´ã€‘:2022-06-22 09:12:26,134
 ã€çº§åˆ«ã€‘:ERROR
 ã€ç±»åã€‘:日志记录
 ã€çº¿ç¨‹ID】: 13 
 ã€æ–‡ä»¶åœ°å€ã€‘: ç¬¬0行
 ã€æ—¥å¿—内容】:
消息类型：SqlException
消息内容：必须声明标量变量 "@unitattr"。
引发异常路径：/api/BasicSetting/AddUpdateCurrentUnit
引发异常的方法：OnError
引发异常源：.Net SqlClient Data Provider   åœ¨ System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   åœ¨ System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   åœ¨ System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   åœ¨ System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   åœ¨ System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   åœ¨ Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)
   åœ¨ Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
   åœ¨ Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   åœ¨ VueWebApi.Tools.DapperHelper.SQL(String sql, Object parametere)
 ã€æ—¥è®°è¯¦ç»†ã€‘： 
---------------------------------------------------------------------------------------------------------------
 ã€æ—¶é—´ã€‘:2022-06-22 15:48:56,142
 ã€çº§åˆ«ã€‘:ERROR
 ã€ç±»åã€‘:日志记录
 ã€çº¿ç¨‹ID】: 21 
 ã€æ–‡ä»¶åœ°å€ã€‘: ç¬¬0行
 ã€æ—¥å¿—内容】:
消息类型：SqlException
消息内容：“,”附近有语法错误。
引发异常路径：/api/BasicSetting/AddUpdateCurrentUnit
引发异常的方法：OnError
引发异常源：.Net SqlClient Data Provider   åœ¨ System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   åœ¨ System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   åœ¨ System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   åœ¨ System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   åœ¨ System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   åœ¨ Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)
   åœ¨ Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
   åœ¨ Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   åœ¨ VueWebApi.Tools.DapperHelper.SQL(String sql, Object parametere)
 ã€æ—¥è®°è¯¦ç»†ã€‘： 
---------------------------------------------------------------------------------------------------------------

 VueWebApi/Models/MaterialRout.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace VueWebApi.Models
{
    public class MaterialRout
    {
        public string code { get; set; }
        public string name { get; set; }
        public string flag { get; set; }
        public DataTable Data { get; set; }
    }
}

 VueWebApi/Models/ObjectDataCont.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace VueWebApi.Models
{
    public class ObjectDataCont
    {
        public string code { get; set; }
        public string name { get; set; }
        public string group { get; set; }
        public string description { get; set; }
    }
}

 VueWebApi/Models/Uom.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace VueWebApi.Models
{
    public class Uom
    {
        public string code { get; set; }
        public string name { get; set; }
        public string digdect { get; set; }
        public string r_ule { get; set; }
    }
}

 VueWebApi/Properties/PublishProfiles/FolderProfile.pubxml.user

@@ -372,13 +372,13 @@
      <publishTime>11/28/2018 13:04:24</publishTime>
    </File>
    <File Include="bin/VueWebApi.dll">
      <publishTime>06/20/2022 21:38:42</publishTime>
      <publishTime>06/22/2022 18:15:29</publishTime>
    </File>
    <File Include="bin/VueWebApi.dll.config">
      <publishTime>06/15/2022 15:31:43</publishTime>
    </File>
    <File Include="bin/VueWebApi.pdb">
      <publishTime>06/20/2022 21:38:42</publishTime>
      <publishTime>06/22/2022 18:15:29</publishTime>
    </File>
    <File Include="bin/VueWebApi.xml">
      <publishTime>06/16/2022 14:26:01</publishTime>
@@ -519,7 +519,7 @@
      <publishTime>06/10/2022 08:20:24</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>06/20/2022 18:40:27</publishTime>
      <publishTime>06/21/2022 16:19:30</publishTime>
    </File>
  </ItemGroup>
</Project>

 VueWebApi/Tools/DapperHelper.cs

@@ -52,6 +52,11 @@
                    LogHelper.WriteLog(ex);
                    throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
                
            }
            return list;
@@ -81,6 +86,11 @@
                    LogHelper.WriteLog(ex);
                    throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
            return result;
        }
@@ -108,6 +118,11 @@
                    LogHelper.WriteLog(ex);
                    throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
            return t;
        }
@@ -124,14 +139,11 @@
        /// <returns></returns>
        public static IEnumerable<T> GetPageList<T>(string sql,Object parm, string orderBy,string sort, int pageIndex, int pageSize, out int total)
        {
            try
            {
                //int skip = 1;
                //if (pageIndex > 0)
                //{
                //    skip = (pageIndex - 1) * pageSize + 1;
                //}

                StringBuilder sb = new StringBuilder();
                sb.AppendFormat("SELECT COUNT(1) FROM ({0}) AS Result;", sql);
                sb.AppendFormat(@"SELECT *
@@ -142,11 +154,12 @@

                using (IDbConnection conn = sqlConnection())
                {
                try
                {
                    using (var reader = conn.QueryMultiple(sb.ToString(), parm))
                    {
                        total = reader.ReadFirst<int>();
                        return reader.Read<T>();
                    }
                }
            }
            catch (Exception ex)
@@ -155,7 +168,13 @@
                LogHelper.WriteLog(ex);
                throw ex;
            }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
           
            }
        }

        /// <summary>
@@ -167,15 +186,14 @@
        public static DataTable selectdata(string sql, Object parm)
        {
            //sql语句
            try
            {
                using (IDbConnection conn = sqlConnection())
            {
                try
                {
                    DataTable table = new DataTable();
                    var data = conn.ExecuteReader(sql, parm);
                    table.Load(data);
                    return table;
                }
            }
            catch (Exception ex)
            {
@@ -183,7 +201,12 @@
                LogHelper.WriteLog(ex);
                throw ex;
            }
           
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
        }

        /// <summary>
@@ -194,15 +217,14 @@
        public static DataTable selecttable(string sql)
        {
            //sql语句
            try
            {
                using (IDbConnection conn = sqlConnection())
            {
                try
                {
                    DataTable table = new DataTable();
                    var data = conn.ExecuteReader(sql);
                    table.Load(data);
                    return table;
                }
            }
            catch (Exception ex)
            {
@@ -210,7 +232,12 @@
                LogHelper.WriteLog(ex);
                throw ex;
            }

                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
        }

        /// <summary>
@@ -222,9 +249,9 @@
        public static DataTable selectProcedure(string sql, Object parm)
        {
            //sql语句
            try
            {
                using (IDbConnection conn = sqlConnection())
            {
                try
                {
                    DataTable table = new DataTable();
                    //var data = conn.ExecuteReader(sql, parm);
@@ -232,12 +259,17 @@
                    table.Load(res);
                    return table;
                }
            }
            catch (Exception ex)
            {
                //创建日志记录组件实例
                LogHelper.WriteLog(ex);
                throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }

        }
@@ -252,19 +284,24 @@
        {
            //sql语句
            int result = 0;
            try
            {
                using (IDbConnection conn = sqlConnection())
                {
                try
                {
                    result = conn.Query(sql, parm).Count();
                }
                return result;
            }
            catch (Exception ex)
            {
                //创建日志记录组件实例
                LogHelper.WriteLog(ex);
                throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
                return result;
            }
        }

@@ -278,13 +315,11 @@
        {
            //sql语句
            int result = 0;
            try
            {
                using (IDbConnection conn = sqlConnection())
                {
                try
                {
                    result = conn.Execute(sql, parametere);
                }
                return result;
            }
            catch (Exception ex)
            {
@@ -292,6 +327,13 @@
                LogHelper.WriteLog(ex);
                throw ex;
            }   
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
            return result;
        }

        /// <summary>
@@ -323,6 +365,11 @@
                    tranction.Rollback();
                    throw ex;
                }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
                return result;
            }
        }
@@ -339,9 +386,9 @@
        {

            int result = 0;
            try
            {
                using (IDbConnection conn = sqlConnection())
            {
                try
                {
                    result = conn.Execute(sql, parameter);
                    if (result != 0)
@@ -349,14 +396,19 @@
                        result = conn.Query<int>("select ident_current(@table)", new { table = tableName }).Single<int>();
                    }
                }
                return result;
            }
            catch (Exception ex)
            { 
                //创建日志记录组件实例
                LogHelper.WriteLog(ex);
                throw ex;
            }
                finally
                {
                    conn.Dispose();
                    conn.Close();
                }
            }
            return result;
        }
    }
}

 VueWebApi/Tools/RedisHelper.cs

@@ -121,6 +121,7 @@
        public bool Remove(string key, int db = 0)
        {
            Redis = (RedisClient)ChooseRedisInstance(db).GetClient();
            Redis.Dispose();
            return Redis.Remove(key);
        }

@@ -164,6 +165,7 @@
            var redisList = iredisClient.Lists[listId];
            redisList.AddRange(values);
            iredisClient.Save();
            Redis.Dispose();
        }
        /// <summary>  
        /// æ·»åŠ å•ä¸ªå®žä½“到链表中  
@@ -187,6 +189,7 @@
            var redisList = iredisClient.Lists[listId];
            redisList.Add(Item);
            iredisClient.Save();
            Redis.Dispose();
        }
        /// <summary>  
        /// èŽ·å–链表  
@@ -198,6 +201,7 @@
        {
            Redis = (RedisClient)ChooseRedisInstance(db).GetClient();
            IRedisTypedClient<T> iredisClient = Redis.As<T>();
            Redis.Dispose();
            return iredisClient.Lists[listId];
        }
        /// <summary>  
@@ -213,6 +217,7 @@
            var redisList = iredisClient.Lists[listId];
            redisList.RemoveValue(t);
            iredisClient.Save();
            Redis.Dispose();
        }
        /// <summary>  
        /// æ ¹æ®lambada表达式删除符合条件的实体  
@@ -240,7 +245,7 @@
            T value = redisList.Where(func).FirstOrDefault();
            redisList.RemoveValue(value);
            iredisClient.Save();

            Redis.Dispose();

        }
        public void test()

 VueWebApi/Tools/SeachEncode.cs

@@ -369,7 +369,7 @@
                    //第一层
                    sql = @"select distinct A.parent_id from TRight A
                        inner join  TRoleRightRelation B on A.right_code=B.right_code 
                        where B.role_code='S001' and A.Type='PC' ";
                        where B.role_code=@rolecode and A.Type='PC' ";
                    dynamicParams.Add("@rolecode", rolecode);
                    dynamicParams.Add("@type", type);
                    var data1 = DapperHelper.selectdata(sql, dynamicParams);
@@ -412,10 +412,11 @@
                                     from TRight A
                                     left join (
                                      select  B.right_code from TRight A
                                      inner join  TRoleRightRelation B on A.right_code=B.right_code where A.parent_id=@right_code
                                      inner join  TRoleRightRelation B on A.right_code=B.right_code where A.parent_id=@right_code and B.role_code=@rolecode
                                     ) C on A.right_code=C.right_code
                                     where A.parent_id=@right_code";
                        dynamicParams.Add("@right_code", data2.Rows[i]["RIGHT_CODE"].ToString());
                        dynamicParams.Add("@rolecode", rolecode);
                        var data3 = DapperHelper.selectdata(sql, dynamicParams);
                        for (int j = 0; j < data3.Rows.Count; j++)
                        {
@@ -432,22 +433,22 @@
                             //第一层
                    sql = @"select distinct A.parent_id from TRight A
                        inner join  TRoleRightRelation B on A.right_code=B.right_code 
                        where B.role_code='S001' and A.Type='PC' ";
                        where B.role_code=@rolecode and A.Type='APP' ";
                    dynamicParams.Add("@rolecode", rolecode);
                    dynamicParams.Add("@type", type);
                    var date1 = DapperHelper.selectdata(sql, dynamicParams);
                    TreeDM cmt = new TreeDM();
                    if (date1.Rows.Count > 0)
                    {
                        cmt.code = "PC";
                        cmt.name = "PC";
                        cmt.code = "APP";
                        cmt.name = "APP";
                        cmt.flag = "Y";

                    }
                    else
                    {
                        cmt.code = "PC";
                        cmt.name = "PC";
                        cmt.code = "APP";
                        cmt.name = "APP";
                        cmt.flag = "N";
                    }
                    cmt.children = new List<TreeDMOne>();
@@ -475,10 +476,11 @@
                                     from TRight A
                                     left join (
                                      select  B.right_code from TRight A
                                      inner join  TRoleRightRelation B on A.right_code=B.right_code where A.parent_id=@right_code
                                      inner join  TRoleRightRelation B on A.right_code=B.right_code where A.parent_id=@right_code and B.role_code=@rolecode
                                     ) C on A.right_code=C.right_code
                                     where A.parent_id=@right_code";
                        dynamicParams.Add("@right_code", date2.Rows[i]["RIGHT_CODE"].ToString());
                        dynamicParams.Add("@rolecode", rolecode);
                        var date3 = DapperHelper.selectdata(sql, dynamicParams);
                        for (int j = 0; j < date3.Rows.Count; j++)
                        {

 VueWebApi/VueWebApi.csproj

@@ -255,29 +255,38 @@
    <Compile Include="Controllers\DeviceManagerController.cs" />
    <Compile Include="Controllers\ImportExcelController.cs" />
    <Compile Include="Controllers\LoginController.cs" />
    <Compile Include="Controllers\MaterialManagerController.cs" />
    <Compile Include="Controllers\ProductModelController.cs" />
    <Compile Include="Controllers\SystemSettingController.cs" />
    <Compile Include="Controllers\ValuesController.cs" />
    <Compile Include="DLL\BLL\BasicSettingBLL.cs" />
    <Compile Include="DLL\BLL\DeviceManagerBLL.cs" />
    <Compile Include="DLL\BLL\ExcelCheckBLL.cs" />
    <Compile Include="DLL\BLL\LoginBLL.cs" />
    <Compile Include="DLL\BLL\MaterialManagerBLL.cs" />
    <Compile Include="DLL\BLL\ProductModelBLL.cs" />
    <Compile Include="DLL\BLL\SystemSettingBLL.cs" />
    <Compile Include="DLL\BLL\UserDataBLL.cs" />
    <Compile Include="DLL\DAL\BasicSettingDAL.cs" />
    <Compile Include="DLL\DAL\DeviceManagerDAL.cs" />
    <Compile Include="DLL\DAL\ExcelCheckDAL.cs" />
    <Compile Include="DLL\DAL\LoginDAL.cs" />
    <Compile Include="DLL\DAL\MaterialManagerDAL.cs" />
    <Compile Include="DLL\DAL\ProductModelDAL.cs" />
    <Compile Include="DLL\DAL\SystemSettingDAL.cs" />
    <Compile Include="DLL\DAL\UserDataDAL.cs" />
    <Compile Include="Global.asax.cs">
      <DependentUpon>Global.asax</DependentUpon>
    </Compile>
    <Compile Include="Models\ExcelErro.cs" />
    <Compile Include="Models\MaterialRout.cs" />
    <Compile Include="Models\ObjectData.cs" />
    <Compile Include="Models\ObjectDataCont.cs" />
    <Compile Include="Models\RoleUserSubmit.cs" />
    <Compile Include="Models\TreeDG.cs" />
    <Compile Include="Models\TreeDM.cs" />
    <Compile Include="Models\TreeObejct.cs" />
    <Compile Include="Models\Uom.cs" />
    <Compile Include="Models\User.cs" />
    <Compile Include="Properties\AssemblyInfo.cs" />
    <Compile Include="Tools\ChannelActionFilterAttribute.cs" />

 VueWebApi/Web.config

@@ -15,13 +15,13 @@
        <!--本地环境-->
        <!--<add key="DBServer" value="Data Source=.;Initial Catalog=vmes;Integrated Security=True" />-->
        <!--服务器环境-->
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602" />
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602;pooling=false" />
        <!--redis数据库链接配置ip-->
        <add key="RedisConnIp" value="127.0.0.1" />
        <!--redis数据库链接配置端口号-->
        <add key="RedisConnPort" value="6379" />
        <!--key失效时间30秒-->
        <add key="RedisKeyTimeCont" value="120" />
        <add key="RedisKeyTimeCont" value="30" />
        <!--Excel导出模板配置IP-->
        <add key="FileIP" value="http://121.196.36.24:8001/" />
        <add key="webpages:Version" value="3.0.0.0" />
@@ -35,9 +35,7 @@
        <httpRuntime targetFramework="4.6.1" />
        <!--session失效时间-->
        <sessionState mode="InProc" timeout="240">
            <providers>
                <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection"/>
            </providers>
        <!--<sessionState mode="Off">-->
        </sessionState>
    </system.web>
    <system.webServer>

 VueWebApi/bin/VueWebApi.dll.config

@@ -15,13 +15,13 @@
        <!--本地环境-->
        <!--<add key="DBServer" value="Data Source=.;Initial Catalog=vmes;Integrated Security=True" />-->
        <!--服务器环境-->
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602" />
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602;pooling=false" />
        <!--redis数据库链接配置ip-->
        <add key="RedisConnIp" value="127.0.0.1" />
        <!--redis数据库链接配置端口号-->
        <add key="RedisConnPort" value="6379" />
        <!--key失效时间30秒-->
        <add key="RedisKeyTimeCont" value="120" />
        <add key="RedisKeyTimeCont" value="30" />
        <!--Excel导出模板配置IP-->
        <add key="FileIP" value="http://121.196.36.24:8001/" />
        <add key="webpages:Version" value="3.0.0.0" />
@@ -35,9 +35,7 @@
        <httpRuntime targetFramework="4.6.1" />
        <!--session失效时间-->
        <sessionState mode="InProc" timeout="240">
            <providers>
                <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection"/>
            </providers>
        <!--<sessionState mode="Off">-->
        </sessionState>
    </system.web>
    <system.webServer>

 VueWebApi/bin/VueWebApi.pdb

Binary files differ

 VueWebApi/bin/VueWebApi.xml

@@ -600,7 +600,7 @@
        </member>
        <member name="M:VueWebApi.Controllers.BasicSettingController.RoleTypeSearch(System.Int32,System.Int32,System.String,System.String)">
            <summary>
            è§’色类型查询
            è§’色类型列表查询
            </summary>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
@@ -620,6 +620,12 @@
            è§’色类型删除
            </summary>
            <param name="RoleTypeCode">角色类型编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.BasicSettingController.RoleTypeSelect">
            <summary>
            è§’色类型下拉接口
            </summary>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.BasicSettingController.RoleSearch(System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
@@ -735,18 +741,61 @@
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.AddUpdateDeviceType(Newtonsoft.Json.Linq.JObject)">
        <member name="M:VueWebApi.Controllers.DeviceManagerController.AddUpdateDeviceType(System.Collections.Generic.List{VueWebApi.Models.ObjectDataCont})">
            <summary>
            è®¾å¤‡ç±»åž‹æ–°å¢ž
            </summary>
            <param name="obj">提交数据对象</param>
            <param name="json">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeleteDeviceType(System.String)">
            <summary>
            è®¾å¤‡ç±»åž‹åˆ é™¤
            </summary>
            <param name="devicetypeid">设备类型ID</param>
            <param name="devicetypecode">设备类型编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeviceTypeSelect">
            <summary>
            è®¾å¤‡ç±»åž‹ä¸‹æ‹‰æ¡†æŽ¥å£
            </summary>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeviceGroupSearch(System.Int32,System.Int32,System.String,System.String)">
            <summary>
            è®¾å¤‡ç»„查询
            </summary>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
            <param name="prop">排序字段</param>
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.AddUpdateDeviceGroup(System.Collections.Generic.List{VueWebApi.Models.ObjectDataCont})">
            <summary>
            è®¾å¤‡ç»„新增
            </summary>
            <param name="json">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeleteDeviceGroup(System.String)">
            <summary>
            è®¾å¤‡ç»„删除
            </summary>
            <param name="devicegroupcode">设备组编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeviceTypeSelectGroup(System.String)">
            <summary>
            è®¾å¤‡ç±»åž‹æŸ¥æ‰¾è®¾å¤‡ç»„
            </summary>
            <param name="eqptypecode">设备类型编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.WorkShopSelect">
            <summary>
            æ‰€å±žè½¦é—´ä¸‹æ‹‰æŽ¥å£
            </summary>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.DeviceManagerController.DeviceMangerSearch(System.String,System.String,System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
@@ -776,7 +825,7 @@
            <summary>
            è®¾å¤‡æ¸…单删除
            </summary>
            <param name="deviceid">设备ID</param>
            <param name="devicecode">设备编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ImportExcelController.DownLoadExcel(System.String)">
@@ -868,6 +917,170 @@
            <param name="usertype">操作端PC/APP</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.WareHouseDefSearch(System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
            <summary>
            ä»“库定义查询
            </summary>
            <param name="warehousecode">仓库编码</param>
            <param name="warehousename">仓库名称</param>
            <param name="description">仓库描述</param>
            <param name="createuser">创建人员</param>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
            <param name="prop">排序字段</param>
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.AddUpdateWareHouseDef(Newtonsoft.Json.Linq.JObject)">
            <summary>
            ä»“库定义新增编辑
            </summary>
            <param name="obj">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.DeleteWareHouseDef(System.String)">
            <summary>
            ä»“库删除
            </summary>
            <param name="warehousecode">仓库编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.WareHouseSelect">
            <summary>
            æ‰€å±žä»“库接口
            </summary>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.StorageDefSearch(System.String,System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
            <summary>
            åº“位定义查询
            </summary>
            <param name="storagecode">库位编码</param>
            <param name="storagename">库位名称</param>
            <param name="description">仓库描述</param>
            <param name="createuser">创建人员</param>
            <param name="stockcode">所属仓库编码</param>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
            <param name="prop">排序字段</param>
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.AddUpdateStorageDef(Newtonsoft.Json.Linq.JObject)">
            <summary>
            åº“位定义新增编辑
            </summary>
            <param name="obj">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.MaterialManagerController.DeleteStorageDef(System.String)">
            <summary>
            åº“位删除
            </summary>
            <param name="storagecode">库位编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.StockTypeSelect">
            <summary>
            å­˜è´§ç±»åž‹æŽ¥å£
            </summary>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.MaterialTypeSearch(System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
            <summary>
            ç‰©æ–™ç±»åž‹æŸ¥è¯¢
            </summary>
            <param name="materialtypecode">物料类型编码</param>
            <param name="materialtypename">物料类型名称</param>
            <param name="stocktypecode">存货类型编码</param>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
            <param name="prop">排序字段</param>
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.AddUpdateMaterialType(Newtonsoft.Json.Linq.JObject)">
            <summary>
            ç‰©æ–™ç±»åž‹æ–°å¢žç¼–辑
            </summary>
            <param name="obj">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.DeleteMaterialType(System.String)">
            <summary>
            ç‰©æ–™ç±»åž‹åˆ é™¤
            </summary>
            <param name="materialtypecode">物料类型编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.UomSearch(System.Int32,System.Int32,System.String,System.String)">
            <summary>
            å•ä½åˆ—表查询
            </summary>
            <param name="page">页码</param>
            <param name="rows">每页显示条数</param>
            <param name="prop">排序字段</param>
            <param name="order">排序规则</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.UomAdd(System.Collections.Generic.List{VueWebApi.Models.Uom})">
            <summary>
            å•ä½æ–°å¢ž
            </summary>
            <param name="json">单位提交数据</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.UomDelete(System.String)">
            <summary>
            å•ä½åˆ é™¤
            </summary>
            <param name="uomcode">单位编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.StockTypeSelectMaterialType(System.String)">
            <summary>
            å­˜ç±»åž‹æŸ¥æ‰¾ç‰©æ–™ç±»åž‹
            </summary>
            <param name="stocktypecode">存货类型编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.InventoryFileSelect(System.String,System.String,System.String,System.String,System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
            <summary>
            å­˜è´§æ¡£æ¡ˆæŸ¥è¯¢
            </summary>
            <param name="partcode"></param>
            <param name="partname"></param>
            <param name="partspec"></param>
            <param name="stocktypecode"></param>
            <param name="materialtypecode"></param>
            <param name="storehousecode"></param>
            <param name="page"></param>
            <param name="rows"></param>
            <param name="prop"></param>
            <param name="order"></param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.AddUpdateInventoryFile(Newtonsoft.Json.Linq.JObject)">
            <summary>
            å­˜è´§æ¡£æ¡ˆæ–°å¢žç¼–辑
            </summary>
            <param name="obj">提交数据对象</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.DeleteInventoryFile(System.String)">
            <summary>
            å­˜è´§æ¡£æ¡ˆåˆ é™¤
            </summary>
            <param name="materialcode">物料编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.ProductModelController.InventoryFileAssociationRoute(System.String)">
            <summary>
            å­˜è´§æ¡£æ¡ˆå…³è”工艺路线查询
            </summary>
            <param name="partcode">物料编码</param>
            <returns></returns>
        </member>
        <member name="M:VueWebApi.Controllers.SystemSettingController.EncodingRules(System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
            <summary>
            ç¼–码规则查询

 VueWebApi/obj/Debug/VueWebApi.csproj.AssemblyReference.cache

Binary files differ

 VueWebApi/obj/Debug/VueWebApi.csproj.CoreCompileInputs.cache

@@ -1 +1 @@
a8d5377e259202f5d8af99199b3a5c31575ca216
35bd76ae72fd355c9137f72fe96aec389f85212c

 VueWebApi/obj/Debug/VueWebApi.csproj.FileListAbsolute.txt

@@ -1,3 +1,6 @@
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OOXML.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OpenXml4Net.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OpenXmlFormats.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\VueWebApi.dll.config
D:\新凯迪MES\VueWebApi\VueWebApi\bin\VueWebApi.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\VueWebApi.dll
@@ -108,10 +111,7 @@
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OOXML.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OOXML.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OpenXml4Net.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OpenXml4Net.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\NPOI.OpenXmlFormats.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\bin\Pipelines.Sockets.Unofficial.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\ServiceStack.Common.xml
D:\新凯迪MES\VueWebApi\VueWebApi\bin\ServiceStack.Interfaces.xml
@@ -149,6 +149,7 @@
D:\新凯迪MES\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.resources.dll
D:\新凯迪MES\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Deployment.resources.dll
D:\新凯迪MES\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Razor.resources.dll
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Debug\VueWebApi.csproj.AssemblyReference.cache
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Debug\VueWebApi.csproj.CoreCompileInputs.cache
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Debug\VueWebApi.csproj.CopyComplete
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Debug\VueWebApi.dll

 VueWebApi/obj/Debug/VueWebApi.pdb

Binary files differ

 VueWebApi/obj/Release/Package/PackageTmp/Web.config

@@ -15,13 +15,13 @@
    <!--本地环境-->
    <!--<add key="DBServer" value="Data Source=.;Initial Catalog=vmes;Integrated Security=True" />-->
    <!--服务器环境-->
    <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602" />
    <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602;pooling=false" />
    <!--redis数据库链接配置ip-->
    <add key="RedisConnIp" value="127.0.0.1" />
    <!--redis数据库链接配置端口号-->
    <add key="RedisConnPort" value="6379" />
    <!--key失效时间30秒-->
    <add key="RedisKeyTimeCont" value="120" />
    <add key="RedisKeyTimeCont" value="30" />
    <!--Excel导出模板配置IP-->
    <add key="FileIP" value="http://121.196.36.24:8001/" />
    <add key="webpages:Version" value="3.0.0.0" />
@@ -35,9 +35,7 @@
    <httpRuntime targetFramework="4.6.1" />
    <!--session失效时间-->
    <sessionState mode="InProc" timeout="240">
      <providers>
        <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" />
      </providers>
      <!--<sessionState mode="Off">-->
    </sessionState>
  </system.web>
  <system.webServer>

 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb

Binary files differ

 VueWebApi/obj/Release/TransformWebConfig/original/Web.config

@@ -15,13 +15,13 @@
        <!--本地环境-->
        <!--<add key="DBServer" value="Data Source=.;Initial Catalog=vmes;Integrated Security=True" />-->
        <!--服务器环境-->
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602" />
        <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602;pooling=false" />
        <!--redis数据库链接配置ip-->
        <add key="RedisConnIp" value="127.0.0.1" />
        <!--redis数据库链接配置端口号-->
        <add key="RedisConnPort" value="6379" />
        <!--key失效时间30秒-->
        <add key="RedisKeyTimeCont" value="120" />
        <add key="RedisKeyTimeCont" value="30" />
        <!--Excel导出模板配置IP-->
        <add key="FileIP" value="http://121.196.36.24:8001/" />
        <add key="webpages:Version" value="3.0.0.0" />
@@ -35,9 +35,7 @@
        <httpRuntime targetFramework="4.6.1" />
        <!--session失效时间-->
        <sessionState mode="InProc" timeout="240">
            <providers>
                <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection"/>
            </providers>
        <!--<sessionState mode="Off">-->
        </sessionState>
    </system.web>
    <system.webServer>

 VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config

@@ -15,13 +15,13 @@
    <!--本地环境-->
    <!--<add key="DBServer" value="Data Source=.;Initial Catalog=vmes;Integrated Security=True" />-->
    <!--服务器环境-->
    <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602" />
    <add key="DBServer" value="Data Source=121.196.36.24;Initial Catalog=vmes;User ID=sa;Password=xkd@20220602;pooling=false" />
    <!--redis数据库链接配置ip-->
    <add key="RedisConnIp" value="127.0.0.1" />
    <!--redis数据库链接配置端口号-->
    <add key="RedisConnPort" value="6379" />
    <!--key失效时间30秒-->
    <add key="RedisKeyTimeCont" value="120" />
    <add key="RedisKeyTimeCont" value="30" />
    <!--Excel导出模板配置IP-->
    <add key="FileIP" value="http://121.196.36.24:8001/" />
    <add key="webpages:Version" value="3.0.0.0" />
@@ -35,9 +35,7 @@
    <httpRuntime targetFramework="4.6.1" />
    <!--session失效时间-->
    <sessionState mode="InProc" timeout="240">
      <providers>
        <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" />
      </providers>
      <!--<sessionState mode="Off">-->
    </sessionState>
  </system.web>
  <system.webServer>

 VueWebApi/obj/Release/VueWebApi.csproj.CoreCompileInputs.cache

@@ -1 +1 @@
c5c47174d1dabbc2afee4529f910c97bce066463
facf67c0e99c52b4a568e4dc312c32889b04f076

 VueWebApi/obj/Release/VueWebApi.pdb

Binary files differ