public static SysCode GETSysCode(IQueryBuilder <SysCode> iquery)
{
using (var entity = new BusEntities())
{
return(entity.SysCode.Where(iquery.Expression).FirstOrDefault());
}
}
public static PagedList <BusLineView> List(IQueryBuilder <BusLineView> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.Where(iquery.Expression).OrderBy(x => x.LineName).ToPagedList(Page, PageSize));
}
}
public static BusLineView GETBusLineView(int ID)
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.Where(x => x.ID == ID).FirstOrDefault());
}
}
public static bool SaveEditPayMent(PayMent model)
{
using (var entity = new BusEntities())
{
var obj = entity.PayMent.FirstOrDefault(x => x.ID == model.ID);
if (obj != null)
{
obj.LineID = model.LineID;
obj.UsersID = model.UsersID;
obj.PayNames = model.PayNames;
obj.StartTime = model.StartTime;
obj.EndTime = model.EndTime;
obj.Money = model.Money;
obj.isUse = model.isUse;
obj.PayType = model.PayType;
obj.HeXiao = model.HeXiao;
obj.HXTime = model.HXTime;
obj.Memo = model.Memo;
obj.addUsers = model.addUsers;
obj.ZWQ = model.ZWQ;
obj.SZ = model.SZ;
obj.CreateTime = model.CreateTime;
return(entity.SaveChanges() > 0);
}
return(false);
}
}
public static List <BusLineView> BusLineViewList(IQueryBuilder <BusLineView> iquery)
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.Where(iquery.Expression).OrderByDescending(x => x.ID).ToList());
}
}
public static List <PayMent> PayMentList()
{
using (var entity = new BusEntities())
{
return(entity.PayMent.OrderByDescending(x => x.ID).ToList());
}
}
public static PayMent GETPayMent(IQueryBuilder <PayMent> iquery)
{
using (var entity = new BusEntities())
{
return(entity.PayMent.Where(iquery.Expression).FirstOrDefault());
}
}
public static WXUsers GETWXUsers(int ID)
{
using (var entity = new BusEntities())
{
return(entity.WXUsers.Where(x => x.ID == ID).FirstOrDefault());
}
}
public static List <PayMmListView> PayMmListViewList(IQueryBuilder <PayMmListView> iquery)
{
using (var entity = new BusEntities())
{
return(entity.PayMmListView.Where(iquery.Expression).OrderByDescending(x => x.Names).ToList());
}
}
public static List <WXUsers> WXUsersList()
{
using (var entity = new BusEntities())
{
return(entity.WXUsers.OrderByDescending(x => x.ID).ToList());
}
}
public static WXUsers GETWXUsers(IQueryBuilder <WXUsers> iquery)
{
using (var entity = new BusEntities())
{
return(entity.WXUsers.Where(iquery.Expression).FirstOrDefault());
}
}
public static List <WXUsers> WXUsersList(IQueryBuilder <WXUsers> iquery)
{
using (var entity = new BusEntities())
{
return(entity.WXUsers.Where(iquery.Expression).OrderByDescending(x => x.ID).ToList());
}
}
public static int AddMultiLineUser(List <LineUser> modelList)
{
using (var entity = new BusEntities())
{
var addCnt = 0;
try
{
foreach (var model in modelList)
{
var q = QueryBuilder.Create <Data.LineUser>();
q = q.Equals(x => x.UserID, model.UserID);
q = q.Equals(x => x.LineID, model.LineID);
q = q.Equals(x => x.RideType, model.RideType);
q = q.Equals(x => x.DelFlag, model.DelFlag);
var list = LineUserList(q);
if (list != null && list.Count > 0)
{
continue;
}
entity.AddToLineUser(model);
entity.SaveChanges();
addCnt++;
}
}
catch { }
return(addCnt);
}
}
public static SysCode GETSysCode(int ID)
{
using (var entity = new BusEntities())
{
return(entity.SysCode.Where(x => x.ID == ID).FirstOrDefault());
}
}
public static List <PayMent> PayMentList(IQueryBuilder <PayMent> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.PayMent.Where(iquery.Expression).OrderByDescending(x => x.ID).Skip(((Page == 0 ? 1 : Page) - 1) * PageSize).Take(PageSize).ToList <PayMent>());
}
}
public static List <PayMmListView> PayMmListViewList()
{
using (var entity = new BusEntities())
{
return(entity.PayMmListView.OrderByDescending(x => x.Names).ToList());
}
}
public static List <PayMent> PayMentList(IQueryBuilder <PayMent> iquery)
{
using (var entity = new BusEntities())
{
return(entity.PayMent.Where(iquery.Expression).OrderByDescending(x => x.ID).ToList());
}
}
public static List <Driver> DriverList(IQueryBuilder <Driver> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.Driver.Where(iquery.Expression).OrderByDescending(x => x.DriverName).ThenByDescending(x => x.ID).Skip(((Page == 0 ? 1 : Page) - 1) * PageSize).Take(PageSize).ToList <Driver>());
}
}
public static PagedList <PayMent> List(IQueryBuilder <PayMent> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.PayMent.Where(iquery.Expression).OrderByDescending(x => x.ID).ToPagedList(Page, PageSize));
}
}
public static List <Driver> DriverList(IQueryBuilder <Driver> iquery)
{
using (var entity = new BusEntities())
{
return(entity.Driver.Where(iquery.Expression).OrderByDescending(x => x.ID).ToList());
}
}
public static PayMent GETPayMent(int ID)
{
using (var entity = new BusEntities())
{
return(entity.PayMent.FirstOrDefault(x => x.ID == ID));
}
}
public static List <Driver> DriverList()
{
using (var entity = new BusEntities())
{
return(entity.Driver.OrderByDescending(x => x.ID).ToList());
}
}
public static List <BusLineView> BusLineViewList(IQueryBuilder <BusLineView> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.Where(iquery.Expression).OrderByDescending(x => x.EndBusID).ThenByDescending(x => x.ID).Skip(((Page == 0 ? 1 : Page) - 1) * PageSize).Take(PageSize).ToList <BusLineView>());
}
}
public static PagedList <Driver> List(IQueryBuilder <Driver> iquery, int Page = 1, int PageSize = 10)
{
using (var entity = new BusEntities())
{
return(entity.Driver.Where(iquery.Expression).OrderByDescending(x => x.DriverName).ThenByDescending(x => x.ID).ToPagedList(Page, PageSize));
}
}
public static List <BusLineView> BusLineViewList()
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.OrderByDescending(x => x.ID).ToList());
}
}
public static Driver GETDriver(IQueryBuilder <Driver> iquery)
{
using (var entity = new BusEntities())
{
return(entity.Driver.Where(iquery.Expression).FirstOrDefault());
}
}
public static BusLineView GETBusLineView(IQueryBuilder <BusLineView> iquery)
{
using (var entity = new BusEntities())
{
return(entity.BusLineView.Where(iquery.Expression).FirstOrDefault());
}
}
public static Driver GETDriver(int ID)
{
using (var entity = new BusEntities())
{
return(entity.Driver.Where(x => x.ID == ID).FirstOrDefault());
}
}
public static bool SaveEditBusLineView(BusLineView model)
{
using (var entity = new BusEntities())
{
var obj = entity.BusLineView.FirstOrDefault(x => x.ID == model.ID);
if (obj != null)
{
//obj.BusNo = model.BusNo;
//obj.DriverName = model.DriverName;
//obj.Phone = model.Phone;
//obj.CreateTime = model.CreateTime;
//obj.MotoType = model.MotoType;
//obj.SeatCnt = model.SeatCnt;
//obj.Corp = model.Corp;
//obj.ID = model.ID;
//obj.InsuEndDate = model.InsuEndDate;
//obj.BuyDate = model.BuyDate;
//obj.OwnerName = model.OwnerName;
//obj.OwnerPhone = model.OwnerPhone;
//obj.Etc1 = model.Etc1;
//obj.Etc2 = model.Etc2;
//obj.Etc3 = model.Etc3;
return(entity.SaveChanges() > 0);
}
return(false);
}
}
public static List <SysCode> SysCodeList()
{
using (var entity = new BusEntities())
{
return(entity.SysCode.OrderByDescending(x => x.ID).ToList());
}
}
