//模糊查询物料名称 protected void SelectMatBasicData(object sender, EventArgs e) { try { Label_BasicData_Source.Text = "模糊查询数据源"; string condition = GetCondition(); BindGridView_MatBasicData_Serarch(condition); if (DropDownList1.SelectedValue != "") { Label17.Text = Gridview_MatType.Rows[0].Cells[1].Text.ToString(); Gridview_MatType.DataSource = mat.Select_MaterialTypeCondition("and IMMt_MaterialTypeID='" + DropDownList1.SelectedValue.ToString() + "'"); Gridview_MatType.DataBind(); UpdatePanel_MatType.Update(); } else { Label17.Text = "检索的"; UpdatePanel_MatType.Update(); } Panel_MaterBasicData.Visible = true; UpdatePanel_MaterBasicData.Update(); //this.MatName.Text = ""; //this.Model.Text = ""; //this.SafeStock.Text = ""; //this.StockDay.Text = ""; } catch (Exception) { //throw; ScriptManager.RegisterClientScriptBlock(UpdatePanel_Search, GetType(), "alert", "alert('you make some mistakes')", true); } }
//换页 protected void Gridview_MatTypeID_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView theGrid = sender as GridView; // refer to the GridView int newPageIndex = 0; if (-2 == e.NewPageIndex) { TextBox txtNewPageIndex = null; GridViewRow pagerRow = Gridview_MatType.BottomPagerRow; if (null != pagerRow) { txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value } if (null != txtNewPageIndex && txtNewPageIndex.Text != "") { newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex } } else { newPageIndex = e.NewPageIndex; } BindGridView_MatType(); Gridview_MatType.DataSource = mat.Select_V_MaterialType(); Gridview_MatType.DataBind(); newPageIndex = newPageIndex < 0 ? 0 : newPageIndex; newPageIndex = newPageIndex >= Gridview_MatType.PageCount ? Gridview_MatType.PageCount - 1 : newPageIndex; Gridview_MatType.PageIndex = newPageIndex; Gridview_MatType.DataBind(); }
//绑定类型表 private void BindGridView_MatType() { try { if (label_Mattypesource.Text == "search") { Gridview_MatType.DataSource = mat.Select_MaterialTypeCondition(GetCondition1()); Gridview_MatType.DataBind(); } else { Gridview_MatType.DataSource = mat.Select_V_MaterialType(); Gridview_MatType.DataBind(); } } catch (Exception) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>"); } }