public static Item GetItemInfo(int id)
{
using (var entity = new BidingSystemDBEntities())
{
return(entity.Item.Where(x => x.ItemId == id).FirstOrDefault());
}
}
public static User GetUserInfo(int id)
{
using (var entity = new BidingSystemDBEntities())
{
return(entity.User.Where(x => x.CompanyId == id).FirstOrDefault());
}
}
// 获取公司信息列表
public static List <Item> GetPageEntityList(int pageIndex, int pageSize)
{
using (var entity = new BidingSystemDBEntities())
{
return(entity.Item.OrderBy(x => x.Status).ThenBy(x => x.StartTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
}
// 获取公司信息列表
public static List <User> GetPageEntityList(int pageIndex, int pageSize)
{
using (var entity = new BidingSystemDBEntities())
{
return(entity.User.OrderBy(x => x.CompanyId).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
}
public static int Validate(string userName, string passwrod)
{
using (var entity = new BidingSystemDBEntities())
{
var user = entity.User.Where(x => x.CompanyName == userName && x.Password == passwrod).FirstOrDefault();
if (user == null)
{
return(-1);
}
else if (user != null)
{
if (user.Type == 1)
{
return(1);
}
else if (user.Type == 0)
{
return(0);
}
else
{
return(-1);
}
}
else
{
return(-1);
}
}
}
public static int RemoveItem(int id)
{
using (var entity = new BidingSystemDBEntities())
{
var item = entity.Item.Where(x => x.ItemId == id).FirstOrDefault();
entity.Item.Remove(item);
return(entity.SaveChanges());
}
}
public static int RemoveUser(int id)
{
using (var entity = new BidingSystemDBEntities())
{
var user = entity.User.Where(x => x.CompanyId == id).FirstOrDefault();
entity.User.Remove(user);
return(entity.SaveChanges());
}
}
public static User GetUserInfoInLogin(string userName, string passwrod)
{
using (var entity = new BidingSystemDBEntities())
{
var user = entity.User.Where(x => x.CompanyName == userName && x.Password == passwrod).FirstOrDefault();
if (user == null)
{
return(null);
}
return(user);
}
}
private static int GetRecordCount()
{
try
{
using (var entity = new BidingSystemDBEntities())
{
var item = entity.Item.ToList();
if (item != null)
{
return(item.Count());
}
else
{
return(-1);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(-1);
}
}
