//根据入库单号查询 public static IQueryable GetById(string OutboundNum) { CKSJKEntities ck = new CKSJKEntities(); var obj = from p in ck.outWarehourse where p.OutboundNum == OutboundNum select new { //出库单号 OutboundNum = p.OutboundNum, //类型 OutboundTypeName = p.OutboundType.OutboundTypeName, //状态 examineState = p.examineState, //地址编号 AddressNum = p.customerAddressInfo.AddressNum, //具体地址 AddressXinxi = p.customerAddressInfo.AddressXinxi, //联系人 contacts = p.customerAddressInfo.contacts, //关联订单号 orderNo = p.orderNo, //创建人 ygNumber = p.Staff.ygName, //创建时间 createTime = p.customer.createTime, //电话 phone = p.customer.phone, //备注 contents = p.customer.contents, //审核备注 OperationMode = p.OperationMode, }; return(obj); }
public static PageList Hu(int pageIndex, int PageSize) { CKSJKEntities c = new CKSJKEntities(); //实例化分页类 PageList list = new PageList(); var obj = from p in c.product orderby p.productNum select new { //产品名称 productName = p.productName, //产品条码 Probarcode = p.Probarcode, //规格 Specifications = p.Specifications, //批次 productNum = p.productNum, //单价 price = p.price, //入库数 productCount = p.productCount, //总价 num = (p.price * p.productCount), //库位 LocationName = p.Location.LocationName }; //设置分页数据 list.Datalist = obj.Skip((pageIndex - 1) * PageSize).Take(PageSize); int rows = c.product.Count(); //设置总页数 list.PageCount = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1; return(list); }
//根据条件普通查 public static PageList queryid(int pageIndex, int pagesize, string id, DateTime kxtime, DateTime jstime) { PageList list = new PageList(); CKSJKEntities c = new CKSJKEntities(); var obj = from p in c.putWarehourse orderby p.receiptNum where p.receiptNum == id && p.createTime >= kxtime && p.createTime <= jstime select new { receiptNum = p.receiptNum, receiptTypeNum = p.receiptTypeNum, orderNo = p.orderNo, ygNumber = p.ygNumber, supplierNum = p.supplierNum, createTime = p.createTime, totalNum = p.totalNum, examineState = p.examineState, OperationMode = p.OperationMode, totalAmount = p.totalAmount, contents = p.contents, isDel = p.isDel, supplierName = p.supplier.supplierName, receiptTypeName = p.receiptType.receiptTypeName }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = c.putWarehourse.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
public static PageList Page(int pageIndex, int pagesize) { PageList list = new PageList(); CKSJKEntities s = new CKSJKEntities(); var obj = from p in s.outWarehourse orderby p.OutboundNum select new { //出库单号 OutboundNum = p.OutboundNum, //日期 Probarcode = p.IssuanceDate, //供应商名称 //supplierName = p.supplier.supplierName, //关联订单号 orderNo = p.orderNo, //总数 totalNum = p.totalNum, //总价 totalAmount = p.totalAmount }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = s.outWarehourse.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
//分页 public static PageList Page(int pageIndex, int pagesize) { PageList list = new PageList(); CKSJKEntities s = new CKSJKEntities(); var obj = from p in s.product orderby p.productNum select new { //产品编号 productNum = p.productNum, //产品条码 Probarcode = p.Probarcode, //产品名称 productName = p.productName, //类别 productLeixNum = p.productLeix.productLeixName, //预警值下限 //规格 Specifications = p.Specifications, //库存数 productCount = p.productCount, //进货总数 JhCount = from pp in p.putWareDetail where pp.productNum == p.productNum select pp.productCount, //出货总数 ChCount = from pp in p.outWareDetail where pp.productNum == p.productNum select pp.productCount, //报损总数 BsCount = from pp in p.LossReportDetails where pp.productNum == p.productNum select pp.productCount }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = s.product.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
public static PageList Page(int pageIndex, int pagesize) { PageList list = new PageList(); CKSJKEntities s = new CKSJKEntities(); var obj = from p in s.putWarehourse orderby p.receiptNum select new { //入库单号 receiptNum = p.receiptNum, //日期 Probarcode = p.createTime, //供应商名称 supplierName = p.supplier.supplierName, //总数 totalNum = p.totalNum, //总价 totalAmount = p.totalAmount }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = s.putWarehourse.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
/// <summary> /// 库存清单 /// </summary> //分页 public static PageList Page(int pageIndex, int pagesize) { PageList list = new PageList(); CKSJKEntities s = new CKSJKEntities(); var obj = from p in s.product orderby p.productNum select new { //库位 warehourseNum = p.Location.warehourse.warehourseNum, //库位类型 warehourseName = p.Location.warehourse.warehourseName, //产品编号 productNum = p.productNum, //产品条码 Probarcode = p.Probarcode, //产品名称 productName = p.productName, //类别 productLeixNum = p.productLeix.productLeixName, //规格 Specifications = p.Specifications, //预警值下限 //预警值上限 //库存数 productCount = p.productCount, }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); list.PageCount = obj.Count(); return(list); }
//新增 public static int Add(position po) { CKSJKEntities ck = new CKSJKEntities(); ck.position.Add(po); return(ck.SaveChanges()); }
//根据入库单号查询 public static IQueryable GetById(string receiptNum) { CKSJKEntities ck = new CKSJKEntities(); var obj = from p in ck.putWarehourse where p.receiptNum == receiptNum select new { //入库单号 receiptNum = p.receiptNum, //类型 receiptTypeNum = p.receiptType.receiptTypeName, //状态 examineState = p.examineState, //供应商编号 supplierNum = p.supplierNum, //供应商名称 supplierName = p.supplier.supplierName, //联系人 LoginName = p.Staff.LoginName, //关联订单号 orderNo = p.orderNo, //创建人 ygNumber = p.Staff.ygName, //创建时间 createTime = p.createTime, //电话 phone = p.Staff.phone, //备注 contents = p.contents, //审核备注 OperationMode = p.OperationMode, }; return(obj); }
//根据用户名或工号进行查询 public static PageList ShowByName(int pageIndex, int pagesize, string userName, string ygNum) { PageList list = new PageList(); CKSJKEntities ck = new CKSJKEntities(); var obj = from p in ck.Staff orderby p.ygNumber where p.LoginName == userName || p.ygNumber == ygNum && p.isDel == 1 select new { LoginName = p.LoginName, ygNumber = p.ygNumber, ygName = p.ygName, email = p.email, phone = p.phone, LoginNum = p.LoginNum, dBmName = p.department.BmName, pZwName = p.position.ZwName }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = ck.Staff.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
//登录o public static int login(string name, string pwd) { CKSJKEntities s = new CKSJKEntities(); var count = (from p in s.Staff where p.LoginName == name && p.loginPwd == pwd && p.ZwNum == "NB000" select p).Count(); return(count); }
//查询仓库表 public List <warehourse> Warehourses() { CKSJKEntities ck = new CKSJKEntities(); var list = from p in ck.warehourse select p; return(list.ToList()); }
//新增 public int Add(Location war) { CKSJKEntities ck = new CKSJKEntities(); ck.Location.Add(war); return(ck.SaveChanges()); }
//新增 public static int Add(Staff sta) { CKSJKEntities ck = new CKSJKEntities(); ck.Staff.Add(sta); return(ck.SaveChanges()); }
//新增 public static int Add(department dep) { CKSJKEntities ck = new CKSJKEntities(); ck.department.Add(dep); return(ck.SaveChanges()); }
public static int YGAdd(Staff w) { CKSJKEntities q = new CKSJKEntities(); q.Staff.Add(w); return(q.SaveChanges()); }
//根据条件普通查询 public static PageList queryid(int pageIndex, int pagesize, string warehourseNum, string productNum, string Probarcode, string productName, string warehourseName) { PageList list = new PageList(); CKSJKEntities c = new CKSJKEntities(); var obj = from p in c.product orderby p.productNum where p.Location.warehourseNum == warehourseNum || p.productNum == productNum || p.Probarcode == Probarcode || p.productName == productName || p.Location.warehourse.warehourseName == warehourseName select new { //库位 warehourseNum = p.Location.warehourse.warehourseNum, //库位类型 warehourseName = p.Location.warehourse.warehourseName, //产品编号 productNum = p.productNum, //产品条码 Probarcode = p.Probarcode, //产品名称 productName = p.productName, //类别 productLeixNum = p.productLeix.productLeixName, //规格 Specifications = p.Specifications, //预警值下限 //预警值上限 //库存数 productCount = p.productCount, }; list.Datalist = obj.Skip((pageIndex - 1) * pagesize).Take(pagesize); int row = c.product.Count(); list.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1; return(list); }
//删除 public int delete(string id) { CKSJKEntities ck = new CKSJKEntities(); Location su = ck.Location.Find(id); su.isDel = 0; return(ck.SaveChanges()); }
//删除 public static int Del(string bmNumber) { CKSJKEntities ck = new CKSJKEntities(); department obj = ck.department.Find(bmNumber); obj.isDel = 0; return(ck.SaveChanges()); }
//是否禁用 public int JinYong(string id, int isDisable) { CKSJKEntities ck = new CKSJKEntities(); Location su = ck.Location.Find(id); su.isDisable = isDisable; return(ck.SaveChanges()); }
//删除 public static int Del(string receiptNum) { CKSJKEntities lian = new CKSJKEntities(); var obj = (from p in lian.putWarehourse where p.receiptNum == receiptNum select p).First(); lian.putWarehourse.Remove(obj); return(lian.SaveChanges()); }
//删除 public static int Del(string ygNum) { CKSJKEntities ck = new CKSJKEntities(); Staff obj = ck.Staff.Find(ygNum); obj.isDel = 0; return(ck.SaveChanges()); }
//删除 public static int Del(string zwNumber) { CKSJKEntities ck = new CKSJKEntities(); position obj = ck.position.Find(zwNumber); obj.isDel = 0; return(ck.SaveChanges()); }
//public static IQueryable QueryTest(product book) //{ // CKSJKEntities entity = new CKSJKEntities(); // var obj = from p in entity.product // select new // { // //库位 // warehourseNum = p.Location.warehourse.warehourseNum, // //库位类型 // warehourseName = p.Location.warehourse.warehourseName, // //产品编号 // productNum = p.productNum, // //产品条码 // Probarcode = p.Probarcode, // //产品名称 // productName = p.productName, // //类别 // productLeixNum = p.productLeix.productLeixName, // //规格 // Specifications = p.Specifications, // //预警值下限 // //预警值上限 // //库存数 // productCount = p.productCount // }; // if (!string.IsNullOrEmpty(book.Location.warehourseNum)) // { // obj = obj.Where(p => p.warehourseNum.Contains(book.Location.warehourseNum)); // } // if (!string.IsNullOrEmpty(book.productNum)) // { // obj = obj.Where(p => p.productNum.Contains(book.productNum)); // } // if (!string.IsNullOrEmpty(book.Probarcode)) // { // obj = obj.Where(p => p.Probarcode.Contains(book.Probarcode)); // } // if (!string.IsNullOrEmpty(book.productName)) // { // obj = obj.Where(p => p.productName.Contains(book.productName)); // } // if (!string.IsNullOrEmpty(book.Location.warehourse.warehourseName)) // { // obj = obj.Where(p => p.warehourseName.Contains(book.Location.warehourse.warehourseName)); // } // return obj; //} //下拉框 public static IQueryable Show() { CKSJKEntities c = new CKSJKEntities(); var obj = from p in c.warehourse select new { warehourseNum = p.warehourseNum, warehourseName = p.warehourseName }; return(obj); }
//修改 public static int DepUp(department de) { CKSJKEntities ck = new CKSJKEntities(); var obj = (from p in ck.department where p.BmNum == de.BmNum select p).First(); obj.BmNum = de.BmNum; obj.BmName = de.BmName; obj.createTime = de.createTime; obj.title = de.title; return(ck.SaveChanges()); }
//角色表修改 public static int PosiUp(position po) { CKSJKEntities ck = new CKSJKEntities(); var obj = (from p in ck.position where p.ZwNum == po.ZwNum select p).First(); obj.ZwNum = po.ZwNum; obj.ZwName = po.ZwName; obj.CreateTime = po.CreateTime; obj.title = po.title; return(ck.SaveChanges()); }
//查询部门名称 public static IQueryable BybmName() { CKSJKEntities ck = new CKSJKEntities(); var obj = from p in ck.department select new { BmNum = p.BmNum, BmName = p.BmName }; return(obj); }
//修改 public int Update(Location war) { CKSJKEntities ck = new CKSJKEntities(); Location su = ck.Location.Find(war.LocationNum); su.LocationNum = war.LocationNum; su.LocationName = war.LocationName; su.isDefult = war.isDefult; su.warehourseNum = war.warehourseNum; su.barcode = war.barcode; return(ck.SaveChanges()); }
//查询角色名称 public static IQueryable ByjsName() { CKSJKEntities ck = new CKSJKEntities(); var obj = from p in ck.position where p.isDel == 1 select new { ZwNum = p.ZwNum, ZwName = p.ZwName }; return(obj); }
//修改 public static int StaUp(Staff sta) { CKSJKEntities ck = new CKSJKEntities(); var obj = (from p in ck.Staff where p.ygNumber == sta.ygNumber select p).First(); obj.ygNumber = sta.ygNumber; obj.LoginName = sta.LoginName; obj.loginPwd = sta.loginPwd; obj.ygName = sta.ygName; obj.email = sta.email; obj.phone = sta.phone; obj.BmNum = sta.BmNum; obj.ZwNum = sta.ZwNum; return(ck.SaveChanges()); }