protected void btn_search_Click(object sender, EventArgs e)
{
int pageSize = 20;
string keyword = this.txt_paymentItemSetting_filter_keyword.Text.Trim();
string cashApply = this.ddl_paymentItemSetting_filter_cashApply.SelectedValue.Trim();
AccountItemViewModel.AccountItemTaxRateSettingListQueryParameter param = new AccountItemViewModel.AccountItemTaxRateSettingListQueryParameter();
param.cashApplyTypeKey = cashApply;
param.includeDeleteItem = false;
param.orderField = "dateCreated";
param.pageSize = pageSize;
param.pageIndex = 1;
param.desc = true;
param.keyword = keyword;
AccountItemViewModel.AccountItemTaxRateSettingListResult listResult = this.accountItemSvc.getAccountItemTaxRateSettingListResult(param);
if (listResult.success)
{
this.rpt_paymentItemSetting.DataSource = listResult.list;
this.rpt_paymentItemSetting.DataBind();
this.component_pager.queryString = "pg";
this.component_pager.pageSize = pageSize;
this.component_pager.showPageItem = 5;
this.component_pager.currentPage = 1;
this.component_pager.count = listResult.count;
this.component_pager.load();
this.component_pager.DataBind();
}
else
{
}
}
public Tuple <int, List <AccountItemTaxRateSetting> > getAccountItemTaxRateSettingList(AccountItemViewModel.AccountItemTaxRateSettingListQueryParameter param)
{
List <AccountItemTaxRateSetting> list = new List <AccountItemTaxRateSetting>();
int count = 0;
Tuple <int, List <AccountItemTaxRateSetting> > ret = null;
using (NaNaEntities db = new NaNaEntities()) {
var predicate = PredicateBuilder.True <AccountItemTaxRateSetting>();
if (!string.IsNullOrEmpty(param.cashApplyTypeKey))
{
predicate = predicate.And(x => x.applyTypeKey == param.cashApplyTypeKey);
}
if (!param.includeDeleteItem)
{
predicate = predicate.And(x => !x.deleted);
}
//用關鍵字搜尋
if (!string.IsNullOrEmpty(param.keyword))
{
predicate = predicate.And(x =>
x.code.Contains(param.keyword) ||
x.itemName.Contains(param.keyword) ||
x.memo.Contains(param.keyword));
}
if (string.IsNullOrEmpty(param.orderField))
{
param.orderField = "dataCreated";
}
list = db.AccountItemTaxRateSetting.AsExpandable()
.Where(predicate)
.OrderBy(param.orderField, param.desc)
.Skip((param.pageIndex - 1) * param.pageSize)
.Take(param.pageSize)
.ToList();
count = db.AccountItemTaxRateSetting.AsExpandable()
.Where(predicate).Count();
ret = Tuple.Create(count, list);
}
return(ret);
}
protected void reloadAccountList()
{
string pg_str = Request.QueryString["pg"] as string;
pg_str = string.IsNullOrEmpty(pg_str) ? "1" : pg_str;
int pg_int = 1;
int.TryParse(pg_str, out pg_int);
int pageSize = 20;
string keyword = Request.QueryString["keyword"] as string;
string cashApply = Request.QueryString["cashApply"] as string;
if (string.IsNullOrWhiteSpace(keyword))
{
keyword = "";
}
else
{
keyword = HttpUtility.UrlDecode(keyword);
}
if (string.IsNullOrWhiteSpace(cashApply))
{
cashApply = "";
}
else
{
cashApply = HttpUtility.UrlDecode(cashApply);
}
AccountItemViewModel.AccountItemTaxRateSettingListQueryParameter param = new AccountItemViewModel.AccountItemTaxRateSettingListQueryParameter();
param.cashApplyTypeKey = cashApply;
param.includeDeleteItem = false;
param.orderField = "dateCreated";
param.pageSize = pageSize;
param.pageIndex = pg_int;
param.desc = true;
param.keyword = keyword;
AccountItemViewModel.AccountItemTaxRateSettingListResult listResult = this.accountItemSvc.getAccountItemTaxRateSettingListResult(param);
if (listResult.success)
{
this.rpt_paymentItemSetting.DataSource = listResult.list;
this.rpt_paymentItemSetting.DataBind();
this.component_pager.queryString = "pg";
this.component_pager.pageSize = pageSize;
this.component_pager.showPageItem = 5;
this.component_pager.currentPage = pg_int;
this.component_pager.count = listResult.count;
this.component_pager.load();
this.component_pager.DataBind();
}
else
{
}
}
