/// <summary> /// 获取列表 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <IEnumerable <AccountDBModel> > GetList(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { #if DEBUG try { var result = dal.GetList(account); //throw new Exception("需要捕获的人造错误"); return(result); } catch (Exception ex) { return(ex.Fail <IEnumerable <AccountDBModel> >()); } return(new DataShell <IEnumerable <AccountDBModel> >()); #else var result = dal.GetList(account); return(result); #endif } } //return "未能提取到数据".Fail<IEnumerable<BimUser>>(); }
public IDataShell <AccountDBModel> Login(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) using (var dal = new UserAccountTDAL(conn)) { var result = dal.GetSingle(account); return(result); } }
/// <summary> /// 获取全部用户信息,用于管理端对照提取用户关联信息使用 /// </summary> /// <returns></returns> public IDataShell <IEnumerable <AccountDBModel> > GetAllAccount() { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.GetAllAccount(); return(result); } } }
/// <summary> /// 分页提取数据 /// </summary> /// <param name="condition"></param> /// <returns></returns> public IDataShell <PageShell <AccountDBModel> > GetPage(PageCondition <UserQueryPageCondition> condition) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.GetPage(condition); return(result); } } }
/// <summary> /// 获取所有用户的简要信息,用于对照名字之类 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> GetAllUser(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var res = dal.GetByCoreID(user); return(res); } } }
/// <summary> /// 逻辑删除列表通过ids /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <int> DelList(List <string> accountids) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.DelList(accountids);//要测试是否可行 return(result); } } }
// 登录更新(查询验证,更新登录时间,次数) // 改密码更新 // 改高级密码更新 // 更新状态 // 更新邮件 // 更新手机号 // 设置临时密码 // 验证临时密码 // 改昵称 // 设置真名,身份证 // // 管理系统 改状态 更新 // /// <summary> /// 逻辑上删除 /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <int> Del(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Del(account); return(result); } } }
/// <summary> /// 获取单个记录 /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <AccountDBModel> Get(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.GetSingle(account); return(result); } } //return "未能提取到数据".Fail<BimUser>(); }
/// <summary> /// 插入新纪录 /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <AccountDBModel> Insert(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var uid = dal.NewUserID(); account.AccountID = Convert.ToString(uid.Data); var result = dal.Insert(account); return(result); } } }
/*更新有几类:更新到外部来的新值,依据旧值更新如累加,更新其他旧值*/ /// <summary> /// 登录后更新 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> UpdateAfterLogin(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "TotalLoginTimes=TotalLoginTimes+1, LastLoginTime=@LastLoginTime", "AccountID=@AccountID", new { @AccountID = user.AccountID, @LastLoginTime = user.LastLoginTime }); if (result != 1) { return($"登录更新影响行数异常{result}".Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 更新帐号状态 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> UpdateStatus(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "Status=@Status", "AccountID=@AccountID", new { Status = user.Status, @AccountID = user.AccountID }); if (result != 1) { return($"修改状态更新影响行数异常{result}".Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 修改密码更新 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> UpdateModifyPassword(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "Password=@Password", "AccountID=@AccountID", new { @AccountID = user.AccountID, @Password = user.Password }); if (result != 1) { return($"修改密码更新影响行数异常{result}".Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 事务方式插入新纪录 /// 事务范例 /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <AccountDBModel> TranWork(AccountDBModel account) { using (var conn = ConnFactory.GetUserConn()) //打开链接 { using (var uk = new UniteWork(conn)) //启动事务 { var dal = new UserAccountTDAL(conn, uk.Tran); var uid = dal.NewUserID(); account.AccountID = Convert.ToString(uid.Data); var result = dal.Insert(account); account.Account = "XXEW"; result = dal.Update(account); account.Email = "XXEW11"; result = dal.Update(account); uk.Commit();//成功就提交事务 return(result); } } }
/// <summary> /// 设置临时密码,(TempPassword,TempPassOverTime,TempPassUseFor) /// 用空参数设置临时密码就是清空临时密码 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> SetTempPassword(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "TempPassword=@TempPassword, TempPassOverTime=@TempPassOverTime, TempPassUseFor=@TempPassUseFor", "AccountID=@AccountID", new { @TempPassword = user.TempPassword, @TempPassOverTime = user.TempPassOverTime, @TempPassUseFor = user.TempPassUseFor, @AccountID = user.AccountID }); if (result != 1) { return(PubError.DBError("ERR-00200301", "SetTempPassword|设置临时密码").ToStr().Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 高级 管理 更新 /// </summary> /// <param name="account"></param> /// <returns></returns> public IDataShell <AccountDBModel> Update(AccountDBModel account) { var ig_list = new List <string>() { "AccountID", "CoreID", "UserID", "Account" }; using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(account, updateIgnoreField: ig_list); if (result != 1) { throw new Exception("高级更新失败影响数据为0"); } return(account.Succ()); } } }
/// <summary> /// 更新系统备注 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> UpdateSysRemark(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "SysRemark=@SysRemark", "AccountID=@AccountID", new { @SysRemark = user.SysRemark, @AccountID = user.AccountID }); if (result != 1) { return(PubError.DBError("ERR-00200301", "UpdateSysRemark|更新系统备注").ToStr().Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 设置真名 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> SetRealName(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "RealName=@RealName", "AccountID=@AccountID", new { @RealName = user.RealName, @AccountID = user.AccountID }); if (result != 1) { return(PubError.DBError("ERR-00200301", "SetRealName|设置真名").ToStr().Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 更新头像 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> UpdateNickPic(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "NickPic=NickPic", "AccountID=@AccountID", new { @NickPic = user.NickPic, @AccountID = user.AccountID }); if (result != 1) { return(PubError.DBError("ERR-00200301", "UpdateNickPic|更新头像").ToStr().Fail <AccountDBModel>()); } return(user.Succ()); } } }
/// <summary> /// 设置身份证信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public IDataShell <AccountDBModel> SetIDCard(AccountDBModel user) { using (var conn = ConnFactory.GetUserConn()) { using (var dal = new UserAccountTDAL(conn)) { var result = dal.Update(user, "IDCard=@IDCard, IDCardPic=@IDCardPic", "AccountID=@AccountID", new { @IDCard = user.IDCard, @IDCardPic = user.IDCardPic, @AccountID = user.AccountID }); if (result != 1) { return(PubError.DBError("ERR-00200301", "SetIDCard|设置身份证信息").ToStr().Fail <AccountDBModel>()); } return(user.Succ()); } } }