public static int SaveCustomerAddress(DataBaseTransaction p_tran, int p_CustomerID, string p_Address1, string p_Address2, string p_City, string p_State, string p_ZIP, int p_Country, string p_DayPhone, string p_MobilePhone, string p_Email)
{
StoredProcedure sp = new StoredProcedure("p_CustomerAddresses_i", p_tran);
sp["@CustomerID"].Value = p_CustomerID;
sp["@Address1"].Value = p_Address1.Trim();
sp["@Address2"].Value = p_Address2 == null ? DBNull.Value : (object)p_Address2;
sp["@City"].Value = p_City.Trim();
sp["@State"].Value = p_State.Trim();
sp["@ZIP"].Value = p_ZIP.Trim();
sp["@Country"].Value = p_Country;
sp["@DayPhone"].Value = p_DayPhone;
sp["@MobilePhone"].Value = p_MobilePhone.Trim();
sp["@Email"].Value = p_Email.Trim();
return sp.ExecuteReturn();
}
public void Dispose()
{
if (m_tran.IsInTransaction)
m_tran.Rollback();
m_tran = null;
m_Proc.CloseConnection();
m_Proc = null;
}
public BannersData()
{
m_tran = new DataBaseTransaction(false);
m_Proc = new StoredProcedure(m_tran);
}
/// <summary>
/// 批量添加
/// </summary>
/// <param name="list">Comments实体列表</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool AddBatch(List<CommentsModel> list)
{
try
{
using (DataBaseTransaction trans = new DataBaseTransaction(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig)))
{
foreach(CommentsModel comments in list)
{
Add(comments,trans.DbTransaction);
}
trans.Complete();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="list">Admin主键实体列表</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool DeleteBatch(List<int> list)
{
try
{
using (DataBaseTransaction trans = new DataBaseTransaction(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig)))
{
foreach(int aid in list)
{
Delete(aid,trans.DbTransaction);
}
trans.Complete();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 批量更新
/// </summary>
/// <param name="list">Admin实体列表</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool UpdateBatch(List<AdminModel> list)
{
try
{
using (DataBaseTransaction trans = new DataBaseTransaction(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig)))
{
foreach(AdminModel admin in list)
{
Update(admin.AId,admin,trans.DbTransaction);
}
trans.Complete();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 批量更新
/// </summary>
/// <param name="list">JQResource实体列表</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool UpdateBatch(List<JQResourceModel> list)
{
try
{
using (DataBaseTransaction trans = new DataBaseTransaction(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig)))
{
foreach(JQResourceModel jqresource in list)
{
Update(jqresource.JQRId,jqresource,trans.DbTransaction);
}
trans.Complete();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 批量更新
/// </summary>
/// <param name="list">OrderTable实体列表</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool UpdateBatch(List<OrderTableModel> list)
{
try
{
using (DataBaseTransaction trans = new DataBaseTransaction(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig)))
{
foreach(OrderTableModel ordertable in list)
{
Update(ordertable.OTId,ordertable,trans.DbTransaction);
}
trans.Complete();
}
return true;
}
catch
{
return false;
}
}
