public List <DBA.Model.CKRecord> SearchProject(Conris.DBA.ViewModel.CKRecordSearch model)
{
if (model == null)
{
return(null);
}
StringBuilder sb = new StringBuilder(" 1=1");
if (!string.IsNullOrEmpty(model.GoodsName))
{
sb.Append(" And BookName like '%" + model.GoodsName + "%'");
}
if (!string.IsNullOrEmpty(model.ISBN))
{
sb.Append(" And ISBN like '%" + model.ISBN + "%'");
}
if (!string.IsNullOrEmpty(model.GoodsZZ))
{
sb.Append(" And BookZZ like '%" + model.GoodsZZ + "%'");
}
if (!string.IsNullOrEmpty(model.StartTime))
{
sb.Append(" And Time>='" + model.StartTime + "'");
}
if (!string.IsNullOrEmpty(model.EndTime))
{
sb.Append(" And Time<='" + model.EndTime + "'");
}
sb.Append(" Order by ID Desc");
return(GetModelList(sb.ToString()));
}
public List <DBA.Model.CKRecordCount> SearchProject2(Conris.DBA.ViewModel.CKRecordSearch model)
{
if (model == null)
{
return(null);
}
StringBuilder sb = new StringBuilder(" 1=1");
if (!string.IsNullOrEmpty(model.Time))
{
sb.Append(" And Time like '%" + model.Time + "%'");
}
return(GetCountModelList(sb.ToString()));
}
public PartialViewResult CRecordSearch(Conris.DBA.ViewModel.CKRecordSearch model)
{
List <DBA.Model.CKRecord> list = bll.SearchProject(model);
double d1 = 0;
double d2 = 0;
foreach (var item in list)
{
d1 = d1 + Convert.ToDouble(item.Price);
d2 = d2 + Convert.ToDouble(item.Str2);
}
TempData["Num"] = d1;
TempData["Tol"] = d2;
return(PartialView(model));
}
public PartialViewResult CKRecordCountSearch(Conris.DBA.ViewModel.CKRecordSearch model)
{
List <DBA.Model.CKRecordCount> list = bll.SearchProject2(model);
double d1 = 0;
double d2 = 0;
foreach (var item in list)
{
d1 += Convert.ToDouble(item.SumPrice);
d2 += Convert.ToDouble(item.SumProfit);
}
TempData["SumPrice"] = d1;
TempData["SumProfit"] = d2;
return(PartialView(model));
}
public PartialViewResult CKRecordList(Conris.DBA.ViewModel.CKRecordSearch model)
{
return(PartialView(bll.SearchProject(model)));
}
public PartialViewResult CKRecordSearch(Conris.DBA.ViewModel.CKRecordSearch model)
{
return(PartialView(model));
}
public ActionResult CKRecordCountManage(Conris.DBA.ViewModel.CKRecordSearch model)
{
return(View(model));
}
