public string UpdateMaterial(Material material, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(16) { ProcedureName = "MASTER_PACK.M_MATERIAL_UPD" }; param.AddParamInput(0, "strMTL_SEQ_NO", material.MTL_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)); } else { param.AddParamInput(10, "strMTL_IMAGE", DBNull.Value); } 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); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString result = (OracleString)param.ReturnValue(15); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }
public string UpdateProduct(Product prod, string userid) { string resultMsg = string.Empty; try { ProcParam param = new ProcParam(17) { ProcedureName = "MASTER_PACK.M_PRODUCT_UPD" }; param.AddParamInput(0, "strPROD_SEQ_NO", 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.AddParamBLOBInput(8, "strPROD_IMAGE", OracleDbType.Blob, 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 result = (OracleString)param.ReturnValue(16); if (!result.IsNull) { resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }