| | |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | 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 |
|---|
| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //获取采购订单物料信息 |
|---|
| | | sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity, |
|---|
| | | sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,A.countreturnquantity, |
|---|
| | | A.acceptdate,S.name as housename,M.is_incheck |
|---|
| | | from T_PurchaseOrder_sub A |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
