public ActionResult MyFunds(BillsSearchModel info) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int user = PageValidate.FilterParam(User.Identity.Name); Bills dal = new Bills(db); if (!RoleCheck.CheckHasAuthority(user, db, "经费管理")) { info.userId = user; } info.PageSize = 0; info.userId = user; var bills = dal.GetApplyList(info).ToList(); foreach (var bill in bills) { bill.contents = dal.getContents(bill.reimbursementCode, 0).ToList(); bill.attachmentsCount = dal.getAttachments(bill.reimbursementCode, 0).Count(); } ViewData["Bills"] = bills; List <SelectOption> options = DropDownList.RespondStateSelect(); ViewData["RState"] = DropDownList.SetDropDownList(options); return(View(info)); }
public ActionResult Responded(BillsSearchModel info) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "Index" })); } ApplyManager dal = new ApplyManager(db); int userId = PageValidate.FilterParam(User.Identity.Name); if (!RoleCheck.CheckHasAuthority(userId, db, "批复管理", "批复")) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限。" })); } if (RoleCheck.CheckHasAuthority(userId, db, "批复管理")) { if (info.userId == null) { info.userId = 0; } } else { info.userId = userId; } SetSelect(); var list = getResponseDetail((int)info.userId, 1, 2, 3, 4); ViewData["Bills"] = list; return(View(info)); }
/// <summary> /// 获取主报帐单列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public List <ApplyListModel> GetApplyList(BillsSearchModel search) { StringBuilder sql = new StringBuilder(); sql.Append("select r_add_user_id as userId,r_bill_amount as amount,reimbursement_code as reimbursementCode,r_bill_state as state,drs_state_name as strState,r_add_date as time,f_code as fundsCode,f_name as fundsName,reimbursement_info as info,"); sql.Append("(select COUNT(attachment_id) from Reimbursement_Attachment where atta_reimbursement_code=reimbursement_code) as attachmentsCount"); sql.Append(" from Reimbursements"); sql.Append(" inner join Dic_Respond_State on drs_state_id=r_bill_state"); sql.Append(" inner join Funds on f_id=r_funds_id"); sql.Append(" where 1=1"); if (search.fid != 0) { sql.Append(" and r_funds_id=").Append(search.fid); } if (search.userId != 0) { sql.Append(" and r_add_user_id=").Append(search.userId); } if (search.state != null) { sql.Append(" and r_bill_state=").Append(search.state); } if (!string.IsNullOrEmpty(search.reimbursementCode)) { sql.Append(" and reimbursement_code='").Append(search.reimbursementCode).Append("'"); } if (search.beginDate != null) { sql.Append(" and r_add_date>'").Append(((DateTime)search.beginDate).ToString()).Append("'"); } if (search.endDate != null) { sql.Append(" and r_add_date<'").Append(((DateTime)search.endDate).ToString()).Append("'"); } if (!string.IsNullOrEmpty(search.KeyWord)) { sql.Append(" and reimbursement_info like '%").Append(search.KeyWord).Append("%'"); } if (search.PageSize > 0) { return(db.Database.SqlQuery <ApplyListModel>(sql.ToString()).Skip(search.PageSize * (search.PageIndex - 1)).Take(search.PageSize).ToList()); } else { return(db.Database.SqlQuery <ApplyListModel>(sql.ToString()).ToList()); } }
// GET: FundsManager public ActionResult Index(BillsSearchModel info) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int user = PageValidate.FilterParam(User.Identity.Name); bool isAdmin = RoleCheck.CheckHasAuthority(user, db, "经费管理", "添加经费"); if (!isAdmin) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限。" })); } ApplyManager dal = new ApplyManager(db); if (info.userId != 0) { if (!RoleCheck.CheckHasAuthority(user, db, "经费管理")) { info.userId = user; } } info.PageSize = 0; //管理的经费 var mfunds = from funds in db.Funds join u in db.User_Info on funds.f_manager equals u.user_id select new mFundsListModel { manager = funds.f_manager, code = funds.f_code, amount = funds.f_amount, balance = funds.f_balance, id = funds.f_id, name = funds.f_name, managerName = u.real_name, strState = funds.f_state == 0 ? "未启用" : (funds.f_state == 1 ? "正常" : "锁定"), userCount = (from bill in db.Reimbursement where bill.r_funds_id == funds.f_id && bill.r_bill_state == 1 select bill ).Count(), applyamount = ( from bill in db.Reimbursement where bill.r_funds_id == funds.f_id && bill.r_bill_state == 1 select bill.r_fact_amount ).DefaultIfEmpty(0).Sum() }; if (info.userId > 0) { mfunds = mfunds.Where(x => x.manager == info.userId); } var list = mfunds.ToList(); foreach (var item in list) { item.managerName = Common.DEncrypt.AESEncrypt.Decrypt(item.managerName); } ViewData["Funds"] = list; List <SelectOption> options = DropDownList.FundsManagerSelect(user); ViewData["ViewUsers"] = DropDownList.SetDropDownList(options); return(View(info)); }