public void SavePassword(String UName, String newPassword) { FinancialERPDAL db = new FinancialERPDAL(); User tmp = new User(); var user = from m in db.Users select m; user = user.Where(s => s.UName.Equals(UName)); tmp = user.SingleOrDefault <User>(); tmp.UPassword = newPassword; db.SaveChanges(); }
/* 查询类型(收入、支出) */ // 获取类名 public String SearchType(int TID) { FinancialERPDAL db = new FinancialERPDAL(); Genre g = new Genre(); var genres = from m in db.Genres select m; if (TID != 0) { genres = genres.Where(s => s.GenreID == TID); } g = genres.First <Genre>(); return(g.Gname); }
// 获取类ID public int SearchType(String type) { FinancialERPDAL db = new FinancialERPDAL(); Genre g = new Genre(); var genres = from m in db.Genres select m; if (!String.IsNullOrEmpty(type)) { genres = genres.Where(s => s.Gname.Contains(type)); } g = genres.First <Genre>(); return(g.GenreID); }
/* 查询分类(通讯费、餐费等) */ // 获取分类名 public String SearchClass(int CID) { FinancialERPDAL db = new FinancialERPDAL(); Classes c = new Classes(); var tclasses = from m in db.TClasses select m; if (CID != 0) { tclasses = tclasses.Where(s => s.ClassesID == CID); } c = tclasses.First <Classes>(); return(c.Cname); }
// 获取分类ID public int SearchClass(String classes) { FinancialERPDAL db = new FinancialERPDAL(); Classes c = new Classes(); var tclasses = from m in db.TClasses select m; if (!String.IsNullOrEmpty(classes)) { tclasses = tclasses.Where(s => s.Cname.Contains(classes)); } c = tclasses.First <Classes>(); return(c.ClassesID); }
/* 获取、查询账单目录 */ // 通过用户ID查询目录 public List <Account> SearchList(int UID) { FinancialERPDAL db = new FinancialERPDAL(); var accounts = from m in db.Accounts select m; if (UID != 0) { accounts = accounts.Where(s => s.UserID == UID); accounts = accounts.OrderByDescending(m => m.AccountID).OrderByDescending(s => s.Date); } return(accounts.ToList <Account>()); }
public String GetUPhone(string searchString) { FinancialERPDAL db = new FinancialERPDAL(); User u = new User(); var users = from m in db.Users select m; if (!String.IsNullOrEmpty(searchString)) { users = users.Where(s => s.UName.Equals(searchString)); } u = users.FirstOrDefault <User>(); return(u.UPhone); }
public Admin SearchAdmin(string searchString) { FinancialERPDAL db = new FinancialERPDAL(); Admin a = new Admin(); var admins = from m in db.Admins select m; if (!String.IsNullOrEmpty(searchString)) { admins = admins.Where(s => s.Aname.Equals(searchString)); } a = admins.FirstOrDefault <Admin>(); return(a); }
public List <Borrow> GetFinishBorrowList(int UID) { FinancialERPDAL db = new FinancialERPDAL(); var borrows = from m in db.Borrows select m; if (UID != 0) { borrows = borrows.Where(s => s.UserID == UID); borrows = borrows.Where(s => s.BFinish == true); borrows = borrows.OrderBy(s => s.BNextRepay); } return(borrows.ToList <Borrow>()); }
public void ChangeItemState(Borrow b) { FinancialERPDAL db = new FinancialERPDAL(); Borrow tmp = new Borrow(); tmp = (from m in db.Borrows where m.BorrowID == b.BorrowID select m).Single <Borrow>(); tmp.BNextRepay = b.BNextRepay; tmp.BHavePay = b.BHavePay; tmp.BFinish = b.BFinish; db.SaveChanges(); }
// 搜索借贷信息 public List <Borrow> SearchBorrowList(String SearchKey, Boolean fin) { FinancialERPDAL db = new FinancialERPDAL(); var borrows = from m in db.Borrows select m; if (!String.IsNullOrEmpty(SearchKey)) { borrows = borrows.Where(s => s.BTitle.Contains(SearchKey)); borrows = borrows.Where(s => s.BFinish == fin); borrows = borrows.OrderBy(s => s.BNextRepay); } return(borrows.ToList <Borrow>()); }
// 查询今日收支情况 public List <AccountInOut> GetTodayInOut(int UID, DateTime today) { FinancialERPDAL db = new FinancialERPDAL(); List <AccountInOut> ag = new List <AccountInOut>(); // 初始化 for (int i = 1; i <= 2; i++) { AccountInOut t = new AccountInOut(); t.GenreID = i; t.Money = 0M; ag.Add(t); } var accounts = from m in db.Accounts select m; if (UID != 0) { accounts = accounts.Where(s => s.UserID == UID); accounts = accounts.Where(s => s.Date == today); } if (accounts.ToList <Account>().Count == 0) { return(ag); } var query = from l in accounts group l by new { l.GenreID } into g select new { GID = g.Key.GenreID, Money = g.Sum(a => a.Money) }; foreach (var q in query) { if (q.GID == 1) { ag[0].Money = q.Money; } else { ag[1].Money = q.Money; } } return(ag); }
public int GetTitle(String Tname) { FinancialERPDAL db = new FinancialERPDAL(); var titles = from m in db.Titles select m; if (!String.IsNullOrEmpty(Tname)) { titles = titles.Where(s => s.TName.Equals(Tname)); } Title t = titles.FirstOrDefault <Title>(); return(t.TitleID); }
public String GetUPassword(int UID) { FinancialERPDAL db = new FinancialERPDAL(); var users = from m in db.Users select m; User u = new User(); if (UID != 0) { users = users.Where(s => s.UserID == UID); } u = users.FirstOrDefault <User>(); return(u.UPassword); }
public String GetTitle(int TID) { FinancialERPDAL db = new FinancialERPDAL(); var titles = from m in db.Titles select m; if (TID != 0) { titles = titles.Where(s => s.TitleID == TID); } Title t = titles.FirstOrDefault <Title>(); return(t.TName); }
public void EditItem(Account a) { FinancialERPDAL db = new FinancialERPDAL(); Account tmp = new Account(); tmp = (from m in db.Accounts where m.AccountID == a.AccountID select m).Single <Account>(); tmp.GenreID = a.GenreID; tmp.ClassesID = a.ClassesID; tmp.Money = a.Money; tmp.Date = a.Date; tmp.Remark = a.Remark; db.SaveChanges(); }
public Boolean DeleteTitle(int TID) { FinancialERPDAL db = new FinancialERPDAL(); var contentions = db.Contentions.Where(m => m.TitleID == TID); var titles = db.Titles.SingleOrDefault(m => m.TitleID == TID); if (contentions != null) { foreach (var item in contentions) { db.Contentions.Remove(item); } db.Titles.Remove(titles); db.SaveChanges(); return(true); } return(false); }
public void EditItem(Borrow b) { FinancialERPDAL db = new FinancialERPDAL(); Borrow tmp = new Borrow(); tmp = (from m in db.Borrows where m.BorrowID == b.BorrowID select m).Single <Borrow>(); tmp.BTitle = b.BTitle; tmp.BTotal = b.BTotal; tmp.BMonthShouldPay = b.BMonthShouldPay; tmp.BNextRepay = b.BNextRepay; tmp.BShouldPay = b.BShouldPay; tmp.BHavePay = b.BHavePay; tmp.BRemark = b.BRemark; tmp.BFinish = b.BFinish; db.SaveChanges(); }
public int GetPostingAmount(int UID) { FinancialERPDAL db = new FinancialERPDAL(); int num = 0; var contentions = from m in db.Contentions select m; if (UID != 0) { contentions = contentions.Where(s => s.UserID == UID); } if (contentions.ToList <Contention>().Count == 0) { return(0); } num = contentions.ToList <Contention>().Count; return(num); }
public ActionResult SaveApply(Apply a, String BtnSubmit) { switch (BtnSubmit) { case "保存": FinancialERPDAL db = new FinancialERPDAL(); string s = System.Web.HttpContext.Current.Session["UserID"].ToString(); int UID = int.Parse(s); a.ApplyDate = DateTime.Now; a.IsDeal = false; a.UserID = UID; db.Applys.Add(a); db.SaveChanges(); ViewData["Message"] = "提交成功!"; return(RedirectToAction("Title")); case "取消": return(RedirectToAction("Title")); } return(new EmptyResult()); }
public void ChangeState(int id, Boolean state) { FinancialERPDAL db = new FinancialERPDAL(); Apply apply = (from m in db.Applys where m.ApplyID == id select m).Single <Apply>(); apply.IsDeal = true; string s = System.Web.HttpContext.Current.Session["UserID"].ToString(); Diary d = new Diary(); d.AdminID = int.Parse(s); d.ApplyID = id; d.DiaryDate = DateTime.Now; if (state) { User user = (from n in db.Users where n.UserID == apply.UserID select n).Single <User>(); user.UAuthority = true; d.ApplyState = "批准"; Operate o = new Operate(); o.AdminID = d.AdminID; o.OperateDate = d.DiaryDate; o.UserID = id; o.OperateState = "授权"; db.Operates.Add(o); } else { d.ApplyState = "驳回"; } db.Diaries.Add(d); db.SaveChanges(); }
// 通过日期范围查询目录 public List <Account> SearchList(int UID, DateTime date1, DateTime date2) { FinancialERPDAL db = new FinancialERPDAL(); var accounts = from m in db.Accounts select m; if (UID != 0) { accounts = accounts.Where(s => s.UserID == UID); accounts = accounts.OrderByDescending(m => m.AccountID).OrderByDescending(s => s.Date); } if (date1 != DateTime.MinValue) { accounts = accounts.Where(s => s.Date >= date1); } if (date1 < date2) { accounts = accounts.Where(s => s.Date <= date2); } return(accounts.ToList <Account>()); }
/* 获取类别列表 */ public List <Genre> GetTypeList() { FinancialERPDAL db = new FinancialERPDAL(); return(db.Genres.ToList <Genre>()); }