public Order updateStatus(Order order) { if (order != null) { using (DataContext db = new SqlserverContext()) { Table <Order> T_Order = db.GetTable <Order>(); //Order orders = (from c in T_Order where c.UserID == userId && c.ID == orderId select c) as Order; Order orders = T_Order.FirstOrDefault <Order>(x => x.ID.Equals(order.ID)); LogerHelper.debug(orders.UserID); if (orders != null) { Order order1 = T_Order.FirstOrDefault <Order>(x => x.ID.Equals(order.ID)); order1.State = (int)Commons.Type.USING; db.SubmitChanges(); LogerHelper.debug("还车修改订单状态成功!" + orders.State); if (orders != null) { return(orders); } } else { LogerHelper.debug("还车修改订单状态失败!"); } } } else { LogerHelper.debug("输入order为空"); } return(null); }
public Car findCarByCarId(string id) { using (DataContext db = new SqlserverContext()) { Table <Car> T_Car = db.GetTable <Car>(); Table <RunRealTime> runRealTimeTable = db.GetTable <RunRealTime>(); Table <Order> orderTable = db.GetTable <Order>(); Car car = T_Car.FirstOrDefault <Car>(o => o.id.Equals(id)); if (car != null) { RunRealTime runRealTime = (from m in runRealTimeTable where m.TerminalId == car.TermID orderby m.sampleTime descending select m).FirstOrDefault(); //if (runRealTime != null) //{ //} car.miles = (Convert.ToInt32(car.CarCharge) * 10).ToString(); Order order = (from m in orderTable where m.CarID == car.id orderby m.CreateTime descending select m).FirstOrDefault(); if (order != null) { car.lastUsedTime = order.CreateTime; } Order uorder = (from m in orderTable where m.CarID == car.id orderby m.CreateTime select m).FirstOrDefault(); if (uorder != null) { car.UpdateTime = order.CreateTime; } } return(car); } }
//只有订单在预约和已经使用状态才能下发 public string[] queryTelByTermiId(string termiId) { OrderEx order = null; if (termiId != null) { using (DataContext db = new SqlserverContext()) { Table <Car> T_car = db.GetTable <Car>(); Table <Order> T_order = db.GetTable <Order>(); Table <CarStat> T_Stat = db.GetTable <CarStat>(); Car car = T_car.FirstOrDefault <Car>(o => o.TermID.Equals(termiId)); if (car != null) { order = (from m in T_order join n in T_Stat on m.CarID equals n.CarID where m.CarID == car.id && (n.stat == (int)Commons.CatStatus.book || n.stat == (int)Commons.CatStatus.run) && (m.State == (int)Commons.Type.BOOK || m.State == (int)Commons.Type.USING) orderby n.CreateTime descending select new OrderEx { CarID = m.CarID, ID = m.ID, State = m.State, UserID = m.UserID, }).FirstOrDefault(); if (order != null) { return(new string[] { order.UserID, order.CarID }); } } } } return(null); }
public IList <Station> queryIdleStation() { IList <Station> stations = new List <Station>(); //查询有空闲车的租赁点 using (DataContext db = new SqlserverContext()) { Table <Station> T_Station = db.GetTable <Station>(); Table <Car> T_Car = db.GetTable <Car>(); Table <Piles> T_Piles = db.GetTable <Piles>(); Table <CarStat> T_CarStat = db.GetTable <CarStat>(); IList <Station> allStation = T_Station.ToList <Station>(); if (allStation != null && allStation.Count() > 0) { foreach (var i in allStation) { IList <Piles> allPiles = T_Piles.Where <Piles>(o => o.StationID == i.id).ToList <Piles>(); if (allPiles != null && allPiles.Count() > 0) { foreach (var m in allPiles) { CarStat stat = T_CarStat.Where <CarStat>(o => o.PilesID == m.id).OrderByDescending(x => x.CreateTime).First(); if (stat != null && stat.stat == (int)Commons.CatStatus.idle) { stations.Add(i); break; } } } } } } return(stations); }
public User CreateOrUpdate(User info) { //DbTransaction tran = null; //DbConnection conn = null; //内存中不包含该用户,保存用户信息 if (info != null) { using (DataContext db = new SqlserverContext()) { Table <User> T_USER = db.GetTable <User>(); User u = T_USER.FirstOrDefault <User>(o => o.UserId.Equals(info.UserId)); if (u != null) { u.CardID = info.CardID; u.Name = info.Name; u.UserDriverLicense = info.UserDriverLicense; u.UserStatus = ((int)(Commons.Authentication.Verified)).ToString(); db.SubmitChanges(); return(u); } else { T_USER.InsertOnSubmit(info); db.SubmitChanges(); return(info); } } } return(null); }
public User getUserByCardID(string CardId) { using (DataContext ctx = new SqlserverContext()) { Table <User> wcUser = ctx.GetTable <User>(); return(wcUser.SingleOrDefault <User>(o => o.CardID.Equals(CardId))); } }
//根据登录名查询userid public string getUserId(UserLogin login) { using (DataContext db = new SqlserverContext()) { Table <UserLogin> T_UserLogin = db.GetTable <UserLogin>(); return(T_UserLogin.FirstOrDefault <UserLogin>(x => x.LoginID.Equals(login.LoginID)).UserId); } }
public User getUserByPhoneNumber(string phoneNumber) { using (DataContext ctx = new SqlserverContext()) { Table <User> wcUser = ctx.GetTable <User>(); return(wcUser.SingleOrDefault <User>(o => o.PhoneNumber.Equals(phoneNumber))); } }
//订单撤销 //return true:成功 false:失败 public bool cancelOrder(string orderid) { if (!String.IsNullOrWhiteSpace(orderid)) { using (DataContext db = new SqlserverContext()) { Table <Order> T_order = db.GetTable <Order>(); Table <OrderLog> T_orderLog = db.GetTable <OrderLog>(); Table <CarStat> carStatTable = db.GetTable <CarStat>(); IEnumerable <OrderLog> orders = T_orderLog.Where <OrderLog>(o => o.OrderID.Equals(orderid)); IList <UserAuthorization> list = null; Table <UserAuthorization> AuthTable = db.GetTable <UserAuthorization>(); if (orders != null && orders.Count() > 0) { return(false); } //如果当前时间可以取消,修改该订单状态 Order order = T_order.FirstOrDefault <Order>(x => x.ID.Equals(orderid)); // DateTime t1 = DateTime.ParseExact(order.Time,"yyyy-MM-dd HH:mm:ss",System.Globalization.CultureInfo.CurrentCulture); if (order != null && order.State == (int)Commons.Type.BOOK) {//在订单状态为预约状态,车状态为预定状态,可以取消订单 CarStat carStat = (from m in carStatTable where m.CarID == order.CarID orderby m.CreateTime descending select m).FirstOrDefault(); if (carStat.stat == (int)Commons.CatStatus.book) { order.State = (int)Commons.Type.CANCEL; CarStat stat = new CarStat(); stat.id = Guid.NewGuid().ToString().Replace("-", ""); stat.stat = (int)Commons.CatStatus.idle; stat.UserID = order.UserID; stat.CarID = order.CarID; stat.PilesID = carStat.PilesID; stat.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); carStatTable.InsertOnSubmit(stat); //收回授权状态 list = (from c in AuthTable where c.OrderId.Equals(orderid) && c.Status == (int)Commons.Authorized.AUTHORIZE select c).ToList(); foreach (UserAuthorization item in list) { item.Status = (int)Commons.Authorized.UNAUTHORIZE; } db.SubmitChanges(); return(true); } } } } return(false); }
/** * param: userReg * return: true--用户存在 * false--用户不存在 */ public bool veriryUserExistOrNot(string CardId, string tel) { using (DataContext ctx = new SqlserverContext()) { Table <User> wcUser = ctx.GetTable <User>(); User user = wcUser.FirstOrDefault <User>(o => o.CardID.Equals(CardId) || o.PhoneNumber.Equals(tel)); if (user != null) { return(true); } } return(false); }
public User findUserId(string id) { using (DataContext db = new SqlserverContext()) { Table <User> T_UserLogin = db.GetTable <User>(); User users = T_UserLogin.FirstOrDefault <User>(x => x.UserId.Equals(id)); if (users != null) { return(users); } } return(null); }
public User findLoginUser(UserLogin LoginUser) { using (DataContext db = new SqlserverContext()) { Table <User> T_UserLogin = db.GetTable <User>(); User users = T_UserLogin.FirstOrDefault <User>(x => x.PhoneNumber.Equals(LoginUser.LoginID) && x.Password.Equals(LoginUser.LoginPwd)); if (users != null) { return(users); } } return(null); }
//查询用户是否已经注册 //false 没有注册 true 已经注册 public bool verifyUser(UserReg login) { using (DataContext db = new SqlserverContext()) { Table <UserLogin> T_UserLogin = db.GetTable <UserLogin>(); //db账号不存在 if (T_UserLogin.FirstOrDefault(o => login.LoginID.Equals(o.LoginID) && login.LoginPwd.Equals(o.LoginPwd)) == null) { return(false); } } return(true); }
public int SelectNum(string userid) { if (!String.IsNullOrWhiteSpace(userid)) { using (DataContext db = new SqlserverContext()) { Table <Order> T_order = db.GetTable <Order>(); int num = T_order.Where(o => o.UserID.Equals(userid)).ToList().Count(); return(num); } } return(0); }
public Com.ChinaPalmPay.Platform.RentCar.Model.Alipay Addalipay(Com.ChinaPalmPay.Platform.RentCar.Model.Alipay ali) { if (ali != null) { using (DataContext db = new SqlserverContext()) { Table <Com.ChinaPalmPay.Platform.RentCar.Model.Alipay> T_order = db.GetTable <Com.ChinaPalmPay.Platform.RentCar.Model.Alipay>(); T_order.InsertOnSubmit(ali); db.SubmitChanges(); return(ali); } } return(null); }
public OrderLog Addlog(OrderLog log) { if (log != null) { using (DataContext db = new SqlserverContext()) { Table <OrderLog> T_order = db.GetTable <OrderLog>(); T_order.InsertOnSubmit(log); db.SubmitChanges(); return(log); } } return(null); }
public Cup AddCup(Cup charge) { if (charge != null) { using (DataContext db = new SqlserverContext()) { Table <Cup> T_order = db.GetTable <Cup>(); T_order.InsertOnSubmit(charge); db.SubmitChanges(); return(charge); } } return(null); }
public UserAuthorization Add(UserAuthorization auth) { if (auth != null) { using (DataContext db = new SqlserverContext()) { Table <UserAuthorization> AuthTable = db.GetTable <UserAuthorization>(); AuthTable.InsertOnSubmit(auth); db.SubmitChanges(); return(auth); } } return(null); }
public Recharge Addpay(Recharge charge) { if (charge != null) { using (DataContext db = new SqlserverContext()) { Table <Recharge> T_order = db.GetTable <Recharge>(); T_order.InsertOnSubmit(charge); db.SubmitChanges(); return(charge); } } return(null); }
public CarStat findCarStat(string userId, string carId) { using (DataContext db = new SqlserverContext()) { Table <CarStat> T_CarStat = db.GetTable <CarStat>(); CarStat carstat = T_CarStat.FirstOrDefault <CarStat>(o => o.UserID.Equals(userId) && o.CarID.Equals(carId) && o.stat == (int)Commons.CatStatus.idle); if (carstat != null) { return(carstat); } } return(null); }
public Messages AddMsg(Messages msg) { if (msg != null) { using (DataContext db = new SqlserverContext()) { Table <Messages> T_Msg = db.GetTable <Messages>(); T_Msg.InsertOnSubmit(msg); db.SubmitChanges(); return(msg); } } return(null); }
public IList <Messages> queryMsg(string id) { IList <Messages> msgs = new List <Messages>(); if (!String.IsNullOrWhiteSpace(id)) { using (DataContext ctx = new SqlserverContext()) { Table <Messages> MSG = ctx.GetTable <Messages>(); msgs = (from c in MSG where c.userid == id || c.type == (((int)(Commons.MessagesType.sysType)).ToString()) select c).ToList(); } } return(msgs); }
public StopRealTime AddStopRealTime(StopRealTime run) { if (run != null) { using (DataContext db = new SqlserverContext()) { Table <StopRealTime> T_order = db.GetTable <StopRealTime>(); T_order.InsertOnSubmit(run); db.SubmitChanges(); return(run); } } return(null); }
public IList <Recharge> queryRecharge(string userId, string orderId) { IList <Recharge> list = null; if (!String.IsNullOrWhiteSpace(userId) && !String.IsNullOrWhiteSpace(orderId)) { using (DataContext db = new SqlserverContext()) { Table <Recharge> T_REC = db.GetTable <Recharge>(); list = (from c in T_REC where c.UserID.Equals(userId) && c.OrderID.Equals(orderId) && c.Type == (int)Commons.PayType.CONSUME select c).ToList() as IList <Recharge>; return(list); } } return(new List <Recharge>()); }
public AuthorizationRequest AddAuthorizationRealTime(AuthorizationRequest run) { if (run != null) { using (DataContext db = new SqlserverContext()) { Table <AuthorizationRequest> T_order = db.GetTable <AuthorizationRequest>(); T_order.InsertOnSubmit(run); db.SubmitChanges(); return(run); } } return(null); }
public Order Create(Order order) { if (order != null) { using (DataContext db = new SqlserverContext()) { Table <Order> T_order = db.GetTable <Order>(); T_order.InsertOnSubmit(order); db.SubmitChanges(); return(order); } } return(null); }
public OpenOrCloseGateRequest AddOpenOrCloseGate(OpenOrCloseGateRequest open) { if (open != null) { using (DataContext db = new SqlserverContext()) { Table <OpenOrCloseGateRequest> T_order = db.GetTable <OpenOrCloseGateRequest>(); T_order.InsertOnSubmit(open); db.SubmitChanges(); return(open); } } return(null); }
//修改头像 public User userChangePhoto(User user) { using (DataContext db = new SqlserverContext()) { Table <User> T_UserLogin = db.GetTable <User>(); User users = T_UserLogin.FirstOrDefault <User>(x => x.UserId.Equals(user.UserId)); if (users != null) { users.PitcurePath = user.PitcurePath; db.SubmitChanges(); return(users); } } return(null); }
//查询微信用户是否已经注册 public string WechatBinding(string tel, string openId) { using (DataContext db = new SqlserverContext()) { Table <UserLogin> T_UserLogin = db.GetTable <UserLogin>(); // Table<WcUser> T_WcUser = db.GetTable<WcUser>(); UserLogin login = T_UserLogin.FirstOrDefault(x => x.LoginID.Equals(tel)); //手机号 if (login == null) { } } return(null); }
public UserLogin AddExistUserLogin(UserLogin log) { if (log != null) { using (DataContext ctx = new SqlserverContext()) { Table <UserLogin> wcUser = ctx.GetTable <UserLogin>(); wcUser.InsertOnSubmit(log); ctx.SubmitChanges(); return(log); } } return(null); }