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