//一般:從DB抓總表資料出來根據PAGE進行分頁 搜尋:抓取Keyword資料，進DB後將篩選的資料依據PAGE進行分頁
private void LoadPettyCashView()
{
//----- Get Query string parameters -----
string page = Request.QueryString["Page"];
int pIndex = 0;
//當頁面不為0時,進入預設第一頁
if (string.IsNullOrEmpty(page))
{
pIndex = 1;
}
else
{
//將PAGE轉為數字，回傳pIndex
int.TryParse(page, out pIndex);
//如果回傳值小於0,強制轉成1
if (pIndex <= 0)
{
pIndex = 1;
}
}
//----- Get Query string parameters -----
//設定關鍵搜尋網址
string Keyword_DD = Request.QueryString["Keyword_DD"];
string Keyword_txt = Request.QueryString["Keyword_txt"];
int totalSize = 0;
var manager = new PettyCashmanager();
var list = manager.ViewAllPettyCash(Keyword_DD, Keyword_txt, out totalSize, pIndex, _pageSize);
int pages = PagingHelper.CalculatePages(totalSize, _pageSize);
List <PagingLink> pagingList = new List <PagingLink>();
for (var i = 1; i <= pages; i++)
{
pagingList.Add(new PagingLink()
{
Link = $"PettyCashList.aspx{this.GetQueryString(false, i)}",
Name = $"{i}",
Title = $"前往第 {i} 頁",
Color = (i == pIndex) ? "BLACK" : ""
});
}
this.repPaging.DataSource = pagingList;
this.repPaging.DataBind();
this.tableRepeater.DataSource = list;
this.tableRepeater.DataBind();
}
private void LoadCase(Guid id) //偵測有無GUID
{
var manager = new PettyCashmanager(); //實體化PettyCashmanager
var model = manager.GetCashmodel(id); //引用PettyCashmanager的GetCashmodel 依GUID為KEY來帶出其他資料
if (model == null) //如果沒這筆資料頁面轉回管理畫面
{
Response.Redirect("PettyCashList.aspx"); //畫面轉回零用金管理
}
this.titalable.Text = "零用金修改"; //將標題改為"零用金修改"
this.dateinpu.Value = model.Date.ToString("yyyy-MM-dd"); //將申請日期的值帶入輸入框
this.Case.Value = model.CaseID.ToString(); //將案件編號的值帶入輸入框
this.ItemclassTxt.SelectedValue = model.Class; //將課目的值帶入下拉式選單
this.Paytxt.Value = model.pay.ToString(); //將金額的值帶入輸入框
this.reasonTxt.SelectedValue = model.Event; // 將事由的值帶入下拉式選單
this.invoiceTxt.Value = model.invoiceCode; // 將發票的值帶入輸入框
}
