public GrossProfitForm() { InitializeComponent(); // This line of code is generated by Data Source Configuration Wizard // Instantiate a new DBContext MiniSteelworksMES.Data.MesEntities dbContext = new MiniSteelworksMES.Data.MesEntities(); // Call the LoadAsync method to asynchronously get the data for the given DbSet from the database. dbContext.GrossProfits.LoadAsync().ContinueWith(loadTask => { // Bind data to control when loading complete pivotGridControl1.DataSource = dbContext.GrossProfits.Local.ToBindingList(); }, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext()); // This line of code is generated by Data Source Configuration Wizard // Instantiate a new DBContext //MiniSteelworksMES.Data.MesEntities dbContext = new MiniSteelworksMES.Data.MesEntities(); // Call the LoadAsync method to asynchronously get the data for the given DbSet from the database. dbContext.GrossProfits.LoadAsync().ContinueWith(loadTask => { // Bind data to control when loading complete pivotGridControl1.DataSource = dbContext.GrossProfits.Local.ToBindingList(); }, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext()); // This line of code is generated by Data Source Configuration Wizard // Instantiate a new DBContext //MiniSteelworksMES.Data.MesEntities dbContext = new MiniSteelworksMES.Data.MesEntities(); // Call the LoadAsync method to asynchronously get the data for the given DbSet from the database. dbContext.GrossProfits.LoadAsync().ContinueWith(loadTask => { // Bind data to control when loading complete pivotGridControl1.DataSource = dbContext.GrossProfits.Local.ToBindingList(); }, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext()); }
public List <Transaction> GetByDate(DateTime start, DateTime end) { using (var context = new MesEntities()) { var query = from x in context.Transactions where x.Date >= start && x.Date <= end select x; return(query.ToList()); } }
public List <Transaction> GetByResourceIdAndDate(int rscId, DateTime start, DateTime end) { using (var context = new MesEntities()) { var query = from x in context.Transactions where x.Date >= start && x.Date <= end && x.ResourceId == rscId select x; List <Transaction> list = query.ToList(); return(query.ToList()); } }
public List <Transaction> GetByResourceId(int rscId) { using (var context = new MesEntities()) { var query = from x in context.Transactions where x.ResourceId == rscId select x; List <Transaction> list = query.ToList(); return(query.ToList()); } }
public int GetPageCount(int skipCount) { using (var context = new MesEntities()) { int totalCount = (from x in context.Transactions select x).Count(); int nPageCount = 0; nPageCount = totalCount / skipCount; if (totalCount % skipCount != 0) { nPageCount += 1; } return(nPageCount); } }
public List <Transaction> GetAllByPagingQuery(int showPage) { using (var context = new MesEntities()) { int totalCount = (from x in context.Transactions select x).Count(); int nPageCount = 0; nPageCount = totalCount / rowsCountPerPage; if (totalCount % rowsCountPerPage != 0) { nPageCount += 1; } var query = (from x in context.Transactions select x).OrderBy(x => x.Date).Skip((showPage - 1) * rowsCountPerPage).Take(rowsCountPerPage); return(query.ToList()); } }
public List <Transaction> Search() { using (MesEntities context = DbContextCreator.Create()) { Dictionary <int, string> ResourCeategories = context.Resources.ToDictionary( x => x.ResourceId, x => x.Name); var query = from x in context.Transactions select x; var list = query.ToList(); foreach (var x in list) { x.ResourceCategory = ResourCeategories[x.ResourceId]; } return(list); } }
//public List<TransactionModel> GetModels() //{ // using (MesEntities context = (MesEntities)DbContextCreator.Create()) // { // var query = (from x in context.Transactions // select x).GroupBy(x => x.ResourceId).Select( // group => new // { // group.FirstOrDefault().ResourceId, // Quantity = group.Sum( // x => x.Quantity) // }); // List<TransactionModel> list = new List<TransactionModel>(); // foreach (var item in query) // { // if (item != null) // list.Add(new TransactionModel(item.ResourceId, item.Quantity)); // } // foreach (var item in list) // { // Debug.WriteLine(item.ResourceId + " " + item.Quantity); // } // return list; // } //} //public List<TransactionModel> GetModels() //{ // using (MesEntities context = (MesEntities)DbContextCreator.Create()) // { // Dictionary<int, string> resourceNames = context.Resources.ToDictionary(x => x.ResourceId, x => x.Name); // var query = from x in context.Transactions // group x by x.ResourceId into g // select g; // List<TransactionModel> models = new List<TransactionModel>(); // foreach (var @group in query) // { // TransactionModel model = new TransactionModel(group.Key, group.Sum(x => x.Quantity));//key는 위에서 만든 g의 ResourceId // model.ResourceName = resourceNames[model.ResourceId]; // models.Add(model); // } // return models; // } //} public List <TransactionModel> GetModels() { using (MesEntities context = (MesEntities)DbContextCreator.Create()) { Dictionary <int, string> resourceNames = context.Resources.ToDictionary(x => x.ResourceId, x => x.Name); //Dictionary<int, DateTime> period = context.Transactions.ToDictionary(x => x.ResourceId, x => x.Date); var query = from x in context.Transactions //Transaction 요소를 모두 가져와 group x by x.ResourceId into g //ResourceId별로 정렬 select g; List <TransactionModel> models = new List <TransactionModel>(); foreach (var @group in query) { TransactionModel model = new TransactionModel(group.Key, group.Sum(x => x.Quantity));//key는 위에서 만든 g의 ResourceId model.ResourceName = resourceNames[model.ResourceId]; models.Add(model); } return(models); } }