public DemoSearchResultModel GetDemoResult(DemoSearchModel search)
{
string formatSql = @"SELECT {0} From {1} B WITH(NOLOCK)";
List<SqlParameter> Collection = new List<SqlParameter>();
Dictionary<string, string> dicParam = new Dictionary<string, string>();
dicParam.Add("BasicId", "int");
search.SelectFileds = " B.IDPlus,B.Id,B.Delstatus,B.AddTime,B.BrandName,B.IsDisplay,B.DisplayOrder ";
StringBuilder strCondictionSql = new StringBuilder(string.Format(formatSql, "B.IDPlus", "Product_Brand"));
int total = 0;
string strQuerySql = string.Format(formatSql, search.SelectFileds.Length > 0 ? search.SelectFileds : "B.*",
"Product_Brand");
strQuerySql += string.Format(" INNER JOIN @indexTabel it on it.BasicId=B.IDPlus ");
strCondictionSql.Append(" WHERE 1=1 ");
if (!string.IsNullOrWhiteSpace(search.BrandName))
{
strCondictionSql.Append("AND B.BrandName=@BrandName ");
Collection.Add(new SqlParameter("@BrandName", search.BrandName));
}
strCondictionSql.Append(" ORDER BY B.AddTime DESC ");
DataTable dt = PageSplitQuery.GeneralHighPerformancePager(strCondictionSql.ToString(), strQuerySql, dicParam, search.PageIndex, search.PageSize, ref total, Collection.ToArray());
DemoSearchResultModel model = new DemoSearchResultModel
{
TotalCount = total,
ProductBrandList = EntityUtil.ToList<Product_Brand>(dt)
};
return model;
}
public ActionResult ResultDemo2(DemoSearchModel search, int id = 0)
{
search.PageSize = 10;
search.PageIndex = (id == 0 ? 1 : id);
var model = service.GetDemoResult(search);
ViewData["TotalCount"] = model.TotalCount;
return PartialView("DemoResultView", model.ProductBrandList);
}
public DemoSearchResultModel GetDemoResult(DemoSearchModel search)
{
return new DemoDataAccess().GetDemoResult(search);
}
public JsonResult ResultDemo1(DemoSearchModel search)
{
return Json(service.GetDemoResult(search));
}