public ActionResult _AjaxList(GridCommand command, BillMasterSearchModel searchModel)
{
this.GetCommand(ref command, searchModel);
if (!this.CheckSearchModelIsNull(searchModel))
{
return PartialView(new GridModel(new List<BillMaster>()));
}
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<BillMaster>(searchStatementModel, command));
}
public ActionResult List(GridCommand command, BillMasterSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (this.CheckSearchModelIsNull(searchCacheModel.SearchObject))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.SYS.ErrorMessage.Errors_NoConditions);
}
if (searchCacheModel.isBack == true)
{
ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page;
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public void ExportXLSSearch(BillMasterSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value;
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
IList<BillMaster> actingBillLists = GetAjaxPageData<BillMaster>(searchStatementModel, command).Data.ToList();
ExportToXLS<BillMaster>("SaleBillSearch.xls", actingBillLists);
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, BillMasterSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
SecurityHelper.AddBillPermissionStatement(ref whereStatement, "b", "Party", com.Sconit.CodeMaster.BillType.Distribution);
HqlStatementHelper.AddLikeStatement("ExternalBillNo", searchModel.ExternalBillNo, HqlStatementHelper.LikeMatchMode.Start, "b", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("BillNo", searchModel.BillNo, HqlStatementHelper.LikeMatchMode.Start, "b", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "b", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "b", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Type", (int)Sconit.CodeMaster.BillType.Distribution, "b", ref whereStatement, param);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "b", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "b", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "b", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by b.CreateDate desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public void ExportXLSBillNotice(BillMasterSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value;
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<BillMaster> gridModel = GetAjaxPageData<BillMaster>(searchStatementModel, command);
List<BillMaster> BillMasterLists = new List<BillMaster>();
if (this.CheckSearchModelIsNull(searchModel))
{
foreach (BillMaster BillMasterList in gridModel.Data)
{
BillMasterLists.Add(BillMasterList);
}
}
ExportToXLS<BillMaster>("BillNotice.xls", BillMasterLists);
}