/// <summary>
/// 供应商报表
/// </summary>
/// <param name="ven">供应商对象</param>
/// <param name="pagesize">每页数</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PagelistVendor(Vendor ven, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Vendor
orderby p.VenId
select new
{
VenName = p.VenName,
VenTel = p.VenTel,
VenEmain = p.VenEmain,
VenPerson = p.VenPerson,
VenAddress = p.VenAddress,
Remake = p.Remake,
};
var row = 0;
if (!string.IsNullOrEmpty(ven.VenName))
{
obj = obj.Where(p => p.VenName.Contains(ven.VenName));
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
/// <summary>
/// 库存清单报表
/// </summary>
/// <param name="pagesize">每页数据行</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PageLsitPro(ProbaictStorage proc, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.ProbaictStorage
orderby p.Num
select new
{
StoreName = p.Storehouse.StoreName,
StName = from pp in entity.Storehousetype where pp.StId == p.Storehouse.StId select pp.StName,
StId = from stid in entity.Storehousetype where stid.StId == p.Storehouse.StId select stid.StId,
ProId = p.Probaict.ProId,
ProName = p.Probaict.ProName,
ProCName = from type in entity.ProbaictCatagory where type.ProCId == p.Probaict.ProCId select type.ProCName,
PorGuiGe = p.Probaict.PorGuiGe,
Num = p.Num,
};
var row = 0;
if (!string.IsNullOrEmpty(proc.Storehouse.StoreName))
{
obj = obj.Where(p => p.StoreName.Contains(proc.Storehouse.StoreName));
}
if (!string.IsNullOrEmpty(proc.Probaict.ProName))
{
obj = obj.Where(p => p.ProName.Contains(proc.Probaict.ProName));
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
/// <summary>
/// 客户报表
/// </summary>
/// <param name="cus">客户对象</param>
/// <param name="pagesize">每页数量</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PagelistCustomer(Customer cus, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Customer
orderby p.CusId
where p.IsDelete == 0
select new
{
CusId = p.CusId,
CusName = p.CusName,
CusTel = p.CusTel,
CreateTime = p.CreateTime,
CusNum = p.CusNum,
};
var row = 0;
if (!string.IsNullOrEmpty(cus.CusName))
{
obj = obj.Where(p => p.CusName.Contains(cus.CusName));
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
/// <summary>
/// 入库报表
/// </summary>
/// <param name="pagesize">每页数量</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PagelistWarehouse(Warehouse war, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Warehouse
orderby p.WarId
select new {
WarId = p.WarId,
CreateTime = p.CreateTime,
VenName = p.Vendor.VenName,
count = (from pp in entity.WarehouseStorage where pp.WarId == p.WarId select p).Count(),
};
var row = 0;
if (!string.IsNullOrEmpty(war.Vendor.VenName))
{
obj = obj.Where(p => p.VenName == war.Vendor.VenName);
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
/// <summary>
/// 退货报表
/// </summary>
/// <param name="pro">商品对象</param>
/// <param name="pagesize">每页数量</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PagelistComeback(Probaict pro, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Probaict
where p.ProTuihuo != 0
orderby p.ProTuihuo
select new {
ProId = p.ProId,
ProName = p.ProName,
ProTuihuo = p.ProTuihuo,
Sum = (p.ProTuihuo * p.ProPrice),
ProNumber = p.ProNumber,
};
var row = 0;
if (!string.IsNullOrEmpty(pro.ProName))
{
obj = obj.Where(p => p.ProName.Contains(pro.ProName));
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
public static ShuaiPageList TuiHuoTongHuo(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.Comeback
where p.AudiId == 2
orderby p.CobId
select new
{
CobId = p.CobId,
CobType = p.CobType,
DeliId = from jj in hh.Deliver select jj.DeliId,
CobPerson = p.CobPerson,
AudiId = p.AudiId,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
comNum = from kk in hh.CombackStorage select kk.ComNum,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static int UnitAdd(Unit unit)
{
CangChuEntities1 contxt = new CangChuEntities1();
contxt.Unit.Add(unit);
return(contxt.SaveChanges());
}
public static int Add(Storehouse stroe)
{
CangChuEntities1 contxt = new CangChuEntities1();
contxt.Storehouse.Add(stroe);
return(contxt.SaveChanges());
}
/// <summary>
/// 分页查询Warehouse表所有数据
/// 状态为2:审核通过
/// </summary>
/// <returns></returns>
public static Model.Jie.PageList GetPageListDeliver2(int pageIndex, int pageSize)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.Jie.PageList list = new Model.Jie.PageList();
var obj = from p in entity.Deliver
where p.AudiId == 2
orderby p.DeliId
select new
{
DeliId = p.DeliId,
DeliType = p.DeliType,
DeliaOrder = p.DeliaOrder,
DelDate = p.DelDate,
CusId = from pp in entity.Customer where p.CusId == pp.CusId select pp.CusName,
DeliPerson = p.DeliPerson,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
Remake = p.Remake,
AudiId = from ppp in entity.Auditing where p.AudiId == ppp.AudiId select ppp.AudiName
};
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
int rows = entity.Probaict.Count();
list.PageCount = rows % pageSize == 0 ? rows / pageSize : rows / pageSize + 1;
return(list);
}
public static int tadd(GarageShiftStorage ll)
{
CangChuEntities1 hh = new CangChuEntities1();
hh.GarageShiftStorage.Add(ll);
return(hh.SaveChanges());
}
public static int Add(GarageShift kk)
{
CangChuEntities1 hh = new CangChuEntities1();
hh.GarageShift.Add(kk);
return(hh.SaveChanges());
}
public static ShuaiPageList Queryshibai(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.GarageShift
where p.AudiId == 3
orderby p.GarSId
select new
{
GarSId = p.GarSId,
AudiId = p.AudiId,
GarSType = p.GarSType,
GarSOrder = p.GarSOrder,
num = from jj in hh.GarageShiftStorage select jj.Num,
GarSPerson = p.GarSPerson,
ProId = from jj in hh.GarageShiftStorage select jj.ProId,
IsDelete = p.IsDelete,
Remake = p.Remake,
CreateTime = p.CreateTime,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static ShuaiPageList GetPageList(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.Damage
where p.IsDelete == 0
orderby p.Damid
select new {
Damid = p.Damid,
DamType = p.DamType,
DamOrder = p.DamOrder,
DamPerson = p.DamPerson,
AudiId = p.AudiId,
ProId = from jj in hh.DamageStorage select jj.ProId,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
Remake = p.Remake,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static int Add(Admin r)
{
CangChuEntities1 entities = new CangChuEntities1();
entities.Admin.Add(r);
return(entities.SaveChanges());
}
/// <summary>
/// 登录
/// </summary>
/// <param name="name">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static int Login(string name, string pwd)
{
CangChuEntities1 entity = new CangChuEntities1();
int count = (from p in entity.Admin where p.UserName == name && p.PassWord == pwd && p.IsDelete == 0 && p.RoleId == 1 || p.RoleId == 2 select p).Count();
return(count);
}
public static int Add(Role r)
{
CangChuEntities1 entities = new CangChuEntities1();
entities.Role.Add(r);
return(entities.SaveChanges());
}
/// <summary>
/// 所有条件查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="name"></param>
/// <param name="sname"></param>
/// <param name="sname2"></param>
/// <returns></returns>
public static ShuaiPageList YikuPageList2(int PageIndex, int PageSize, string name, DateTime sname, DateTime sname2)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.GarageShift
where p.GarSType.Contains(name) && p.CreateTime >= sname && p.CreateTime <= sname2
orderby p.GarSId
select new
{
GarSId = p.GarSId,
AudiId = p.AudiId,
GarSType = p.GarSType,
GarSOrder = p.GarSOrder,
num = from jj in hh.GarageShiftStorage select jj.Num,
GarSPerson = p.GarSPerson,
IsDelete = p.IsDelete,
CreateTime = p.CreateTime,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
//
public static PageList ShowByName(int pageIndex, int pageSize, int VenId, string VenName)
{
PageList list = new PageList();
CangChuEntities1 contxt = new CangChuEntities1();
var obj = from p in contxt.Vendor
orderby p.VenId
where p.VenId == VenId || p.VenName == VenName
select new
{
VenId = p.VenId,
VenType = p.VenType,
VenName = p.VenName,
VenTel = p.VenTel,
VenEmain = p.VenEmain,
VenPerson = p.VenPerson,
VenAddress = p.VenAddress,
Remake = p.Remake
};
list.Datalist = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
int row = contxt.Vendor.Count();
list.PageCount = row % pageSize == 0 ? row / pageSize : row / pageSize + 1;
return(list);
}
public static int Add(Dept de)
{
CangChuEntities1 entities = new CangChuEntities1();
entities.Dept.Add(de);
return(entities.SaveChanges());
}
/// <summary>
/// 分页查询Warehouse表所有数据
/// 状态为2:审核通过
/// </summary>
/// <returns></returns>
public static Model.Jie.PageList GetPageListWarehouse2(int pageIndex, int pageSize)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.Jie.PageList list = new Model.Jie.PageList();
var obj = from p in entity.Warehouse
where p.AudiId == 2
orderby p.WarId
select new
{
WarId = p.WarId,
WarType = p.WarType,
WarOrder = p.WarOrder,
WarPerson = p.WarPerson,
VenId = from pp in entity.Vendor where p.VenId == pp.VenId select pp.VenName,
AudiId = from ppp in entity.Auditing where p.AudiId == ppp.AudiId select ppp.AudiName,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
Remake = p.Remake
};
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
int rows = entity.Probaict.Count();
list.PageCount = rows % pageSize == 0 ? rows / pageSize : rows / pageSize + 1;
return(list);
}
public static PageList PageListDemo(int pageIndex, int PageSize)
{
CangChuEntities1 contxt = new CangChuEntities1();
//实例化分页类
PageList list = new PageList();
var obj = from p in contxt.Vendor
orderby p.VenId
select new
{
VenId = p.VenId,
VenType = p.VenType,
VenName = p.VenName,
VenTel = p.VenTel,
VenEmain = p.VenEmain,
VenPerson = p.VenPerson,
VenAddress = p.VenAddress,
Remake = p.Remake
};
//设置分页数据
list.DataList = obj.Skip((pageIndex - 1) * PageSize).Take(PageSize);
int rows = contxt.Vendor.Count();
//设置总页数
list.PageCount = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static Model.Huang.PageList PageListDemo(int pageindex, int pagesize)
{
CangChuEntities1 entities = new CangChuEntities1();
Model.Huang.PageList list = new Model.Huang.PageList();
var obj = from p in entities.Admin
where p.IsDelete == 0
orderby p.Id
select new
{
Id = p.Id,
UserName = p.UserName,
RealName = p.RealName,
RoleId = p.RoleId,
DeptId = p.DeptId,
Rname = p.Role.RoleName,
Dname = p.Dept.DeptName,
Email = p.Email,
phone = p.phone,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
DeleteTime = p.DeleteTime,
Remake = p.Remake
};
list.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
int rows = entities.Role.Count();
list.PageCount = rows % pagesize == 0 ? rows / pagesize : rows / pagesize + 1;
return(list);
}
public static int VendorAdd(Vendor ven)
{
CangChuEntities1 contxt = new CangChuEntities1();
contxt.Vendor.Add(ven);
return(contxt.SaveChanges());
}
public static int CustAdd(Customer cust)
{
CangChuEntities1 contxt = new CangChuEntities1();
contxt.Customer.Add(cust);
return(contxt.SaveChanges());
}
public static int dele(Admin r)
{
CangChuEntities1 entity = new CangChuEntities1();
var obj = (from p in entity.Admin where p.Id == r.Id select p).First();
obj.IsDelete = r.IsDelete;
return(entity.SaveChanges());
}
public static int Del(int RoleId)
{
CangChuEntities1 entities = new CangChuEntities1();
var obj = (from p in entities.Role where p.RoleId == RoleId select p).First();
entities.Role.Remove(obj);
return(entities.SaveChanges());
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="admin">对象</param>
/// <returns>受影响行数</returns>
public static int UpdatePwd(int id, string pwd)
{
CangChuEntities1 entity = new CangChuEntities1();
var count = (from p in entity.Admin where p.Id == id select p).First();
count.PassWord = pwd;
return(entity.SaveChanges());
}
public static int dele(Dept dd)
{
CangChuEntities1 entity = new CangChuEntities1();
var obj = (from p in entity.Dept where p.DeptId == dd.DeptId select p).First();
obj.IsDelete = dd.IsDelete;
return(entity.SaveChanges());
}
public static int Edit(Dept de)
{
CangChuEntities1 entity = new CangChuEntities1();
var obj = (from p in entity.Dept where p.DeptId == de.DeptId select p).First();
obj.DeptName = de.DeptName;
return(entity.SaveChanges());
}
public static int Edit(Role r)
{
CangChuEntities1 entity = new CangChuEntities1();
var obj = (from p in entity.Role where p.RoleId == r.RoleId select p).First();
obj.RoleName = r.RoleName;
return(entity.SaveChanges());
}
