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