public decimal UpdateContract_Logistic(Contrac_logistic Obj_Info) { try { OracleParameter paramReturn = new OracleParameter("p_result", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Common.gConnectString, CommandType.StoredProcedure, "pkg_contract_logistic.proc_logistic_update", new OracleParameter("p_id", OracleDbType.Decimal, Obj_Info.ID, ParameterDirection.Input), new OracleParameter("p_contract_code", OracleDbType.Varchar2, Obj_Info.Contract_code, ParameterDirection.Input), new OracleParameter("p_product_code", OracleDbType.Varchar2, Obj_Info.Product_code, ParameterDirection.Input), new OracleParameter("p_atz_recv_cert_date", OracleDbType.Date, Obj_Info.Atz_Recv_Cert_Date, ParameterDirection.Input), new OracleParameter("p_decla_open_date", OracleDbType.Date, Obj_Info.Decla_Open_Date, ParameterDirection.Input), new OracleParameter("p_decla_number", OracleDbType.Varchar2, Obj_Info.Decla_Number, ParameterDirection.Input), new OracleParameter("p_clearance_expec_date", OracleDbType.Date, Obj_Info.Clearance_Expec_Date, ParameterDirection.Input), new OracleParameter("p_clearance_date", OracleDbType.Date, Obj_Info.Clearance_Date, ParameterDirection.Input), new OracleParameter("p_exp_storage_cont_date", OracleDbType.Date, Obj_Info.Exp_Storage_Cont_Date, ParameterDirection.Input), new OracleParameter("p_exp_storage_bark_date", OracleDbType.Date, Obj_Info.Exp_Storage_Bark_Date, ParameterDirection.Input), new OracleParameter("p_exp_storage_space_date", OracleDbType.Date, Obj_Info.Exp_Storage_Space_Date, ParameterDirection.Input), new OracleParameter("p_notes", OracleDbType.Varchar2, Obj_Info.Notes, ParameterDirection.Input), new OracleParameter("p_modifiedby", OracleDbType.Varchar2, Obj_Info.ModifiedBy, ParameterDirection.Input), new OracleParameter("p_modifieddate", OracleDbType.Date, DateTime.Now, ParameterDirection.Input), paramReturn); return(Convert.ToDecimal(paramReturn.Value.ToString())); } catch (Exception ex) { Common.log.Error(ex.ToString()); return(-1); } }
public decimal Update_Contract_Logistic(Contrac_logistic Obj_Info) { Contrac_LogisticDA Obj_da = new Contrac_LogisticDA(); try { return(Obj_da.UpdateContract_Logistic(Obj_Info)); } catch (Exception ex) { Common.log.Error(ex.ToString()); return(-1); } }