public ActionResult ArticleSearch( string name = null, string otherside = null, double?minmoney = null, double?maxmoney = null, string number = null, string year = null, string city = null, string town = null, string projecttype = null, string state = null, string payCompany = null, int page = 1) { var parameter = new ArticleParameter { Name = name, OtherSide = otherside, MinMoney = minmoney, MaxMoney = maxmoney, Number = number, Year = year, City = city, Town = town, ProjectType = projecttype, PayCompany = payCompany, Page = new PageParameter(page, 20) }; if (!string.IsNullOrEmpty(state)) { parameter.State = EnumHelper.GetEnum <ArticleState>(state); } ViewBag.List = Core.ArticleManager.Search2(parameter); ViewBag.Parameter = parameter; ViewBag.Page = parameter.Page; return(View()); }
/// <summary> /// 作用:下载项目洽谈表格 /// 作者:汪建龙 /// 编写时间:2017年1月16日19:53:26 /// </summary> /// <param name="name"></param> /// <param name="otherside"></param> /// <param name="minmoney"></param> /// <param name="maxmoney"></param> /// <param name="number"></param> /// <param name="year"></param> /// <param name="city"></param> /// <param name="town"></param> /// <param name="projecttype"></param> /// <param name="state"></param> /// <param name="payCompany"></param> /// <returns></returns> public ActionResult DownloadArticle( string name = null, string otherside = null, double?minmoney = null, double?maxmoney = null, string number = null, string year = null, string city = null, string town = null, string projecttype = null, string state = null, string payCompany = null) { var parameter = new ArticleParameter { Name = name, OtherSide = otherside, MinMoney = minmoney, MaxMoney = maxmoney, Number = number, Year = year, City = city, Town = town, ProjectType = projecttype, PayCompany = payCompany }; if (!string.IsNullOrEmpty(state)) { parameter.State = EnumHelper.GetEnum <ArticleState>(state); } var list = Core.ArticleManager.Search2(parameter); var workbook = ExcelManager.DownloadArticleWorkbook(list); if (workbook != null) { byte[] fileContents = ExcelManager.Translate(workbook); return(File(fileContents, "application/ms-excel", string.Format("项目洽谈统计表-{0}.xls", DateTime.Now.ToLongDateString()))); } return(Content("内部服务器错误!")); }
public ArticlePresenter(IArticleView view, Domain.Module module, IUnitOfWork work) { this.view = view; this.module = module; this.work = work; parameter = ParameterBuilder.Deserialize <ArticleParameter>(this.module.Parameter); }
public List <ArticleView> Search2(ArticleParameter parameter) { using (var db = GetDbContext()) { var query = db.Article_Views.AsQueryable(); if (parameter.Deleted.HasValue) { query = query.Where(e => e.Deleted == parameter.Deleted.Value); } if (parameter.State.HasValue) { query = query.Where(e => e.State == parameter.State.Value); } if (!string.IsNullOrEmpty(parameter.Number)) { query = query.Where(e => e.Number.Contains(parameter.Number)); } if (!string.IsNullOrEmpty(parameter.Year)) { query = query.Where(e => e.Year.Contains(parameter.Year)); } if (!string.IsNullOrEmpty(parameter.Town)) { query = query.Where(e => e.Town.Contains(parameter.Town)); } if (!string.IsNullOrEmpty(parameter.Name)) { query = query.Where(e => e.Name.Contains(parameter.Name)); } if (!string.IsNullOrEmpty(parameter.OtherSide)) { query = query.Where(e => e.OtherSide.Contains(parameter.OtherSide)); } if (!string.IsNullOrEmpty(parameter.City)) { query = query.Where(e => e.CName.Contains(parameter.City)); } if (!string.IsNullOrEmpty(parameter.ProjectType)) { query = query.Where(e => e.PName.Contains(parameter.ProjectType)); } if (parameter.MinMoney.HasValue) { query = query.Where(e => e.Money >= parameter.MinMoney.Value); } if (parameter.MaxMoney.HasValue) { query = query.Where(e => e.Money <= parameter.MaxMoney.Value); } query = query.OrderBy(e => e.ID).SetPage(parameter.Page); return(query.ToList()); } }
public ActionResult GetJsonArticle(string name = null, string otherside = null, double?minmoney = null, double?maxmoney = null) { var parameter = new ArticleParameter() { Name = name, OtherSide = otherside, MinMoney = minmoney, MaxMoney = maxmoney }; var list = Core.ArticleManager.Search(parameter); return(Json(list, JsonRequestBehavior.AllowGet)); }
protected void Page_Load(object sender, EventArgs e) { Response.Write("HALLLO"); var work = new Data.UnitOfWork(); var module1 = work.ModuleRepository.GetById(1); var article1 = new Domain.Article() { Text = "Hallo World!", CreatedAt = DateTime.Now, CreatedById = 1, Heading = "Test Heading" }; article1.Id = work.ArticleRepository.Save(article1); var par1 = new ArticleParameter() { ArticleId = article1.Id }; module1.Parameter = Code.ModuleParameters.ParameterBuilder.Serialize(par1); module1.Id = work.ModuleRepository.Save(module1); var module2 = work.ModuleRepository.GetById(2); var article2 = new Domain.Article() { Text = "Zweiter Artikel!", Heading = "Zweiter", CreatedById = 1, CreatedAt = DateTime.Now }; article2.Id = work.ArticleRepository.Save(article2); var par2 = new ArticleParameter() { ArticleId = article2.Id }; module2.Parameter = Code.ModuleParameters.ParameterBuilder.Serialize(par2); module2.Id = work.ModuleRepository.Save(module2); }