public void LoadTable() { Hlp Hlp = new Hlp(); DbHelper dbHelper = new DbHelper(); TableRow[] Row; DataTable Table = null; MessageCtrl messageCtrl = new MessageCtrl(); String DataInicial = txt_data_inicial.Text; String DataFinal = txt_data_final.Text; String Destinatario = dd_destinatario.SelectedValue; try { String Part = dd_unidades.SelectedValue; String[] Empresa_id = Part.Split('-'); if (!String.IsNullOrEmpty(DataInicial) && !String.IsNullOrEmpty(DataFinal)) { String Script2 = messageCtrl.Pesquisar(Destinatario, Convert.ToInt32(Empresa_id[0]), DataInicial, DataFinal); Table = dbHelper.DisplayData(Script2); } Row = Hlp.TableLoad(Table); tbl_control.Rows.AddRange(Row); lbl_title_control.Text = " Qtd: " + Table.Rows.Count; Session.Add("Table", Table); Session.Add("quantidade_sms", Table.Rows.Count); } catch (Exception Err) { } }
public void Preencher(DataTable Table = null) { Hlp Hlp = new Hlp(); TableRow[] Row; // Row = Hlp.TableLoad((DataTable)Session["Table"]); Row = Hlp.TableLoad(TableInit); if (Table == null) { Session.Add("TableInit", TableInit); } if (TableInit != null) { Row = Hlp.TableLoad((DataTable)Session["TableInit"]); tbl_control.Rows.AddRange(Row); } }
public void InitPage() { Hlp Hlp = new Hlp(); TableRow[] Row; if ((String)Session["User"] != "ADMIN") { pnl_control.Enabled = false; dd_unidades.SelectedValue = (String)Session["User"]; pnl_control_category.Enabled = false; dd_category.SelectedValue = "2"; } if (Session["Table"] != null) { Row = Hlp.TableLoad((DataTable)Session["Table"]); tbl_control.Rows.AddRange(Row); } }