private void DisciplinesSort_CheckedChanged(object sender, EventArgs e)
{
if (DisciplinesSort.Checked)
{
MaterialsGridView.Sort(MaterialsGridView.Columns[1], ListSortDirection.Ascending);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SectionTreeList.DataBind();
SectionTreeList.ExpandToLevel(1);
TreeListNode node = SectionTreeList.FindNodeByFieldValue("code", "21-020101");
if (node != null)
{
node.Focus();
Session["sec_id"] = node.Key;
}
MaterialsGridView.DataBind();
}
}
private void SelectMaterials(string text)
{
int g_width = 0;
int g_height = 0;
if (text == MaterialsHintText)
{
text = String.Empty;
}
MySqlDataAdapter adap = new MySqlDataAdapter();
DataTable table = new DataTable();
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("ShowMaterials", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_name", text);
adap.SelectCommand = cmd;
adap.Fill(table);
MaterialsGridView.DataSource = table;
MaterialsGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
MaterialsGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
foreach (DataGridViewColumn column in MaterialsGridView.Columns)
{
if (column.Visible == true)
{
g_width += column.Width;
}
}
Width = g_width + 75;
if (UserSort.Checked)
{
MaterialsGridView.Sort(MaterialsGridView.Columns[0], ListSortDirection.Ascending);
}
}
protected void MaterialsGridView_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
Session["sec_id"] = e.Parameters;
MaterialsGridView.DataBind();
}
