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