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);
}
