/// <summary> /// 增加一条数据 /// </summary> public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords01 model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.AutoID != null) { strSql1.Append("AutoID,"); strSql2.Append("" + model.AutoID + ","); } if (model.ID != null) { strSql1.Append("ID,"); strSql2.Append("" + model.ID + ","); } if (model.cInvCode != null) { strSql1.Append("cInvCode,"); strSql2.Append("'" + model.cInvCode + "',"); } if (model.iNum != null) { strSql1.Append("iNum,"); strSql2.Append("" + model.iNum + ","); } if (model.iQuantity != null) { strSql1.Append("iQuantity,"); strSql2.Append("" + model.iQuantity + ","); } if (model.iUnitCost != null) { strSql1.Append("iUnitCost,"); strSql2.Append("" + model.iUnitCost + ","); } if (model.iPrice != null) { strSql1.Append("iPrice,"); strSql2.Append("" + model.iPrice + ","); } if (model.iAPrice != null) { strSql1.Append("iAPrice,"); strSql2.Append("" + model.iAPrice + ","); } if (model.iPUnitCost != null) { strSql1.Append("iPUnitCost,"); strSql2.Append("" + model.iPUnitCost + ","); } if (model.iPPrice != null) { strSql1.Append("iPPrice,"); strSql2.Append("" + model.iPPrice + ","); } if (model.cBatch != null) { strSql1.Append("cBatch,"); strSql2.Append("'" + model.cBatch + "',"); } if (model.cVouchCode != null) { strSql1.Append("cVouchCode,"); strSql2.Append("" + model.cVouchCode + ","); } if (model.cInVouchCode != null) { strSql1.Append("cInVouchCode,"); strSql2.Append("'" + model.cInVouchCode + "',"); } if (model.cinvouchtype != null) { strSql1.Append("cinvouchtype,"); strSql2.Append("'" + model.cinvouchtype + "',"); } if (model.iSOutQuantity != null) { strSql1.Append("iSOutQuantity,"); strSql2.Append("" + model.iSOutQuantity + ","); } if (model.iSOutNum != null) { strSql1.Append("iSOutNum,"); strSql2.Append("" + model.iSOutNum + ","); } if (model.cFree1 != null) { strSql1.Append("cFree1,"); strSql2.Append("'" + model.cFree1 + "',"); } if (model.cFree2 != null) { strSql1.Append("cFree2,"); strSql2.Append("'" + model.cFree2 + "',"); } if (model.iFlag != null) { strSql1.Append("iFlag,"); strSql2.Append("" + model.iFlag + ","); } if (model.dSDate != null) { strSql1.Append("dSDate,"); strSql2.Append("'" + model.dSDate + "',"); } if (model.iTax != null) { strSql1.Append("iTax,"); strSql2.Append("" + model.iTax + ","); } if (model.iSQuantity != null) { strSql1.Append("iSQuantity,"); strSql2.Append("" + model.iSQuantity + ","); } if (model.iSNum != null) { strSql1.Append("iSNum,"); strSql2.Append("" + model.iSNum + ","); } if (model.iMoney != null) { strSql1.Append("iMoney,"); strSql2.Append("" + model.iMoney + ","); } if (model.iFNum != null) { strSql1.Append("iFNum,"); strSql2.Append("" + model.iFNum + ","); } if (model.iFQuantity != null) { strSql1.Append("iFQuantity,"); strSql2.Append("" + model.iFQuantity + ","); } if (model.dVDate != null) { strSql1.Append("dVDate,"); strSql2.Append("'" + model.dVDate + "',"); } if (model.cPosition != null) { strSql1.Append("cPosition,"); strSql2.Append("'" + model.cPosition + "',"); } if (model.cDefine22 != null) { strSql1.Append("cDefine22,"); strSql2.Append("'" + model.cDefine22 + "',"); } if (model.cDefine23 != null) { strSql1.Append("cDefine23,"); strSql2.Append("'" + model.cDefine23 + "',"); } if (model.cDefine24 != null) { strSql1.Append("cDefine24,"); strSql2.Append("'" + model.cDefine24 + "',"); } if (model.cDefine25 != null) { strSql1.Append("cDefine25,"); strSql2.Append("'" + model.cDefine25 + "',"); } if (model.cDefine26 != null) { strSql1.Append("cDefine26,"); strSql2.Append("" + model.cDefine26 + ","); } if (model.cDefine27 != null) { strSql1.Append("cDefine27,"); strSql2.Append("" + model.cDefine27 + ","); } if (model.cItem_class != null) { strSql1.Append("cItem_class,"); strSql2.Append("'" + model.cItem_class + "',"); } if (model.cItemCode != null) { strSql1.Append("cItemCode,"); strSql2.Append("'" + model.cItemCode + "',"); } if (model.iPOsID != null) { strSql1.Append("iPOsID,"); strSql2.Append("" + model.iPOsID + ","); } if (model.fACost != null) { strSql1.Append("fACost,"); strSql2.Append("" + model.fACost + ","); } if (model.cName != null) { strSql1.Append("cName,"); strSql2.Append("'" + model.cName + "',"); } if (model.cItemCName != null) { strSql1.Append("cItemCName,"); strSql2.Append("'" + model.cItemCName + "',"); } if (model.cFree3 != null) { strSql1.Append("cFree3,"); strSql2.Append("'" + model.cFree3 + "',"); } if (model.cFree4 != null) { strSql1.Append("cFree4,"); strSql2.Append("'" + model.cFree4 + "',"); } if (model.cFree5 != null) { strSql1.Append("cFree5,"); strSql2.Append("'" + model.cFree5 + "',"); } if (model.cFree6 != null) { strSql1.Append("cFree6,"); strSql2.Append("'" + model.cFree6 + "',"); } if (model.cFree7 != null) { strSql1.Append("cFree7,"); strSql2.Append("'" + model.cFree7 + "',"); } if (model.cFree8 != null) { strSql1.Append("cFree8,"); strSql2.Append("'" + model.cFree8 + "',"); } if (model.cFree9 != null) { strSql1.Append("cFree9,"); strSql2.Append("'" + model.cFree9 + "',"); } if (model.cFree10 != null) { strSql1.Append("cFree10,"); strSql2.Append("'" + model.cFree10 + "',"); } if (model.cBarCode != null) { strSql1.Append("cBarCode,"); strSql2.Append("'" + model.cBarCode + "',"); } if (model.iNQuantity != null) { strSql1.Append("iNQuantity,"); strSql2.Append("" + model.iNQuantity + ","); } if (model.iNNum != null) { strSql1.Append("iNNum,"); strSql2.Append("" + model.iNNum + ","); } if (model.cAssUnit != null) { strSql1.Append("cAssUnit,"); strSql2.Append("'" + model.cAssUnit + "',"); } if (model.dMadeDate != null) { strSql1.Append("dMadeDate,"); strSql2.Append("'" + model.dMadeDate + "',"); } if (model.iMassDate != null) { strSql1.Append("iMassDate,"); strSql2.Append("" + model.iMassDate + ","); } if (model.cDefine28 != null) { strSql1.Append("cDefine28,"); strSql2.Append("'" + model.cDefine28 + "',"); } if (model.cDefine29 != null) { strSql1.Append("cDefine29,"); strSql2.Append("'" + model.cDefine29 + "',"); } if (model.cDefine30 != null) { strSql1.Append("cDefine30,"); strSql2.Append("'" + model.cDefine30 + "',"); } if (model.cDefine31 != null) { strSql1.Append("cDefine31,"); strSql2.Append("'" + model.cDefine31 + "',"); } if (model.cDefine32 != null) { strSql1.Append("cDefine32,"); strSql2.Append("'" + model.cDefine32 + "',"); } if (model.cDefine33 != null) { strSql1.Append("cDefine33,"); strSql2.Append("'" + model.cDefine33 + "',"); } if (model.cDefine34 != null) { strSql1.Append("cDefine34,"); strSql2.Append("" + model.cDefine34 + ","); } if (model.cDefine35 != null) { strSql1.Append("cDefine35,"); strSql2.Append("" + model.cDefine35 + ","); } if (model.cDefine36 != null) { strSql1.Append("cDefine36,"); strSql2.Append("'" + model.cDefine36 + "',"); } if (model.cDefine37 != null) { strSql1.Append("cDefine37,"); strSql2.Append("'" + model.cDefine37 + "',"); } if (model.iCheckIds != null) { strSql1.Append("iCheckIds,"); strSql2.Append("" + model.iCheckIds + ","); } if (model.cBVencode != null) { strSql1.Append("cBVencode,"); strSql2.Append("'" + model.cBVencode + "',"); } if (model.chVencode != null) { strSql1.Append("chVencode,"); strSql2.Append("'" + model.chVencode + "',"); } if (model.bGsp != null) { strSql1.Append("bGsp,"); strSql2.Append("" + (model.bGsp ? 1 : 0) + ","); } if (model.cGspState != null) { strSql1.Append("cGspState,"); strSql2.Append("'" + model.cGspState + "',"); } if (model.iArrsId != null) { strSql1.Append("iArrsId,"); strSql2.Append("" + model.iArrsId + ","); } if (model.cCheckCode != null) { strSql1.Append("cCheckCode,"); strSql2.Append("'" + model.cCheckCode + "',"); } if (model.iCheckIdBaks != null) { strSql1.Append("iCheckIdBaks,"); strSql2.Append("" + model.iCheckIdBaks + ","); } if (model.cRejectCode != null) { strSql1.Append("cRejectCode,"); strSql2.Append("'" + model.cRejectCode + "',"); } if (model.iRejectIds != null) { strSql1.Append("iRejectIds,"); strSql2.Append("" + model.iRejectIds + ","); } if (model.cCheckPersonCode != null) { strSql1.Append("cCheckPersonCode,"); strSql2.Append("'" + model.cCheckPersonCode + "',"); } if (model.dCheckDate != null) { strSql1.Append("dCheckDate,"); strSql2.Append("'" + model.dCheckDate + "',"); } if (model.iOriTaxCost != null) { strSql1.Append("iOriTaxCost,"); strSql2.Append("" + model.iOriTaxCost + ","); } if (model.iOriCost != null) { strSql1.Append("iOriCost,"); strSql2.Append("" + model.iOriCost + ","); } if (model.iOriMoney != null) { strSql1.Append("iOriMoney,"); strSql2.Append("" + model.iOriMoney + ","); } if (model.iOriTaxPrice != null) { strSql1.Append("iOriTaxPrice,"); strSql2.Append("" + model.iOriTaxPrice + ","); } if (model.ioriSum != null) { strSql1.Append("ioriSum,"); strSql2.Append("" + model.ioriSum + ","); } if (model.iTaxRate != null) { strSql1.Append("iTaxRate,"); strSql2.Append("" + model.iTaxRate + ","); } if (model.iTaxPrice != null) { strSql1.Append("iTaxPrice,"); strSql2.Append("" + model.iTaxPrice + ","); } if (model.iSum != null) { strSql1.Append("iSum,"); strSql2.Append("" + model.iSum + ","); } if (model.bTaxCost != null) { strSql1.Append("bTaxCost,"); strSql2.Append("" + (model.bTaxCost ? 1 : 0) + ","); } if (model.cPOID != null) { strSql1.Append("cPOID,"); strSql2.Append("'" + model.cPOID + "',"); } if (model.cMassUnit != null) { strSql1.Append("cMassUnit,"); strSql2.Append("" + model.cMassUnit + ","); } if (model.iMaterialFee != null) { strSql1.Append("iMaterialFee,"); strSql2.Append("" + model.iMaterialFee + ","); } if (model.iProcessCost != null) { strSql1.Append("iProcessCost,"); strSql2.Append("" + model.iProcessCost + ","); } if (model.iProcessFee != null) { strSql1.Append("iProcessFee,"); strSql2.Append("" + model.iProcessFee + ","); } if (model.dMSDate != null) { strSql1.Append("dMSDate,"); strSql2.Append("'" + model.dMSDate + "',"); } if (model.iSMaterialFee != null) { strSql1.Append("iSMaterialFee,"); strSql2.Append("" + model.iSMaterialFee + ","); } if (model.iSProcessFee != null) { strSql1.Append("iSProcessFee,"); strSql2.Append("" + model.iSProcessFee + ","); } if (model.iOMoDID != null) { strSql1.Append("iOMoDID,"); strSql2.Append("" + model.iOMoDID + ","); } if (model.strContractId != null) { strSql1.Append("strContractId,"); strSql2.Append("'" + model.strContractId + "',"); } if (model.strCode != null) { strSql1.Append("strCode,"); strSql2.Append("'" + model.strCode + "',"); } if (model.bChecked != null) { strSql1.Append("bChecked,"); strSql2.Append("" + (model.bChecked ? 1 : 0) + ","); } if (model.bRelated != null) { strSql1.Append("bRelated,"); strSql2.Append("" + (model.bRelated ? 1 : 0) + ","); } if (model.iOMoMID != null) { strSql1.Append("iOMoMID,"); strSql2.Append("" + model.iOMoMID + ","); } if (model.iMatSettleState != null) { strSql1.Append("iMatSettleState,"); strSql2.Append("" + model.iMatSettleState + ","); } if (model.iBillSettleCount != null) { strSql1.Append("iBillSettleCount,"); strSql2.Append("" + model.iBillSettleCount + ","); } if (model.bLPUseFree != null) { strSql1.Append("bLPUseFree,"); strSql2.Append("" + (model.bLPUseFree ? 1 : 0) + ","); } if (model.iOriTrackID != null) { strSql1.Append("iOriTrackID,"); strSql2.Append("" + model.iOriTrackID + ","); } if (model.coritracktype != null) { strSql1.Append("coritracktype,"); strSql2.Append("'" + model.coritracktype + "',"); } if (model.cbaccounter != null) { strSql1.Append("cbaccounter,"); strSql2.Append("'" + model.cbaccounter + "',"); } if (model.dbKeepDate != null) { strSql1.Append("dbKeepDate,"); strSql2.Append("'" + model.dbKeepDate + "',"); } if (model.bCosting != null) { strSql1.Append("bCosting,"); strSql2.Append("" + (model.bCosting ? 1 : 0) + ","); } if (model.iSumBillQuantity != null) { strSql1.Append("iSumBillQuantity,"); strSql2.Append("" + model.iSumBillQuantity + ","); } if (model.bVMIUsed != null) { strSql1.Append("bVMIUsed,"); strSql2.Append("" + (model.bVMIUsed ? 1 : 0) + ","); } if (model.iVMISettleQuantity != null) { strSql1.Append("iVMISettleQuantity,"); strSql2.Append("" + model.iVMISettleQuantity + ","); } if (model.iVMISettleNum != null) { strSql1.Append("iVMISettleNum,"); strSql2.Append("" + model.iVMISettleNum + ","); } if (model.cvmivencode != null) { strSql1.Append("cvmivencode,"); strSql2.Append("'" + model.cvmivencode + "',"); } if (model.iInvSNCount != null) { strSql1.Append("iInvSNCount,"); strSql2.Append("" + model.iInvSNCount + ","); } if (model.cwhpersoncode != null) { strSql1.Append("cwhpersoncode,"); strSql2.Append("'" + model.cwhpersoncode + "',"); } if (model.cwhpersonname != null) { strSql1.Append("cwhpersonname,"); strSql2.Append("'" + model.cwhpersonname + "',"); } if (model.impcost != null) { strSql1.Append("impcost,"); strSql2.Append("" + model.impcost + ","); } //if (model.iIMBSID != null) //{ // strSql1.Append("iIMBSID,"); // strSql2.Append("" + model.iIMBSID + ","); //} if (model.cbarvcode != null) { strSql1.Append("cbarvcode,"); strSql2.Append("'" + model.cbarvcode + "',"); } if (model.dbarvdate != null) { strSql1.Append("dbarvdate,"); strSql2.Append("'" + model.dbarvdate + "',"); } if (model.iinvexchrate != null) { strSql1.Append("iinvexchrate,"); strSql2.Append("" + model.iinvexchrate + ","); } if (model.corufts != null) { strSql1.Append("corufts,"); strSql2.Append("'" + model.corufts + "',"); } if (model.comcode != null) { strSql1.Append("comcode,"); strSql2.Append("'" + model.comcode + "',"); } if (model.strContractGUID != null) { strSql1.Append("strContractGUID,"); strSql2.Append("'" + Guid.NewGuid().ToString() + "',"); } if (model.iExpiratDateCalcu != null) { strSql1.Append("iExpiratDateCalcu,"); strSql2.Append("" + model.iExpiratDateCalcu + ","); } if (model.cExpirationdate != null) { strSql1.Append("cExpirationdate,"); strSql2.Append("'" + model.cExpirationdate + "',"); } if (model.dExpirationdate != null) { strSql1.Append("dExpirationdate,"); strSql2.Append("'" + model.dExpirationdate + "',"); } if (model.cciqbookcode != null) { strSql1.Append("cciqbookcode,"); strSql2.Append("'" + model.cciqbookcode + "',"); } if (model.iBondedSumQty != null) { strSql1.Append("iBondedSumQty,"); strSql2.Append("" + model.iBondedSumQty + ","); } if (model.iordertype != null) { strSql1.Append("iordertype,"); strSql2.Append("" + model.iordertype + ","); } if (model.iorderdid != null) { strSql1.Append("iorderdid,"); strSql2.Append("" + model.iorderdid + ","); } if (model.iordercode != null) { strSql1.Append("iordercode,"); strSql2.Append("'" + model.iordercode + "',"); } if (model.iorderseq != null) { strSql1.Append("iorderseq,"); strSql2.Append("" + model.iorderseq + ","); } if (model.isodid != null) { strSql1.Append("isodid,"); strSql2.Append("'" + model.isodid + "',"); } if (model.isotype != null) { strSql1.Append("isotype,"); strSql2.Append("" + model.isotype + ","); } if (model.csocode != null) { strSql1.Append("csocode,"); strSql2.Append("'" + model.csocode + "',"); } if (model.isoseq != null) { strSql1.Append("isoseq,"); strSql2.Append("" + model.isoseq + ","); } if (model.cBatchProperty1 != null) { strSql1.Append("cBatchProperty1,"); strSql2.Append("" + model.cBatchProperty1 + ","); } if (model.cBatchProperty2 != null) { strSql1.Append("cBatchProperty2,"); strSql2.Append("" + model.cBatchProperty2 + ","); } if (model.cBatchProperty3 != null) { strSql1.Append("cBatchProperty3,"); strSql2.Append("" + model.cBatchProperty3 + ","); } if (model.cBatchProperty4 != null) { strSql1.Append("cBatchProperty4,"); strSql2.Append("" + model.cBatchProperty4 + ","); } if (model.cBatchProperty5 != null) { strSql1.Append("cBatchProperty5,"); strSql2.Append("" + model.cBatchProperty5 + ","); } if (model.cBatchProperty6 != null) { strSql1.Append("cBatchProperty6,"); strSql2.Append("'" + model.cBatchProperty6 + "',"); } if (model.cBatchProperty7 != null) { strSql1.Append("cBatchProperty7,"); strSql2.Append("'" + model.cBatchProperty7 + "',"); } if (model.cBatchProperty8 != null) { strSql1.Append("cBatchProperty8,"); strSql2.Append("'" + model.cBatchProperty8 + "',"); } if (model.cBatchProperty9 != null) { strSql1.Append("cBatchProperty9,"); strSql2.Append("'" + model.cBatchProperty9 + "',"); } if (model.cBatchProperty10 != null) { strSql1.Append("cBatchProperty10,"); strSql2.Append("'" + model.cBatchProperty10 + "',"); } if (model.cbMemo != null) { strSql1.Append("cbMemo,"); strSql2.Append("'" + model.cbMemo + "',"); } if (model.iFaQty != null) { strSql1.Append("iFaQty,"); strSql2.Append("" + model.iFaQty + ","); } if (model.isTax != null) { strSql1.Append("isTax,"); strSql2.Append("" + model.isTax + ","); } if (model.irowno != null) { strSql1.Append("irowno,"); strSql2.Append("" + model.irowno + ","); } if (model.strowguid != null) { strSql1.Append("strowguid,"); strSql2.Append("'" + Guid.NewGuid().ToString() + "',"); } if (model.rowufts != null) { strSql1.Append("rowufts,"); strSql2.Append("" + model.rowufts + ","); } if (model.ipreuseqty != null) { strSql1.Append("ipreuseqty,"); strSql2.Append("" + model.ipreuseqty + ","); } if (model.ipreuseinum != null) { strSql1.Append("ipreuseinum,"); strSql2.Append("" + model.ipreuseinum + ","); } if (model.iDebitIDs != null) { strSql1.Append("iDebitIDs,"); strSql2.Append("" + model.iDebitIDs + ","); } if (model.OutCopiedQuantity != null) { strSql1.Append("OutCopiedQuantity,"); strSql2.Append("" + model.OutCopiedQuantity + ","); } if (model.iOldPartId != null) { strSql1.Append("iOldPartId,"); strSql2.Append("" + model.iOldPartId + ","); } if (model.fOldQuantity != null) { strSql1.Append("fOldQuantity,"); strSql2.Append("" + model.fOldQuantity + ","); } if (model.cbsysbarcode != null) { strSql1.Append("cbsysbarcode,"); strSql2.Append("'" + model.cbsysbarcode + "',"); } if (model.bmergecheck != null) { strSql1.Append("bmergecheck,"); strSql2.Append("" + (model.bmergecheck ? 1 : 0) + ","); } if (model.iMergeCheckAutoId != null) { strSql1.Append("iMergeCheckAutoId,"); strSql2.Append("" + model.iMergeCheckAutoId + ","); } if (model.bnoitemused != null) { strSql1.Append("bnoitemused,"); strSql2.Append("" + model.bnoitemused + ","); } if (model.cReworkMOCode != null) { strSql1.Append("cReworkMOCode,"); strSql2.Append("'" + model.cReworkMOCode + "',"); } if (model.iReworkMODetailsid != null) { strSql1.Append("iReworkMODetailsid,"); strSql2.Append("" + model.iReworkMODetailsid + ","); } if (model.iProductType != null) { strSql1.Append("iProductType,"); strSql2.Append("" + model.iProductType + ","); } if (model.cMainInvCode != null) { strSql1.Append("cMainInvCode,"); strSql2.Append("'" + model.cMainInvCode + "',"); } if (model.iMainMoDetailsID != null) { strSql1.Append("iMainMoDetailsID,"); strSql2.Append("" + model.iMainMoDetailsID + ","); } if (model.iShareMaterialFee != null) { strSql1.Append("iShareMaterialFee,"); strSql2.Append("" + model.iShareMaterialFee + ","); } strSql.Append("insert into rdrecords01("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); return(strSql.ToString()); }
private void btnImprot_Click(object sender, EventArgs e) { try { gridViewPL.FocusedRowHandle -= 1; gridViewPL.FocusedRowHandle += 1; } catch { } try { if (txtCurrency.Text.Trim() == "") { throw new Exception("Please set currency"); } decimal dExch = BaseFunction.ReturnDecimal(txtExchangeRate.Text.Trim()); if (dExch == 0) { throw new Exception("Please set the exchange rate"); } if (lookUpEditWarehouse.EditValue == null || lookUpEditWarehouse.Text.Trim() == "") { lookUpEditWarehouse.Focus(); throw new Exception("Please choose warehouse"); } int iCou = gridViewPL.RowCount; if (iCou == 0) { throw new Exception("no data"); } string sErr = ""; int iCount = 0; SqlConnection conn = new SqlConnection(Conn); conn.Open(); //启用事务 SqlTransaction tran = conn.BeginTransaction(); try { DateTime dLogDate = BaseFunction.ReturnDate(sLogDate); string sWhCode = lookUpEditWarehouse.Text.Trim(); string sRdCode = "101"; string sSQL = @" select * from _Code where VouchType = 'RdRecord01' "; DataTable dtCode = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtCode != null && dtCode.Rows.Count > 0) { sRdCode = dtCode.Rows[0]["cRdCodeIn"].ToString().Trim(); } //string sDate = dateEdit1.DateTime.ToString("yyyy-MM-dd"); string sDate = sLogDate; sSQL = @" select bflag_ST from gl_mend where iyear = aaaaaa and iperiod = bbbbbb "; sSQL = sSQL.Replace("aaaaaa", dLogDate.Year.ToString()); sSQL = sSQL.Replace("bbbbbb", dLogDate.Month.ToString()); DataTable dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (BaseFunction.ReturnBool(dtTemp.Rows[0]["bflag_ST"])) { throw new Exception("The current date has been checked out"); } string sDateTime = dateEditQuery.DateTime.ToString("yyyy-MM-dd"); // sSQL = @" //select * from exch where cdate = 'aaaaaa' //"; // sSQL = sSQL.Replace("aaaaaa", dtmBL.DateTime.ToString("yyyy.MM.dd")); // DataTable dtExch = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; // if (dtExch == null || dtExch.Rows.Count == 0) // { // throw new Exception("Please set exchange rate"); // } long lID = 0; long lIDs = 0; sSQL = @" declare @p5 int set @p5=0 declare @p6 int set @p6=0 exec sp_GetId N'',N'@AccID',N'rd',@iCou,@p5 output,@p6 output,default select @p5, @p6 "; sSQL = sSQL.Replace("@iCou", iCou.ToString()); sSQL = sSQL.Replace("@AccID", sAccID); dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lID = BaseFunction.ReturnLong(dtTemp.Rows[0][0]); lIDs = BaseFunction.ReturnLong(dtTemp.Rows[0][1]) - iCou; sSQL = @" select * From VoucherHistory with (ROWLOCK) Where CardNumber='24' and cContent='日期' and cSeed='aaaaaa' "; sSQL = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd")); dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; long iCode = 0; if (dtTemp != null && dtTemp.Rows.Count > 0) { iCode = BaseFunction.ReturnLong(dtTemp.Rows[0]["cNumber"]) + 1; sSQL = @" update VoucherHistory set cNumber = aaaaaa where autoid = bbbbbb and CardNumber = '24' "; sSQL = sSQL.Replace("aaaaaa", iCode.ToString()); sSQL = sSQL.Replace("bbbbbb", dtTemp.Rows[0]["AutoId"].ToString().Trim()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { iCode = 1; sSQL = @" insert into VoucherHistory(CardNumber, cContent, cContentRule, cSeed, cNumber, bEmpty) values('24','日期','日','aaaaaa',1,0) "; sSQL = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd")); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sSQL = @" select * from PO_POMain where cPOID = 'aaaaaa' "; sSQL = sSQL.Replace("aaaaaa", gridViewPL.GetRowCellValue(0, gridColPONO).ToString().Trim()); DataTable dtPO = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; Model.RdRecord01 mod = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord01(); mod.ID = lID; mod.bRdFlag = 1; mod.cVouchType = "01"; mod.cBusType = "普通采购"; mod.cSource = "采购订单"; //mod.cBusCode = mod.cWhCode = sWhCode; //在途仓库 mod.dDate = dLogDate; //DataRow[] drExch = dtExch.Select("cexch_name = '" + txtCurrency.Text.Trim() + "'"); //if (drExch.Length == 0) //{ // throw new Exception("Please set exchange rate"); //} mod.iExchRate = dExch; string sCode = iCode.ToString(); while (sCode.Length < 4) { sCode = "0" + sCode; } sCode = "RC" + dLogDate.ToString("yyyyMMdd") + sCode; mod.cCode = sCode; mod.cRdCode = sRdCode; mod.cDepCode = "LOG"; mod.cPTCode = dtPO.Rows[0]["cPTCode"].ToString().Trim(); mod.cVenCode = dtPO.Rows[0]["cVenCode"].ToString().Trim(); //mod.cOrderCode = dtPO.Rows[0]["cPOID"].ToString().Trim(); mod.bTransFlag = false; mod.cMaker = sUserName; mod.cDefine10 = txtInvoiceNO.Text.Trim(); mod.bpufirst = false; mod.biafirst = false; mod.VT_ID = 131313; mod.bIsSTQc = false; mod.ipurorderid = BaseFunction.ReturnLong(dtPO.Rows[0]["POID"]); mod.iTaxRate = BaseFunction.ReturnDecimal(dtPO.Rows[0]["iTaxRate"]); mod.cExch_Name = dtPO.Rows[0]["cExch_Name"].ToString().Trim(); mod.bOMFirst = false; mod.bFromPreYear = false; mod.bIsComplement = 0; mod.iDiscountTaxType = 0; mod.ireturncount = 0; mod.iverifystate = 0; mod.iswfcontrolled = 0; mod.dnmaketime = DateTime.Now; mod.bredvouch = 0; mod.bCredit = 0; mod.iPrintCount = 0; mod.csysbarcode = "||st01|" + mod.cCode; mod.cDefine1 = txtBL.Text.Trim(); mod.cDefine10 = txtInvoiceNO.Text.Trim(); //导入单据审核 mod.dVeriDate = mod.dDate; mod.dnverifytime = DateTime.Now; mod.cHandler = mod.cMaker; DAL.RdRecord01 dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord01(); sSQL = dal.Add(mod); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < gridViewPL.RowCount; i++) { if (!BaseFunction.ReturnBool(gridViewPL.GetRowCellValue(i, gridColSelected))) { continue; } //判断是否已经生成了采购入库单 long lRds01Autoid = BaseFunction.ReturnLong(gridViewPL.GetRowCellValue(i, gridColRds01ID)); if (lRds01Autoid > 0) { sSQL = @" select autoid from Rdrecords01 where autoid = aaaaaaaa "; sSQL = sSQL.Replace("aaaaaaaa", lRds01Autoid.ToString()); DataTable dtRds01 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtRds01 != null && dtRds01.Rows.Count > 0) { sErr = sErr + "Line " + (i + 1).ToString() + " is imported\n"; continue; } } string sPONO = gridViewPL.GetRowCellValue(i, gridColPONO).ToString().Trim(); string sInvCode = gridViewPL.GetRowCellValue(i, gridColPARTNO).ToString().Trim(); //同一个订单相同子件只能有一个 sSQL = @" select a.cPOID,a.POID,a.cexch_name ,a.cPTCode,a.cVenCode ,a.cBusType ,a.cDepCode ,b.ID,b.cInvCode,b.iQuantity,isnull(b.freceivedqty ,0) as freceivedqty ,b.irowno ,b.ivouchrowno ,isnull(b.fPoArrQuantity ,0) as fPoArrQuantity ,isnull(b.iReceivedQTY ,0) as iReceivedQTY ,isnull(b.iInvQTY ,0) as iInvQTY ,b.iPerTaxRate ,isnull(b.iArrQTY ,0) as iArrQTY ,b.iPerTaxRate from PO_Pomain a inner join PO_Podetails b on a.POID = b.POID where a.cPOID = 'aaaaaa' and b.cInvCode = 'bbbbbb' "; sSQL = sSQL.Replace("aaaaaa", sPONO); sSQL = sSQL.Replace("bbbbbb", sInvCode); DataTable dtPOs = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtPOs == null || dtPOs.Rows.Count == 0) { throw new Exception("Not found the corresponding purchase order"); } Model.rdrecords01 mods = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords01(); lIDs += 1; mods.AutoID = lIDs; mods.ID = mod.ID; mods.cInvCode = sInvCode; decimal dQty = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColQUANTITY)); decimal dPOQty = BaseFunction.ReturnDecimal(dtPOs.Rows[0]["iQuantity"]); decimal dArrQty = BaseFunction.ReturnDecimal(dtPOs.Rows[0]["iReceivedQTY"]); mods.iTaxRate = BaseFunction.ReturnDecimal(dtPOs.Rows[0]["iPerTaxRate"]); mods.iQuantity = dQty; mods.iOriCost = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColUnitPrice)); //原币无税单价 mods.iOriTaxCost = BaseFunction.ReturnDecimal(mods.iOriCost * (1 + mods.iTaxRate / 100)); //原币含税单价 mods.iOriMoney = BaseFunction.ReturnDecimal(mods.iOriCost * mods.iQuantity, 2); //原币无税金额 mods.ioriSum = BaseFunction.ReturnDecimal(mods.iOriTaxCost * mods.iQuantity, 2); //原币含税金额 mods.iOriTaxPrice = mods.ioriSum - mods.iOriMoney; //税额 mods.iUnitCost = BaseFunction.ReturnDecimal(mods.iOriCost * mod.iExchRate); //单价 mods.iPrice = BaseFunction.ReturnDecimal(mods.iUnitCost * dQty, 2); //金额 mods.iSum = BaseFunction.ReturnDecimal(mods.ioriSum * mod.iExchRate, 2); //本币价税合计 mods.iTaxPrice = mods.iSum - mods.iPrice; //本币税额 mods.bTaxCost = true; mods.fACost = mods.iUnitCost; //暂估单价 mods.iAPrice = mods.iSum; //暂估金额 mods.iMoney = 0; //累计结算金额 mods.iFlag = 0; mods.iSQuantity = 0; mods.iSNum = 0; mods.iPOsID = BaseFunction.ReturnLong(dtPOs.Rows[0]["ID"]); mods.iNQuantity = dQty; mods.chVencode = dtPOs.Rows[0]["cVenCode"].ToString().Trim(); mods.cPOID = dtPOs.Rows[0]["cPOID"].ToString().Trim(); mods.iMatSettleState = 0; mods.iBillSettleCount = 0; mods.bLPUseFree = false; mods.iOriTrackID = 0; mods.bCosting = true; mods.iExpiratDateCalcu = 0; mods.isotype = 0; mods.irowno = i + 1; mods.cbsysbarcode = "||st01|" + mod.cCode + "|" + mods.irowno.ToString(); mods.cDefine22 = gridViewPL.GetRowCellValue(i, gridColCONTAINERNO).ToString().Trim(); mods.cDefine23 = gridViewPL.GetRowCellValue(i, gridColBOXNO).ToString().Trim(); mods.cDefine24 = gridViewPL.GetRowCellValue(i, gridColCASENO).ToString().Trim(); mods.cDefine25 = gridViewPL.GetRowCellValue(i, gridColGWKGS).ToString().Trim(); mods.cDefine28 = gridViewPL.GetRowCellValue(i, gridColNWKGS).ToString().Trim(); DAL.rdrecords01 dals = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords01(); sSQL = dals.Add(mods); iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists (select * from CurrentStock where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch ) update CurrentStock set iQuantity = isnull(iQuantity,0) + @iQuantity where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch else begin declare @itemid varchar(20); declare @iCount int; select @iCount=count(itemid) from CurrentStock where cInvCode = '@cInvCode'; if( @iCount > 0 ) select @itemid=itemid from CurrentStock where cInvCode = '@cInvCode'; else select @itemid=max(itemid+1) from CurrentStock insert into CurrentStock(cWhCode,cInvCode,iQuantity,itemid, cFree1, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10,cBatch,iSoDid) values('@cWhCode','@cInvCode', @iQuantity,isnull(@itemid,1), @cFree1, @cFree2, @cFree3, @cFree4, @cFree5, @cFree6, @cFree7, @cFree8, @cFree9, @cFree10,@cBatch,'') end "; sSQL = sSQL.Replace("@cInvCode", mods.cInvCode); sSQL = sSQL.Replace("@cWhCode", mod.cWhCode); sSQL = sSQL.Replace("@iQuantity", mods.iQuantity.ToString()); sSQL = sSQL.Replace("@iNum", mods.iNum.ToString()); sSQL = sSQL.Replace("@cFree10", mods.cFree10 == null ? "''" : "'" + mods.cFree10 + "'"); sSQL = sSQL.Replace("@cFree1", mods.cFree1 == null ? "''" : "'" + mods.cFree1 + "'"); sSQL = sSQL.Replace("@cFree2", mods.cFree2 == null ? "''" : "'" + mods.cFree2 + "'"); sSQL = sSQL.Replace("@cFree3", mods.cFree3 == null ? "''" : "'" + mods.cFree3 + "'"); sSQL = sSQL.Replace("@cFree4", mods.cFree4 == null ? "''" : "'" + mods.cFree4 + "'"); sSQL = sSQL.Replace("@cFree5", mods.cFree5 == null ? "''" : "'" + mods.cFree5 + "'"); sSQL = sSQL.Replace("@cFree6", mods.cFree6 == null ? "''" : "'" + mods.cFree6 + "'"); sSQL = sSQL.Replace("@cFree7", mods.cFree7 == null ? "''" : "'" + mods.cFree7 + "'"); sSQL = sSQL.Replace("@cFree8", mods.cFree8 == null ? "''" : "'" + mods.cFree8 + "'"); sSQL = sSQL.Replace("@cFree9", mods.cFree9 == null ? "''" : "'" + mods.cFree9 + "'"); sSQL = sSQL.Replace("@cBatch", mods.cBatch == null ? "''" : "'" + mods.cBatch + "'"); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); //回写导入中间表 Rdrecords10_Import sSQL = @" update RdRecords01_Import set Rds01ID = AAAAAA WHERE AUTOID = BBBBBB "; sSQL = sSQL.Replace("AAAAAA", mods.AutoID.ToString()); sSQL = sSQL.Replace("BBBBBB", gridViewPL.GetRowCellValue(i, gridColAutoID).ToString()); int iRet = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); if (iRet != 1) { sErr = sErr + "Row " + (i + 1) + " update dl err\n"; } //回写采购订单 sSQL = @" update PO_Podetails set iReceivedQTY = isnull(iReceivedQTY,0) + aaaaaa where ID = bbbbbb "; sSQL = sSQL.Replace("aaaaaa", mods.iQuantity.ToString()); sSQL = sSQL.Replace("bbbbbb", mods.iPOsID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sSQL = @" exec ST_SaveForStock N'01',N'aaaaaa',1,0 ,1 "; sSQL = sSQL.Replace("aaaaaa", mod.ID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec ST_SaveForTrackStock N'01',N'aaaaaa', 0 ,1 "; sSQL = sSQL.Replace("aaaaaa", mod.ID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec IA_SP_WriteUnAccountVouchForST 'aaaaaa',N'01' "; sSQL = sSQL.Replace("aaaaaa", mod.ID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); if (sErr != "") { throw new Exception(sErr); } if (iCount > 0) { tran.Commit(); MessageBox.Show("Success:" + mod.cCode); SetTxtNull(); } else { throw new Exception("Save failed,no data"); } } catch (Exception error) { tran.Rollback(); throw new Exception(error.Message); } } catch (Exception ee) { FrmMsgBox frm = new FrmMsgBox(); frm.richTextBox1.Text = ee.Message; frm.ShowDialog(); } }