public JsonResponse AccountUserList([FromUri] string Code, string UserId) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(UserId)) { return(BadResponse("用户未登录", null, false)); } AccountList model = new AccountList(); model = AccountListBll.GetModelByCode(Code); string[] allUserIdArray = model.AllUserId.Split(','); List <UserInfo> AllUserList = UserInfoBll.GetListByIdList(allUserIdArray).ToList(); List <AccountListAllUserDto> returnList = new List <AccountListAllUserDto>(); foreach (var user in AllUserList) { AccountListAllUserDto userModel = new AccountListAllUserDto { NickName = user.Nickname, UserId = user.Id }; returnList.Add(userModel); } return(OkResponse(returnList, "请求成功!")); }
public JsonResponse AddAccount([FromBody] AccountDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } string sql = "INSERT INTO " + dto.TableName + " VALUES "; foreach (Account model in dto.List) { //( sql += "("; //RecorderId sql += ("'" + model.RecorderId + "',"); //UserId sql += ("'" + model.UserId + "',"); //CreateDate sql += ("'" + DateTime.Now + "',"); //Money sql += ("" + model.Money + ","); //Category sql += ("'" + model.Category + "',"); //Note sql += ("'" + model.Note + "'"); //) sql += "),"; } sql = sql.Substring(0, sql.Length - 1); if (!BaseBll <Account> .ExecuteSql(sql)) { BadResponse("添加失败!"); } return(OkResponse(null, "添加成功!")); }
public JsonResponse SignIn([FromBody] SignInDto dto) { if (dto.Email == null || dto.Password == null || dto.Verify == null || dto.VerifyId == null) { return(BadResponse("参数提供不完整")); } //判断验证码是否输入正确 if (!TokenHelper.CheckVerify(dto.VerifyId, dto.Verify)) { return(BadResponse("验证码错误")); } //检查用户名密码是否正确 UserInfo model = new UserInfo(); model = UserInfoBll.GetModelByEmail(dto.Email); if (model == null) { return(BadResponse("用户不存在", null)); } //检查用户是否登录,若有登录信息则刷新时间 //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(model.Id)) { LoginState loginState = new LoginState { UserId = model.Id, StartTime = DateTime.Now }; LoginStateBll.Insert(loginState); } return(OkResponse(null)); }
public JsonResponse ChangeCategoryName([FromBody] ChangeCategoryNameDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } //获取更改者信息 var userModel = UserInfoBll.GetModelById(dto.UserId); if (userModel == null) { return(BadResponse("用户信息出错,请重试!")); } //查询使用人数 var categoryModel = AccountCategoryBll.GetModelByName(dto.OldName); if (categoryModel == null) { //此时代表数据库出问题了,应作出处理----------------------------------------------------------------- return(BadResponse("分类信息出错,请重试!")); } //若使用人数为1则直接更新名字 if (categoryModel.UserNum <= 1) { categoryModel.Name = dto.NewName; if (!AccountCategoryBll.Update(categoryModel)) { return(BadResponse("网络错误,请重试!")); } } //若有他人使用则新建一条,原条目使用人数-1,将UserInfo中的Category字段更换为新Id else { categoryModel.UserNum--; if (!AccountCategoryBll.Update(categoryModel)) { return(BadResponse("网络错误,请重试!")); } categoryModel = new AccountCategory { Name = dto.NewName, CreateUserId = dto.UserId }; if (!AccountCategoryBll.Insert(categoryModel)) { return(BadResponse("网络错误,请重试!")); } } userModel.Category = userModel.Category.Replace(dto.OldName, dto.NewName); if (!UserInfoBll.Update(userModel)) { return(BadResponse("网络错误,请重试!")); } return(OkResponse(null, "修改成功!")); }
public JsonResponse CheckLogin(string UserId) { if (!TokenHelper.CheckLoginStateByUserId(UserId)) { return(BadResponse("用户未登录", null, false)); } else { return(OkResponse(null)); } }
public JsonResponse UserAccountList([FromUri] string UserId) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(UserId)) { return(BadResponse("用户未登录", null, false)); } //获取账单列表 List <AccountList> accountList = new List <AccountList>(); accountList = AccountListBll.GetListByCreateUserId(UserId).ToList(); return(OkResponse(accountList, "请求成功!")); }
public JsonResponse AddAccountList([FromBody] AccountListDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } string accountName = "我的手账"; //若用户没有写账单名则默认为“我的手账”;若有“我的手账”则命名为“我的手账1” if (dto.Name != null && dto.Name != "") { List <AccountList> accountList = AccountListBll.GetListByCreateUserId(dto.UserId).ToList(); int flag = 1; for (int i = 0; i < accountList.Count; i++) { if (accountList[i].Name == accountName) { accountName = (accountName + flag.ToString()); flag++; } } } else { accountName = dto.Name; } //往AccountList写账单基本信息 DateTime time = DateTime.Now; AccountList model = new AccountList { AllUserId = dto.AllUserId, Code = "Z" + (time.Year - 2000).ToString() + time.Month.ToString() + time.Day.ToString() + TokenHelper.GetRandomString(3, false, true, true, false, "") + TokenHelper.GetRandomString(5, true, true, true, false, ""), CreateDate = time, CreateUserId = dto.UserId, Member = dto.AllUserId.Split(',').Length, Name = accountName }; //新建账单表 if (BaseBll <AccountList> .ExecuteSql("exec proc_CreateAccountTable '" + model.Code + "'") && AccountListBll.Insert(model)) { return(OkResponse(null, "添加成功!")); } else { return(BadResponse("添加失败!", null)); } }
public JsonResponse AddCategory([FromBody] AccountCategoryDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } //查询有没有 var model = AccountCategoryBll.GetModelByName(dto.Name); //有的话则UserNum+1 if (model != null) { model.UserNum = model.UserNum + 1; if (!AccountCategoryBll.Update(model)) { return(BadResponse("网络错误,请重试!")); } } //没有则添加 else { model = new AccountCategory { Name = dto.Name, CreateUserId = dto.UserId }; if (!AccountCategoryBll.Insert(model)) { return(BadResponse("网络错误,请重试!")); } } //将Category的Id添加到UserInfo的Category字段中 model = AccountCategoryBll.GetModelByName(dto.Name); var user = UserInfoBll.GetModelById(dto.UserId); if (user == null) { return(BadResponse("用户信息出错,请重试!")); } user.Category += (model.Name + ","); if (!UserInfoBll.Update(user)) { return(BadResponse("网络错误,请重试!")); } return(OkResponse(null, "添加成功!")); }
public JsonResponse ChangeCategoryShow([FromBody] ChangeCategoryShowDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } //将所有dto.ShowName的IsShow改为true //将所有dto.HideName的IsShow改为false //dto.ShowName->"'1','2'" var sql = "update AccountCategory set IsShow = 1 where Name in(" + dto.ShowName + ");update AccountCategory set IsShow = 0 where UserId in(" + dto.HideName + ")"; if (!AccountCategoryBll.ExecuteSql(sql)) { return(BadResponse("网络错误,请重试!")); } return(OkResponse(null, "修改成功!")); }
public JsonResponse DeleteUserCategory([FromBody] AccountCategoryDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } //查询该类别的Id var categoryModel = AccountCategoryBll.GetModelByName(dto.Name); //从UserInfo中的Category字段里删除该类别 var userModel = UserInfoBll.GetModelById(dto.UserId); if (userModel == null) { return(BadResponse("用户信息出错,请重试!")); } userModel.Category = userModel.Category.Replace((categoryModel.Name + ","), ""); if (!UserInfoBll.Update(userModel)) { return(BadResponse("网络错误,请重试!")); } if (categoryModel == null) { //此时代表数据库出问题了,应作出处理----------------------------------------------------------------- return(OkResponse(null, "删除成功!")); } //类别表中该类别使用数-1,若使用数为0则删除该类别 if (categoryModel.UserNum == 1) { AccountCategoryBll.ExecuteSql("delete from AccountCategory where Name='" + categoryModel.Name + "'"); } else { categoryModel.UserNum--; if (AccountCategoryBll.Update(categoryModel)) { return(BadResponse("网络错误,请重试!")); } } return(OkResponse(null, "删除成功!")); }
public JsonResponse ModifyPassword([FromBody] ModifyPasswordDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } if (dto.UserId == null || dto.OldPassword == null || dto.NewPassword == null || dto.Verify == null || dto.VerifyId == null) { return(BadResponse("参数提供不完整")); } //判断验证码是否输入正确 if (!TokenHelper.CheckVerify(dto.VerifyId, dto.Verify)) { return(BadResponse("验证码错误")); } UserInfo model = new UserInfo(); model = UserInfoBll.GetModelById(dto.UserId); //判断用户是否存在 if (model == null) { return(BadResponse("用户不存在")); } //新密码加密 dto.NewPassword = PasswordHelper.PwdStrToHashStr(dto.NewPassword); //判断新旧密码是否相同 if (dto.NewPassword == model.Password) { return(BadResponse("旧密码与新密码相同")); } //若不相同新密码写入数据库 model.Password = dto.NewPassword; if (!UserInfoBll.Update(model)) { return(BadResponse("网络错误,请重试")); } return(OkResponse(null, "密码修改成功")); }
public JsonResponse DeleteAccountList([FromBody] AccountListDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } //获取账单基本信息 AccountList accountListModel = new AccountList(); accountListModel = AccountListBll.GetModelByCode(dto.Code); if (accountListModel == null) { return(BadResponse("无该账单信息!", null)); } string[] userIdArray = dto.AllUserId.Split(','); if (userIdArray.Length == 1) { SystemNoticeBll.ExecuteSql("DELETE FROM AccountList WHERE Code='" + dto.Code + "';DROP TTABLE " + dto.Code); return(OkResponse(null, "账单已删除。")); } //获取账单成员并通知账单成员(写入通知表) string content = "账单:" + accountListModel.Name + "即将被账单创建者删除,请校验账单信息无资金纠纷后确认删除。"; SystemNoticeBll.ExecuteSql(SystemNoticeHelper.InsertNotice(dto.AllUserId, content)); //写入操作记录 AccountListLog log = new AccountListLog { Code = dto.Code, NewInfo = "删除账单" + accountListModel.Name, Type = LogType.Delete }; AccountListLogBll.Insert(log); //若都确认后、自动删除该表,每一个人确认时都查看此人是否为最后确认的人、若是、则直接删除账单 //否则十五天后数据库定时作业会删除该表) return(OkResponse(null, "账单已提交删除,待所有成员均已确认后账单可立即删除,若确认时间超过15日则自动删除。")); }
public JsonResponse ModifyAccountListInfo([FromBody] AccountListDto dto) { //判断用户是否登录 if (!TokenHelper.CheckLoginStateByUserId(dto.UserId)) { return(BadResponse("用户未登录", null, false)); } AccountList model = new AccountList(); model = AccountListBll.GetModelByCode(dto.Code); if (model == null) { return(BadResponse("该账单不存在", null)); } if (dto.Name != null && dto.Name != "" && dto.Name != null && dto.Name != "") { return(BadResponse("参数提供不完整", null)); } //修改名字 if (dto.Name != null && dto.Name != "") { AccountListLog log = new AccountListLog { Code = dto.Code, OldInfo = "账单名:" + model.Name, NewInfo = "账单名:" + dto.Name }; AccountListLogBll.Insert(log); model.Name = dto.Name; } if (dto.AllUserId != null && dto.AllUserId != "") { //根据AllUserId返回昵称 AccountListLog log = new AccountListLog(); log.Code = dto.Code; string sql = "proc_GetNicknameByUserId"; //Old DynamicParameters p = new DynamicParameters(); p.Add("@UserId", model.AllUserId, DbType.String); List <UserInfo> oldList = new List <UserInfo>(); oldList.AddRange(SqlHelper.QuerySP <UserInfo>(sql, p).ToList()); log.OldInfo = "账单使用人:"; foreach (UserInfo user in oldList) { log.OldInfo += (user.Nickname + ";"); } //New p = new DynamicParameters(); p.Add("@UserId", dto.AllUserId, DbType.String); List <UserInfo> newList = new List <UserInfo>(); newList.AddRange(SqlHelper.QuerySP <UserInfo>(sql, p).ToList()); log.OldInfo = "账单使用人:"; foreach (UserInfo user in newList) { log.NewInfo += (user.Nickname + ";"); } //Note //del string delName = ""; bool have = false; for (var i = 0; i < oldList.Count; i++) { have = false; for (var j = 0; j < newList.Count; j++) { if (oldList[i] == newList[j]) { have = true; break; } } if (!have) { delName += oldList[i].Nickname; } } if (delName != "") { log.Note += ("移除成员:" + delName); } //add string addName = ""; for (var i = 0; i < newList.Count; i++) { have = false; for (var j = 0; j < oldList.Count; j++) { if (newList[i] == oldList[j]) { have = true; break; } } if (!have) { addName += oldList[i].Nickname; } } if (addName != "") { log.Note += ("新增成员:" + addName); } AccountListLogBll.Insert(log); model.AllUserId = dto.AllUserId; } if (AccountListBll.Update(model)) { return(OkResponse(null, "修改成功!")); } else { return(BadResponse("修改失败!", null)); } }