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 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); }
//订单撤销 //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); }
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 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 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 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 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 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 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 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 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 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 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); }
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); }
//***********************用户注册DB操作BEGIN********************************* public UserLogin Create(UserGroup Base, UserLogin login, User info, UserRegister register) { //DbTransaction tran = null; //DbConnection conn = null; //内存中不包含该用户,保存用户信息 if (Base != null && info != null && login != null && register != null) { using (DataContext db = new SqlserverContext()) { Table <UserGroup> T_UserGroup = db.GetTable <UserGroup>(); Table <UserLogin> T_UserLogin = db.GetTable <UserLogin>(); Table <User> T_User = db.GetTable <User>(); Table <UserRegister> T_UserRegister = db.GetTable <UserRegister>(); //conn = db.Connection; //if (conn.State == ConnectionState.Closed) //{ // conn.Open(); // tran = conn.BeginTransaction(); //} T_UserGroup.InsertOnSubmit(Base); T_UserLogin.InsertOnSubmit(login); T_User.InsertOnSubmit(info); T_UserRegister.InsertOnSubmit(register); //tran.Commit(); db.SubmitChanges(); LogerHelper.debug("REGESTER SUCCESS"); //conn.Close(); return(login); //注册账号已经存在 } } // ctx.Connection.Close(); //数据保存出错 //HashOperator.getInstance().Set<UserGroup>("InsertUserBaseError", Base.ID, Base); //HashOperator.getInstance().Set<User>("InsertUserInfoError", info.UserGroupID, info); //保存失败,继续存储,保证数据库与内存数据实现同步 //Thread oThread = new Thread(delegate() //{ // List<UserGroup> _userbase = HashOperator.getInstance().GetAll<UserGroup>("InsertUserBaseError"); // List<User> _userinfo = HashOperator.getInstance().GetAll<User>("InsertUserInfoError"); // SaveOrUpdateError.insertUser(_userbase, _userinfo); //}); //oThread.Name = "INSERT_User"; //oThread.Start(); //存储日志 return(null); }
public UserGroup Create(UserGroup Base) { //DbTransaction tran = null; //DbConnection conn = null; //内存中不包含该用户,保存用户信息 if (Base != null) { using (DataContext db = new SqlserverContext()) { Table <UserGroup> T_UserGroup = db.GetTable <UserGroup>(); T_UserGroup.InsertOnSubmit(Base); db.SubmitChanges(); return(Base); } } return(null); }
public User UserComplete(User info) { if (!String.IsNullOrWhiteSpace(info.Name) && !String.IsNullOrWhiteSpace(info.UserDriverLicense) && !String.IsNullOrWhiteSpace(info.PitcurePath) && !String.IsNullOrWhiteSpace(info.CardPath)) { using (DataContext db = new SqlserverContext()) { Table <User> T_USER = db.GetTable <User>(); User u = T_USER.FirstOrDefault <User>(o => o.UserId.Equals(info.UserId)); u.PitcurePath = info.PitcurePath; u.CardPath = info.CardPath; u.Name = info.Name; u.UserDriverLicense = info.UserDriverLicense; u.UserStatus = ((int)Commons.Authentication.Verified).ToString(); db.SubmitChanges(); return(u); } } return(null); }
public bool cancelAuth(string userId, string OrderId) { if (!String.IsNullOrWhiteSpace(userId) && !String.IsNullOrWhiteSpace(OrderId)) { using (DataContext db = new SqlserverContext()) { IList <UserAuthorization> list = null; Table <UserAuthorization> AuthTable = db.GetTable <UserAuthorization>(); 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); }
public CarStat addCarStat(OrderLog order) { LogerHelper.DefaultInfo("addCarStat:" + order.OrderID); //增加车状态 using (DataContext db = new SqlserverContext()) { Table <CarStat> T_PILE = db.GetTable <CarStat>(); CarStat stat = new CarStat(); CarStat c = (from m in T_PILE where m.CarID == order.CarID select m).FirstOrDefault(); stat.id = Guid.NewGuid().ToString().Replace("-", ""); stat.stat = (int)Commons.CatStatus.idle; stat.UserID = order.UserID; stat.CarID = order.CarID; stat.PilesID = c.PilesID; stat.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); T_PILE.InsertOnSubmit(stat); db.SubmitChanges(); LogerHelper.debug("还车 Add CarStat 成功!"); return(stat); } }
public bool updateToOpenDoor(string userId) {//根据UserId修改Order状态为开门 using (DataContext db = new SqlserverContext()) { Table <Order> orderTable = db.GetTable <Order>(); Table <UserAuthorization> AuthTable = db.GetTable <UserAuthorization>(); UserAuthorization auth = AuthTable.Where(o => o.UserId.Equals(userId)).OrderByDescending(p => p.Date).FirstOrDefault(); //查询该订单 if (auth != null) { if (auth.Status == (int)Commons.Authorized.BASED || auth.Status == (int)Commons.Authorized.AUTHORIZE) { Order order = orderTable.Where(x => x.ID.Equals(auth.OrderId)).FirstOrDefault(); if (order != null) { order.State = (int)Commons.Type.OPENDOOR; db.SubmitChanges(); return(true); } } } } return(false); }
public UserLogin CreateOrUpdate(UserLogin Base) { //DbTransaction tran = null; //DbConnection conn = null; //内存中不包含该用户,保存用户信息 if (Base != null) { using (DataContext db = new SqlserverContext()) { Table <UserLogin> T_UserGroup = db.GetTable <UserLogin>(); List <UserLogin> loginList = (from m in T_UserGroup where m.UserId == Base.UserId select m).ToList(); bool isUpdate = false; foreach (UserLogin item in loginList) { if ((Base.LoginPwd == null && item.LoginPwd == null) || (Base.LoginPwd != null && item.LoginPwd != null)) { item.LoginID = Base.LoginID; item.LoginPwd = Base.LoginPwd; item.UpdateTime = DateTime.Now.ToString(); isUpdate = true; } } if (!isUpdate) { UserLogin login = new UserLogin(); login.LoginID = Base.LoginID; login.LoginPwd = Base.LoginPwd; login.UpdateTime = DateTime.Now.ToString(); login.UserId = Base.UserId; T_UserGroup.InsertOnSubmit(login); } db.SubmitChanges(); /* * * * if (login != null) * { * if (login.LoginPwd == null) * { * * } * else { * * } * login.LoginID = Base.LoginID; * login.LoginPwd = Base.LoginPwd; * login.UpdateTime = DateTime.Now.ToString(); * db.SubmitChanges(); * return login; * } * else * { * //添加 * T_UserGroup.InsertOnSubmit(Base); * db.SubmitChanges(); * return Base; * } * */ } } return(null); }