public bool AddNewCraft(T_Crafts craft)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(craft).State = EntityState.Added;
return db.SaveChanges() > 0 ? true : false;
}
}
/// <summary>
/// 删除销售订单主表
/// </summary>
/// <param name="so">销售订单主表</param>
/// <returns></returns>
public bool DeleteSaleOrder(T_saleorder so)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(so).State = EntityState.Deleted;
return db.SaveChanges() > 0 ? true : false;
}
}
internal void DelSupplierContacts(T_Suppliers_contacts contact)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(contact).State = EntityState.Deleted;
db.SaveChanges();
}
}
internal void DelCustomerAddress(T_Customer_address address)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(address).State = EntityState.Deleted;
db.SaveChanges();
}
}
internal void addNewCustomer(T_Customer newcustomer)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Customer.Add(newcustomer);
db.SaveChanges();
}
}
internal void AddCustomerAddress(T_Customer_address address)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Customer_address.Add(address);
db.SaveChanges();
}
}
internal void addNewSupplier(T_Suppliers newsupplier)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Suppliers.Add(newsupplier);
db.SaveChanges();
}
}
/// <summary>
/// 添加新的报价单产品明细
/// </summary>
/// <param name="qtprice"></param>
public bool AddNewQtPrice(QtProduct qtprice)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry<T_quotationprice>(qtprice.qp).State = EntityState.Added;
return db.SaveChanges() > 0 ? true : false;
}
}
public bool AddNewProduct(T_Product product)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Product.Add(product);
return db.SaveChanges() > 0 ? true : false;
}
}
internal void AddCustomerContacts(T_Customer_contacts contact)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Customer_contacts.Add(contact);
db.SaveChanges();
}
}
public List<T_Customer> getCustomerAllList()
{
using (MEMSContext db = new MEMSContext())
{
var clist = from c in db.T_Customer
select c;
return clist.ToList();
}
}
internal void AddSupplierContacts(T_Suppliers_contacts contact)
{
using (MEMSContext db = new MEMSContext())
{
db.T_Suppliers_contacts.Add(contact);
db.SaveChanges();
}
}
public List<T_Suppliers> getSupplierList()
{
using (var db = new MEMSContext())
{
var rst = from s in db.T_Suppliers
select s;
//select new { s.id, s.supplierno, s.suppliername, s.suppliertype, s.simplename, s.country, s.province, s.city };
return rst.ToList();
}
}
internal void delCustomer(T_Customer customer)
{
using (MEMSContext db = new MEMSContext())
{
//db.T_Customer.Remove(customer);
var entityentry = db.Entry(customer);
entityentry.State = EntityState.Deleted;
db.SaveChanges();
}
}
public T_Customer getCustomerByid(int id)
{
using (MEMSContext db = new MEMSContext())
{
var customer = from c in db.T_Customer
where c.id == id
select c;
return customer.First();
}
}
public List<T_Suppliers> getSupplierList(string sno,string sname)
{
using (var db = new MEMSContext())
{
var rst = from s in db.T_Suppliers
where s.supplierno.Contains(sno) && s.suppliername.Contains(sname)
select s;
return rst.ToList();
}
}
public T_Suppliers getSupplierbyId(int id)
{
using (var db = new MEMSContext())
{
var rst = from s in db.T_Suppliers
where s.id == id
select s;
return rst.FirstOrDefault();
}
}
//public List<SaleRev> getSaleRevList(int soid)
//{
// using (MEMSContext db = new MEMSContext())
// {
// var rs=from r in db.T_SaleReceive
// join u in db.t_
// }
//}
public bool AddNewSaleRev(List<T_SaleReceive> revlst)
{
using (MEMSContext db = new MEMSContext())
{
foreach (var r in revlst)
{
db.Entry<T_SaleReceive>(r).State = EntityState.Added;
}
return db.SaveChanges() > 0 ? true : false;
}
}
public bool AddNewCraftPricelst(List<T_CraftsPrice> ncplst, int pbid)
{
using (MEMSContext db = new MEMSContext())
{
foreach (var newcp in ncplst)
{
newcp.pricebasicid = pbid;
db.Entry(newcp).State = EntityState.Added;
}
return db.SaveChanges() > 0 ? true : false;
}
}
/// <summary>
/// 添加新销售订单主从表信息
/// </summary>
/// <param name="so">主表对象</param>
/// <param name="sdlist">从表对象</param>
/// <returns></returns>
public bool AddNewSaleOrder(T_saleorder so, List<T_saledetail> sdlist)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(so).State = EntityState.Added;
db.SaveChanges();
foreach (var sd in sdlist)
{
sd.soid = so.id;
db.Entry(sd).State = EntityState.Added;
}
return db.SaveChanges() > 0 ? true : false;
}
}
/// <summary>
/// 添加新的报价单产品明细列表
/// </summary>
/// <param name="qtpricelst"></param>
public bool AddNewQtPriceList(List<QtProduct> qtpricelst)
{
try
{
using (MEMSContext db = new MEMSContext())
{
foreach (var qp in qtpricelst)
{
db.Entry<T_quotationprice>(qp.qp).State = EntityState.Added;
}
return db.SaveChanges() > 0 ? true : false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
/// <summary>
/// 返回销售订单集合
/// </summary>
/// <returns></returns>
public List<SaleOrder> getAllSaleOrderList()
{
using (MEMSContext db = new MEMSContext())
{
var rs = from s in db.T_saleorder
join q in db.T_quotation on s.quotationid equals (q.id)
select new SaleOrder{so = s, qtno = q.qutationno };
return rs.ToList();
}
}
public bool UpdateSaleDetail(List<T_saledetail> sdlst)
{
using (MEMSContext db = new MEMSContext())
{
foreach (var d in sdlst)
{
db.Entry(d).State = EntityState.Modified;
}
return db.SaveChanges() > 0 ? true : false;
}
}
public List<T_SaleReceive> getSaleRecievebysoid(int soid)
{
using (MEMSContext db = new MEMSContext())
{
var rs = from r in db.T_SaleReceive
where r.soid == soid
select r;
return rs.ToList();
}
}
/// <summary>
/// 获得
/// </summary>
/// <param name="soid"></param>
/// <returns></returns>
public List<SaleProduct> getSaleProductbysoid(int soid)
{
using (MEMSContext db = new MEMSContext())
{
var rs = from sd in db.T_saledetail
join p in db.T_Product on sd.productid equals (p.id)
join q in db.T_quotationprice on p.id equals (q.productid)
where sd.soid == soid
select new SaleProduct
{
sd = sd,
productCode = p.procode,
productName = p.proname,
productSpec = p.prospecification,
pModelPrice = q.modelprice,
pUnitPrice = q.unitprice
};
return rs.ToList();
}
}
/// <summary>
/// 根据销售单号以及销售日期返回销售订单列表
/// </summary>
/// <param name="saleOrderNo">销售单号</param>
/// <param name="dtstart">开始日期</param>
/// <param name="dtend">结束日期</param>
/// <returns></returns>
public List<SaleOrder> getSaleOrderList(string saleOrderNo,DateTime dtstart,DateTime dtend)
{
using (MEMSContext db = new MEMSContext())
{
var rs = from s in db.T_saleorder
where s.saleno.Contains(saleOrderNo) && s.saledate >= dtstart && s.saledate <= dtend
join q in db.T_quotation on s.quotationid equals (q.id)
join c in db.T_Customer on s.customerid equals (c.id)
select new SaleOrder { so = s, qtno = q.qutationno, customername = c.customername };
return rs.ToList();
}
}
/// <summary>
/// 根据ID返回销售订单
/// </summary>
/// <param name="soid"></param>
/// <returns></returns>
public T_saleorder getSaleOrderbyId(int soid)
{
using (MEMSContext db = new MEMSContext())
{
var rs = from s in db.T_saleorder
where s.id == soid
select s;
return rs.FirstOrDefault();
}
}
/// <summary>
/// 根据销售单主表id获取从表数据
/// </summary>
/// <param name="soid"></param>
/// <returns></returns>
public List<T_saledetail> getSaleDetailbysoid(int soid)
{
using (MEMSContext db = new MEMSContext())
{
var rs = from sd in db.T_saledetail
where sd.soid == soid
select sd;
return rs.ToList();
}
}
/// <summary>
/// 添加新的报价单
/// </summary>
/// <param name="newqt"></param>
/// <returns></returns>
public bool AddNewQuotation(T_quotation newqt)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(newqt).State = EntityState.Added;
return db.SaveChanges() > 0 ? true : false;
}
}
/// <summary>
/// 修改报价单
/// </summary>
/// <param name="qt"></param>
/// <returns></returns>
public bool UpdateQuotation(T_quotation qt)
{
using (MEMSContext db = new MEMSContext())
{
db.Entry(qt).State = EntityState.Modified;
return db.SaveChanges() > 0 ? true : false;
}
}
