private void Window_Loaded(object sender, RoutedEventArgs e)
{
idbod = idBod;
idemp = idEmp;
System.Data.DataRow foundRow = SiaWin.Empresas.Rows.Find(idemp);
int idLogo = Convert.ToInt32(foundRow["BusinessLogo"].ToString().Trim());
//cnEmp = foundRow["BusinessCn"].ToString().Trim();
string aliasemp = foundRow["BusinessAlias"].ToString().Trim();
string nomempresa = foundRow["BusinessName"].ToString().Trim();
// tabitem.Logo(idLogo, ".png");
// tabitem.Title = "Analisis de Venta(" + aliasemp + ")";
codemp = foundRow["BusinessCode"].ToString().Trim();
this.Title = "Saldos de Inventario - Empresa:" + codemp + "-" + nomempresa;
//GroupId = 0;
ultbusqueda = UltBusqueda;
if (TiboBusqueda)
{
TxtTipoBusqueda.Text = "Busqueda por:";
}
if (TiboBusqueda == false)
{
TxtTipoBusqueda.Text = "Busqueda por:";
}
if (MostrarTodo == true)
{
if (where != string.Empty)
{
where = " where " + where;
}
dataGrid.ItemsSource = GetDataTable(where).DefaultView;
BtnBuscar.Visibility = Visibility.Collapsed;
TxtShear.Visibility = Visibility.Collapsed;
dataGrid.SelectedIndex = 0;
dataGrid.Focus();
}
else
{
if (ultbusqueda != string.Empty)
{
TxtShear.Text = ultbusqueda;
}
TxtShear.Text = "";
TxtShear.Focus();
TxtShear.SelectAll();
}
//if (SiaWin.Func.Var.ContainsKey("_UltimaReferenciaBuscar")) TxtShear.Text = SiaWin.Func.Var["_UltimaReferenciaBuscar"].ToString().Trim();
//if (!SiaWin.Func.Var.ContainsKey("_UltimaReferenciaBuscar")) SiaWin.Func.Var.Add("_UltimaReferenciaBuscar", "");
//if (!string.IsNullOrEmpty(TxtShear.Text.Trim())) BtnBuscar.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
private void dataGrid_PreviewKeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter || e.Key == Key.Escape)
{
SelectItem();
e.Handled = true;
}
if (e.Key == Key.Left)
{
if (mostrartodo == false)
{
TxtShear.SelectAll();
TxtShear.Focus();
TxtShear.SelectAll();
e.Handled = true;
}
}
if (e.Key == Key.F2)
{
DataRowView row = (DataRowView)dataGrid.SelectedItems[0];
if (row != null)
{
// int nPnt = Int32.Parse(row[0].ToString());
this.Codigo = row[1].ToString();
this.Nombre = row[0].ToString();
//this.IdRowReturn = nPnt;
/// valida si hay saldos en bodega
DataTable dtcnd = LoadBodega(codigo, idBod, 1); //cnd
if (dtcnd == null)
{
return;
}
DataTable dtpv = LoadBodega(codigo, idBod, 2); //cnd
if (dtpv == null)
{
return;
}
//DataTable dtcnd = LoadBodega(codigo, idBod, 21); //cnd
//DataSet ds1 = LoadData(codigo, idBod); //cnd
if (dtcnd.Rows.Count + dtpv.Rows.Count == 0)
{
MessageBox.Show("Producto:" + codigo + "-" + Nombre.Trim() + " Sin saldos en bodegas..");
return;
}
//MessageBox.Show(ds1.Tables[0].Rows.Count.ToString());
SaldosBodegas xx = new SaldosBodegas(this.Codigo, this.Nombre, 0, Conexion, idbod, idemp);
xx.TxtLinea.Text = row["cod_tip"].ToString();
xx.TxtProveedor.Text = row["cod_prv"].ToString();
xx.dataGrid.ItemsSource = dtcnd.DefaultView;
xx.dataGridPV.ItemsSource = dtpv.DefaultView;
xx.TxtFecCrea.Text = fechaCreacion.ToShortDateString();
decimal sumInv = 0;
decimal sumImp = 0;
//foreach (System.Data.DataColumn col in ds1.Tables[0].Columns) col.ReadOnly = false;
foreach (DataRow dr in dtcnd.Rows) // search whole table
{
decimal saldoin = Convert.ToDecimal(dr["saldo"]);
//decimal saldoinImp = Convert.ToDecimal(dr["importacion"]);
//dr["saldo"] = saldoin; //change the name
sumInv = sumInv + saldoin;
//sumImp = sumImp + saldoinImp;
}
xx.TotalCndExit.Text = sumInv.ToString("N2");
//xx.TotalCndImpor.Text = sumImp.ToString("N2");
xx.TotalCnd.Text = (sumInv + sumImp).ToString("N2");
decimal sumInvPv = 0;
decimal sumImpPv = 0;
//foreach (System.Data.DataColumn col in ds1.Tables[0].Columns) col.ReadOnly = false;
foreach (DataRow dr in dtpv.Rows) // search whole table
{
decimal saldoinPv = Convert.ToDecimal(dr["saldo"]);
//decimal saldoinImpPv = Convert.ToDecimal(dr["importacion"]);
//dr["saldo"] = saldoin; //change the name
sumInvPv = sumInvPv + saldoinPv;
//sumImpPv = sumImpPv;
//+ saldoinImpPv;
}
xx.TotalPvExit.Text = sumInvPv.ToString("N2");
//xx.TotalPvImpor.Text = sumImpPv.ToString("N2");
xx.TotalPv.Text = (sumInvPv + sumImpPv).ToString("N2");
xx.TotalExit.Text = (sumInv + sumInvPv).ToString("N2");
//xx.TotalImpor.Text =(sumImp+sumImpPv).ToString("N2");
xx.Total.Text = (sumInv + sumInvPv).ToString("N2");
//xx.dataGrid.ItemsSource = ds1.Tables[0].DefaultView;
xx.ShowInTaskbar = false;
xx.Owner = Application.Current.MainWindow;
xx.dataGrid.Focus();
xx.dataGrid.SelectedItem = dataGrid.Items[0];
xx.dataGrid.SelectedIndex = 0;
xx.dataGrid.Focus();
xx.dataGrid.SelectedIndex = 0;
xx.ShowDialog();
e.Handled = true;
}
}
}
