public string InsertMaterial(ref Material material, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(16) { ProcedureName = "MASTER_PACK.M_MATERIAL_INS" }; param.AddParamInOutput(0, "strMTL_SEQ_NO", OracleDbType.Varchar2, 255, material.MTL_SEQ_NO); //OracleDbType.Varchar2, prod.PROD_SEQ_NO param.AddParamInput(1, "strMTL_CODE", material.MTL_CODE); param.AddParamInput(2, "strMTL_NAME", material.MTL_NAME); param.AddParamInput(3, "strMTL_GRADE", material.MTL_GRADE); param.AddParamInput(4, "strMTL_COLOR", material.MTL_COLOR); param.AddParamInput(5, "strUNIT", material.UNIT); param.AddParamInput(6, "strSTD_QTY", material.STD_QTY); param.AddParamInput(7, "strMIN_QTY", material.MIN_QTY); param.AddParamInput(8, "strMAX_QTY", material.MAX_QTY); param.AddParamInput(9, "strPARTY_ID", material.PARTY_ID); if (material.MTL_IMAGE != null) { param.AddParamBLOBInput(10, "strMTL_IMAGE", OracleDbType.Blob, this.BitmapToByteArray(material.MTL_IMAGE)); //this.BitmapToByteArray(prod.PROD_IMAGE) } else { param.AddParamInput(10, "strMTL_IMAGE", DBNull.Value); //this.BitmapToByteArray(prod.PROD_IMAGE) } param.AddParamInput(11, "strLOCATION_ID", material.LOCATION_ID); param.AddParamInput(12, "strREMARK", material.REMARK); param.AddParamInput(13, "strUSER_ID", userid); param.AddParamInput(14, "strREC_STAT", (material.REC_STAT ? "Y" : "N")); param.AddParamOutput(15, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString mtlSeq = (OracleString)param.ReturnValue(0); OracleString result = (OracleString)param.ReturnValue(15); if (!result.IsNull) { material.MTL_SEQ_NO = mtlSeq.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertParty(ref Party party, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(15); param.ProcedureName = "MASTER_PACK.M_PARTY_INS"; param.AddParamInOutput(0, "strPARTY_ID", OracleDbType.Varchar2, 100, party.PARTY_ID); param.AddParamInput(1, "strPARTY_NAME", party.PARTY_NAME); param.AddParamInput(2, "strPARTY_TYPE", party.PARTY_TYPE); param.AddParamInput(3, "strADD1", party.ADD1); param.AddParamInput(4, "strADD2", party.ADD2); param.AddParamInput(5, "strADD3", party.ADD3); param.AddParamInput(6, "strADD4", party.ADD4); param.AddParamInput(7, "strTEL", party.TEL); param.AddParamInput(8, "strFAX", party.FAX); param.AddParamInput(9, "strEMAIL", party.EMAIL); param.AddParamInput(10, "strPIC", party.PIC); param.AddParamInput(11, "strREMARK", party.REMARK); param.AddParamInput(12, "strREC_STAT", (party.REC_STAT ? "Y" : "N")); param.AddParamInput(13, "strUSER_ID", userid); param.AddParamOutput(14, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)param.ReturnValue(14); if (!result.IsNull) { resultMsg = result.Value; OracleString resultPartyID = (OracleString)param.ReturnValue(0); if (!resultPartyID.IsNull) { party.PARTY_ID = resultPartyID.Value; } } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertTransferOrder(ref TransferOrderHdr TO_HDR, string userid) { string resultMsg = string.Empty; try { #region "Transaction Header" ProcParam paramHDR = new ProcParam(10); paramHDR.ProcedureName = "TO_PACK.TO_HDR_INS"; paramHDR.AddParamInOutput(0, "strTO_NO", OracleDbType.Varchar2, 255, TO_HDR.TO_NO); paramHDR.AddParamInput(1, "strTO_DATE ", TO_HDR.TO_DATE); paramHDR.AddParamInput(2, "strREF_NO", TO_HDR.REF_NO); paramHDR.AddParamInput(3, "strPROD_TYPE", TO_HDR.PROD_TYPE); paramHDR.AddParamInput(4, "strTO_DEST", TO_HDR.TO_DEST); paramHDR.AddParamInput(5, "strDELIVERY_DATE", TO_HDR.DELIVERY_DATE); paramHDR.AddParamInput(6, "strREMARK", TO_HDR.REMARK); paramHDR.AddParamInput(7, "strREC_STAT", (TO_HDR.REC_STAT ? "Y" : "N")); paramHDR.AddParamInput(8, "strUSER_ID", userid); paramHDR.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255); #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)paramHDR.ReturnValue(0); OracleString result = (OracleString)paramHDR.ReturnValue(9); if (!result.IsNull) { TO_HDR.TO_NO = resultDB.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertLoadingOrder(ref LoadingOrder loadingOrd, string userid) { string resultMsg = string.Empty; try { #region "Transaction Header" ProcParam paramHDR = new ProcParam(10) { ProcedureName = "LOADING_PACK.LOADING_HDR_INS" }; paramHDR.AddParamInOutput(0, "strLOADING_NO", OracleDbType.Varchar2, 255, loadingOrd.LOADING_NO); paramHDR.AddParamInput(1, "strLOADING_DATE ", loadingOrd.LOADING_DATE); paramHDR.AddParamInput(2, "strDELIVERY_DATE", loadingOrd.DELIVERY_DATE); paramHDR.AddParamInput(3, "strTRUCK_NO", loadingOrd.TRUCK_NO); paramHDR.AddParamInput(4, "strCONTAINER_NO", loadingOrd.CONTAINER_NO); paramHDR.AddParamInput(5, "strWH_ID", loadingOrd.WH_ID); paramHDR.AddParamInput(6, "strREMARK", loadingOrd.REMARK); paramHDR.AddParamInput(7, "strREC_STAT", (loadingOrd.REC_STAT ? "Y" : "N")); paramHDR.AddParamInput(8, "strUSER_ID", userid); paramHDR.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255); #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)paramHDR.ReturnValue(0); OracleString result = (OracleString)paramHDR.ReturnValue(9); if (!result.IsNull) { loadingOrd.LOADING_NO = resultDB.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertArrival(T_ARRIVAL_HDR ArrHdr, List <T_ARRIVAL_DTL> lstArrDtl, string userid, out string ARRIVAL_NO) { string resultMsg = string.Empty; ARRIVAL_NO = string.Empty; try { #region "Transaction Header" ProcParam procHeader = new ProcParam(11) { ProcedureName = "MTL_IN_PACK.T_ARRIVAL_HDR_INS" }; procHeader.AddParamInOutput(0, "strARRIVAL_NO", OracleDbType.NVarchar2, 30, ArrHdr.ARRIVAL_NO); procHeader.AddParamInput(1, "strARRIVAL_DATE", ArrHdr.ARRIVAL_DATE); procHeader.AddParamInput(2, "strWH_ID", ArrHdr.WH_ID); procHeader.AddParamInput(3, "strPARTY_ID", ArrHdr.PARTY_ID); procHeader.AddParamInput(4, "strREF_NO ", ArrHdr.REF_NO); procHeader.AddParamInput(5, "strREF_DATE", ArrHdr.REF_DATE); procHeader.AddParamInput(6, "strREMARK", ArrHdr.REMARK); procHeader.AddParamInput(7, "strUSER_ID", ArrHdr.USER_ID); procHeader.AddParamInput(8, "strREC_STAT", ArrHdr.REC_STAT ? "Y" : "N"); procHeader.AddParamInput(9, "strARR_TYPE", ArrHdr.ARR_TYPE); procHeader.AddParamOutput(10, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK"); #endregion "Transaction Header" #region "Transaction Detail" #region Arrival Insert #Flag=2 var insArr = from arr in lstArrDtl where arr.FLAG == 2 select arr; ProcParam paramIns = null; if (insArr.Any() && insArr.Count() > 0) { paramIns = new ProcParam(10) { ProcedureName = "MTL_IN_PACK.T_ARRIVAL_DTL_INS" }; var arrARRIVAL_NO = (from arr in insArr select arr.ARRIVAL_NO).ToArray(); paramIns.AddParamInput(0, "strARRIVAL_NO", arrARRIVAL_NO, OracleDbType.Varchar2); var arrLINE_NO = (from arr in insArr select(object) arr.LINE_NO).ToArray(); paramIns.AddParamInput(1, "strLINE_NO", arrLINE_NO, OracleDbType.Int32); var arrMTL_SEQ_NO = (from arr in insArr select arr.MTL_SEQ_NO).ToArray(); paramIns.AddParamInput(2, "strMTL_SEQ_NO", arrMTL_SEQ_NO, OracleDbType.Varchar2); var arrUNIT_ID = (from arr in insArr select arr.UNIT_ID).ToArray(); paramIns.AddParamInput(3, "strUNIT_ID", arrUNIT_ID, OracleDbType.Varchar2); var arrQTY = (from arr in insArr select(object) arr.QTY).ToArray(); paramIns.AddParamInput(4, "strQTY", arrQTY, OracleDbType.Decimal); var arrREMARK = (from arr in insArr select arr.REMARK).ToArray(); paramIns.AddParamInput(5, "strREMARK", arrREMARK, OracleDbType.Varchar2); //strCREATED_BY paramIns.AddParamInput(6, "strUSER_ID", ArrayOf <object> .Create(insArr.Count(), userid), OracleDbType.Varchar2); //REC_STATUS paramIns.AddParamInput(7, "strREC_STAT", ArrayOf <object> .Create(insArr.Count(), "Y"), OracleDbType.Varchar2); var arrLOT_DATE = (from arr in insArr select(object) arr.LOT_DATE).ToArray(); paramIns.AddParamInput(8, "strLOT_DATE", arrLOT_DATE, OracleDbType.Date); //RESULTMSG paramIns.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", insArr.Count()); } #endregion #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(procHeader, paramIns, insArr.Count(), 0, 0); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } OracleString resultKey = (OracleString)procHeader.ReturnValue(0); OracleString result = (OracleString)procHeader.ReturnValue(10); if (!resultKey.IsNull) { ARRIVAL_NO = resultKey.Value; } if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertPlan(string PlanType, DataTable DtExcelPlan_DTL, DateTime planDate, string userid) { string resultMsg = string.Empty; try { #region Transaction Header ProcParam paramHDR = new ProcParam(5) { ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_HDR_INSERT" }; paramHDR.AddParamInOutput(0, "strPLAN_NO", OracleDbType.Varchar2, 30, ""); paramHDR.AddParamInput(1, "strUSER_ID", userid); paramHDR.AddParamInput(2, "strTYPE", PlanType); paramHDR.AddParamInput(3, "strPLAN_DATE", planDate); paramHDR.AddParamOutput(4, "RESULTMSG", OracleDbType.NVarchar2, 255); #endregion #region Transaction Detail // DataRow[] insertRows = dtCOMPDtl.Rows; ProcParam paramDTL = null; if (DtExcelPlan_DTL.Rows.Count > 0) { paramDTL = new ProcParam(34) { ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_DTL_INSERT" }; paramDTL.AddParamInput(0, "strPLAN_NO", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); var arrMC_SIZE_TON = (from DataRow row in DtExcelPlan_DTL.Rows select row["MC_SIZE_TON"]).ToArray(); paramDTL.AddParamInput(1, "strMC_SIZE_TON", arrMC_SIZE_TON, OracleDbType.Varchar2); var arrPDTL_BLOCK = (from DataRow row in DtExcelPlan_DTL.Rows select row["PDTL_BLOCK"]).ToArray(); paramDTL.AddParamInput(2, "strPDTL_BLOCK", arrPDTL_BLOCK, OracleDbType.Varchar2); var arrMC_NO = (from DataRow row in DtExcelPlan_DTL.Rows select row["MC_NO"]).ToArray(); paramDTL.AddParamInput(3, "strMC_NO", arrMC_NO, OracleDbType.Varchar2); var arrPDTL_SEQUENCE = (from DataRow row in DtExcelPlan_DTL.Rows select row["PDTL_SEQUENCE"]).ToArray(); paramDTL.AddParamInput(4, "strPDTL_SEQUENCE", arrPDTL_SEQUENCE, OracleDbType.Varchar2); var arrPRODUCT_NO = (from DataRow row in DtExcelPlan_DTL.Rows select row["PRODUCT_NO"]).ToArray(); paramDTL.AddParamInput(5, "strPRODUCT_NO", arrPRODUCT_NO, OracleDbType.Varchar2); if (PlanType == "H") { var arrPARTNAME = (from DataRow row in DtExcelPlan_DTL.Rows select row["PARTNAME"]).ToArray(); paramDTL.AddParamInput(6, "strPARTNAME", arrPARTNAME, OracleDbType.Varchar2); } else { paramDTL.AddParamInput(6, "strPARTNAME", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); } var arrMAT_TYPE = (from DataRow row in DtExcelPlan_DTL.Rows select row["MAT_TYPE"]).ToArray(); paramDTL.AddParamInput(7, "strMAT_TYPE", arrMAT_TYPE, OracleDbType.Varchar2); if (PlanType == "V") { var arrINSERT_1 = (from DataRow row in DtExcelPlan_DTL.Rows select row["INSERT_1"]).ToArray(); paramDTL.AddParamInput(8, "strINSERT_1", arrINSERT_1, OracleDbType.Varchar2); var arrINSERT_2 = (from DataRow row in DtExcelPlan_DTL.Rows select row["INSERT_2"]).ToArray(); paramDTL.AddParamInput(9, "strINSERT_2", arrINSERT_2, OracleDbType.Varchar2); var arrINSERT_3 = (from DataRow row in DtExcelPlan_DTL.Rows select row["INSERT_3"]).ToArray(); paramDTL.AddParamInput(10, "strINSERT_3", arrINSERT_3, OracleDbType.Varchar2); var arrTARGET_DAY = (from DataRow row in DtExcelPlan_DTL.Rows select row["TARGET_DAY"]).ToArray(); paramDTL.AddParamInput(24, "strTARGET_DAY", arrTARGET_DAY, OracleDbType.Int32); var arrPROD_LOT = (from DataRow row in DtExcelPlan_DTL.Rows select row["PROD_LOT"]).ToArray(); paramDTL.AddParamInput(27, "strPROD_LOT", arrPROD_LOT, OracleDbType.Varchar2); } else { paramDTL.AddParamInput(8, "strINSERT_1", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); paramDTL.AddParamInput(9, "strINSERT_2", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); paramDTL.AddParamInput(10, "strINSERT_3", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); paramDTL.AddParamInput(24, "strTARGET_DAY", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, null), OracleDbType.Int32); paramDTL.AddParamInput(27, "strPROD_LOT", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2); } var arrCAV_ACT = (from DataRow row in DtExcelPlan_DTL.Rows select row["CAV_ACT"]).ToArray(); paramDTL.AddParamInput(11, "strCAV_ACT", arrCAV_ACT, OracleDbType.Int32); var arrCAV_FULL = (from DataRow row in DtExcelPlan_DTL.Rows select row["CAV_FULL"]).ToArray(); paramDTL.AddParamInput(12, "strCAV_FULL", arrCAV_FULL, OracleDbType.Int32); var arrMP_START = (from DataRow row in DtExcelPlan_DTL.Rows select row["MP_START"]).ToArray(); paramDTL.AddParamInput(13, "strMP_START", arrMP_START, OracleDbType.Date); var arrMP_FINISH = (from DataRow row in DtExcelPlan_DTL.Rows select row["MP_FINISH"]).ToArray(); paramDTL.AddParamInput(14, "strMP_FINISH", arrMP_FINISH, OracleDbType.Date); var arrPLAN_MP_DAY = (from DataRow row in DtExcelPlan_DTL.Rows select row["PLAN_MP_DAY"]).ToArray(); paramDTL.AddParamInput(15, "strPLAN_MP_DAY", arrPLAN_MP_DAY, OracleDbType.Decimal); var arrPRO_SHOT_WEIGHT = (from DataRow row in DtExcelPlan_DTL.Rows select row["PRO_SHOT_WEIGHT"]).ToArray(); paramDTL.AddParamInput(16, "strPRO_SHOT_WEIGHT", arrPRO_SHOT_WEIGHT, OracleDbType.Decimal); var arrCYCLE_TIME = (from DataRow row in DtExcelPlan_DTL.Rows select row["CYCLE_TIME"]).ToArray(); paramDTL.AddParamInput(17, "strCYCLE_TIME", arrCYCLE_TIME, OracleDbType.Decimal); var arrQTY_DAY = (from DataRow row in DtExcelPlan_DTL.Rows select row["QTY_DAY"]).ToArray(); paramDTL.AddParamInput(18, "strQTY_DAY", arrQTY_DAY, OracleDbType.Int32); var arrTOTAL_MAT_USE_KG = (from DataRow row in DtExcelPlan_DTL.Rows select row["TOTAL_MAT_USE_KG"]).ToArray(); paramDTL.AddParamInput(19, "strTOTAL_MAT_USE_KG", arrTOTAL_MAT_USE_KG, OracleDbType.Decimal); var arrTPCT_LOSS = (from DataRow row in DtExcelPlan_DTL.Rows select row["TPCT_LOSS"]).ToArray(); paramDTL.AddParamInput(20, "strTPCT_LOSS", arrTPCT_LOSS, OracleDbType.Decimal); var arrQTY_PLAN = (from DataRow row in DtExcelPlan_DTL.Rows select row["QTY_PLAN"]).ToArray(); paramDTL.AddParamInput(21, "strQTY_PLAN", arrQTY_PLAN, OracleDbType.Int32); var arrPLAN_MAT_AVG_DAY_KG = (from DataRow row in DtExcelPlan_DTL.Rows select row["PLAN_MAT_AVG_DAY_KG"]).ToArray(); paramDTL.AddParamInput(22, "strPLAN_MAT_AVG_DAY_KG", arrPLAN_MAT_AVG_DAY_KG, OracleDbType.Decimal); var arrMAT_DRY = (from DataRow row in DtExcelPlan_DTL.Rows select row["MAT_DRY"]).ToArray(); paramDTL.AddParamInput(23, "strMAT_DRY", arrMAT_DRY, OracleDbType.NVarchar2); var arrPDTL_REMARK = (from DataRow row in DtExcelPlan_DTL.Rows select row["PDTL_REMARK"]).ToArray(); paramDTL.AddParamInput(25, "strPDTL_REMARK", arrPDTL_REMARK, OracleDbType.Varchar2); var arrPARTY_ID = (from DataRow row in DtExcelPlan_DTL.Rows select row["PARTY_ID"]).ToArray(); paramDTL.AddParamInput(26, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2); paramDTL.AddParamInput(28, "strN_USER_ID", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, userid), OracleDbType.Varchar2); var arrPROD_SEQ_NO = (from DataRow row in DtExcelPlan_DTL.Rows select row["PROD_SEQ_NO"]).ToArray(); paramDTL.AddParamInput(29, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2); paramDTL.AddParamInput(30, "strCHANGE_MOLD", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2); paramDTL.AddParamInput(31, "strCONTINUE_ORDER", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2); paramDTL.AddParamInput(32, "strREVISED_PLAN", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2); //RESULTMSG paramDTL.AddParamOutput(33, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", DtExcelPlan_DTL.Rows.Count); } #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR, paramDTL, DtExcelPlan_DTL.Rows.Count, 0, 0); // GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR, paramDTL, lstCOMPDtl.Count,0,0); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } OracleString result = (OracleString)paramHDR.ReturnValue(4); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertProduct(ref Product prod, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(17) { ProcedureName = "MASTER_PACK.M_PRODUCT_INS" }; param.AddParamInOutput(0, "strPROD_SEQ_NO", OracleDbType.Varchar2, 255, prod.PROD_SEQ_NO); //OracleDbType.Varchar2, prod.PROD_SEQ_NO param.AddParamInput(1, "strPRODUCT_NO", prod.PRODUCT_NO); param.AddParamInput(2, "strPRODUCT_NAME", prod.PRODUCT_NAME); param.AddParamInput(3, "strMATERIAL_TYPE", prod.MATERIAL_TYPE); param.AddParamInput(4, "strPRODUCTION_TYPE", prod.PRODUCTION_TYPE); param.AddParamInput(5, "strMC_NO", prod.MC_NO); param.AddParamInput(6, "strBOX_QTY", prod.BOX_QTY); param.AddParamInput(7, "strUNIT", prod.UNIT); if (prod.PROD_IMAGE != null) { param.AddParamBLOBInput(8, "strPROD_IMAGE", OracleDbType.Blob, this.BitmapToByteArray(prod.PROD_IMAGE)); //this.BitmapToByteArray(prod.PROD_IMAGE) } else { param.AddParamInput(8, "strPROD_IMAGE", DBNull.Value); //this.BitmapToByteArray(prod.PROD_IMAGE) } param.AddParamInput(9, "strREMARK", prod.REMARK); param.AddParamInput(10, "strREC_STAT", (prod.REC_STAT ? "Y" : "N")); param.AddParamInput(11, "strUSER_ID", userid); //add new parameter on 07-Jun-2011 param.AddParamInput(12, "strCUST_PROD_NO", prod.CUST_PROD_NO); param.AddParamInput(13, "strBUYER", prod.BUYER_PRICE); param.AddParamInput(14, "strSELLING", prod.SELLING_PRICE); param.AddParamInput(15, "strCOST", prod.COST_PRICE); param.AddParamOutput(16, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString prodSeq = (OracleString)param.ReturnValue(0); OracleString result = (OracleString)param.ReturnValue(16); if (!result.IsNull) { prod.PROD_SEQ_NO = prodSeq.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string InsertDeliveryOrder(ref DeliveryOrder delOrd, string userid) { string resultMsg = string.Empty; try { #region "Transaction Header" ProcParam paramHDR = new ProcParam(10) { ProcedureName = "DO_PACK.DO_HDR_INS" }; paramHDR.AddParamInOutput(0, "strDO_NO", OracleDbType.Varchar2, 255, delOrd.DO_NO); paramHDR.AddParamInput(1, "strDO_DATE ", delOrd.DO_DATE); paramHDR.AddParamInput(2, "strREF_NO", delOrd.REF_NO); paramHDR.AddParamInput(3, "strPROD_TYPE", delOrd.PROD_TYPE); paramHDR.AddParamInput(4, "strTO_DEST", delOrd.TO_DEST); paramHDR.AddParamInput(5, "strDELIVERY_DATE", delOrd.DELIVERY_DATE); paramHDR.AddParamInput(6, "strREMARK", delOrd.REMARK); paramHDR.AddParamInput(7, "strREC_STAT", (delOrd.REC_STAT ? "Y" : "N")); paramHDR.AddParamInput(8, "strUSER_ID", userid); paramHDR.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255); #endregion #region "Transcation Detail" List <ProcParam> lstParam = new List <ProcParam>(); ProcParam paramDTL = null; foreach (DeliveryOrderDtl delDtl in delOrd.DELIVERY_ORD_DTL) { paramDTL = new ProcParam(8); paramDTL.ProcedureName = "DO_PACK.DO_DTL_INS"; paramDTL.AddParamInput(0, "strDO_NO", DBNull.Value); paramDTL.AddParamInput(1, "strPROD_SEQ_NO", delDtl.PROD_SEQ_NO); paramDTL.AddParamInput(2, "strQTY", delDtl.QTY); paramDTL.AddParamInput(3, "strUNIT_ID", delDtl.UNIT_ID); paramDTL.AddParamInput(4, "strREMARK", delDtl.REMARK); paramDTL.AddParamInput(5, "strREC_STAT ", "Y"); //default is 'Y' paramDTL.AddParamInput(6, "strUSER_ID", userid); paramDTL.AddParamOutput(7, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK"); lstParam.Add(paramDTL); } #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR, lstParam, 0, 0); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)paramHDR.ReturnValue(0); OracleString result = (OracleString)paramHDR.ReturnValue(9); if (!result.IsNull) { delOrd.DO_NO = resultDB.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }