| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | break; |
| | | case "年月": |
| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | break; |
| | | case "年": |
| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | |
| | | break; |
| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | break; |
| | | case "年月": |
| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | break; |
| | | case "年": |
| | |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "失败!"; |
| | | mes.data = null; |
| | | } |
| | | break; |
| | | default: |
| | |
| | | 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; |
| | | } |
| | |
| | | //第一层 |
| | | 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); |
| | |
| | | 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++) |
| | | { |
| | |
| | | //第一层 |
| | | 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>(); |
| | |
| | | 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++) |
| | | { |