private SearchStatementModel PrepareActingBillToListSearchStatement(GridCommand command, ActingBillSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Currency", searchModel.Currency, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsProvisionalEstimate", false, "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 = selectCountActingBillStatement; searchStatementModel.SelectStatement = selectActingBillStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _AjaxCalculateDetailList(GridCommand command, ActingBillSearchModel searchModel) { var actingBillList = this.billMgr.GetRecalculatePrice(CodeMaster.BillType.Distribution, searchModel.Party, searchModel.Flow, searchModel.ReceiptNo, searchModel.ExtReceiptNo, searchModel.Item, searchModel.Currency, searchModel.StartTime.HasValue ? searchModel.StartTime.Value : DateTime.Now, searchModel.EndTime.HasValue ? searchModel.EndTime.Value : DateTime.Now, searchModel.IncludeNoEstPrice); return PartialView(new GridModel(actingBillList)); }
public ActionResult _ReCalculateDetailList(GridCommand command, ActingBillSearchModel searchModel) { TempData["ActingBillSearchModel"] = searchModel; ViewBag.Party = searchModel.Party; ViewBag.ReceiptNo = searchModel.ReceiptNo; ViewBag.Currency = searchModel.Currency; ViewBag.Item = searchModel.Item; ViewBag.StartTime = searchModel.StartTime; ViewBag.EndTime = searchModel.EndTime; ViewBag.IncludeNoEstPrice = searchModel.IncludeNoEstPrice; return PartialView(); }
public void ExportXLS(ActingBillSearchModel searchModel) { if (string.IsNullOrEmpty(searchModel.Party)) { SaveErrorMessage(Resources.EXT.ControllerLan.Con_PleaseChooseCustomer); return; } IList<object> param = new List<object>(); string hql = "from ActingBill where IsClose=? and Type=? "; param.Add(false); param.Add((int)Sconit.CodeMaster.BillType.Distribution); if (!string.IsNullOrEmpty(searchModel.ReceiptNo)) { hql += " and ReceiptNo=?"; param.Add(searchModel.ReceiptNo); } if (!string.IsNullOrEmpty(searchModel.Item)) { hql += " and Item=?"; param.Add(searchModel.Item); } if (!string.IsNullOrEmpty(searchModel.Flow)) { hql += " and Flow=?"; param.Add(searchModel.Flow); } if (!string.IsNullOrEmpty(searchModel.Party)) { hql += " and Party=?"; param.Add(searchModel.Party); } if (!string.IsNullOrEmpty(searchModel.Currency)) { hql += " and Currency=?"; param.Add(searchModel.Currency); } if (!string.IsNullOrEmpty(searchModel.ExtReceiptNo)) { hql += " and ExternalReceiptNo=?"; param.Add(searchModel.ExtReceiptNo); } if (searchModel.StartTime != null & searchModel.EndTime != null) { hql += " and CreateDate Between ? and ? "; param.Add(searchModel.StartTime); param.Add(searchModel.EndTime); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { hql += " and CreateDate>=?"; param.Add(searchModel.StartTime); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { hql += " and CreateDate<=?"; param.Add(searchModel.EndTime); } IList<ActingBill> actingBillList = this.genericMgr.FindAll<ActingBill>(hql, param.ToArray()); ExportToXLS<ActingBill>("SalesActBill.xls", actingBillList); }
public ActionResult _AjaxActBillList(GridCommand command, ActingBillSearchModel searchModel) { if (string.IsNullOrEmpty(searchModel.Party)) { return PartialView(new GridModel(new List<ActingBill>())); } string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("ReceiptNo", searchModel.ReceiptNo, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("ExternalReceiptNo", searchModel.ExtReceiptNo, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Currency", searchModel.Currency, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsClose", false, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsProvisionalEstimate", false, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Type", (int)Sconit.CodeMaster.BillType.Distribution, "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<ActingBill> actingBillList = genericMgr.FindAll<ActingBill> (string.Format(" from ActingBill a {0}", whereStatement), param.ToArray()); GridModel<ActingBill> gdList = new GridModel<ActingBill>(); foreach (var actingBill in actingBillList) { actingBill.CurrentBillAmount = actingBill.UnitPrice * (actingBill.BillQty - actingBill.BillingQty); } gdList.Data = actingBillList.OrderBy(p=>p.ExternalReceiptNo); return PartialView(gdList); }
public ActionResult _ActingBillList(GridCommand command, ActingBillSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); if (!string.IsNullOrEmpty(searchModel.Party)) { TempData["_AjaxMessage"] = ""; } else { SaveWarningMessage(Resources.EXT.ControllerLan.Con_SupplierCanNotBeEmpty); } ViewBag.Party = searchModel.Party; ViewBag.ReceiptNo = searchModel.ReceiptNo; ViewBag.ExternalReceiptNo = searchModel.ExtReceiptNo; ViewBag.Flow = searchModel.Flow; ViewBag.Item = searchModel.Item; ViewBag.StartTime = searchModel.StartTime; ViewBag.EndTime = searchModel.EndTime; ViewBag.EndTime = searchModel.Currency; return PartialView(); }