private void ListCategory() { MarketEntities db = new MarketEntities(); var ProductCategories = (from p in db.ProductCategories select new { p.categoryID, p.CategoryName }).ToList(); dgvProducts.DataSource = ProductCategories; }
private void ListProducts() { MarketEntities db = new MarketEntities(); var Products = (from p in db.Products select new { p.ProductID, p.BarcodeNo, p.ProductName, p.ProductPicture, p.Brand, p.Price, p.ExpirationDate, p.ProductionPlace, p.Contents, p.Weights, p.Stock, p.CategoryName }).ToList(); dgvProducts.DataSource = Products; }
private void ListCustomers() { MarketEntities db = new MarketEntities(); var Customers = (from c in db.Customers select new { c.CustomerID, c.FirstName, c.Addres, c.Phone, c.Mail, c.Gender, c.quantity, c.question, c.reply, c.Picture, c.Tc, c.UserName, c.UserPassword }).ToList(); dgvCustomers.DataSource = Customers; }
private void ListStaff() { MarketEntities db = new MarketEntities(); var Staff = (from c in db.Staffs select new { c.StaffID, c.FirstName, c.LastName, c.Addres, c.Tc, c.Gender, c.Picture, c.Phone, c.Mail, c.Username, c.UserPassword }).ToList(); dgvCustomers.DataSource = Staff; }
private void ListProducts() { MarketEntities db = new MarketEntities(); var JobApplications = (from c in db.JobApplications select new { c.Id, c.FirstName, c.LastName, c.Addres, c.Gender, c.Picture, c.Tc, c.Phone, c.Mail, c.Experience, c.Education, c.username, c.password }).ToList(); dgvCustomers.DataSource = JobApplications; }
private void ListGovernance() { MarketEntities db = new MarketEntities(); var Governances = (from p in db.Governances select new { p.GovernanceID, p.FirstName, p.LastName, p.Gender, p.UserName, p.UserPassword, }).ToList(); dgvProducts.DataSource = Governances; }
private void ListSales() { MarketEntities db = new MarketEntities(); var Sale = (from p in db.Sales select new { p.ProductID, p.BarcodeNo, p.CustomerFirstName, p.CustomerLastName, p.DateTimee, p.Price, p.ProductName, p.TotalPrice, }).ToList(); dgvCustomers.DataSource = Sale; }
//获取需要删除的里程碑 收款项 public void GetDelReceiptObjList(List <S_C_ManageContract_ReceiptObj> delReceiptObjList, string mileStoneID, string selectRecpObjIDs, MarketEntities marketEntities) { if (!string.IsNullOrEmpty(mileStoneID)) { //获得当前里程碑关联的收款项,但是本次没有选中的收款项,即需要删除和当前里程碑关联关系的收款项 var tempDelReceiptObjList = marketEntities.Set <S_C_ManageContract_ReceiptObj>().Where(c => c.MileStoneID.Contains(mileStoneID) && !selectRecpObjIDs.Contains(c.ID)).ToList(); foreach (var receiptObj in tempDelReceiptObjList) { if (string.IsNullOrEmpty(receiptObj.MileStoneID)) { continue; } //重新赋值收款项的里程碑ID、Name,去除当前里程碑 RemoveReceiptObjMileStoneInfo(receiptObj, mileStoneID); if (!delReceiptObjList.Contains(receiptObj)) { delReceiptObjList.Add(receiptObj); } } } }
public MarketEntities Init() { return(dbContext ?? (dbContext = new MarketEntities())); }
private void ListStaff() { MarketEntities db = new MarketEntities(); var Staff = (from c in db.Staffs select new { c.StaffID, c.FirstName, c.LastName, c.Mail, }).ToList(); dgvCustomers.DataSource = Staff; }
private void ListSale() { MarketEntities db = new MarketEntities(); var Sepet = (from c in db.Sepets select new { c.BarcodeNo, c.Ad, c.Soyad, c.DateTimee, c.Price, c.ProductID, c.ProductName, c.quantity, c.TotalPrice }).ToList(); dgvProducts.DataSource = Sepet; }
public ProductDataAcess(MarketEntities entities) : base(Program.conn) { this.entities = entities; }