protected void FilledCurrentDataGrid(string search_string)
{
string select_string = "SELECT * FROM ORDER_FORM WHERE `ITEMS` = \"" +
search_string + "\" OR `OWNERS` =\"" + search_string + "\"";
g_dt = UtilityEventClass.UtilityFilledGridViewFunction(this.GridView1, display_columns, select_string);
}
protected void FilledCurrentDataGrid(string search_string)
{
string select_string = "SELECT * FROM USER_FORM WHERE `account` = \"" +
search_string + "\" OR `name` =\"" + search_string + "\"";
UtilityEventClass.UtilityFilledGridViewFunction(this.GridView1, display_columns, select_string);
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script>document.getElementById(\"ShowButton\").click()</script>");
int count = UtilityEventClass.UtilitySelectedIndexChanging(sender, e);
sequences = Convert.ToInt32(g_dt.Rows[count].ItemArray[0].ToString());
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script>document.getElementById(\"ShowButton\").click()</script>");
int count = UtilityEventClass.UtilitySelectedIndexChanging(sender, e);
this.sequences.Value = g_dt.Rows[count].ItemArray[0].ToString();
this.contract_numbers.Value = g_dt.Rows[count].ItemArray[1].ToString();
this.items.Value = g_dt.Rows[count].ItemArray[2].ToString();
this.other_cabinet.Value = g_dt.Rows[count].ItemArray[3].ToString();
}
// 上传用户填写的表格数据
protected void SubmitButton_Click()
{
UtilityEventClass.UtilitySubmitButtonClick(MySqlRequest.INSERT, create_cmd);
FilledCurrentDataGrid();
}
/// <summary>
/// 填充数据
/// </summary>
protected void FilledCurrentDataGrid()
{
string select_string = "SELECT * FROM USER_FORM ORDER BY `sequences`";
UtilityEventClass.UtilityFilledGridViewFunction(this.GridView1, display_columns, select_string);
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
UtilityEventClass.UtilityPageIndexChanging(sender, e);
FilledCurrentDataGrid();
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
UtilityEventClass.UtilitySubmitButtonClick(MySqlRequest.UPDATE, create_cmd);
FilledCurrentDataGrid();
}
protected void FilledCurrentDataGrid()
{
g_dt = UtilityEventClass.UtilityFilledGridViewFunction(this.GridView1, display_columns);
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
UtilityEventClass.UtilityPageIndexChanging(sender, e);
FilledCurrentDataGrid(this.search_text.Value.ToString());
}
