//根据入库单号查询
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());
}
