/// <summary>
/// 验证账号是否在登陆中
/// </summary>
/// <param name="userId">用户ID</param>
/// <returns></returns>
public RetJsonModel IsLogin(string userId)
{
var db = DBContext.GetInstance;
try
{
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = FunctionHelper.GetTimestamp();
SYS_USER_ACCOUNT account = db.Queryable <SYS_USER_ACCOUNT>()
.Where(x => x.STATE == "A" && x.ID == userId)
.First();
if (account != null && account.STATUS == 1)
{
jsonModel.status = 1;
jsonModel.msg = "账号登陆中";
jsonModel.data = true;
}
else
{
jsonModel.status = 0;
jsonModel.msg = "账号未登录";
jsonModel.data = false;
}
return(jsonModel);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 注册方法
/// </summary>
/// <param name="userId">账号</param>
/// <param name="passWord">密码</param>
public RetJsonModel Register(string userId, string passWord)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
int timestamp = FunctionHelper.GetTimestamp();
jsonModel.time = timestamp;
//查询账号是否已存在
var data = db.Queryable <SYS_USER_ACCOUNT>()
.Where(x => x.ACCOUNT_NUMBER == userId)
.First();
if (data == null)
{
db.Ado.BeginTran();
//账号表新增记录
SYS_USER_ACCOUNT model = new SYS_USER_ACCOUNT();
model.ID = System.Guid.NewGuid().ToString();
model.DATETIME_CREATED = now;
model.STATE = "A";
model.ACCOUNT_NUMBER = userId;
model.PASSWORD = passWord;
model.TIMESTAMP_INT = timestamp;
model.STATUS = 1;
db.Insertable(model).ExecuteCommand();
//先在用户注册时，默认在用户个人信息表插入一条记录
bool isExist = true;
string nickName = "";
do
{
nickName = FunctionHelper.GetRandomString(8, true, false, true, false, "");
int count = db.Queryable <SYS_USER_INFO>().Where(x => x.NICK_NAME == nickName && x.STATE == "A").Count();
isExist = count == 0;
} while (!isExist);
SYS_USER_INFO uInfoModel = new SYS_USER_INFO();
uInfoModel.ID = System.Guid.NewGuid().ToString();
uInfoModel.DATETIME_CREATED = now;
uInfoModel.STATE = "A";
uInfoModel.TIMESTAMP_INT = timestamp;
uInfoModel.USER_ID = model.ID;
uInfoModel.NICK_NAME = nickName;
db.Insertable(uInfoModel).ExecuteCommand();
LoginReturnModel lrm = new LoginReturnModel();
lrm.user_info = new UserInfoReturnModel
{
USER_ID = model.ID,
NiCK_NAME = uInfoModel.NICK_NAME
};
jsonModel.status = 1;
jsonModel.msg = "注册成功";
jsonModel.data = lrm;
db.Ado.CommitTran();
}
else
{
jsonModel.status = 0;
jsonModel.msg = "账号已存在，请重新输入";
}
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
