private SearchStatementModel PrepareTransportActingBillToListSearchStatement(GridCommand command, TransportActingBillSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "a", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Carrier", searchModel.Carrier, "a", ref whereStatement, param);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "a", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "a", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "a", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountTransportActingBillStatement;
searchStatementModel.SelectStatement = selectTransportActingBillStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxCalculateDetailList(GridCommand command, TransportActingBillSearchModel searchModel)
{
var actingBillList = new List<ActingBill>();
return PartialView(new GridModel(actingBillList));
}
public ActionResult _AjaxTransportActingBillList(GridCommand command, TransportActingBillSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.Carrier))
{
return PartialView(new GridModel(new List<TransportActingBill>()));
}
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "a", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Carrier", searchModel.Carrier, "a", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Type", (int)Sconit.CodeMaster.BillType.Transport, "a", ref whereStatement, param);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "a", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "a", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "a", ref whereStatement, param);
}
IList<TransportActingBill> actingBillList = genericMgr.FindAll<TransportActingBill>(string.Format(" from TransportActingBill a {0}", whereStatement), param.ToArray());
GridModel<TransportActingBill> gdList = new GridModel<TransportActingBill>();
foreach (var actingBill in actingBillList)
{
actingBill.CurrentBillAmount = actingBill.UnitPrice * (actingBill.BillQty - actingBill.BillingQty);
}
gdList.Data = actingBillList;
return PartialView(gdList);
}
public ActionResult _ReCalculateDetailList(GridCommand command, TransportActingBillSearchModel searchModel)
{
TempData["TransportActingBillSearchModel"] = searchModel;
ViewBag.Carrier = searchModel.Carrier;
ViewBag.Flow = searchModel.Flow;
ViewBag.StartTime = searchModel.StartTime;
ViewBag.EndTime = searchModel.EndTime;
// ViewBag.IncludeNoEstPrice = searchModel.IncludeNoEstPrice;
return PartialView();
}
public ActionResult _TransportActingBillList(GridCommand command, TransportActingBillSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (!string.IsNullOrEmpty(searchModel.Carrier))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SupplierCanNotBeEmpty);
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
ViewBag.Carrier = searchModel.Carrier;
ViewBag.Flow = searchModel.Flow;
ViewBag.StartTime = searchModel.StartTime;
ViewBag.EndTime = searchModel.EndTime;
return PartialView();
}
