设备点检标准(查询、新增、编辑、删除、查看)接口开发

yl

2022-08-17 3e783ac35c550b1d823f11dacb029885a6c760fe

设备点检标准(查询、新增、编辑、删除、查看)接口开发

 .vs/VueWebApi/v16/.suo

Binary files differ

 VueWebApi/Controllers/DeviceManagerController.cs

@@ -397,5 +397,90 @@
        }
        #endregion


        #region[设备点检标准列表查询]
        /// <summary>
        /// 设备点检标准列表查询
        /// </summary>
        /// <param name="checkstandcode">点检标准编码</param>
        /// <param name="checkstandname">点检标准名称</param>
        /// <param name="checkcontr">点检管控</param>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "DeviceCheckStandArdSearch")]
        [HttpGet]
        public HttpResponseMessage DeviceCheckStandArdSearch(string checkstandcode = null, string checkstandname = null, string checkcontr = 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 = DeviceManagerBLL.DeviceCheckStandArdSearch(checkstandcode, checkstandname, checkcontr, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备点检标准新增、编辑获取检验项目下拉列表]
        /// <summary>
        /// 设备点检标准新增、编辑获取检验项目下拉列表
        /// </summary>
        /// <returns></returns>
        [Route(template: "DeviceCheckItemSelect")]
        [HttpGet]
        public HttpResponseMessage DeviceCheckItemSelect()
        {
            mes = DeviceManagerBLL.DeviceCheckItemSelect();
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备点检标准编辑/查看获取数据]
        /// <summary>
        /// 设备点检标准编辑/查看获取数据
        /// </summary>
        /// <param name="checkstand_code">设备点检标准编码</param>
        /// <returns></returns>
        [Route(template: "ViewDeviceCheckStanedSearch")]
        [HttpPost]
        public HttpResponseMessage ViewDeviceCheckStanedSearch(string checkstand_code)
        {
            mes = DeviceManagerBLL.ViewDeviceCheckStanedSearch(checkstand_code);
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备点检标准新增编辑]
        /// <summary>
        /// 设备点检标准新增编辑
        /// </summary>
        /// <param name="opertype">操作类型</param>
        /// <param name="json">提交数据</param>
        /// <returns></returns>
        [Route(template: "AddUpdateDeviceCheckStandArd")]
        [HttpPost]
        public HttpResponseMessage AddUpdateDeviceCheckStandArd(string opertype, RoutEdit json)
        {
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            mes = DeviceManagerBLL.AddUpdateDeviceCheckStandArd(opertype, json, username);
            return TJson.toJson(mes);
        }
        #endregion

        #region[设备点检标准删除]
        /// <summary>
        /// 设备点检标准删除
        /// </summary>
        /// <param name="checkstand_code">设备点检标准编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceCheckStaned")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceCheckStaned(string checkstand_code)
        {
            mes = DeviceManagerBLL.DeleteDeviceCheckStaned(checkstand_code);
            return TJson.toJson(mes);
        }
        #endregion

    }
}

 VueWebApi/Controllers/QualityManagementController.cs

@@ -137,7 +137,7 @@
        /// <summary>
        /// 工序检验标准删除
        /// </summary>
        /// <param name="stanedcode">stanedcode</param>
        /// <param name="stanedcode">工序检验标准删除</param>
        /// <returns></returns>
        [Route(template: "DeleteStepCheckStaned")]
        [HttpPost]

 VueWebApi/DLL/BLL/DeviceManagerBLL.cs

@@ -148,5 +148,42 @@
            return DeviceManagerDAL.DeleteDeviceMaiItem(maiitemcode);
        }
        #endregion



        #region[设备点检标准列表查询]
        public static ToMessage DeviceCheckStandArdSearch(string checkstandcode, string checkstandname, string checkcontr, int startNum, int endNum, string prop, string order)
        {
            return DeviceManagerDAL.DeviceCheckStandArdSearch(checkstandcode, checkstandname, checkcontr, startNum, endNum, prop, order);
        }
        #endregion

        #region[设备点检标准新增、编辑获取检验项目下拉列表]
        public static ToMessage DeviceCheckItemSelect()
        {
            return DeviceManagerDAL.DeviceCheckItemSelect();
        }
        #endregion

        #region[设备点检标准编辑/查看获取数据]
        public static ToMessage ViewDeviceCheckStanedSearch(string checkstand_code)
        {
            return DeviceManagerDAL.ViewDeviceCheckStanedSearch(checkstand_code);
        }
        #endregion

        #region[设备点检标准新增编辑]
        public static ToMessage AddUpdateDeviceCheckStandArd(string opertype, RoutEdit json, string username)
        {
            return DeviceManagerDAL.AddUpdateDeviceCheckStandArd(opertype, json, username);
        }
        #endregion

        #region[设备点检标准删除]
        public static ToMessage DeleteDeviceCheckStaned(string checkstand_code)
        {
            return DeviceManagerDAL.DeleteDeviceCheckStaned(checkstand_code);
        }
        #endregion
    }
}

 VueWebApi/DLL/DAL/DeviceManagerDAL.cs

@@ -648,7 +648,7 @@


        #region[设备点检项列表查询]
        public static ToMessage DeviceCheckItemSearch(string checkitemcode, string checkitemname, string checkdescr, string isqrcode,string cycle, int startNum, int endNum, string prop, string order)
        public static ToMessage DeviceCheckItemSearch(string checkitemcode, string checkitemname, string checkdescr, string isqrcode, string cycle, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
@@ -800,7 +800,7 @@
                    mes.data = null;
                    return mes;
                }
               

                //删除点检项目
                sql = @"delete TEqpchk_Item  where code=@checkitemcode";
                list.Add(new { str = sql, parm = new { checkitemcode = checkitemcode } });
@@ -1018,5 +1018,294 @@
            return mes;
        }
        #endregion



        #region[设备点检标准列表查询]
        public static ToMessage DeviceCheckStandArdSearch(string checkstandcode, string checkstandname, string checkcontr, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (checkstandcode != "" && checkstandcode != null)
                {
                    search += "and code like '%'+@checkstandcode+'%' ";
                    dynamicParams.Add("@checkstandcode", checkstandcode);
                }
                if (checkstandname != "" && checkstandname != null)
                {
                    search += "and name like '%'+@checkstandname+'%' ";
                    dynamicParams.Add("@checkstandname", checkstandname);
                }
                if (checkcontr != "" && checkcontr != null)
                {
                    search += "and iscontr=@checkcontr ";
                    dynamicParams.Add("@checkcontr", checkcontr);
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                //search = search.Substring(3);//截取索引2后面的字符
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select id,code,name,description,iscontr,is_checkeqp,lm_user,lm_date 
                            from TEqpchk_Main 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 DeviceCheckItemSelect()
        {
            string sql = "";
            try
            {
                //获取设备点检项目数据
                sql = @"select code,name,description from TEqpchk_Item 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 ViewDeviceCheckStanedSearch(string checkstand_code)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取设备点检标准信息
                sql = @"select code,name,description,iscontr
                        from TEqpchk_Main
                        where code=@checkstand_code and is_delete<>'1'";
                dynamicParams.Add("@checkstand_code", checkstand_code);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                RoutEdit rout = new RoutEdit();
                if (data.Rows.Count > 0)
                {
                    rout.code = data.Rows[0]["CODE"].ToString();
                    rout.name = data.Rows[0]["NAME"].ToString();
                    rout.description = data.Rows[0]["DESCRIPTION"].ToString();
                    rout.enable = data.Rows[0]["ISCONTR"].ToString();
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "无点检标准信息!";
                    mes.data = null;
                    return mes;
                }
                //根据设备点检标准编码获取关联的检验项目信息
                sql = @"select B.code,B.name,A.chkdesc,A.isscan,A.cycle  from TEqpchk_Deta A
                        left join TEqpchk_Item  B on A.code=B.code
                        where  A.eqpcheck_main_code=@checkstaned_code order by A.seq asc";
                dynamicParams.Add("@checkstaned_code", rout.code);
                var data0 = DapperHelper.selectdata(sql, dynamicParams);
                rout.Data = data0;

                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = rout;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[设备点检标准新增编辑]
        public static ToMessage AddUpdateDeviceCheckStandArd(string opertype, RoutEdit json, string username)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            List<object> list = new List<object>();
            try
            {
                if (opertype == "Add")
                {
                    //新增设备点检标准主表
                    sql = @"insert into TEqpchk_Main(code,name,description,iscontr,lm_user,lm_date) values(@code,@name,@descr,@lm_user,@lm_date)";
                    list.Add(new { str = sql, parm = new { code = json.code, name = json.name, descr = json.description, iscontr = json.enable, lm_user = username, lm_date = DateTime.Now.ToString() } });
                    for (int i = 0; i < json.Data.Rows.Count; i++)
                    {
                        //新增设备点检标准关联点检项子表
                        sql = @"insert TEqpchk_Deta (seq,code,name,eqpchk_main_code,cycle,chkdesc,isscan,lm_user,lm_date) 
                                values(@checkitem_seq,@checkitem_code,@checkitem_name,@code,@cycle,@chkdesc,@isscan,@lm_user,@lm_date)";
                        list.Add(new
                        {
                            str = sql,
                            parm = new
                            {
                                checkitem_seq = Convert.ToInt32(json.Data.Rows[i]["CHECKITEM_SEQ"].ToString()),
                                checkitem_code = json.Data.Rows[i]["CHECKITEM_CODE"].ToString(),
                                checkitem_name = json.Data.Rows[i]["CHECKITEM_NAME"].ToString(),
                                code = json.code,
                                cycle = json.Data.Rows[i]["CYCLE"].ToString(),
                                chkdesc= json.Data.Rows[i]["CHECKITEM_DESCR"].ToString(),
                                isscan= json.Data.Rows[i]["ISSCAN"].ToString(),
                                lm_user = username,
                                lm_date = 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;
                    }
                }
                if (opertype == "Update")
                {
                    //删除点检标准关联点检项目子表
                    sql = @"delete from TEqpchk_Deta where eqpchk_main_code=@checkstaned_code";
                    list.Add(new { str = sql, parm = new { checkstaned_code = json.code } });
                    //修改点检标准主表
                    sql = @"update  TEqpchk_Main set name=@checkstaned_name,description=@checkstaned_desc,iscontr=@iscontr where code=@checkstaned_code";
                    list.Add(new { str = sql, parm = new { checkstaned_code = json.code, checkstaned_name = json.name, checkstaned_desc = json.description } });
                    //新增点检标准关联点检项目子表
                    for (int i = 0; i < json.Data.Rows.Count; i++)
                    {
                        sql = @"insert TEqpchk_Deta (seq,code,name,eqpchk_main_code,cycle,chkdesc,isscan,lm_user,lm_date) 
                                values(@checkitem_seq,@checkitem_code,@checkitem_name,@code,@cycle,@chkdesc,@isscan,@lm_user,@lm_date)";
                        list.Add(new
                        {
                            str = sql,
                            parm = new
                            {
                                checkitem_seq = Convert.ToInt32(json.Data.Rows[i]["CHECKITEM_SEQ"].ToString()),
                                checkitem_code = json.Data.Rows[i]["CHECKITEM_CODE"].ToString(),
                                checkitem_name = json.Data.Rows[i]["CHECKITEM_NAME"].ToString(),
                                code = json.code,
                                cycle = json.Data.Rows[i]["CYCLE"].ToString(),
                                chkdesc = json.Data.Rows[i]["CHECKITEM_DESCR"].ToString(),
                                isscan = json.Data.Rows[i]["ISSCAN"].ToString(),
                                lm_user = username,
                                lm_date = 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 DeleteDeviceCheckStaned(string checkstand_code)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select * from  TEqpchk_Proc_Main  where eqpchkmain_code=@checkstand_code";
                dynamicParams.Add("@checkstand_code", checkstand_code);
                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 = @"delete TEqpchk_Main  where code=@checkstand_code";
                list.Add(new { str = sql, parm = new { checkstand_code = checkstand_code } });
                //删除设备点检标准关联点检项目子表
                sql = @"delete TEqpchk_Deta  where eqpchk_main_code=@checkstand_code";
                list.Add(new { str = sql, parm = new { checkstand_code = checkstand_code } });

                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/QualityManagementDAL.cs

@@ -400,14 +400,14 @@
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.Message = "操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.Message = "操作失败!";
                        mes.data = null;
                    }
                }
@@ -433,14 +433,14 @@
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.Message = "操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.Message = "操作失败!";
                        mes.data = null;
                    }
                }
@@ -636,8 +636,6 @@
            return mes;
        }
        #endregion



    }
}