protected void RunFilter(String querystring, String col, String val, String includedparts)
{
//AccessDataSource1.SelectCommand = "SELECT [ProductLine], [Series], [Codename], [ModelName], [ConfigurationNumber], [ReleaseDate], [CodenameInSpareParts] FROM [Products_Basic] WHERE (Series = '" + currentseries + "') AND (" + col + " LIKE '%" + val + "%') ORDER BY [ReleaseDate] DESC, [Codename], [ConfigurationNumber]";
AccessDataSource3.SelectCommand = "SELECT ProductConfiguration.ConfigurationNumber, PartsBOM.PRTNUM, PartsBOM.PRTEUREPAI, PartsBOM.COLVAL, PartsOrdPart.DESCRIPTION, PartsOrdPart.LOCATION, PartsOrdPart.LISTEACH, PartsOrdPart.QUANTITY FROM ((PartsBOM INNER JOIN PartsOrdPart ON PartsBOM.PRTNUM = PartsOrdPart.PARTNUM) INNER JOIN ProductConfiguration ON PartsBOM.MDLCONFIG = ProductConfiguration.ConfigurationNumber) WHERE (PartsOrdPart.DESCRIPTION <> 'ZERO') AND (ProductConfiguration.ConfigurationNumber = '" + querystring + "') AND (" + col + " LIKE '%" + val + "%')" + includedparts + " ORDER BY PartsOrdPart.DESCRIPTION, PartsBOM.PRTNUM";
AccessDataSource3.DataBind();
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Session["Now"] = DateTime.Now.ToString();
AccessDataSource3.Insert();
AccessDataSource1.Update();
Response.Redirect("~/Member/ViewHistory.aspx");
}
private void get_product()
{
DataView dv = (DataView)AccessDataSource3.Select(DataSourceSelectArguments.Empty);
DataTable myTable = new DataTable();
myTable = dv.ToTable();
okquery_string = myTable.Rows[0][3].ToString();
okentry_string = myTable.Rows[0][4].ToString();
authrization_type = myTable.Rows[0][1].ToString();
}
private string GetDescriptionById(string id)
{
AccessDataSource3.SelectParameters["CategoryID"].DefaultValue = id;
DataView result = (DataView)AccessDataSource3.Select(DataSourceSelectArguments.Empty);
if (result.Count == 0)
{
return(string.Empty);
}
return(result[0]["Description"].ToString());
}
