/// <summary>
/// 获取列表
/// </summary>
public List<ConstructionSiteModel> GetList(ref PagerModel pager, string address, string cusName, string designer, string proMinister, string checker, string startDateStart, string startDateEnd, string endDateStart, string endDateEnd)
{
StringBuilder sql = new StringBuilder(string.Format(@"
select *
from Pro_ConstructionSite
where 1=1 "));
if (!string.IsNullOrWhiteSpace(address))
{
sql.AppendFormat(" and Address like '%{0}%'", address);
}
if (!string.IsNullOrWhiteSpace(cusName))
{
sql.AppendFormat(" and CusName like '%{0}%'", cusName);
}
if (!string.IsNullOrWhiteSpace(designer))
{
sql.AppendFormat(" and Designer like '%{0}%'", designer);
}
if (!string.IsNullOrWhiteSpace(proMinister))
{
sql.AppendFormat(" and ProMinister like '%{0}%'", proMinister);
}
if (!string.IsNullOrWhiteSpace(checker))
{
sql.AppendFormat(" and Checker like '%{0}%'", checker);
}
if (!string.IsNullOrWhiteSpace(startDateStart))
{
sql.AppendFormat(" and StartDate >= '{0}'", startDateStart);
}
if (!string.IsNullOrWhiteSpace(startDateEnd))
{
sql.AppendFormat(" and StartDate <= '{0}'", startDateEnd);
}
if (!string.IsNullOrWhiteSpace(endDateStart))
{
sql.AppendFormat(" and EndDate >= '{0}'", endDateStart);
}
if (!string.IsNullOrWhiteSpace(endDateEnd))
{
sql.AppendFormat(" and EndDate <= '{0}'", endDateEnd);
}
string orderby = string.Format("order by {0} {1}", pager.sort, pager.order);
PagerModel pagerModel = sqliteHelper.FindPageBySql<ConstructionSiteModel>(sql.ToString(), orderby, pager.rows, pager.page);
pager.totalRows = pagerModel.totalRows;
pager.result = pagerModel.result;
return pagerModel.result as List<ConstructionSiteModel>;
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetList(PagerModel pager, string address, string cusName, string designer, string proMinister, string checker, string startDateStart, string startDateEnd, string endDateStart, string endDateEnd)
{
constructionSiteDal.GetList(ref pager, address, cusName, designer, proMinister, checker, startDateStart, startDateEnd, endDateStart, endDateEnd);
var json = new
{
total = pager.totalRows,
rows = pager.result as List<ConstructionSiteModel>
};
return Json(json, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetList(PagerModel pager, string startDate, string endDate, string address, string designer, string adviser, string follower)
{
followDal.GetList(ref pager, startDate, endDate, address, designer, adviser, follower);
var json = new
{
total = pager.totalRows,
rows = pager.result as List<FollowModel>
};
return Json(json, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetList(PagerModel pager)
{
roleDal.GetList(ref pager);
var json = new
{
total = pager.totalRows,
rows = pager.result as List<RoleModel>
};
return Json(json, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 获取集合
/// </summary>
public List<RoleModel> GetList(ref PagerModel pager)
{
StringBuilder sql = new StringBuilder(string.Format(@"
select role.*
from Sys_Role role
where 1=1 "));
string orderby = string.Format("order by {0} {1}", pager.sort, pager.order);
PagerModel pagerModel = sqliteHelper.FindPageBySql<RoleModel>(sql.ToString(), orderby, pager.rows, pager.page);
pager.totalRows = pagerModel.totalRows;
pager.result = pagerModel.result;
return pagerModel.result as List<RoleModel>;
}
/// <summary>
/// 获取列表
/// </summary>
public List<FollowModel> GetList(ref PagerModel pager, string startDate, string endDate, string address, string designer, string adviser, string follower)
{
StringBuilder sql = new StringBuilder(string.Format(@"
select *
from Pro_Follow
where 1=1 "));
if (!string.IsNullOrWhiteSpace(startDate))
{
sql.AppendFormat(" and FollowDate >= '{0}'", startDate);
}
if (!string.IsNullOrWhiteSpace(endDate))
{
sql.AppendFormat(" and FollowDate <= '{0}'", endDate);
}
if (!string.IsNullOrWhiteSpace(address))
{
sql.AppendFormat(" and Address like '%{0}%'", address);
}
if (!string.IsNullOrWhiteSpace(designer))
{
sql.AppendFormat(" and Designer like '%{0}%'", designer);
}
if (!string.IsNullOrWhiteSpace(adviser))
{
sql.AppendFormat(" and Adviser like '%{0}%'", adviser);
}
if (!string.IsNullOrWhiteSpace(follower))
{
sql.AppendFormat(" and Follower like '%{0}%'", follower);
}
string orderby = string.Format("order by {0} {1}", pager.sort, pager.order);
PagerModel pagerModel = sqliteHelper.FindPageBySql<FollowModel>(sql.ToString(), orderby, pager.rows, pager.page);
pager.totalRows = pagerModel.totalRows;
pager.result = pagerModel.result;
return pagerModel.result as List<FollowModel>;
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetList(PagerModel pager, string billCode, string startDate, string endDate, string cusName, string proMinister, string address)
{
constructDal.GetList(ref pager, billCode, startDate, endDate, cusName, proMinister, address);
var json = new
{
total = pager.totalRows,
rows = pager.result as List<ConstructModel>
};
return Json(json, JsonRequestBehavior.AllowGet);
}
