public ActionResult list() { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); List<User> mlist = db.getAllUser(); List<UserViewModel> obj = new List<UserViewModel>(); foreach (User u in mlist) { UserInfo ui=db.getUserInfo(u.Id); UserViewModel uv = new UserViewModel(); uv.Id = u.Id; uv.IsAdmin = u.IsAdmin; uv.RegisterTime = u.RegisterTime; uv.UserName = u.UserName; uv.Address = ui.Address; uv.Email = ui.Email; uv.Info = ui.Info; uv.Phone = ui.Phone; obj.Add(uv); } UserListViewModel viewmodel = new UserListViewModel() { list=obj }; return View(viewmodel); }
public ActionResult accountList(string tags="", string starttime="", string endtime="") { if (!isLogin()) return RedirectToAction("login", "auth"); User user=getCurrentUser(); Provider db = new Provider(); List<Account> result = new List<Account>(); tags = tags.Trim(); if (String.IsNullOrEmpty(tags)) { if (String.IsNullOrEmpty(starttime)) { result = db.getAccountsByUser(user.Id); } else { result = db.getAccountsByDate(user.Id, Convert.ToDateTime(starttime), Convert.ToDateTime(endtime)); } } else { string[] tagarray = tags.Split(new char[] { ',','|',' ' }); List<int> tagIds = new List<int>(); foreach (string s in tagarray) { try { tagIds.Add(Convert.ToInt32(s)); } catch (Exception e) { Console.WriteLine(e.Message); continue; } } List<Account> tmp = db.getAccountsByTags(tagIds); if (String.IsNullOrEmpty(starttime)) { result = tmp; } else { DateTime start=Convert.ToDateTime(starttime); DateTime end=Convert.ToDateTime(endtime); foreach (Account a in tmp) { if (a.Time >= start && a.Time <= end) result.Add(a); } } } AccountListViewModel obj = new AccountListViewModel(); obj.list=new List<AccountViewModel>(); foreach (Account r in result) { obj.list.Add(new AccountViewModel() { Id=r.Id, Info=r.Info, Money=r.Money, State=r.State, SubmitTime=r.SubmitTime, Time=r.Time, Type=r.Type, UserId=r.UserId, Tag=getTagString(db.getTagsByAccount(r.Id)) }); } return View(obj); }
public ActionResult edit(EditPasswordViewModel m) { m.Password = Global.md5(m.Password); m.Password1 = Global.md5(m.Password1); m.Password2 = Global.md5(m.Password2); if (!isLogin()) return RedirectToAction("login", "auth"); Provider db = new Provider(); if (m.Password1 != m.Password2) { ViewData["error"] = "两次密码不一样"; return View(); } User u = getCurrentUser(); if (u.Password != m.Password) { ViewData["error"] = "密码错了,再试试吧"; return View(); } u.Password = m.Password1; db.updateUser(u); UserInfo ui = new UserInfo(); ui.Id = u.Id; ui.Address = m.Address; ui.Phone = m.Phone; ui.Email = m.Email; ui.Info = m.Info; db.updateUserInfo(ui); return View("EditSuccess"); }
public static void addDefaultTag(int uid) { Provider db = new Provider(); foreach (string t in DefaultTag) { Tag tag = new Tag() { Name = t, UserId = uid, Count = 0 }; db.insertTag(tag); } }
public ActionResult edit(Note m) { try { Provider db = new Provider(); db.updateNote(m); string content = "<td>" + m.Name + "</td><td>" + m.Content + "</td><td>" + m.SubmitTime.ToString("yyyy-MM-dd") + "</td><td style='font-size:20px;'><a href='javascript:void(0)' class='btn_edit' onclick='showEditNote(" + m.Id + ")'> </a></td><td style='font-size:20px;'><a href='javascript:void(0)' class='btn_delete' onclick='showDeleteNote(" + m.Id + ")'> </a></td>"; return Content(content); } catch (Exception e) { return Content("fail" + e.Message); } }
public ActionResult delete(int id) { if (!isLogin()) return RedirectToAction("login", "auth"); Provider db = new Provider(); try { db.deleteNote(id); } catch (Exception e) { return Content("fail" + e.Message); } return Content("ok"); }
public ActionResult edit() { if (!isLogin()) return RedirectToAction("login", "auth"); Provider db = new Provider(); User u=getCurrentUser(); UserInfo userinfo=db.getUserInfo(u.Id); EditPasswordViewModel obj = new EditPasswordViewModel(); obj.Address = userinfo.Address; obj.Phone = userinfo.Phone; obj.Email = userinfo.Email; obj.Info = userinfo.Info; obj.Password = ""; obj.Password1 = ""; obj.Password2 = ""; return View(obj); }
public ActionResult add(Note m) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); m.UserId = user.Id; m.SubmitTime = DateTime.Now; Provider db = new Provider(); try { db.insertNote(m); int nid = (int)db.getDataRow("SELECT Id FROM Note ORDER BY Id DESC")["Id"]; string content = "<tr id='note_item_" + nid + "'><td>" + m.Name+ "</td><td>" +m.Content + "</td><td>" + m.SubmitTime.ToString("yyyy-MM-dd") + "</td><td style='font-size:20px;'><a href='javascript:void(0)' class='btn_edit' onclick='showEditNote(" + nid + ")'> </a></td><td style='style='font-size:20px;'><a href='javascript:void(0)' class='btn_delete' onclick='showDeleteNote(" + nid + ")'><span style='font-size:24px'> </a></td></tr>"; return Content(content); } catch (Exception e) { return Content("fail" + e.Message); } }
public ActionResult editTag(Tag tag) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); tag.UserId = user.Id; Provider db = new Provider(); try { db.updateTag(tag); db.mergeTag(tag.Id, tag.Name); } catch (Exception e) { return Content("fail" + e.Message); } return Content("ok"); }
public ActionResult list() { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); List<Note> mlist = db.getNotesByUser(user.Id); NoteListViewModel obj = new NoteListViewModel() { list = mlist }; return View(obj); }
public ActionResult login(LoginViewModel m) { if (m.Password == null || m.UserName == null) { ViewData["error"] = "没填的input伤不起"; return View(); } m.Password = Global.md5(m.Password); Provider db = new Provider(); User user = db.getUser(m.UserName); if (user == null) { ViewData["error"] = "用户名不存在,要先注册有木有!!!"; return View(); } if (user.Password != m.Password) { ViewData["error"] = "密码错了,再试试吧"; return View(); } Session["user"] = user; if (user.IsAdmin) { return RedirectToAction("index", "admin"); } return RedirectToAction("index","home"); }
public ActionResult addAccount(AccountViewModel account) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); account.SubmitTime = DateTime.Now; account.State = false; if (account.Info==null) account.Info = ""; account.UserId = user.Id; Provider db=new Provider(); db.insertAccount(account); int aid = (int)db.getDataRow("SELECT Id FROM Account ORDER BY Id DESC")["Id"]; db.deleteAccountTagByAccount(aid); string[] tmp = account.Tag.Split(new char[] { ' ', ',', ',', ' ' }); foreach (string t in tmp) { Tag tag = db.getTagsByName(t); if (tag == null) { db.insertTag(new Tag() {Name=t,Count=0, UserId=user.Id }); } db.insertAccountTag(aid, tag.Id); } string content = "<tr id='account_item_" + aid + "'><td>" + (account.Type ? "收入" : "支出") + "</td><td>" + account.Money + "</td><td>" + account.Time.ToString("yyyy-MM-dd") + "</td><td>" + account.Info + "</td><td>" + account.Tag + "</td><td style='font-size:20px;'><a href='javascript:void(0)' class='btn_edit' onclick='showEditAccount(" + aid + ")'> </a></td><td style='style='font-size:20px;'><a href='javascript:void(0)' class='btn_delete' onclick='showDeleteAccount(" + aid + ")'><span style='font-size:24px'> </a></td></tr>"; return Content(content); }
public ActionResult addAccount() { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); ViewData["TagCloud"] = db.getTagsByUser(user.Id); return View(); }
public ActionResult taglist() { if (!isLogin()) return RedirectToAction("login", "auth"); int uid = getCurrentUser().Id; Provider db = new Provider(); TagListViewModel obj = new TagListViewModel() { list=db.getTagsByUser(uid) }; return View(obj); }
public ActionResult statics(string tags="", string starttime="", string endtime="") { if (!isLogin()) return RedirectToAction("login", "auth"); User user=getCurrentUser(); Provider db = new Provider(); List<Account> result = new List<Account>(); tags = tags.Trim(); if (String.IsNullOrEmpty(tags)) { if (String.IsNullOrEmpty(starttime)) { result = db.getAccountsByUser(user.Id); } else { result = db.getAccountsByDate(user.Id, Convert.ToDateTime(starttime), Convert.ToDateTime(endtime)); } } else { string[] tagarray = tags.Split(new char[] { ',','|',' ' }); List<int> tagIds = new List<int>(); foreach (string s in tagarray) { try { tagIds.Add(Convert.ToInt32(s)); } catch (Exception e) { Console.WriteLine(e.Message); continue; } } List<Account> tmp = db.getAccountsByTags(tagIds); if (String.IsNullOrEmpty(starttime)) { result = tmp; } else { DateTime start=Convert.ToDateTime(starttime); DateTime end=Convert.ToDateTime(endtime); foreach (Account a in tmp) { if (a.Time >= start && a.Time <= end) result.Add(a); } } } double tincome = 0; double toutcome = 0; Dictionary<string, double> ttagout = new Dictionary<string, double>(); Dictionary<string, double> ttagin = new Dictionary<string, double>(); Dictionary<long, double> inchart = new Dictionary<long, double>(); Dictionary<long, double> outchart = new Dictionary<long, double>(); Dictionary<long, double> chart = new Dictionary<long, double>(); foreach (Account a in result) { if (a.Type == false) toutcome += a.Money; else tincome += a.Money; List<Tag> tlist = db.getTagsByAccount(a.Id); foreach (Tag tt in tlist) { if (!ttagin.ContainsKey(tt.Name) || !ttagout.ContainsKey(tt.Name)) { ttagin[tt.Name] = 0; ttagout[tt.Name] = 0; } if (a.Type == false) ttagout[tt.Name] += a.Money; else ttagin[tt.Name] += a.Money; } long ts = Global.getTimestamp(a.Time); if (!chart.ContainsKey(ts)) chart[ts] = 0; if (!inchart.ContainsKey(ts)) inchart[ts] = 0; if (!outchart.ContainsKey(ts)) outchart[ts] = 0; if (a.Type == false) { chart[ts] -= a.Money; inchart[ts] += a.Money; } else { chart[ts] += a.Money; outchart[ts] += a.Money; } } StaticsViewModel obj = new StaticsViewModel() { income = tincome, outcome = toutcome, tagin = ttagin, tagout = ttagout, schart = chart, ichart= inchart, ochart = outchart }; return View(obj); }
public ActionResult edit(int id) { Provider db = new Provider(); Note m = db.getNoteById(id); return View(m); }
public ActionResult editAccount(int id) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db=new Provider(); Account r=db.getAccount(id); if (user.Id != r.UserId) return View("msg", new MsgViewModel() { msg = "没有权限" }); AccountViewModel obj = new AccountViewModel() { Id = r.Id, Info = r.Info, Money = r.Money, State = r.State, SubmitTime = r.SubmitTime, Time = r.Time, Type = r.Type, UserId = r.UserId, Tag = getTagString(db.getTagsByAccount(r.Id)) }; ViewData["TagCloud"] = db.getTagsByUser(user.Id); return View(obj); }
public ActionResult addTag(Tag tag) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); tag.UserId = user.Id; tag.Count = 0; Provider db = new Provider(); try { db.insertTag(tag); } catch (Exception e) { return Content("fail" + e.Message); } tag.Id=(int)db.getDataRow("SELECT Id FROM Tag ORDER BY Id DESC")["Id"]; db.mergeTag(tag.Id, tag.Name); string content = "<li id='tag_item_+" + tag.Id + "> <span class='tag_name'>" + tag.Name + " </span><a href='javascript:void(0)' onclick='showEditTag(" + tag.Id + ")'>编辑</a> | <a href='javascript:void(0)' onclick='showDeleteTag(" + tag.Id + ")'>删除</a></li>"; return Content(content); }
public ActionResult detail(int id = 1) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); Account account = db.getAccount(id); if (account == null) return View("msg", new MsgViewModel() { msg = "出错了肿么办...页面不存在", url = "/" }); if (account.UserId != user.Id) return View("msg", new MsgViewModel() { msg = "没有权限...看别人隐私的不是好孩纸" }); return View(account); }
public ActionResult deleteTag(int id) { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); try { db.deleteAccountTagByTag(id); db.deleteTag(id); } catch (Exception e) { return Content("fail" + e.Message); } return Content("ok"); }
public ActionResult editTagList() { if (!isLogin()) return RedirectToAction("login", "auth"); User user = getCurrentUser(); Provider db = new Provider(); List<Tag> tags = db.getTagsByUser(user.Id); TagListViewModel obj = new TagListViewModel() { list = tags }; return View(obj); }
public ActionResult register(RegisterViewModel m) { if (m.UserName==null || m.Password1 == null || m.Password2 == null) { ViewData["error"] = "没填的input伤不起"; return View(); } m.Password1 = Global.md5(m.Password1); m.Password2 = Global.md5(m.Password2); Provider db = new Provider(); User user = db.getUser(m.UserName); if (user != null) { ViewData["error"] = "哎呀,此用户名已经被注册了"; return View(); } if (m.Password1 != m.Password2) { ViewData["error"] = "两次密码不一样"; return View(); } Regex emailExp = new Regex(@"^\w+@\w+(\.\w+)+(\,\w+@\w+(\.\w+)+)*$"); if (!string.IsNullOrEmpty(m.Email) && !emailExp.Match(m.Email).Success) { ViewData["error"] = "邮箱格式不正确"; return View(); } User u = new User(); u.UserName = m.UserName; u.Password = m.Password1; u.RegisterTime = DateTime.Now; db.insertUser(u); int uid = (int)db.getDataRow("SELECT Id FROM [User] ORDER BY Id DESC")["Id"]; Global.addDefaultTag(uid); UserInfo userinfo = new UserInfo(); userinfo.Id = uid; userinfo.Address = m.Address; userinfo.Email = m.Email; userinfo.Phone = m.Phone; userinfo.Info = ""; db.insertUserInfo(userinfo); return View("msg", new MsgViewModel() { msg = "注册成功", url = "/auth/login" }); }