森楷其他入库扫描物料条码写入临时表,源单信息存入数据修改
| | |
| | | " select " + model.HInterID.ToString() + ",'" + model.HBillNo + "','" + model.HBillType + "',HMaterID,HAuxPropID," + model.HProcID.ToString() + |
| | | "," + model.HWhID.ToString() + "," + model.HSCWHID.ToString() + "," + model.HStockPlaceID.ToString() + "," + model.HOutStockPlaceID.ToString() + "," + model.HGroupID.ToString() + ",'" + model.HAddr + "'" + |
| | | "," + model.HQtyMust.ToString() + ",HQty," + model.HPieceQty.ToString() + ",HBatchNo,HBarCode,''" + |
| | | ",'" + model.HMaker + "',getdate()," + model.HSourceInterID.ToString() + "," + model.HSourceEntryID.ToString() + ",'" + model.HSourceBillType + "','" + model.HSourceBillNo + "'" + |
| | | ",'" + model.HMaker + "',getdate()" + |
| | | ",case when '" + model.HBillType + "'='1203' then HSourceInterID else " + model.HSourceInterID.ToString() + " end" + |
| | | ",case when '" + model.HBillType + "'='1203' then HSourceEntryID else " + model.HSourceEntryID.ToString() + " end" + |
| | | ",case when '" + model.HBillType + "'='1203' then HSourceBillType else '" + model.HSourceBillType + "' end" + |
| | | ",case when '" + model.HBillType + "'='1203' then HSourceBillNo else '" + model.HSourceBillNo + "' end" + |
| | | "," + model.HRelationInterID.ToString() + "," + model.HRelationEntryID.ToString() + ",'" + model.HRelationBillNo + "'," + Convert.ToString(model.HRedBlueFlag ? 1 : 0) + ",'" + model.HMTONo + "',0" + |
| | | "," + model.HSTOCKORGID.ToString() + "," + model.HOWNERID.ToString() + "," + model.HSTOCKORGID.ToString() + ",'','','" + model.HSubBillType + "'" + |
| | | ",0,0,'" + model.HCusBarCode + "'," + model.HMulSourceBill.ToString() + |