public static void SaveManagerPrize(List <LadderManagerhistoryEntity> list, MailinfoDataSet.Mail_InfoDataTable mailInfoDataTable, string zoneId = "") { var connectionString = ConnectionFactory.Instance.GetConnectionString(zoneId, EnumDbType.Main); var ladderTable = BuildManagerPrizeTable(list); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { SaveManagerPrize(ladderTable, trans); MailSqlHelper.SaveMailBulk(mailInfoDataTable, trans); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } finally { conn.Close(); } } }
public static bool SaveMailBulk(MailinfoDataSet.Mail_InfoDataTable mailInfoData, SqlTransaction trans) { if (mailInfoData == null) { return(false); } SqlBatchHelper.BulkInsert(trans, mailInfoData); return(true); }
public static bool SaveMailBulk(MailinfoDataSet.Mail_InfoDataTable mailInfoData, string connectionstring) { if (mailInfoData == null) { return(false); } SqlBatchHelper.BulkInsert(connectionstring, mailInfoData); return(true); }
public static bool SaveMailBulk(MailinfoDataSet.Mail_InfoDataTable mailInfoData) { if (mailInfoData == null) { return(false); } SqlBatchHelper.BulkInsert(ConnectionFactory.Instance.GetDefault(), mailInfoData); return(true); }