| | |
| | | //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 = "查询成功!"; |
| | |
| | | #endregion |
| | | |
| | | |
| | | #region[生成系统条码(自定义)] |
| | | public static ToMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty) |
| | | { |
| | | mes = AppLableBarCode.EncodingSeach(rightcode, partcode, qty, onelabqty); |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[车间公告列表] |
| | | public static ToMessage SystemAnnouncementSearch(string wkspcode, string ancetitle, string ancecont, string cancel, string level, int startNum, int endNum, string prop, string order) |
| | | { |