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