| | |
| | | { |
| | | public Model.ClsSc_ProcessExchangeBillMain omodel = new Model.ClsSc_ProcessExchangeBillMain(); |
| | | public List<Model.ClsSc_ProcessExchangeBillSub> DetailColl = new List<Model.ClsSc_ProcessExchangeBillSub>(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | public ClsSc_ProcessExchangeBill() |
| | | { |
| | |
| | | |
| | | sErr = sErr + "7;"; |
| | | |
| | | //å·¥åºæµè½¬å¡ä¿åæ¶èªå¨åæ¥æ¡ç ä¿¡æ¯è³æ¡ç æ¡£æ¡(Y èªå¨åæ¥) |
| | | //è·åç³»ç»åæ° |
| | | string sErrMsg = ""; |
| | | if (oSystemParameter.ShowBillByOrgID(omodel.HPRDORGID, ref sErrMsg) == true) |
| | | { |
| | | if (oSystemParameter.omodel.Sc_ProcessExchangeBill_AutoBarCode == "Y") //ç³»ç»åæ° å·¥åºæµè½¬å¡ä¿åæ¶èªå¨åæ¥æ¡ç ä¿¡æ¯è³æ¡ç æ¡£æ¡ |
| | | { |
| | | oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty" + |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark" + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate" + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag" + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" + |
| | | ") values (" |
| | | + "'" + omodel.HBillNo + "','å¯ä¸æ¡ç '," + omodel.HMaterID.ToString() + "," + omodel.HUnitID.ToString() + "," + omodel.HQty.ToString() |
| | | + ",'" + omodel.HBatchNo + "'," + omodel.HSupID.ToString() + ",0,'" + omodel.HMaker + "',getdate(),0," + omodel.HQty.ToString() |
| | | + ", " + omodel.HInterID.ToString() + ",1,'" + omodel.HBillNo + "','3772',''" |
| | | + ",1,1,0,0,0,'å·¥åºæµè½¬å¡ä¿åèªå¨åæ¥'" |
| | | + ",0,'',getdate(),'',getdate()" |
| | | + ", " + omodel.HPRDORGID + "," + omodel.HPRDORGID + ",'',0,0" |
| | | + ",'','','',0,'','')"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sReturn = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErrMsg; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | |
| | | // |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |