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