| | |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select case when A.status='NEW' then '新订单' when A.status='CHECK' then '已审核' when A.status='CLOSED' then '已关闭' end as status, |
|---|
| | | A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate |
|---|
| | | var sql = @"select A.status,A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate |
|---|
| | | from T_PurchaseOrder A |
|---|
| | | left join TOrganization T on A.departmentcode=T.org_code |
|---|
| | | left join TCustomer C on A.customercode=C.code |
|---|
