/// <summary>
/// 新增
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int Add(Supplier s)
{
StorageEntities entity = new StorageEntities();
entity.Supplier.Add(s);
return(entity.SaveChanges());
}
/// <summary>
/// 所有移库分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static PageList YiKuList(int PageIndex, int PageSize)
{
StorageEntities ent = new StorageEntities();
var obj = from p in ent.Movement
where p.DataState == true
orderby p.MovementID ascending
select new
{
//[MovementID], [MovementType], [Associatednumber], [MovementCount],
//[State], [EmployeeID], [StateText], [CreationTime], [DataState]
MovementID = p.MovementID,
MovementType = p.MovementType,
Associatednumber = p.Associatednumber,
MovementCount = p.MovementCount,
State = p.State,
EmployeeID = p.EmployeeID,
name = p.Admin.UserName,
StateText = p.StateText,
CreationTime = p.CreationTime,
DataState = p.DataState
};
PageList list = new PageList();
list.DataList = obj;
//.Skip((PageIndex - 1) * PageSize).Take(PageSize);
list.PageCount = obj.Count();
return(list);
}
//模糊查询
public static IQueryable CplbQuery(int pageIndex, int pageSize, string CpLbName)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.CpLbinfo
where p.CpLbName.IndexOf(CpLbName) != -1 &&
p.Delit == true
orderby p.CpLbName ascending
select new
{
ID = p.ID,
CpId = p.CpId,
CpLbName = p.CpLbName,
UserName = p.Admin.UserName, //管理员的名称
CpTime = p.CpTime,
remark = p.remark,
Delit = p.Delit //是否删除
};
PageList list = new PageList();
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
list.PageCount = obj.Count();
return(list.DataList);
}
/// <summary>
/// 查询所有入库信息
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="State"></param>
/// <returns></returns>
public static PageList RuKuList(int PageSize, int PageIndex)
{
StorageEntities ent = new StorageEntities();
PageList list = new PageList();
var obj = from p in ent.Storage
where p.DataState == true
orderby p.StorageID ascending
select new
{
//[StorageID], [StorageType], [SupplierID], [AssociatedNumber], [GoodsCount],
//[Summoney], [State], [EmployeeID], [OperationType], [CreationTime], [DataState], [StateText]
StorageID = p.StorageID,
StorageType = p.StorageType,
SupplierID = p.SupplierID,
AssociatedNumber = p.AssociatedNumber,
GoodsCount = p.GoodsCount,
Summoney = p.Summoney,
State = p.State,
EmployeeID = p.Admin.UserName,
OperationType = p.OperationType,
CreationTime = p.CreationTime,
DataState = p.DataState,
StateText = p.StateText
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
list.PageCount = obj.Count();
return(list);
}
/// <summary>
/// 添加移库主表
/// </summary>
/// <param name="zhu"></param>
/// <returns></returns>
public static int AddYiKu(Movement zhu)
{
StorageEntities ent = new StorageEntities();
ent.Movement.Add(zhu);
return(ent.SaveChanges());
}
public AccountService(ILogger log)
{
Raise.ArgumentNullException.IfIsNull <ILogger>(log);
_context = new StorageEntities();
_log = log;
}
/// <summary>
/// 添加入库主表
/// </summary>
/// <param name="zhu"></param>
/// <returns></returns>
public static int ADDRuku(Storage zhu)
{
StorageEntities ent = new StorageEntities();
ent.Storage.Add(zhu);
return(ent.SaveChanges());
}
//模糊查询
public static IQueryable CpGlQuery(int pageIndex, int pageSize, string CpXsName)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.CpGlinfo
where p.CpXsName.IndexOf(CpXsName) != -1 && p.State == true
orderby p.CpID ascending
select new
{
CpID = p.CpID,
Cpbh = p.Cpbh,
CpXsName = p.CpXsName,
CpSx = p.CpSx,
CpXx = p.CpXx,
CpPrice = p.CpPrice,
CpShuLiang = p.CpShuLiang,
Specification = p.Specification,
UserName = p.Client.KhName, //客户 用户名
CpLbName = p.CpLbinfo.CpLbName, //产品类别的名称
CkName = p.Cangku.CKName, //仓库的名称
KwName = p.LocationManagement.kwName, //仓库库位的名称
JlName = p.JLinfo.JlName, //计量单位的名称
State = p.State, //是否删除
remark = p.remark
};
PageList list = new PageList();
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
list.PageCount = obj.Count();
return(list.DataList);
}
/// <summary>
/// 产品管理新增
/// </summary>
/// <param name="cpgl"></param>
/// <returns></returns>
public static int CpGlAdd(Models.CpGlinfo cpgl)
{
StorageEntities b = new StorageEntities();
b.CpGlinfo.Add(cpgl);
return(b.SaveChanges());
}
//新增
public static int SysAdminadd(Admin admin)
{
StorageEntities h = new StorageEntities();
h.Admin.Add(admin);
return(h.SaveChanges());
}
/// <summary>
/// 退货分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static PageList TuiHuoList(int PageIndex, int PageSize)
{
StorageEntities ent = new StorageEntities();
var obj = from p in ent.Returns
where p.DataState == true
orderby p.ReturnsID ascending
select new
{
//[ReturnsID], [ReturnsType], [AssociatedNumber], [State], [EmployeeID], [StateText], [CreationTime], [DataState]
ReturnsID = p.ReturnsID,
ReturnsType = p.ReturnsType,
AssociatedNumber = p.AssociatedNumber,
State = p.State,
tuihuoSum = (from pp in p.ReturnsDetailed select pp.QuestionNum).Sum(),
EmployeeID = p.Admin.UserName,
StateText = p.StateText,
CreationTime = p.CreationTime,
DataState = p.DataState
};
PageList list = new PageList();
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
list.PageCount = obj.Count();
return(list);
}
public static PageList Adminfenye(int pageIndex, int pageSize, int Stuate)
{
StorageEntities entity = new StorageEntities();
//匿名类型
var obj = from p in entity.Admin
where p.SysStatus.StatusID == Stuate &&
p.IsDelete == true
orderby p.AdminID ascending
select new
{
AdminID = p.AdminID,
UserName = p.UserName,
UserCode = p.UserCode,
RealName = p.RealName,
Email = p.Email,
Phone = p.Phone,
LoginCount = p.LoginCount,
//DepartNum_id = p.DepartNum_id,
//RoleNum = p.RoleNum,
IsDelete = p.IsDelete,
Stuate = p.SysStatus.StatusID,
DepartName = p.SysDepart.DepartName,
RoleName = p.SysRole.RoleName,
};
PageList list = new PageList();
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
list.PageCount = obj.Count();
return(list);
}
//模糊查询
public static IQueryable AdminQuery(int pageIndex, int pageSize, string UserName)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.Admin
where p.UserName.IndexOf(UserName) != -1 &&
p.IsDelete == true
orderby p.AdminID
select new
{
AdminID = p.AdminID,
UserName = p.UserName,
UserCode = p.UserCode,
RealName = p.RealName,
Email = p.Email,
Phone = p.Phone,
LoginCount = p.LoginCount,
IsDelete = p.IsDelete,
Stuate = p.SysStatus.StatusID,
DepartName = p.SysDepart.DepartName,
RoleName = p.SysRole.RoleName,
};
PageList list = new PageList();
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
list.PageCount = obj.Count();
return(list.DataList);
}
/// <summary>
/// 供应商管理分页类查询
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static PageList PageListDemo(int pageIndex = 1, int PageSize = 5, string SlrName = "")
{
StorageEntities entity = new StorageEntities();
//实例化分页类
PageList list = new PageList();
var obj = from p in entity.Supplier
where p.SlrName.Contains(SlrName)
orderby p.SlId
select new
{
SlId = p.SlId,
SupplierTypeName = p.SupplierType.SupplierTypeName,
SlrName = p.SlrName,
SlDescribe = p.SlDescribe,
SlContacts = p.SlContacts,
SlIphone = p.SlIphone,
SlAddress = p.SlAddress
};
//设置分页数据
list.DataList = obj.Skip((pageIndex - 1) * PageSize).Take(PageSize);
//设置总行数
list.PageCount = obj.Count();
return(list);
}
//查询审核成功
public static PageList SelectRuKuSHCG(int pageIndex, int PageSize)
{
StorageEntities test = new StorageEntities();
//实例化分页类
PageList list = new PageList();
var obj = from p in test.Warehousing
where p.WState == 2
orderby p.Wid
select new
{
wid = p.Wid,
tname = p.WareStateType.TName,
sname = p.Supplier.SlrName,
rid = p.Rid,
num = from pp in p.WareProduct where p.Wid == pp.Wid select pp.WPnum,
price = from pp in p.WareProduct where p.Wid == pp.Wid select pp.WPprice,
state = p.WareState.Sname,
user = p.User.UserName,
time = p.time
};
list.DataList = obj.Skip((pageIndex - 1) * PageSize).Take(PageSize);
//设置总页数
list.PageCount = obj.Count();
return(list);
}
//根据id单个查询
public static IQueryable CpGlGetById(int CpID)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.CpGlinfo
where p.CpID == CpID
select new
{
CpID = p.CpID,
Cpbh = p.Cpbh,
CpXsName = p.CpXsName,
CpSx = p.CpSx,
CpXx = p.CpXx,
CpPrice = p.CpPrice,
CpShuLiang = p.CpShuLiang,
Specification = p.Specification,
UserId = p.UserId, //客户 用户名
CpLb = p.CpLb, //产品类别的名称
CkId = p.CkId, //仓库的名称
KwId = p.KwId, //仓库库位的名称
CpJlName = p.CpJlName, //计量单位的名称
State = p.State, //是否删除
remark = p.remark
};
return(obj);
}
//登录
public static User Login(string name, string pwd)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.User where p.UserName == name && p.PassWord == pwd select p;
return(obj.FirstOrDefault());
}
//新增
public static int JldwAdd(Models.JLinfo jldw)
{
StorageEntities b = new StorageEntities();
b.JLinfo.Add(jldw);
return(b.SaveChanges());
}
//新增
public static int SysDepartadd(SysDepart depart)
{
StorageEntities h = new StorageEntities();
h.SysDepart.Add(depart);
return(h.SaveChanges());
}
//新增
public static int caidanadd(Function cd)
{
StorageEntities entity = new StorageEntities();
entity.Function.Add(cd);
return(entity.SaveChanges());
}
/// <summary>
/// 添加入库详表
/// </summary>
/// <param name="xiang"></param>
/// <returns></returns>
public static int ADDRukuXiang(StorageDetailed xiang)
{
StorageEntities ent = new StorageEntities();
ent.StorageDetailed.Add(xiang);
return(ent.SaveChanges());
}
//
public static IQueryable FunctionQuery(int pageIndex, int pageSize, string DisplayName)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.Function
where p.DisplayName.IndexOf(DisplayName) != -1 &&
p.State == true
orderby p.NodeId
select new
{
NodeId = p.NodeId,
DisplayName = p.DisplayName,
NodeURL = p.NodeURL,
DisplayOrder = p.DisplayOrder,
ParentNodeId = p.ParentNodeId,
ADDTime = p.ADDTime,
State = p.State,
};
PageList list = new PageList();
list.DataList = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize);
list.PageCount = obj.Count();
return(list.DataList);
}
public static PageList ProductList(int PageIndex, int PageSize, string PName)
{
StorageEntities entities = new StorageEntities();
PageList list = new PageList();
var obj = from p in entities.Product
orderby p.PId
where p.PState == 0 && p.PName.Contains(PName)
select new
{
PId = p.PId,
PName = p.PName,
PRemarks = p.PRemarks,
PState = p.PState,
PPrice = p.PPrice,
Pspecifications = p.Pspecifications,
PCount = p.PCount,
Mname = p.Metering.Mname,
PcName = p.ProductCategory.PcName,
WhName = p.WareHouse.WhName,
CtName = p.Customer.CtName,
};
//设置分页数据
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
//设置总页数
list.PageCount = obj.Count();
return(list);
}
/// <summary>
/// 新增出库主表
/// </summary>
/// <param name="chuku"></param>
/// <returns></returns>
public static int AddChuKu(StockRemoval zhu)
{
StorageEntities ent = new StorageEntities();
ent.StockRemoval.Add(zhu);
return(ent.SaveChanges());
}
/// <summary>
/// 添加移库详表
/// </summary>
/// <param name="xiang"></param>
/// <returns></returns>
public static int AddYiKuxiang(MovementDetailed xiang)
{
StorageEntities ent = new StorageEntities();
ent.MovementDetailed.Add(xiang);
return(ent.SaveChanges());
}
/// <summary>
/// 新增出库详表
/// </summary>
/// <param name="chuku"></param>
/// <returns></returns>
public static int AddChuKuXiang(StockRemovalDetailed xiang)
{
StorageEntities ent = new StorageEntities();
ent.StockRemovalDetailed.Add(xiang);
return(ent.SaveChanges());
}
/// <summary>
/// 产品类别新增
/// </summary>
/// <param name="cplb"></param>
/// <returns></returns>
public static int CplbAdd(Models.CpLbinfo cplb)
{
StorageEntities b = new StorageEntities();
b.CpLbinfo.Add(cplb);
return(b.SaveChanges());
}
///<summary>
///获取入库单总条数
/// </summary>
public static int RuKuRows()
{
StorageEntities test = new StorageEntities();
var obj = from p in test.Warehousing where p.WState != 0 select p;
return(obj.Count());
}
/// <summary>
/// 新增产品类别
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int ProductCategoryAdd(ProductCategory pro)
{
StorageEntities entities = new StorageEntities();
entities.ProductCategory.Add(pro);
return(entities.SaveChanges());
}
/// <summary>
/// 通过文字找到编号
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
public static IQueryable CpGlfenye(string text)
{
StorageEntities entity = new StorageEntities();
var obj = from p in entity.CpGlinfo
where p.State == true &&
p.Cpbh == text
orderby p.CpID ascending
select new
{
CpID = p.CpID,
Cpbh = p.Cpbh,
CpXsName = p.CpXsName,
CpSx = p.CpSx,
CpXx = p.CpXx,
CpPrice = p.CpPrice,
CpShuLiang = p.CpShuLiang,
Specification = p.Specification,
UserName = p.Client.KhName, //客户 用户名
CpLbName = p.CpLbinfo.CpLbName, //产品类别的名称
CkName = p.Cangku.CKName, //仓库的名称
KwName = p.LocationManagement.kwName, //仓库库位的名称
JlName = p.JLinfo.JlName, //计量单位的名称
State = p.State, //是否删除
remark = p.remark
};
return(obj);
}
