| | |
|---|
| | | } |
|---|
| | | if (decimal.Parse(erpqty) == decimal.Parse(markqty) + decimal.Parse(relse_qty)) //如果ERP订单=下单数量+已下单数量,则更新ERP订单表状态为CREATED:已创建 |
|---|
| | | { |
|---|
| | | sql = @"update TKimp_Ewo set status='CREATED',relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid"; |
|---|
| | | sql = @"update TKimp_Ewo set status='CREATED',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
| | |
|---|
| | | { |
|---|
| | | wo = erpordercode, |
|---|
| | | erporderid = erporderid, |
|---|
| | | sumqty = sumqty |
|---|
| | | sumqty = sumqty, |
|---|
| | | saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate) |
|---|
| | | } |
|---|
| | | }); |
|---|
| | | } |
|---|
| | |
|---|
| | | mes.data = null; |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | |
|---|
| | | list.Clear(); |
|---|
| | | //写入设备任务(汇总表)用料 计划数量*子件基本用量*（1+损耗率）/母件基本用量 |
|---|
| | | sql = @"insert into TK_Wrk_EqpSum_Allo(m_id, seq, materiel_code, qty,wo_code,materieltype) |
|---|
