public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_a = db.T_InfoManage; var t_s = db.T_SourceFile; var model = (from a in t_a where a.ID == id select new InfoManageModel { AddTime = a.AddTime, Title = a.Title, ID = a.ID, DeptId = a.DeptId, Desc = a.Desc, State = a.State, LinkUrl = a.LinkUrl, Contact = a.Contact, Phone = a.Phone, Type = a.Type, SourceFileList = t_s.Where(x => x.Guid == a.Guid).ToList() }).SingleOrDefault(); return View(model); } }
// // GET: /Product/ public ActionResult Index(int page = 1, int pageSize =9) { var list = Task.Factory.StartNew<IPagedList<ProductModel>>(() => { using (LoveBankDBContext db = new LoveBankDBContext()) { return GetProduct(page, pageSize); } }); var listHot = Task.Factory.StartNew<List<ProductModel>>(() => { using (LoveBankDBContext db = new LoveBankDBContext()) { return GetHotExchangProduct(page, 3); } }); Task.WaitAll(list,listHot); LoveProductModel model = new LoveProductModel(); model.ProductList = list.Result; model.ProductListHot = listHot.Result; return View(model); }
private List<ProductModel> GetHotExchangProduct(int page = 1, int pageSize = 8) { using (LoveBankDBContext db = new LoveBankDBContext()) { var tp = db.T_Product; var tpe = db.T_LoveBankProductExchangeLog; var t_s = db.T_SourceFile; var list = from pe in tpe join p in tp on pe.LoveBankProductId equals p.ID where p.DeptId == BaseWebSiteConifg.DeptId && p.State != RowState.删除 select new ProductModel { CostScore = p.CostScore, DeptId = p.DeptId, Id = p.ID, Name = p.Name, Price = p.Price, State = p.State, ProductPic = (from s in t_s where s.Guid == p.Guid select new ImgUrlModel { ImgHttpUrl = s.Domain + s.Path }).ToList() }; return list.OrderByDescending(x => x.Id).ToPagedList(page-1, pageSize).ToList(); } }
/// <summary> /// App登录 /// </summary> /// <param name="phone"></param> /// <param name="passWord"></param> /// <returns></returns> public ActionResult AppLogin(string phone,string passWord) { JsonMessage returnJson = new JsonMessage(); using (LoveBankDBContext db = new LoveBankDBContext()) { var t_a = db.T_AppUser; string passWordHash = passWord.Hash(); AppUser appUser = db.T_AppUser.Where(x => x.Phone == phone && x.PassWord == passWordHash).FirstOrDefault(); if (appUser != null) { returnJson.Status = true; appUser.PassWord = string.Empty; returnJson.Data = new { Ticket = AutheTicketManager.CreateAppLoginUserTicket(appUser.ID.ToString()), User=appUser }; returnJson.Info = "登录成功"; return Json(returnJson); } } returnJson.Status = false; returnJson.Info = "登录失败,系统异常"; returnJson.Data = HttpContext.Error; return Json(returnJson); }
public ActionResult AdminApply(int id, int state, string msg) { using (LoveBankDBContext db = new LoveBankDBContext()) { Supervise model = db.T_Supervise.Find(id); var vol = db.T_Vol; Vol vEntity = vol.Find(model.AddUser); if (model.State != SuperviseRowState.已回复) { vEntity.LoveBankScore = vEntity.LoveBankScore + 5; db.Update<Vol>(vEntity); db.SaveChanges(); } model.Msg = msg.Trim(); model.State = (SuperviseRowState)state; db.Update<Supervise>(model); db.SaveChanges(); #region 发送通知信息 //短信通知 //string failMsg = "【社区1+1】您于" + model.AddTime.ToString("yyyy-MM-dd HH:mm") + "投诉的:" + model.Content + ".管理员处理,处理意见是:" + msg; SMSComm.Send(vEntity.Phone, "【社区1+1】您于" + model.AddTime.ToString("yyyy-MM-dd HH:mm") + "反映的问题我们将尽快核实处理,感谢您的参与."); //App 推送通知待完善 #endregion } return Success("操作成功"); }
public ActionResult Index(int? page, int? pageSize) { var pageNumber = page ?? 1; var size = pageSize ?? PageSize; using (LoveBankDBContext db = new LoveBankDBContext()) { var ad = db.T_LoveBank_Ad; var t_d = db.T_Department; var list = from a in ad select new LoveBank_AdModel { AddTime = a.AddTime, Title = a.Title, ID = a.ID, DeptId = a.DeptId, Desc = a.Desc, State = a.State, LinkUrl = a.LinkUrl, Postion = a.Postion, }; list = list.Where(x => x.State != RowState.删除); return View(list.OrderByDescending(x => x.ID).ToPagedList(pageNumber - 1, size)); } }
public ActionResult AppPostAddSuggestion(Suggestion entity) { JsonMessage retJson = new JsonMessage(); using (LoveBankDBContext db = new LoveBankDBContext()) { if (entity.AddUser>0) { var addUserModel = (from v in db.T_Vol where v.ID == entity.AddUser select new { v.DepId, v.Phone, v.RealName }).FirstOrDefault(); entity.DepId = addUserModel.DepId; entity.AddUserName = addUserModel.RealName; entity.AddUserPhone = addUserModel.Phone; } entity.AddTime = DateTime.Now; db.Add<Suggestion>(entity); db.SaveChanges(); retJson.Status = true; retJson.Info = "新增成功"; } return Json(retJson); }
/// <summary> /// 必传参数 /// AppUserId/ /// SeekHelperId/ /// Money:捐助的金额 /// BankCard:支付卡号 /// Desc:捐赠寄语 /// </summary> /// <param name="entity"></param> /// <returns></returns> public ActionResult AppPostHelperMoney(SeekHelperRecorde entity) { JsonMessage ret = new JsonMessage(); entity.AddTime = DateTime.Now; using (LoveBankDBContext db = new LoveBankDBContext()) { var t_a = db.T_SeekHelper; var t_sr = db.T_SeekHelperRecorde; var t_u = db.T_AppUser; ; //SeekHelper sh = t_a.Find(entity.SeekHelperId); AppUser au = t_u.Find(entity.AppUserId); entity.Name = au.Name; entity.Phone = au.Phone; entity.AppUserType = au.Type; db.Add(entity); db.SaveChanges(); ret.Status = true; ret.Info = "捐助成功"; return Json(ret); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_a = db.T_LBStartOrBottomAd; var t_s = db.T_SourceFile; var t_d = db.T_Department; var model = (from a in t_a join d in t_d on a.DeptId equals d.Id where a.ID == id select new LBStartOrBottomAdModel { AddTime = a.AddTime, Department = d, Title = a.Title, ID = a.ID, DeptId = a.DeptId, Desc = a.Desc, State = a.State, Postion=a.Postion, LinkUrl = a.LinkUrl, SourceFileList = t_s.Where(x => x.Guid == a.Guid).ToList() }).SingleOrDefault(); var list = t_d.Where(x => x.Level <= 6).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); return View(model); } }
public ActionResult AppPostTSAdd(Supervise entity) { JsonMessage retJson = new JsonMessage(); try { using (LoveBankDBContext db = new LoveBankDBContext()) { entity.AddTime = DateTime.Now; db.Add(entity); db.SaveChanges(); retJson.Status = true; retJson.Info = "新增成功"; } return Json(retJson); } catch (Exception ex) { retJson.Status = false; retJson.Data = ex.Message + ex.TargetSite; return Json(retJson); } }
public ActionResult AppView(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { Notice notice = db.T_Notice.Find(id); return Json(notice); } }
public ActionResult AppView(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { WorkGuide work = db.T_WorkGuide.Find(id); return Json(work); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var dep = db.T_Department; var grid = db.T_GridMember; var glist =( from g in grid //join d in dep on g.VDeptId equals d.Id where g.Id==id select new GridMemberModel { Desc = g.Desc, VDeptId = g.VDeptId, GridNo = g.GridNo, GridPhone = g.GridPhone, GridName = g.GridName, GridHeaderImg = g.GridHeaderImg, DeptId = g.DeptId, Id = g.Id }).FirstOrDefault(); //glist.VDeptName = dep.Where(x => glist.VDeptId.IndexOf(x.Id+",") > -1).FirstOrDefault().Name; var depNameList = (from d in dep where d.PId.IndexOf(AdminUser.DeptId) > -1 select d).ToList(); if (glist != null && !string.IsNullOrEmpty(glist.VDeptId)) { foreach (var item2 in glist.VDeptId.Split(',')) { string tmp = (depNameList.FirstOrDefault(x => x.Id == item2) ?? new Department()).Name; if (!string.IsNullOrEmpty(tmp)) { glist.VDeptName += tmp + ","; } } } #region //恢复图片数组 SourceFile sf = new SourceFile(); sf.Id = glist.Id+DateTime.Now.Millisecond; Uri uri = new Uri(glist.GridHeaderImg); sf.Domain =uri.Scheme+ "://"+uri.Authority; sf.Path = uri.LocalPath; sf.FileName = uri.Segments[3]; glist.SourceFileList = new List<SourceFile>(); glist.SourceFileList.Add(sf); #endregion //获取当前登录用户下的小区信息 var list = db.T_Department.AsQueryable<Department>().Where(x => x.Level == 7 && x.PId == AdminUser.DeptId).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); return View(glist); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_ConvenienceServices; ConvenienceServices model = t_wsn.Find(id); return View(model); } }
public ActionResult Delete(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { AdminUser user = db.T_AdminUser.Find(id); db.Delete<AdminUser>(user); db.SaveChanges(); return Success("操作成功"); } }
public ActionResult Add() { using (LoveBankDBContext db = new LoveBankDBContext()) { var list = db.T_Department.AsQueryable<Department>().Where(x => x.Level <= 6).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); } return View(); }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_LoveFund; LoveFund model = t_wsn.Find(id); return View(model); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_CServiceCenterInfo; CServiceCenterInfo model = t_wsn.Find(id); return View(model); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_IncomeAndPayDetail; IncomeAndPayDetail model = t_wsn.Find(id); return View(model); } }
public ActionResult Edit(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_WebSitNotice; WebSitNotice model = t_wsn.Find(id); return View(model); } }
public ActionResult Add() { using (LoveBankDBContext db = new LoveBankDBContext()) { //获取当前登录用户下的小区信息 var list = db.T_Department.AsQueryable<Department>().Where(x => x.Level == 7 && x.PId == AdminUser.DeptId).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); } return View(); }
public ActionResult Delete(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { AppVer img = db.T_AppVer.Find(id); db.Delete<AppVer>(img); db.SaveChanges(); db.Dispose(); return Success("操作成功"); } }
public ActionResult Delete(int id) { using (LoveBankDBContext db = new LoveBankDBContext()) { Notice notice = db.T_Notice.Find(id); db.Delete<Notice>(notice); db.SaveChanges(); db.Dispose(); return Success("操作成功"); } }
public ActionResult Add() { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_d = db.T_Department; ////部门组织 var list = t_d.Where(x =>x.Id.Contains("851")&& x.Level>=3 &&x.Level <= 4).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); return View(); } }
public ActionResult ChangeStateAdImg(int id, int state) { using (LoveBankDBContext db = new LoveBankDBContext()) { AppVer img = db.T_AppVer.Find(id); img.State = state; db.Update<AppVer>(img); db.SaveChanges(); db.Dispose(); return Success("操作成功"); } }
public ActionResult Index(int? page, int? pageSize) { var pageNumber = page ?? 1; var size = pageSize ?? PageSize; using (LoveBankDBContext db = new LoveBankDBContext()) { var app = db.T_AppVer; var list = from a in app select a; return View(list.OrderByDescending(x => x.Id).ToPagedList(pageNumber - 1, size)); } }
public ActionResult Add() { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_a = db.T_LBStartOrBottomAd; var t_s = db.T_SourceFile; var t_d = db.T_Department; var list = t_d.Where(x => x.Level <= 6).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); } return View(); }
public ActionResult AddTeamProjectStation() { using (LoveBankDBContext db = new LoveBankDBContext()) { var dep = db.T_Department; //部门组织 //var list = DbProvider.D<Department>().Where(x => x.Level <= 6).ToList(); var list = dep.Where(x => x.Level <= 6).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); return View(); } }
public ActionResult Edit() { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_wsn = db.T_UnitInfoAbout; UnitInfoAbout model = (from w in t_wsn where w.DeptId == AdminUser.DeptId select w).FirstOrDefault(); if (model==null) { model = new UnitInfoAbout(); } return View(model); } }
public ActionResult AddDetail(int unionHelpPojectID) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_d = db.T_Department; var t_u = db.T_UnionHelpPoject; UnionHelpPoject model = t_u.Find(unionHelpPojectID); ////部门组织 var list = t_d.Where(x => x.Id.Contains("851") && x.Level >= 3 && x.Level <= 4).ToList(); ViewData["Department_List"] = HelpSerializer.JSONSerialize<List<Department>>(list); return PartialView(model); } }