| | |
| | | lineone.children = new List<TreeTwo>(); |
| | | |
| | | //查新工单下工序信息 |
| | | sql = @"select A.seq,T.stepcode,T.stepname,A.plan_qty,A.good_qty,A.ng_qty,A.status |
| | | sql = @"select A.seq,T.stepcode,T.stepname,A.plan_qty,A.start_qty,A.good_qty,A.ng_qty,A.status |
| | | from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | where A.wo_code=@wo_code"; |
| | |
| | | string stepcode = data1.Rows[k]["STEPCODE"].ToString();//工序编码 |
| | | string stepname = data1.Rows[k]["STEPNAME"].ToString();//工序名称 |
| | | string planqty = data1.Rows[k]["PLAN_QTY"].ToString();//任务数量 |
| | | string startqty = data1.Rows[k]["START_QTY"].ToString();//开工数量 |
| | | string good_qty = data1.Rows[k]["GOOD_QTY"].ToString();//报工数量 |
| | | string ng_qty = data1.Rows[k]["NG_QTY"].ToString();//不良数量 |
| | | string status = data1.Rows[k]["STATUS"].ToString();//状态 |
| | |
| | | linetwo.stepcode = stepcode; |
| | | linetwo.stepname = stepname; |
| | | linetwo.planqty = planqty; |
| | | linetwo.startqty = startqty; |
| | | linetwo.goodqty = good_qty; |
| | | linetwo.ngqty = ng_qty; |
| | | linetwo.status = status; |