//添加移库表 public static int addyk(yk lo) { warehouseEntities entities = new warehouseEntities(); entities.yk.Add(lo); return(entities.SaveChanges()); }
/// <summary> /// 出库管理 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public static PageList GetChuKu(int pageIndex, int pageSize, int?id, string check) { warehouseEntities entities = new warehouseEntities(); PageList list = new PageList(); var obj = from p in entities.ck from c in entities.client from a in entities.admin where p.Ckclient == c.clientID && p.CreateUser == a.ID select new { ckID = p.ckID, CkType = p.CkType, clientName = p.client.clientName, Sum = p.Sum, Price = p.Price, check1 = p.check1, UserName = p.admin.UserName, CreateTime = p.CreateTime, }; if (id != 0) { obj = obj.Where(p => p.ckID == id); } else if (check != "" && check != null) { obj = obj.Where(p => p.check1 == check); } list.DataList = obj = obj.OrderBy(p => p.ckID).Skip((pageIndex - 1) * pageSize).Take(pageSize); list.PageCount = obj.Count(); return(list); }
//添加退货 public static int addth(th hh) { warehouseEntities entities = new warehouseEntities(); entities.th.Add(hh); return(entities.SaveChanges()); }
public static PageList Queryth(int pageIndex, int pageSize, int?id, string check) { PageList list = new PageList(); warehouseEntities entities = new warehouseEntities(); var obj = from t in entities.th from c in entities.ck from a in entities.admin where t.ckid == c.ckID && c.CreateUser == a.ID && t.Status == 0 select new { thID = t.thID, thType = t.thType, Count = t.Count, check1 = t.check1, UserName = t.admin.UserName, CreateTime = t.CreateTime }; if (id != 0) { obj = obj.Where(p => p.thID == id); } else if (check != "" && check != null) { obj = obj.Where(p => p.check1 == check); } list.DataList = obj.OrderBy(p => p.thID).Skip((pageIndex - 1) * pageSize).Take(pageSize); list.PageCount = obj.Count(); return(list); }
public static PageList Queryyk(int pageIndex, int pageSize, int?id, string check) { PageList list = new PageList(); warehouseEntities entities = new warehouseEntities(); var obj = from y in entities.yk from r in entities.rk from a in entities.admin where y.Rkid == r.ID && y.CreateUser == a.ID && y.Status == 0 select new { ykID = y.ykID, ykType = y.ykType, Count = y.Count, check1 = y.check1, UserName = y.admin.UserName, CreateTime = y.CreateTime, }; if (id != 0) { obj = obj.Where(p => p.ykID == id); } else if (check != "" && check != null) { obj = obj.Where(p => p.check1 == check); } list.DataList = obj.OrderBy(p => p.ykID).Skip((pageIndex - 1) * pageSize).Take(pageSize); list.PageCount = obj.Count(); return(list); }
/// <summary> /// 报损管理 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public static PageList GetBaoSun(int pageIndex, int pageSize, int?id, string check) { warehouseEntities entities = new warehouseEntities(); PageList list = new PageList(); var obj = from b in entities.bs from p in entities.product from a in entities.admin where b.ProductID == p.ProductID && b.CreateUser == a.ID select new { bsID = b.bsID, BsType = b.BsType, ProductName = b.product.ProductName, Count = b.Count, check1 = b.check1, UserName = b.admin.UserName, CreateTime = b.CreateTime }; if (id != 0) { obj = obj.Where(p => p.bsID == id); } else if (check != "" && check != null) { obj = obj.Where(p => p.check1 == check); } list.DataList = obj.OrderBy(p => p.bsID).Skip((pageIndex - 1) * pageSize).Take(pageSize); list.PageCount = obj.Count(); return(list); }
//修改移库 public static int Edit(yk s) { warehouseEntities entities = new warehouseEntities(); var obj = (from p in entities.yk where p.ykID == s.ykID select p).First(); obj.ykID = s.ykID; obj.ykType = s.ykType; obj.Count = s.Count; obj.check1 = s.check1; obj.CreateUser = s.CreateUser; obj.CreateTime = s.CreateTime; return(entities.SaveChanges()); }
public static IQueryable yktype(string yklx) { warehouseEntities entities = new warehouseEntities(); var obj = from p in entities.yk where p.ykType == yklx select new { ykID = p.ykID, ykType = p.ykType, Count = p.Count, check1 = p.check1, CreateUser = p.CreateUser, CreateTime = p.CreateTime.ToString(), }; return(obj); }
/// <summary> /// 根据单号查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public static IQueryable RuDanHao(int id) { warehouseEntities entities = new warehouseEntities(); var obj = from p in entities.rk where p.ID == id && p.Status == 0 select new { ID = p.ID, rkType = p.rkType, rkSupplier = p.rkSupplier, Sum = p.Sum, Price = p.Price, check1 = p.check1, CreateUser = p.CreateUser, CreateTime = p.CreateTime.ToString(), }; return(obj); }
/// <summary> /// 入库管理 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public static PageList GetRuKu(int pageIndex, int pageSize, int?id, string check) { warehouseEntities entities = new warehouseEntities(); PageList list = new PageList(); var obj = from r in entities.rk from s in entities.supplier from a in entities.admin where r.rkSupplier == s.supplierID && r.CreateUser == a.ID //where p.ID == id //orderby p.ID select new { ID = r.ID, rkType = r.rkType, supplierName = r.supplier.supplierName, Sum = r.Sum, Price = r.Price, check1 = r.check1, CreateUser = r.admin.UserName, CreateTime = r.CreateTime, }; if (id != 0) { Debug.WriteLine("sdsd" + id); obj = obj.Where(p => p.ID == id); } else if (check != "" && check != null) { obj = obj.Where(p => p.check1 == check); } else if (id == 0 && check == "") { } list.DataList = obj.OrderBy(p => p.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize); list.PageCount = obj.Count(); return(list); }
public static int Count() { warehouseEntities entities = new warehouseEntities(); return(entities.rk.Count()); }