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