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

yl

2022-06-22 7a0d98456b4ecaf1867cd62ecb7c8169ec15d042

 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++)
                        {