生产开报工接口提交

yl

2022-07-08 350aef928584da9bb91d2de8646ce42e1f5758c1

 VueWebApi/DLL/DAL/SystemSettingDAL.cs

@@ -45,7 +45,7 @@
                var total = 0; //总条数
                var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit  from TRight A
                     left join T_CodeRules B on A.right_code=B.rightcode
                     where "+search+" and A.Type='PC' and A.parent_id<>'0' order by A.right_code,A.right_seq ";
                     where A.Type='PC' and A.parent_id<>'0' " + search + "";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
@@ -76,7 +76,7 @@
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where right_code=@rightcode";
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
                    dynamicParams.Add("@prefix", prefix);
                    dynamicParams.Add("@filingdate", filingdate);
                    dynamicParams.Add("@incbit", incbit);