| | |
|---|
| | | double HBadQty = double.Parse(ds.Tables[0].Rows[0]["HBadQty"].ToString()); |
|---|
| | | double sumqty = HQty + HBadQty + HWasterQty; //汇报数量+不良+报废 |
|---|
| | | //更新产量装量临时表已汇报数量 |
|---|
| | | string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp set HRelationInterID=0,HSplitRelationQty=HSplitRelationQty-"+ sumqty + ",HDateFinishQty=HDateFinishQty-"+ sumqty + " where HInterID='" + HInterID + "' and HICMOInterID='"+ HICMOInterID + "' and HICMOEntryID='"+ HICMOEntryID + "'"); |
|---|
| | | string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp set HICMOStatus='1',HFinishFlag='0', HRelationInterID=0,HSplitRelationQty=HSplitRelationQty-" + sumqty + ",HDateFinishQty=HDateFinishQty-"+ sumqty + " where HICMOInterID='"+ HICMOInterID + "' and HICMOEntryID='"+ HICMOEntryID + "'"); |
|---|
| | | oCN.RunProc(sql1); |
|---|
| | | //更新切换状态值 |
|---|
| | | string sql = string.Format(@"delete Sc_ICMOBillWorkQtyStatus_Tmp where HInterID='" + HInterID + "'"); |
|---|
