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; } }