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;
}
