private void btnExportar_Click(object sender, RoutedEventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (saveFile.ShowDialog() == DialogResult.OK)
{
Thread t1 = new Thread(new ThreadStart(() =>
{
lblLoad.BeginInvoke(new Action(() =>
{
lblLoad.Visible = true;
}));
string path = saveFile.FileName;
ActDAL d = new ActDAL("org");
d.ExpExcel(path, (DataTable)dgTabla.DataSource);
lblLoad.BeginInvoke(new Action(() =>
{
lblLoad.Visible = false;
}));
}));
t1.Start();
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnImportar_Click(object sender, RoutedEventArgs e)
{
string path = string.Empty;
int colnum;
try
{
if (DialogResult.OK == OpenD.ShowDialog())
{
if (OpenD.OpenFile() != null)
{
Thread tv = new Thread(new ThreadStart(() =>
{
try
{
lblLoad.BeginInvoke(new Action(() =>
{
lblLoad.Visible = true;
}));
path = OpenD.FileName;
txtPathExcel.BeginInvoke(new Action(() =>
{
txtPathExcel.Text = path;
}));
ActDAL da = new ActDAL("org");
DataTable dt = da.LeerExcel(path);
if (hist != null)
{
colnum = dt.Columns.Count;
if (dt.Columns[colnum - 1].ColumnName.ToUpper() != "HISTORICO")
{
throw new Exception("Error en la columna Historico");
}
}
dgTabla.BeginInvoke(new Action(() =>
{
dgTabla.DataSource = dt;
}));
lblLoad.BeginInvoke(new Action(() =>
{
lblLoad.Visible = false;
}));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}));
tv.Start();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void llenadatos()
{
try
{
dgAnt.ItemsSource = null;
ActDAL da = new ActDAL("dest");
DataTable dt = da.LeerTabla("bitacora");
dgAnt.ItemsSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
private void frmSelTabExcel_Load(object sender, EventArgs e)
{
DataTable dt;
try
{
if (v.TbActual == string.Empty)
{
throw new Exception("Nombre de Tabla incorrecto");
}
if (esnuevo)
{
ActDAL d = new ActDAL("org");
dt = d.LeerTabla(v.TbActual);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
var bte = v.Tabencript.Where(x => x.Tabla == v.TbActual);
if (bte.ToList().Count == 1)
{
dt = Util.decriptTable(dt, bte.ToList().First());
}
dt.TableName = v.TbActual;
}
}
}
else
{
var b = v.Modtables.Where(x => x.TableName == v.TbActual);
dt = b.ToList().First();
}
dtorg = dt;
var bhist = v.TabHist.Where(x => x.Tabla == dt.TableName);
if (bhist.ToList().Count == 1)
{
hist = bhist.ToList().First();
}
dgTabla.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmMenu_Load(object sender, EventArgs e)
{
List <EntGeneral> lst = new List <EntGeneral>();
try
{
string st = Util.encript("31/12/2016");
ActDAL d = new ActDAL("org");
Var v = new Var();
lst = d.LeerTablas();
v.Tables = lst;
v.Modtables = new List <DataTable>();
paq = string.Empty;
ctrl = string.Empty;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnGuaTabla_Click(object sender, RoutedEventArgs e)
{
Var v = new Var();
ActDAL d = new ActDAL("dest");
string s = string.Empty;
try
{
if (scripts == null)
{
scripts = new List <EntGeneralST>();
}
d.begTran();
foreach (DataTable dt in v.Modtables)
{
s = string.Empty;
if (!d.ActTabla(dt, out s))
{
throw new Exception("Fallo de act de tabla" + dt.TableName);
}
else
{
scripts.Add(new EntGeneralST(dt.TableName, s));
}
}
d.commit();
MessageBox.Show("Tablas correctamente Actualizadas");
}
catch (Exception ex)
{
scripts = new List <EntGeneralST>();
d.roll_back();
MessageBox.Show(ex.Message);
}
finally
{
d.close();
}
}
