| | |
|---|
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 "); |
|---|
| | | |
|---|
| | | //鍥炲～婧愬崟涓存椂琛℉InterID |
|---|
| | | oCn.RunProc("update a set a.HInterID=" + HInterID.ToString() + " from KF_WeighSource_Temp a where a.HInterID<>" + HInterID.ToString() + " and a.HMaker='" + HMaker + "' and convert(varchar(10),a.HMakeDate,120)=convert(varchar(10),getdate(),120)"); |
|---|
| | | oCn.RunProc("update a set a.HInterID=" + HInterID.ToString() + ",a.HBillNo='" + HBillNo + "' from KF_WeighSource_Temp a where a.HInterID<>" + HInterID.ToString() + " and a.HMaker='" + HMaker + "' and convert(varchar(10),a.HMakeDate,120)=convert(varchar(10),getdate(),120)"); |
|---|
| | | |
|---|
| | | //鍐欏叆鏉＄爜鍑哄叆搴撲复鏃惰〃 |
|---|
| | | oCn.RunProc("Insert into KF_PonderationBillMain_Temp " + |
|---|
