/// <summary> /// 修改支付机构记录 /// </summary> /// <param name="paymentOrganization"> /// 需修改的支付机构 /// </param> public void Modify(Config_Payment_Organization paymentOrganization) { this.paymentOrganizationDA.Update(paymentOrganization); }
/// <summary> /// 新增支付机构 /// </summary> /// <param name="paymentOrganization"> /// 要新增的支付机构 /// </param> /// <returns> /// 新增的支付机构Id /// </returns> /// <exception cref="Exception"> /// </exception> public int Insert(Config_Payment_Organization paymentOrganization) { var paraList = new List<SqlParameter>() { this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, paymentOrganization.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "PaymentTypeID", SqlDbType.Int, paymentOrganization.PaymentTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.VarChar, paymentOrganization.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ImageURL", SqlDbType.VarChar, paymentOrganization.ImageURL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, DateTime.Now, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, paymentOrganization.Sorting, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; try { this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Config_Payment_Organization_Insert", paraList, null); return (int)paraList.Find(p => p.ParameterName == "ReferenceID").Value; } catch (Exception exception) { throw new Exception("Exception - ConfigPaymentOrganization - Insert", exception); } }
/// <summary> /// 新增支付机构 /// </summary> /// <param name="paymentOrganization"> /// 需添加的支付机构 /// </param> /// <returns> /// 新增的支付机构ID /// </returns> public int Add(Config_Payment_Organization paymentOrganization) { return this.paymentOrganizationDA.Insert(paymentOrganization); }
/// <summary> /// 更新支付机构 /// </summary> /// <param name="paymentOrganization"> /// 要更新的支付机构 /// </param> /// <exception cref="Exception"> /// </exception> public void Update(Config_Payment_Organization paymentOrganization) { var paraList = new List<SqlParameter>() { this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, paymentOrganization.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "PaymentTypeID", SqlDbType.Int, paymentOrganization.PaymentTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.VarChar, paymentOrganization.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ImageURL", SqlDbType.VarChar, paymentOrganization.ImageURL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, DateTime.Now, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, paymentOrganization.Sorting, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ID", SqlDbType.Int, paymentOrganization.ID, ParameterDirection.Input) }; try { this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Config_Payment_Organization_Update", paraList, null); } catch (Exception exception) { throw new Exception("Exception - ConfigPaymentOrganization - Update", exception); } }