| | |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select * from( |
|---|
| | | select W.wkshp_code,L.org_name as wkshp_name,A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,P.plan_qty,A.defect_qty, |
|---|
| | | select W.wkshp_code,L.org_name as wkshp_name,A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,P.plan_qty,A.defect_qty,A.defect_pendqty,A.bad_qty, |
|---|
| | | A.defect_code, |
|---|
| | | STUFF((SELECT ',' + P.name |
|---|
| | | FROM TDefect P |
|---|
| | |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select AA.wkshp_code as 车间编码,AA.wkshp_name as 车间名称,AA.wo_code as 工单编号,AA.partcode as 产品编码,AA.partname as 产品名称,AA.partspec as 产品规格,AA.stepcode as 工序编码, |
|---|
| | | AA.stepname as 工序名称,AA.plan_qty as 任务数量,AA.defect_qty as 不良数量,AA.defect_code as 缺陷代码,AA.defect_name as 缺陷名称, |
|---|
| | | AA.stepname as 工序名称,AA.plan_qty as 任务数量,AA.defect_qty as 不良数量,A.defect_pendqty as 不良待处理数量,A.bad_qty as 报废数量,AA.defect_code as 缺陷代码,AA.defect_name as 缺陷名称, |
|---|
| | | (case when AA.style='B' then '报工' when AA.style='S' then '收料' end) as '操作类型',AA.username as 操作人员,AA.lm_date as 操作时间 |
|---|
| | | from( |
|---|
| | | select W.wkshp_code,L.org_name as wkshp_name,A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,P.plan_qty,A.defect_qty, |
|---|
