コード例 #1
0
 public decimal Update(UTienInfo pInfo)
 {
     try
     {
         UuTien_DA _obj_da = new UuTien_DA();
         return(_obj_da.Update(pInfo));
     }
     catch (Exception ex)
     {
         Logger.LogException(ex);
         return(ErrorCode.Error);
     }
 }
コード例 #2
0
 public decimal Update(UTienInfo pInfo)
 {
     try
     {
         OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
         OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_don_uu_tien.proc_app_don_uu_tien_update",
                                      new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
                                      new OracleParameter("p_case_code", OracleDbType.Decimal, pInfo.Case_Code, ParameterDirection.Input),
                                      new OracleParameter("p_ut_sodon", OracleDbType.Varchar2, pInfo.UT_SoDon, ParameterDirection.Input),
                                      new OracleParameter("p_ut_ngaynopdon", OracleDbType.Date, pInfo.UT_NgayNopDon, ParameterDirection.Input),
                                      new OracleParameter("p_ut_quocgia", OracleDbType.Decimal, pInfo.UT_QuocGia, ParameterDirection.Input),
                                      new OracleParameter("p_ut_type", OracleDbType.Varchar2, pInfo.UT_Type, ParameterDirection.Input),
                                      new OracleParameter("p_ut_thoathuankhac", OracleDbType.Varchar2, pInfo.UT_ThoaThuanKhac, ParameterDirection.Input),
                                      paramReturn);
         var result = Convert.ToDecimal(paramReturn.Value.ToString());
         return(result);
     }
     catch (Exception ex)
     {
         Logger.LogException(ex);
         return(ErrorCode.Error);
     }
 }