protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int ClickNowSort = 0; int RdyChangeSort = 0; int i = 0; Button btnClick; Button btnRdyChange; if (e.CommandName == "btnSortUp") { if (int.Parse(e.CommandArgument.ToString()) > 0) { btnClick = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Button2"); btnRdyChange = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString()) - 1].FindControl("Button2"); QnaInfo pdClick = qBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString())); QnaInfo pdChange = qBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString())); ClickNowSort = pdClick.q_sort; RdyChangeSort = pdChange.q_sort; pdClick.q_sort = RdyChangeSort; pdChange.q_sort = ClickNowSort; if ((i = qBLL.Update(pdClick) + qBLL.Update(pdChange)) > 1) { ShowMessage("排序成功"); ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("f_title", txtKeyWord.Text, "")); } } else { ShowMessage("此項目排序已是第一位"); } } if (e.CommandName == "btnSortDown") { if (int.Parse(e.CommandArgument.ToString()) < GridView1.Rows.Count - 1) { btnClick = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Button2"); btnRdyChange = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString()) + 1].FindControl("Button2"); QnaInfo pdClick = qBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString())); QnaInfo pdChange = qBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString())); ClickNowSort = pdClick.q_sort; RdyChangeSort = pdChange.q_sort; pdClick.q_sort = RdyChangeSort; pdChange.q_sort = ClickNowSort; if ((i = qBLL.Update(pdClick) + qBLL.Update(pdChange)) > 1) { ShowMessage("排序成功"); ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("f_title", txtKeyWord.Text, "")); } } else { ShowMessage("此項目排序已是最後一位"); } } }
protected void Button1_Click(object sender, EventArgs e) { if (rbProductName.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("o_name", txtKeyWord.Text, "")); } else { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("o_number", txtKeyWord.Text, "")); } }
protected void Search() { if (rbTitle.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("b_title", "b_title", "b_price", txtKeyWord.Text, Tools.TryParseMethod(ddrBannerCategory.SelectedValue), "bc_id", Tools.TryParseMethod(ddrBannerCustomer.SelectedValue), "bcs_id", Tools.TryParseMethod(ddrBannerLocation.SelectedValue), "bl_id", "")); } else { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("b_price", "b_title", "b_price", txtKeyWord.Text, Tools.TryParseMethod(ddrBannerCategory.SelectedValue), "bc_id", Tools.TryParseMethod(ddrBannerCustomer.SelectedValue), "bcs_id", Tools.TryParseMethod(ddrBannerLocation.SelectedValue), "bl_id", "")); } }
protected void Button1_Click(object sender, EventArgs e) { if (rbCompanyName.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("bcs_company_name", txtKeyWord.Text, "")); } else if (rbName.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("bcs_name", txtKeyWord.Text, "")); } else { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("bcs_key", txtKeyWord.Text, "")); } }
protected void Button1_Click(object sender, EventArgs e) { if (rbAccount.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("m_account", txtKeyWord.Text, "")); } else if (rbNickname.Checked) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("m_nickname", txtKeyWord.Text, "")); } else { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("m_name", txtKeyWord.Text, "")); } }
protected void GoToPage_TextChanged(object sender, EventArgs e) { TextBox txtgotopage = (TextBox)sender; int pageNumber; if (int.TryParse(txtgotopage.Text.Trim(), out pageNumber) && pageNumber > 0 && pageNumber <= this.GridView1.PageCount) { this.GridView1.PageIndex = pageNumber - 1; } else { this.GridView1.PageIndex = GridView1.PageCount - 1; AddMethodSystem.ShowBox(UpdatePanel1, this.GetType(), "valuebig", "alert('超出分頁最大值');window.location.href"); ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("pc_name", txtKeyWord.Text, int.Parse(ddrCategory.SelectedValue), "pc_fatherid", lid, "l_id", "")); } }
protected void Button1_Click(object sender, EventArgs e) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("pc_name", txtKeyWord.Text, int.Parse(ddrCategory.SelectedValue), "pc_fatherid", lid, "l_id", "")); }
//public string getTitle(int id) //{ // if (id == 0) // { // return ""; // } // return info.nc_name; //} protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("n_title", txtKeyWord.Text, int.Parse(ddrCategory.SelectedValue), "nc_id", lid, "l_id", "")); }
protected void Button1_Click(object sender, EventArgs e) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("gb_title", txtKeyWord.Text, "")); }
protected void Button1_Click(object sender, EventArgs e) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("sc_Name", txtKeyWord.Text, ddrCategory.SelectedValue, "sc_Class", "")); }
protected void GridView1_PageIndexChanged(object sender, EventArgs e) { ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("bl_title", txtKeyWord.Text, Tools.TryParseMethod(ddlCategory.SelectedValue), "bl_father_id", "")); }