| | |
|---|
| | | //search = search.Substring(3);//截取索引2后面的字符 |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit from TRight A |
|---|
| | | var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit,A.Type from TRight A |
|---|
| | | left join T_CodeRules B on A.right_code=B.rightcode |
|---|
| | | where A.Type='PC' and A.parent_id<>'0' and A.is_delete<>'1' " + search + ""; |
|---|
| | | where A.parent_id<>'0' and A.is_delete<>'1' " + search + ""; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
