| | |
|---|
| | | } |
|---|
| | | if (creatuser != "" && creatuser != null) |
|---|
| | | { |
|---|
| | | search += "and U.username like '%'+@creatuser+'%' "; |
|---|
| | | search += "and A.createuser like '%'+@creatuser+'%' "; |
|---|
| | | dynamicParams.Add("@creatuser", creatuser); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.id, A.status,A.wo,A.materiel_code as partcode,B.partname,B.partspec,A.qty,A.relse_qty,A.wkshp_code,C.org_name as wkshp_name, |
|---|
| | | A.stck_code,D.name as stck_name,A.planstartdate,A.planenddate,U.username as createuser,A.createdate |
|---|
| | | A.stck_code,D.name as stck_name,A.planstartdate,A.planenddate,A.createuser as createuser,A.createdate |
|---|
| | | from TKimp_Ewo A |
|---|
| | | left join TMateriel_Info B on A.materiel_code=B.partcode |
|---|
| | | left join TOrganization C on A.wkshp_code=C.org_code |
|---|
| | | left join T_Sec_Stck D on A.stck_code=D.code |
|---|
| | | left join TUser U on A.createuser=U.usercode |
|---|
| | | left join T_Sec_Stck D on A.stck_code=D.code |
|---|
| | | where A.is_delete<>'1' " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
