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);
}
}
