VueWebApi/Tools/SeachEncode.cs
@@ -81,7 +81,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
                            case "年月":
@@ -126,7 +128,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
                            case "年":
@@ -169,7 +173,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
@@ -223,7 +229,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
                            case "年月":
@@ -268,7 +276,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
                            case "年":
@@ -311,7 +321,9 @@
                                else
                                {
                                    mes.code = "300";
                                    mes.count = 0;
                                    mes.Message = "失败!";
                                    mes.data = null;
                                }
                                break;
                            default:
@@ -322,13 +334,17 @@
                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;
        }
@@ -353,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);
@@ -396,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++)
                        {
@@ -416,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>();
@@ -459,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++)
                        {