1.入库记录查询增加InOrdercode(erp单据号)字段
| | |
| | | //search = search.Substring(3);//截取索引2后面的字符 |
| | | // --------------查询指定数据-------------- |
| | | var total = 0; //总条数 |
| | | var sql = @"select (case when docu_typecode='69' then '产成品入库' end) as hbilltype,hbillno,hbdate,create_user,create_date |
| | | var sql = @"select (case when docu_typecode='69' then '产成品入库' end) as hbilltype,hbillno,InOrdercode,hbdate,create_user,create_date |
| | | from TK_WMS_Inwh_Main where 1=1 " + search; |
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
| | | mes.code = "200"; |