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