安灯报表报错问题修改 设备点检标准导入，模板验证、数据验证接口开发

yl

2022-11-03 f10feb72cae8d10d2e05ca8919b791a8f38dd763

 VueWebApi/DLL/DAL/BasicSettingDAL.cs

@@ -1873,7 +1873,7 @@
                        left join (
                        select B.usercode   from  TAnDon_Roul_ConFig A
                        inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
                        where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and A.enable='Y'
                        where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
                        ) B  on A.usercode=B.usercode
                        where A.userclassid='0'";
                dynamicParams.Add("@wkshopcode", wkshopcode);
@@ -1920,30 +1920,19 @@
                dynamicParams.Add("@wkshopcode", wkshopcode);
                dynamicParams.Add("@calltypecode", calltypecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
                if (json == null || json.Rows.Count <= 0)
                if (data.Rows.Count > 0)
                {
                    //清除安灯、设备任务配置表数据
                    sql = @"delete TAnDon_Roul_ConFig where id=@mid";
                    list.Add(new { str = sql, parm = new { mid = mid } });
                    mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
                    //清除安灯、设备任务配置关联人员表数据
                    sql = @"delete TAnDon_Roul_ConFigUser  where ando_cogfigid=@mid";
                    list.Add(new { str = sql, parm = new { mid = mid } });
                }
                else
                else 
                {
                    //清除安灯、设备任务配置表数据
                    sql = @"delete TAnDon_Roul_ConFig where id=@mid";
                    list.Add(new { str = sql, parm = new { mid = mid } });
                    //清除安灯、设备任务配置关联人员表数据
                    sql = @"delete TAnDon_Roul_ConFigUser  where ando_cogfigid=@mid";
                    list.Add(new { str = sql, parm = new { mid = mid } });


                    //获取主表最大ID
                    sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_Record')+1,1) as id";
                    sql = @"select ISNULL(IDENT_CURRENT('TAnDon_Roul_ConFig')+1,1) as id";
                    var dt = DapperHelper.selecttable(sql);

                    mid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
                    //写入安灯、设备任务配置表数据
                    sql = @"insert into TAnDon_Roul_ConFig(wkshp_code,andotype_code,lm_user,lm_date,enable) values(@wkshp_code,@andotype_code,@lm_user,@lm_date,@enable)";
                    list.Add(new
@@ -1958,12 +1947,12 @@
                            enable = enable
                        }
                    });
                    //循环写入安灯、设备任务配置关联人员表
                    for (int i = 0; i < json.Rows.Count; i++)
                    {
                        sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,user_code) values(@usercode,@role_code)";
                        list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
                    }
                }
                //循环写入安灯、设备任务配置关联人员表
                for (int i = 0; i < json.Rows.Count; i++)
                {
                    sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,usercode) values(@ando_cogfigid,@role_code)";
                    list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
                }
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
@@ -2095,5 +2084,33 @@
            return mes;
        }
        #endregion


        #region[通过车间编码查找设备信息]
        public static ToMessage WhkspIsEqpSearch(string wkshpcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取设备下拉框数据
                sql = @"select code as eqp_code,name as eqp_name  
                            from TEqpInfo where wksp_code=@wkshpcode and enable='Y' ";
                dynamicParams.Add("@wkshpcode", wkshpcode);
                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
    }
}