public List<Ranks> RanksSort(List<Ranks> ranks)
{
long count = ranks.Count;
for (int i = 0; i < count - 1; i++)
for (int j = 0; j < count - 1 - i; j++)
{
if (ranks[j].Solved < ranks[j + 1].Solved)
{
long t = ranks[j].Position;
ranks[j].Position = ranks[j + 1].Position;
ranks[j + 1].Position = t;
Ranks rk = ranks[j];
ranks[j] = ranks[j + 1];
ranks[j + 1] = rk;
}
else if (ranks[j].Solved != 0 && ranks[j + 1].Solved != 0 && ranks[j].Solved == ranks[j + 1].Solved)
if(ranks[j].LastTimeOfAc > ranks[j + 1].LastTimeOfAc)
{
long t = ranks[j].Position;
ranks[j].Position = ranks[j + 1].Position;
ranks[j + 1].Position = t;
Ranks rk = ranks[j];
ranks[j] = ranks[j + 1];
ranks[j + 1] = rk;
}
}
return ranks;
}
public List<IFeedItem> ReadIFeedItems(Uri uri)
{
var feedItems = new List<Data.IFeedItem>();
SyndicationFeed syndicationFeed;
using (var xmlReader = XmlReader.Create(uri.AbsoluteUri))
{
syndicationFeed = SyndicationFeed.Load(xmlReader);
xmlReader.Close();
}
foreach (var item in syndicationFeed.Items)
{
var feedItem = new FeedItem();
var id = Guid.NewGuid();
feedItem.Id = Guid.TryParse(item.Id, out id) ? new Guid(item.Id) : id;
feedItem.Title = item.Title.Text;
feedItem.Mp3Url = item.Links[0].Uri;
feedItem.PublishDate = item.PublishDate.DateTime;
feedItems.Add(feedItem);
}
var ret = new List<IFeedItem>();
feedItems.ForEach(x => ret.Add(new FeedItem() { Id = x.Id, Mp3Url = x.Mp3Url, PublishDate = x.PublishDate, Title = x.Title }));
return ret;
}
public static void actualizarSectoresEdificio(edificio edificio, List<sector> sectores)
{
try {
admEntities db = Datos.getDB();
var s = db.edificios_sectores.Where(x => x.dir_edificio == edificio.direccion).ToList();
foreach (var sectB in s)
{
db.edificios_sectores.Remove(sectB);
}
foreach (sector sect in sectores)
{
edificios_sectores es = new edificios_sectores();
es.dir_edificio = edificio.direccion;
es.id_sector = sect.idsector;
db.edificios_sectores.Add(es);
}
db.SaveChanges();
}
catch (Exception e)
{
string str = e.InnerException == null ? e.Message : e.InnerException.Message;
Logger.Log.write(str);
throw e;
}
}
/// <summary>
/// Validates the field values of this object. Override this method to enable
/// validation of field values.
/// </summary>
/// <param name="validationResults">The validation results, add additional results to this list.</param>
protected override void ValidateFields(List<IFieldValidationResult> validationResults)
{
if (string.IsNullOrWhiteSpace(Name))
{
validationResults.Add(FieldValidationResult.CreateError(NameProperty, "Name of room is required"));
}
}
public void StatC5CX(List<DwNumber> numbers, string dbName)
{
string[] dmNames = new string[] { "Peroid", "He" };
string[] numberTypes = new string[] { "A2", "A3", "A4", "A6", "A7", "A8" };
DwC5CXSpanBiz spanBiz = new DwC5CXSpanBiz(dbName);
foreach (var numberType in numberTypes)
{
Dictionary<string, Dictionary<string, int>> lastSpanDict = new Dictionary<string, Dictionary<string, int>>(16);
List<DwC5CXSpan> c5cxSpans = new List<DwC5CXSpan>(numbers.Count * 20);
string newNumberType = numberType.Replace("A", "C");
string tableName = string.Format("{0}{1}", "C5", newNumberType);
spanBiz.DataAccessor.TableName = ConfigHelper.GetDwSpanTableName(tableName);
long lastP = spanBiz.DataAccessor.SelectLatestPeroid(string.Empty);
foreach (DwNumber number in numbers)
{
var cxNumbers = NumberCache.Instance.GetC5CXNumbers(number.C5, newNumberType);
var c5cxSpanList = this.GetC5CXSpanList(lastSpanDict, cxNumbers, number, dmNames);
if (number.P > lastP)
c5cxSpans.AddRange(c5cxSpanList);
}
spanBiz.DataAccessor.Insert(c5cxSpans, SqlInsertMethod.SqlBulkCopy);
Console.WriteLine("{0} {1} Finished", dbName, tableName);
}
Console.WriteLine("{0} {1} Finished", dbName, "ALL C5CX Span");
}
public static List<Staff> getAllStaff()
{
List<Staff> StaffsList = new List<Staff>();
//Connect to SQL Server
SqlConnection conn = new SqlConnection("Data Source=(local); Database=WebDevelopmentDB; Integrated Security=SSPI");
//Select all columns for a given StaffID as well as their password hash
SqlCommand cmd = new SqlCommand("SELECT dbo.Staff.GivenName, dbo.Staff.Surname, dbo.Staff.Email, dbo.Staff.PhoneNumber1, dbo.Staff.PhoneNumber2, dbo.Staff.Role, dbo.Accounts.PassHash FROM dbo.Staff INNER JOIN dbo.Accounts ON dbo.Staff.StaffID = dbo.Accounts.AccID)", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read()) {
StaffsList.Add(new Staff{
GivenName = rdr[0].ToString(),
Surname = rdr[1].ToString(),
Address = rdr[2].ToString(),
Email = rdr[3].ToString(),
Phone1 = rdr[4].ToString(),
Phone2 = rdr[5].ToString(),
Role = rdr[6].ToString(),
PassHash = rdr[7].ToString()});
}
//Close the reader and the SQL connection
if (rdr != null) {
rdr.Close();
}
conn.Close();
return StaffsList;
}
/// <summary>
/// Validates the field values of this object. Override this method to enable
/// validation of field values.
/// </summary>
/// <param name="validationResults">The validation results, add additional results to this list.</param>
protected override void ValidateFields(List<IFieldValidationResult> validationResults)
{
if (string.IsNullOrWhiteSpace(ApiKey))
{
validationResults.Add(FieldValidationResult.CreateError(ApiKeyProperty, "Api key is required"));
}
}
public static List<UserProfile> GetFarFromOneRelations(Guid userId)
{
// On cherche nos relations. On cherche les relations de nos relations => récursif
List<UserProfile> listUserRelations = GetRelations(userId);
List<UserProfile> listLoggedUserRelation = GetRelations((Guid)(Membership.GetUser(System.Web.HttpContext.Current.User.Identity.Name, false).ProviderUserKey));
List<UserProfile> listFarFromOneRelations = new List<UserProfile>();
// We search all the directly connected users to the actual logged user relations
foreach (UserProfile userRelation in listUserRelations)
{
listFarFromOneRelations.AddRange(GetRelations((Guid)(Membership.GetUser(userRelation.UserName, false).ProviderUserKey)));
}
UserProfile actualUser = UserProfile.GetUserProfile(System.Web.HttpContext.Current.User.Identity.Name);
while(listFarFromOneRelations.Contains(actualUser))
{
// We delete all the occurences of the actual user
listFarFromOneRelations.Remove(actualUser);
}
// On supprime les utilisateurs qui sont déjà directement connectés avec l'utilisateur
foreach (UserProfile user in listLoggedUserRelation)
{
if (listFarFromOneRelations.Contains(user))
{
listFarFromOneRelations.Remove(user);
}
}
return listFarFromOneRelations;
}
public static IRepository<Book> Create()
{
var listOfBooks = new List<Book>();
for (int i = 0; i < 20; i++)
{
listOfBooks.Add(new Book
{
Id = i,
Title = "Book " + i,
Description = "Description" + i,
Author = new Author
{
FirstName = "FirstName " + i,
LastName = "LastName " + i
}
});
}
var repository = new Mock<IRepository<Book>>();
repository.Setup(r => r.All()).Returns(listOfBooks.AsQueryable());
repository.Setup(r => r.Add(It.IsAny<Book>())).Callback<Book>(b =>
{
b.Id = 1;
});
repository.Setup(r => r.SaveChanges()).Verifiable();
return repository.Object;
}
private void btnCobrar_Click(object sender, EventArgs e)
{
List<CatalogoDeudores.DetalleDeuda> detalles = new List<CatalogoDeudores.DetalleDeuda>();
foreach (DataGridViewRow r in dgvLista.Rows)
{
if (r.Cells["Seleccion"].Value != null)
{
CatalogoDeudores.DetalleDeuda d = ((CatalogoDeudores.DetalleDeuda)r.DataBoundItem);
Business.ControladorExpensas.registrarPago(d);
detalles.Add(d);
}
}
if (detalles.Count > 0)
{
if (MessageBox.Show("Desea imprimir comprobante?", "Sistema", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
unidad u = (unidad)cmbUnidad.SelectedItem;
titular t = u.titular;
System.Diagnostics.Process.Start(Business.ControladorExpensas.emitirRecibo(Properties.Resources.qr, detalles, u, t));
}
}
cmbUnidad_SelectedIndexChanged(sender, e);
lblImporte.Text = lblRecargo.Text = lblTotalAPagar.Text = "0,00";
}
public void Deserialise(Reader In)
{
Bookings = new List<Booking>(In.ReadInt32());
for (int x = 0; x < Bookings.Capacity; x++)
Bookings.Add(DataModel.DeserialiseExternal<Booking>(In));
Departments = new List<Department>(In.ReadInt32());
for (int x = 0; x < Departments.Capacity; x++)
Departments.Add(DataModel.DeserialiseExternal<Department>(In));
Periods = new List<TimeSlot>(In.ReadInt32());
for (int x = 0; x < Periods.Capacity; x++)
Periods.Add(DataModel.DeserialiseExternal<TimeSlot>(In));
Rooms = new List<Room>(In.ReadInt32());
for (int x = 0; x < Rooms.Capacity; x++)
Rooms.Add(DataModel.DeserialiseExternal<Room>(In));
Users = new List<User>(In.ReadInt32());
for (int x = 0; x < Users.Capacity; x++)
Users.Add(DataModel.DeserialiseExternal<User>(In));
Subjects = new List<Subject>(In.ReadInt32());
for (int x = 0; x < Subjects.Capacity; x++)
Subjects.Add(DataModel.DeserialiseExternal<Subject>(In));
Classes = new List<Class>(In.ReadInt32());
for (int x = 0; x < Classes.Capacity; x++)
Classes.Add(DataModel.DeserialiseExternal<Class>(In));
}
public static void C5CX(string name, string type, int length, string output)
{
List<DmDPC> srcNumbers = null;
if (length > 5)
{
srcNumbers = NumberCache.Instance.GetNumberList(type);
}
else
{
srcNumbers = NumberCache.Instance.GetNumberList("C5");
}
DmC5CXBiz biz = new DmC5CXBiz(name);
List<DmC5CX> entities = new List<DmC5CX>(srcNumbers.Count * 56);
foreach (var srcNumber in srcNumbers)
{
string number = srcNumber.Number.Replace(' ', ',');
var cxNumbers = new Combinations<int>(number.ToList(), length > 5 ? 5 : length);
foreach (var cxNumber in cxNumbers)
{
string cx = NumberCache.Instance.GetNumberId(length > 5 ? "C5" : type, cxNumber.Format("D2", ","));
DmC5CX entity = new DmC5CX();
entity.C5 = (length > 5) ? cx : srcNumber.Id;
entity.CX = (length > 5) ? srcNumber.Id : cx;
entity.C5Number = (length > 5) ? cx.ToString(2, " ") : srcNumber.Number;
entity.CXNumber = (length > 5) ? srcNumber.Number : cx.ToString(2, " ");
entity.NumberType = type;
entities.Add(entity);
}
}
//biz.DataAccessor.Truncate();
biz.DataAccessor.Insert(entities, SqlInsertMethod.SqlBulkCopy);
}
protected void Page_Load(object sender, EventArgs e)
{
List<recommandation> listR = new List<recommandation>();
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
//on recupere le parametre "del" pour voir si il y a un message à effacer
if (Request.Params["del"] != null && Convert.ToInt16(Request.Params["del"]) != 0)
{
//RecommandationService.deleteRecommandation(Convert.ToInt16(Request.Params["del"]),2);
not.Text = "Recommandation effacée";
}
listR = RecomendationService.getRecommandations((Guid)Membership.GetUser(userName, false).ProviderUserKey);
if (listR.Count > 0)
{
//o utilise le template pour les messages envoyés
rpt.DataSource = RecomendationService.RecommandationToRecommandationPlus(listR);
rpt.DataBind();
}
else
{
errorMessage("Aucune recommandation à afficher");
}
}
else
{
errorMessage("Erreur");
}
}
private void Span(List<DwNumber> numbers)
{
string[] dxs = { "D1", "D2", "D3", "D4", "D5" };
var spanDict = new Dictionary<int, int>(11);
StreamWriter sw = new StreamWriter(@"d:\c1span.txt", false, Encoding.UTF8);
foreach (var number in numbers)
{
foreach (var dx in dxs)
{
int spans = number.Seq - 1;
int dxValue = ConvertHelper.GetInt32(number[dx].ToString());
if (spanDict.ContainsKey(dxValue))
{
spans = number.Seq - spanDict[dxValue] - 1;
spanDict[dxValue] = number.Seq;
}
else
{
spanDict.Add(dxValue, -1);
}
sw.WriteLine("{0},{1},{2}", number.P, dxValue, spans);
}
}
sw.Close();
}
public static List<ExpensasEdificio> getAllExpensas(List<edificio> edificios, DateTime periodo, DateTime vto1, DateTime vto2)
{
try
{
List<ExpensasEdificio> expensas = new List<ExpensasEdificio>();
admEntities db = Datos.getDB();
//var edificios = db.edificio.ToList();
int MaxNroFactura = 0;
List<string> nroFactura = db.Database.SqlQuery<String>(@"select nro_factura from expensas").ToList();
foreach (var s in nroFactura)
{
int temp = int.Parse(s);
if (temp > MaxNroFactura)
MaxNroFactura = temp;
}
int correlativo = MaxNroFactura + 1;
DateTime asd = DateTime.Parse("1 /" + periodo.Month + "/" + periodo.Year);
List<expensas> expensasExistentes = db.expensas.Where(x => x.fecha == asd).ToList();
foreach (var e in edificios)
{
expensas.Add(getExpensasEdificio(e, periodo, vto1, vto2, ref correlativo, db, expensasExistentes));
}
return expensas;
}
catch (Exception e)
{
Logger.Log.write(e.InnerException == null ? e.Message : e.InnerException.Message);
throw e;
}
}
public CategorySettingsForm(List<Category> categories, List<IFeed> allFeeds)
{
InitializeComponent();
this.Categories = categories;
this.AllFeeds = allFeeds;
IsCategoriesChanged = false;
}
// GET: Matching
public ActionResult Index()
{
//Check if user is logged in
if (!PageAuthorization.Authorize()) return RedirectToAction("Login", "Users");
//User user = new User();
//user.Id = 72;
var user = (User)Session["logged_in_user_obj"];
var client = new SMARestClient("MeetUpService.svc");
var meetupContent = client.Get<List<MeetUp>>("meetups/").ToList();
List<MeetUp> received = new List<MeetUp>();
List<MeetUp> sent = new List<MeetUp>();
foreach (var item in meetupContent)
{
if (item.Guide.Id == user.Id)
{
received.Add(item);
}
}
foreach (var item in meetupContent)
{
if (item.Traveler.Id == user.Id)
{
sent.Add(item);
}
}
ViewBag.ReceivedRequest = received;
ViewBag.SentRequest= sent;
return View();
}
public static Game Build()
{
var hidingSpots = new List<HidingSpot>();
var rnd = new Random();
var indexOfHidingSpot = rnd.Next(9);
for (var idx = 0; idx < 9; idx++)
{
hidingSpots.Add(new HidingSpot
{
Id = idx,
HasBeenChecked = false,
HasTreasure = idx == indexOfHidingSpot
});
}
_game = new Game
{
Id = 1,
TurnsRemaining = 3,
HidingSpots = hidingSpots
};
return _game;
}
public static List<Class> getClasses(string student)
{
List<Class> classList = new List<Class>();
//Connect to SQL Server
SqlConnection conn = new SqlConnection("Data Source=PANDORASBOX\\PANDORASBOX; Database=WebDevelopmentDB; Integrated Security=SSPI");
conn.Open();
ClassRoster roster = new ClassRoster(int.Parse(student));
//Select all columns for a given StaffID as well as their password hash
for (int i = 0; i <= roster.Roster.GetLength(0); i++) {
SqlCommand cmd = new SqlCommand("SELECT ClassCode, Day, Time, Semester, TutorID FROM dbo.ClassList WHERE (ClassCode = " + roster.Roster[i, 0] + ")", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read()) {
classList.Add(new Class {
ClassCode = rdr[0].ToString(),
Day = rdr[1].ToString(),
Time = rdr[2].ToString(),
Semester = rdr[3].ToString(),
TutorID = rdr[4].ToString()
});
}
//Close the reader and the SQL connection
if (rdr != null) {
rdr.Close();
}
conn.Close();
}
return classList;
}
public int Them(BOXuLyKho item, List<BOXuLyKhoChiTiet> lsArray, Transit mTransit)
{
ThemMoi(item, lsArray, mTransit);
frmXuLyKho.AddObject(item.XuLyKho);
frmXuLyKho.Commit();
return item.XuLyKho.ChinhKhoID;
}
/// <summary>
/// Devuelve las personas.
/// </summary>
/// <returns>Las personas.</returns>
public static List<Persona> GetPersonasAsList()
{
_dataServer.IniciarTransaccion();
try
{
List<Persona> result = new List<Persona>();
const string Query = "SELECT Id, Nombre, Apellido FROM PERSONAS";
SqlDataReader dataReader = _dataServer.GetDataReader(Query);
while (dataReader.Read())
{
Persona persona = new Persona
{
Id = (int) dataReader["Id"],
Nombre = (string) dataReader["Nombre"],
Apellido = (string) dataReader["Apellido"]
};
result.Add(persona);
}
dataReader.Close();
return result;
}
finally
{
_dataServer.TerminarTrasaccion();
}
}
/// <summary>
/// Создание карточки с фиксированными параметрами.
/// </summary>
public Card()
{
this.Name = "Ivan";
this.SynCode = 100500;
this.Id = 1;
this.ContactsList = new List<Contact>();
}
public static void StorePageLinks(CmsPage page) {
var redirects = new List<RedirectEntity>();
PopulatePageList(redirects, page);
ThreadPool.QueueUserWorkItem(callback => AddPageLinksToDatabase(redirects));
}
public IEnumerable<User> GetAllUsers()
{
var friends = this.UserRepository.GetAllUsers().ToList();
var userFriends = new List<User>();
friends.ForEach(f => f.ParseUserFriend(ref userFriends));
return userFriends;
}
public Feed ReadFeed(Uri uri)
{
Feed feed = null;
var feedItems = new List<FeedItem>();
Category category = null;
SyndicationFeed syndicationFeed;
using (var xmlReader = XmlReader.Create(uri.AbsoluteUri))
{
syndicationFeed = SyndicationFeed.Load(xmlReader);
xmlReader.Close();
}
if (syndicationFeed == null) return null;
foreach (var item in syndicationFeed.Items)
{
var feedItem = new FeedItem();
Guid id;
feedItem.Id = Guid.TryParse(item.Id, out id) ? id : new Guid();
feedItem.Title = item.Title.Text;
feedItem.Mp3Url = item.Links.Count > 1 ? item.Links[1].Uri : item.Links[0].Uri;
feedItem.PublishDate = item.PublishDate.DateTime;
feedItem.Description = StripHTML(item.Summary.Text);
feedItem.IsUsed = false;
feedItems.Add(feedItem);
}
var items = new List<Data.IFeedItem>();
feedItems.ForEach(x => items.Add(x));
feed = new Feed(Guid.NewGuid(), syndicationFeed.Title.Text, items, uri, category,0);
return feed;
}
public IEnumerable<Movie> GetUserMovies(int userId)
{
var movies = this.UserRepository.GetUserMovies(userId).ToList();
var userMovies = new List<Movie>();
movies.ForEach(m => m.ParseMovies(ref userMovies));
return userMovies;
}
public Publications Get(int id)
{
var list = context.Web.Lists.GetByTitle(Title);
var query = new CamlQuery() { ViewXml = "<View><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Integer'>" + id + "</Value></Eq></Where></Query><RowLimit>1</RowLimit></View>" };
var items = list.GetItems(query);
context.Load(items);
context.ExecuteQuery();
if (items.Count > 0)
{
string[] lines = items[0]["_x0422__x044d__x0433__x0438_"].ToString().Split(',');
var tags = new List<Tag>();
foreach (var line in lines)
{
tags.Add(mapTag(line));
}
return new Publications()
{
Title = items[0]["Title"].ToString(),
Article = items[0]["_x0421__x0442__x0430__x0442__x04"].ToString(),
PublicationDate = ((DateTime)items[0]["_x0414__x0430__x0442__x0430__x00"]).AddDays(1),
Source = items[0]["_x0418__x0441__x0442__x043e__x04"].ToString(),
Subtitle = items[0]["_x041f__x043e__x0434__x0437__x04"].ToString(),
Tags = tags
};
}
else
{
return null;
}
}
public static void Main()
{
var tupacDisciplines = new List<Discipline>
{
new Discipline(DisciplineName.Music, 10, 10),
new Discipline(DisciplineName.History, 8, 8)
};
var studentsFromClassA = new List<Student>
{
new Student("Marshall", "Mathers"),
new Student("Earl", "Simmons"),
new Student("Mary", "Blige")
};
var studentsFromClassB = new List<Student>
{
new Student("William", "Roberts"),
new Student("Dwayne", "Carter"),
new Student("Kimberly", "Jones")
};
var teachers = new List<Teacher>
{
new Teacher("Tupac", "Shakur", tupacDisciplines)
};
var classA = new SchoolClass(teachers, studentsFromClassA);
var classB = new SchoolClass(teachers, studentsFromClassB);
var school = new School(new List<SchoolClass> { classA, classB });
Console.WriteLine(school);
}
/// <summary>
/// Inserta en la tabla FUNCIONALIDAD_ROL las funcionalidades seleccionadas que se van a usar en un rol.
/// </summary>
/// <param name="rolId"></param>
/// <param name="funcionalidades"></param>
public static void Insertar(Int32 rolId, List<Int32> funcionalidades)
{
using (var con = DataAccess.GetConnection())
{
var delete = new SqlCommand(SP_DELETE, con);
delete.CommandType = CommandType.StoredProcedure;
delete.Parameters.Add("@idrol", SqlDbType.Int).Value = rolId;
SqlCommand insert = null;
con.Open();
using (var trans = con.BeginTransaction())
{
//En 1 sola transaccion , borro todas los registros viejos e inserto los seleccionados.
//Borron y cuenta nueva.
delete.Transaction = trans;
delete.ExecuteNonQuery();
foreach (var id in funcionalidades)
{
//aca probe reusando la variable y modificando solo el valor del parametro.
//no quiso andar asi que lo martilleamos y listo.
insert = new SqlCommand(SP_INSERT, con, trans);
insert.CommandType = CommandType.StoredProcedure;
insert.Parameters.Add("@id_rol", SqlDbType.Int).Value = rolId;
insert.Parameters.Add("@id_funcionalidad", SqlDbType.Int).Value = id;
insert.ExecuteNonQuery();
}
trans.Commit();
}
con.Close();
}
}
public static void Import11x5()
{
List<NumberType> numberTypes = NumberTypeBiz.Instance.GetAll().Where(x => x.RuleType.Contains("11X5")).ToList();
string[] number1 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012" };
string[] number2 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
string[] number3 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "AC", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
foreach (var numberType in numberTypes)
{
if (numberType.Code.StartsWith("A")) continue;
Data.Biz.D11X5.DmDPCBiz biz = new Data.Biz.D11X5.DmDPCBiz("jiangx11x5", numberType.Code.GetDmTableSuffix());
List<DimensionNumberType> ntds = new List<DimensionNumberType>();
if (numberType.Length == 1)
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number1, numberType.Code);
else if (numberType.Length == 2)
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number2, numberType.Code);
else
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number3, numberType.Code);
foreach (var ntd in ntds)
{
ntd.NumberType = numberType.Code;
ntd.RuleType = numberType.RuleType;
ntd.Amount = ntd.Nums * numberType.Amount;
ntd.Probability = (ntd.Nums * 1.0) * numberType.Probability;
}
DimensionNumberTypeBiz.Instance.DataAccessor.Insert(ntds, SqlInsertMethod.SqlBulkCopy);
}
}
