private void GridConfig_CurrentCellValidating(object sender, CurrentCellValidatingEventArgs e) { try { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); int columnIndex = (sender as SfDataGrid).SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex; var rowData = GridConfig.GetRecordAtRowIndex(columnIndex); //{ // dynamic ww = SiaWin.WindowExt(9326, "InBuscarReferencia"); //carga desde sql // ww.Conexion = SiaWin.Func.DatosEmp(idemp); // ww.idEmp = idemp; // ww.idBod = tx_bodega.Text; // ww.UltBusqueda = ""; // ww.ShowInTaskbar = false; // ww.Owner = Application.Current.MainWindow; // ww.WindowStartupLocation = WindowStartupLocation.CenterScreen; // ww.Height = 400; // ww.ShowDialog(); // string code = ww.Codigo; // reflector.SetValue(rowData, "cod_ref", code); // GridConfig.UpdateDataRow(columnIndex); // GridConfig.UpdateLayout(); // GridConfig.Columns["cod_ref"].AllowEditing = true; // } // else // { // string refe = reflector.GetValue(rowData, "cod_ref").ToString().Trim(); // if (string.IsNullOrEmpty(refe)) // { // dynamic ww = SiaWin.WindowExt(9326, "InBuscarReferencia"); //carga desde sql // ww.Conexion = SiaWin.Func.DatosEmp(idemp); // ww.idEmp = idemp; // ww.idBod = tx_bodega.Text; // ww.UltBusqueda = ""; // ww.ShowInTaskbar = false; // ww.Owner = Application.Current.MainWindow; // ww.WindowStartupLocation = WindowStartupLocation.CenterScreen; // ww.Height = 400; // ww.ShowDialog(); // string code = ww.Codigo; // reflector.SetValue(rowData, "cod_ref", code); // GridConfig.UpdateDataRow(columnIndex); // GridConfig.UpdateLayout(); // GridConfig.Columns["cod_ref"].AllowEditing = true; // } // } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("error Activiting:" + w); } }
private void GridConfig_PreviewKeyDown(object sender, KeyEventArgs e) { try { GridColumn Colum = ((SfDataGrid)sender).CurrentColumn as GridColumn; if (Colum.MappingName == "cod_ref" && e.Key == Key.F8) { if (GridConfig.SelectedIndex == -1) this.GridConfig.SelectionController.CurrentCellManager.BeginEdit(); int idr = 0; string code = ""; string nom = ""; dynamic winb = SiaWin.WindowBuscar("inmae_ref", "cod_ref", "nom_ref", "cod_ref", "idrow", "Maestra de referencia", SiaWin.Func.DatosEmp(idemp), false, "", idEmp: idemp); winb.ShowInTaskbar = false; winb.Owner = System.Windows.Application.Current.MainWindow; winb.Height = 300; winb.Width = 400; winb.ShowDialog(); idr = winb.IdRowReturn; code = winb.Codigo; nom = winb.Nombre; if (!string.IsNullOrEmpty(code)) { var func = refe(code); if (func.Item1) { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); int columnIndex = (sender as SfDataGrid).SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex; var rowData = GridConfig.GetRecordAtRowIndex(columnIndex); reflector.SetValue(rowData, "cod_ref", func.Item2.Rows[0]["cod_ref"].ToString().Trim()); if (DBNull.Value.Equals(reflector.GetValue(rowData, "can_rec"))) reflector.SetValue(rowData, "can_rec", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) reflector.SetValue(rowData, "cantidad", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cant_nr"))) reflector.SetValue(rowData, "cant_nr", 0); reflector.SetValue(rowData, "obs", "Ninguna"); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_h"))) reflector.SetValue(rowData, "r_h", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_r"))) reflector.SetValue(rowData, "r_r", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_t"))) reflector.SetValue(rowData, "r_t", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_o"))) reflector.SetValue(rowData, "r_o", 0); GridConfig.UpdateDataRow(columnIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; GridConfig.Columns["can_rec"].AllowEditing = true; GridConfig.Columns["cantidad"].AllowEditing = true; GridConfig.Columns["cant_nr"].AllowEditing = true; GridConfig.Columns["obs"].AllowEditing = true; GridConfig.Columns["r_h"].AllowEditing = true; GridConfig.Columns["r_r"].AllowEditing = true; GridConfig.Columns["r_t"].AllowEditing = true; GridConfig.Columns["r_o"].AllowEditing = true; } } } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("error en el producto f8:" + w); } }
private void GridConfig_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e) { try { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); var rowData = GridConfig.GetRecordAtRowIndex(e.RowColumnIndex.RowIndex); string refer = reflector.GetValue(rowData, "cod_ref").ToString(); var func = refe(refer); if (func.Item1) { if (DBNull.Value.Equals(reflector.GetValue(rowData, "can_rec"))) reflector.SetValue(rowData, "can_rec", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) reflector.SetValue(rowData, "cantidad", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cant_nr"))) reflector.SetValue(rowData, "cant_nr", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "obs"))) reflector.SetValue(rowData, "obs", "Ninguna"); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_h"))) reflector.SetValue(rowData, "r_h", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_r"))) reflector.SetValue(rowData, "r_r", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_t"))) reflector.SetValue(rowData, "r_t", 0); if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_o"))) reflector.SetValue(rowData, "r_o", 0); GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; GridConfig.Columns["can_rec"].AllowEditing = true; GridConfig.Columns["cantidad"].AllowEditing = true; GridConfig.Columns["cant_nr"].AllowEditing = true; GridConfig.Columns["obs"].AllowEditing = true; GridConfig.Columns["r_h"].AllowEditing = true; GridConfig.Columns["r_r"].AllowEditing = true; GridConfig.Columns["r_t"].AllowEditing = true; GridConfig.Columns["r_o"].AllowEditing = true; } else { reflector.SetValue(rowData, "cod_ref", ""); reflector.SetValue(rowData, "can_rec", 0); reflector.SetValue(rowData, "cantidad", 0); reflector.SetValue(rowData, "cant_nr", 0); reflector.SetValue(rowData, "obs", ""); reflector.SetValue(rowData, "r_h", 0); reflector.SetValue(rowData, "r_r", 0); reflector.SetValue(rowData, "r_t", 0); reflector.SetValue(rowData, "r_o", 0); GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; GridConfig.Columns["can_rec"].AllowEditing = true; GridConfig.Columns["cantidad"].AllowEditing = true; GridConfig.Columns["cant_nr"].AllowEditing = true; GridConfig.Columns["obs"].AllowEditing = true; GridConfig.Columns["r_h"].AllowEditing = true; GridConfig.Columns["r_r"].AllowEditing = true; GridConfig.Columns["r_t"].AllowEditing = true; GridConfig.Columns["r_o"].AllowEditing = true; } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("error al editar:" + w); } }
private void GridConfig_CurrentCellActivated(object sender, CurrentCellActivatedEventArgs e) { try { bool t = this.GridConfig.View.IsAddingNew; if (!t) { if ((e.CurrentRowColumnIndex.RowIndex) > GridConfig.View.Records.Count) { if (e.CurrentRowColumnIndex.ColumnIndex > 0) { this.GridConfig.SelectionController.CurrentCellManager.BeginEdit(); } } else { GridConfig.UpdateLayout(); var reflector = this.GridConfig.View.GetPropertyAccessProvider(); int columnIndex = (sender as SfDataGrid).SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex; var rowData = GridConfig.GetRecordAtRowIndex(columnIndex); string refe = reflector.GetValue(rowData, "cod_ref").ToString().Trim(); if (string.IsNullOrEmpty(refe)) { this.GridConfig.SelectionController.CurrentCellManager.BeginEdit(); } } } if (Keyboard.IsKeyDown(Key.Tab) || Keyboard.IsKeyDown(Key.Right) || Keyboard.IsKeyDown(Key.Return)) { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); int columnIndex = (sender as SfDataGrid).SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex; var rowData = GridConfig.GetRecordAtRowIndex(columnIndex); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cod_ref"))) { dynamic ww = SiaWin.WindowExt(9326, "InBuscarReferencia"); //carga desde sql ww.Conexion = SiaWin.Func.DatosEmp(idemp); ww.idEmp = idemp; ww.idBod = tx_bodega.Text; ww.UltBusqueda = ""; ww.ShowInTaskbar = false; ww.Owner = Application.Current.MainWindow; ww.WindowStartupLocation = WindowStartupLocation.CenterScreen; ww.Height = 400; ww.ShowDialog(); string code = ww.Codigo; if (string.IsNullOrEmpty(code)) { return; } var func = refe(code); reflector.SetValue(rowData, "cod_ref", func.Item2.Rows[0]["cod_ref"].ToString().Trim()); reflector.SetValue(rowData, "nom_ref", func.Item2.Rows[0]["nom_ref"].ToString().Trim()); double getCant = 1; if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) { reflector.SetValue(rowData, "cantidad", 1); } double saldoin = Convert.ToDouble(SiaWin.Func.SaldoInv(func.Item2.Rows[0]["cod_ref"].ToString().Trim(), tx_bodega.Text, cod_empresa)); reflector.SetValue(rowData, "saldo", saldoin); double fal = saldoin - getCant; reflector.SetValue(rowData, "faltantes", fal >= 0 ? 0 : fal); reflector.SetValue(rowData, "val_ref", Convert.ToDouble(func.Item2.Rows[0]["val_ref"].ToString())); double sub = Convert.ToDouble(func.Item2.Rows[0]["val_ref"]) * getCant; reflector.SetValue(rowData, "subtotal", sub); GridConfig.UpdateDataRow(columnIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; } else { string referen = reflector.GetValue(rowData, "cod_ref").ToString().Trim(); if (string.IsNullOrEmpty(referen)) { dynamic ww = SiaWin.WindowExt(9326, "InBuscarReferencia"); //carga desde sql ww.Conexion = SiaWin.Func.DatosEmp(idemp); ww.idEmp = idemp; ww.idBod = tx_bodega.Text; ww.UltBusqueda = ""; ww.ShowInTaskbar = false; ww.Owner = Application.Current.MainWindow; ww.WindowStartupLocation = WindowStartupLocation.CenterScreen; ww.Height = 400; ww.ShowDialog(); string code = ww.Codigo; if (string.IsNullOrEmpty(code)) { return; } var func = refe(code); reflector.SetValue(rowData, "cod_ref", func.Item2.Rows[0]["cod_ref"].ToString().Trim()); reflector.SetValue(rowData, "nom_ref", func.Item2.Rows[0]["nom_ref"].ToString().Trim()); double getCant = 1; if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) { reflector.SetValue(rowData, "cantidad", 1); } double saldoin = Convert.ToDouble(SiaWin.Func.SaldoInv(func.Item2.Rows[0]["cod_ref"].ToString().Trim(), tx_bodega.Text, cod_empresa)); reflector.SetValue(rowData, "saldo", saldoin); double fal = saldoin - getCant; reflector.SetValue(rowData, "faltantes", fal >= 0 ? 0 : fal); reflector.SetValue(rowData, "val_ref", Convert.ToDouble(func.Item2.Rows[0]["val_ref"].ToString())); double sub = Convert.ToDouble(func.Item2.Rows[0]["val_ref"]) * getCant; reflector.SetValue(rowData, "subtotal", sub); GridConfig.UpdateDataRow(columnIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; } } } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("QQQ:" + w); } }
private void GridConfig_PreviewKeyDown(object sender, KeyEventArgs e) { try { GridColumn Colum = ((SfDataGrid)sender).CurrentColumn as GridColumn; if (Colum.MappingName == "cod_ref") { if ((e.Key == Key.Enter || e.Key == Key.F8)) { if (GridConfig.SelectedIndex == -1) { this.GridConfig.SelectionController.CurrentCellManager.BeginEdit(); } dynamic ww = SiaWin.WindowExt(9326, "InBuscarReferencia"); //carga desde sql ww.Conexion = SiaWin.Func.DatosEmp(idemp); ww.idEmp = idemp; ww.idBod = tx_bodega.Text; ww.UltBusqueda = ""; ww.ShowInTaskbar = false; ww.Owner = Application.Current.MainWindow; ww.WindowStartupLocation = WindowStartupLocation.CenterScreen; ww.Height = 400; ww.ShowDialog(); string code = ww.Codigo; if (!string.IsNullOrEmpty(code)) { var func = refe(code); if (func.Item1) { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); int columnIndex = (sender as SfDataGrid).SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex; var rowData = GridConfig.GetRecordAtRowIndex(columnIndex); reflector.SetValue(rowData, "cod_ref", func.Item2.Rows[0]["cod_ref"].ToString().Trim()); reflector.SetValue(rowData, "nom_ref", func.Item2.Rows[0]["nom_ref"].ToString().Trim()); double getCant = 1; if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) { reflector.SetValue(rowData, "cantidad", 1); } getCant = Convert.ToDouble(reflector.GetValue(rowData, "cantidad")); double saldoin = Convert.ToDouble(SiaWin.Func.SaldoInv(func.Item2.Rows[0]["cod_ref"].ToString().Trim(), tx_bodega.Text, cod_empresa)); reflector.SetValue(rowData, "saldo", saldoin); double fal = saldoin - getCant; reflector.SetValue(rowData, "faltantes", fal >= 0 ? 0 : fal); reflector.SetValue(rowData, "val_ref", Convert.ToDouble(func.Item2.Rows[0]["val_ref"].ToString())); double sub = Convert.ToDouble(func.Item2.Rows[0]["val_ref"]) * getCant; reflector.SetValue(rowData, "subtotal", sub); GridConfig.UpdateDataRow(columnIndex); GridConfig.UpdateLayout(); GridConfig.Columns["cod_ref"].AllowEditing = true; updateTot(); } } } } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("error en el producto f8:" + w); } }
private void GridConfig_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e) { try { var reflector = this.GridConfig.View.GetPropertyAccessProvider(); //if (GridConfig.View.IsCurrentBeforeFirst == true)return; if (Keyboard.IsKeyDown(Key.Up)) { return; } if (Keyboard.IsKeyDown(Key.Right) || Keyboard.IsKeyDown(Key.Tab) || Keyboard.IsKeyDown(Key.Return) || Keyboard.IsKeyDown(Key.Enter)) { if (GridConfig.View.IsCurrentBeforeFirst == true) { return; } } var rowData = GridConfig.GetRecordAtRowIndex(e.RowColumnIndex.RowIndex); if (DBNull.Value.Equals(reflector.GetValue(rowData, "cod_ref"))) { return; } string refer = reflector.GetValue(rowData, "cod_ref").ToString(); var func = refe(refer); if (func.Item1) { reflector.SetValue(rowData, "nom_ref", func.Item2.Rows[0]["nom_ref"].ToString().Trim()).ToString(); double getCant = 1; if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad"))) { reflector.SetValue(rowData, "cantidad", 1); } getCant = Convert.ToDouble(reflector.GetValue(rowData, "cantidad")); //if (getCant ==0) reflector.SetValue(rowData, "cantidad", 1); double saldoin = Convert.ToDouble(SiaWin.Func.SaldoInv(func.Item2.Rows[0]["cod_ref"].ToString().Trim(), tx_bodega.Text, cod_empresa)); reflector.SetValue(rowData, "saldo", saldoin); double fal = saldoin - getCant; reflector.SetValue(rowData, "faltantes", fal >= 0 ? 0 : fal); reflector.SetValue(rowData, "val_ref", Convert.ToDouble(func.Item2.Rows[0]["val_ref"].ToString())); double sub = Convert.ToDouble(func.Item2.Rows[0]["val_ref"]) * getCant; reflector.SetValue(rowData, "subtotal", sub); GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex); GridConfig.UpdateLayout(); GridConfig.Columns["nom_ref"].AllowEditing = false; GridConfig.Columns["cantidad"].AllowEditing = true; GridConfig.Columns["saldo"].AllowEditing = false; GridConfig.Columns["faltantes"].AllowEditing = false; GridConfig.Columns["val_ref"].AllowEditing = false; GridConfig.Columns["subtotal"].AllowEditing = false; updateTot(); return; } else { reflector.SetValue(rowData, "cod_ref", ""); reflector.SetValue(rowData, "nom_ref", ""); reflector.SetValue(rowData, "cantidad", 0); reflector.SetValue(rowData, "saldo", 0); reflector.SetValue(rowData, "faltantes", 0); reflector.SetValue(rowData, "subtotal", 0); GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex); GridConfig.UpdateLayout(); GridConfig.Columns["nom_ref"].AllowEditing = false; GridConfig.Columns["cantidad"].AllowEditing = true; GridConfig.Columns["saldo"].AllowEditing = false; GridConfig.Columns["faltantes"].AllowEditing = false; GridConfig.Columns["val_ref"].AllowEditing = false; GridConfig.Columns["subtotal"].AllowEditing = false; updateTot(); return; } } catch (Exception w) { SiaWin.Func.SiaExeptionGobal(w); MessageBox.Show("error al editar:" + w); } }