//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 LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable BuildManagerPrizeTable(List<LadderManagerhistoryEntity> list) //{ // LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable dataTable = new LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable(); // foreach (var entity in list) // { // var row = dataTable.NewRow(); // row["Idx"] = entity.Idx; // row["Season"] = entity.Season; // row["ManagerId"] = entity.ManagerId; // row["Rank"] = entity.Rank; // row["Score"] = entity.Score; // row["PrizeItems"] = entity.PrizeItems; // row["Status"] = entity.Status; // row["RowTime"] = entity.RowTime; // dataTable.Rows.Add(row); // } // return dataTable; //} public static void SaveManagerPrize(LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable dataTable, SqlTransaction trans) { SqlCommand cmd = SqlBatchHelper.GetMyCommand(trans.Connection, CommandType.StoredProcedure, "C_Ladder_SavePrize"); cmd.AddMyParameter("@Idx", SqlDbType.Int, dataTable.IdxColumn.ColumnName); cmd.AddMyParameter("@PrizeItems", SqlDbType.VarChar, dataTable.PrizeItemsColumn.ColumnName); SqlDataAdapter adap = SqlBatchHelper.GetMyBatchAdapter(null, cmd, cmd, cmd); cmd.Transaction = trans; adap.Update(dataTable); cmd.Parameters.Clear(); }
public static LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable BuildManagerPrizeTable(List <LadderManagerhistoryEntity> list) { LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable dataTable = new LadderManagerhistoryDataSet.Ladder_ManagerHistoryDataTable(); foreach (var entity in list) { var row = dataTable.NewRow(); row["Idx"] = entity.Idx; row["Season"] = entity.Season; row["ManagerId"] = entity.ManagerId; row["Rank"] = entity.Rank; row["Score"] = entity.Score; row["PrizeItems"] = entity.PrizeItems; row["Status"] = entity.Status; row["RowTime"] = entity.RowTime; dataTable.Rows.Add(row); } return(dataTable); }