private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
if (ValAdd == false)
{
ValAdd = true;
//***************
if (Permiso != 3)
{
ValAdd = true;
AccionesNavigator(1);
ClsKit cont = (ClsKit)ClsBindingKit.Current;
ClsBindingKit.ResetBindings(false);
textBox2.Enabled = false;
}
else
{
MessageBox.Show("No Tiene los privilegios que le \n Permitan Agregar Registros", "AVISO", MessageBoxButtons.OK, MessageBoxIcon.Stop);
AccionCancelar();
//Llenamos de nuevo el Grid de Articulos que contiene el Kit
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
}
//*****************
}
}
public FrmKit(int _Permiso)
{
InitializeComponent();
try
{
Permiso = _Permiso;
BKit = ClsKit.BuscaKit(0, 0, "");
this.ClsBindingKit.DataSource = BKit;
// ClsKit CK = new ClsKit();
// CK.IdArticulo = 0;
//Borro el grid.
// ClsKit.DeleteartKit(CK);
if (BKit.Count == 0)
{
ClsKit cont = new ClsKit();
BKit.Add(cont);
ClsBindingKit.DataSource = BKit;
ClsBindingKit.ResetBindings(false);
AccionesNavigator(1);
}
else
{
AccionesNavigator(0);
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void ultraGrid2_AfterCellUpdate(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
{
int col = 0;
string Columna = "";
// e.Cell.Row.Cells.GetItem(0);
//char.IsNumber
//int x=0;
//for ( x=0;x<e.Cell.Value.ToString().Length;x++ )
// //e.Cell.Value.ToString()
//{
// char.IsNumber(e.Cell.Value.ToString().Substring(x, 1));
//}
if (e.Cell.Column.Key.ToString().ToUpper() == "CANTIDAD")
{
if (Entra > 0)
{
//e.Cell.Value = "";
e.Cell.Value = "";
MessageBox.Show("No puede actualizar los datos...");
return;
}
}
Columna = e.Cell.Column.Key.ToString().ToUpper();
foreach (Infragistics.Win.UltraWinGrid.UltraGridRow Rn in ultraGrid2.Rows)
{
if (Rn.Cells[0].Value.ToString() != "" && Rn.Cells[1].Value.ToString() != "" && Rn.Cells[2].Value.ToString() != "" && Rn.Cells[3].Value.ToString() != "" && Rn.Cells[4].Value.ToString() != "")
{
ClsKit.AddNewRowArtKitMan(1, Convert.ToInt32(Rn.Cells[0].Value), Convert.ToString(Rn.Cells[1].Value).ToUpper(), Convert.ToString(Rn.Cells[2].Value).ToUpper(), Convert.ToInt32(Rn.Cells[3].Value), Convert.ToDouble(Rn.Cells[4].Value));
}
}
if (Columna == "PRECIOU")
{
ClsKit.AddNewRowArtKitMan(3, 0, "", "", 0, 0);
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
int rows = 0;
rows = ultraGrid2.Rows.Count;
ultraGrid2.Rows[rows - 1].Cells[1].Activated = true;
//e.Cell.Activated = true;
}
}
private void BindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
//preguntarle al pakito que pex
//por que no tenia validado esto
//
try
{
if (Permiso != 1)
{
ClsKit ClKA = new ClsKit();
ClKA.IdArticulo = 0;
MessageBox.Show("No Tiene los privilegios que le \n Permitan Eliminar Registros", "AVISO", MessageBoxButtons.OK, MessageBoxIcon.Stop);
//Borro tabla temporal
ClsKit.DeleteartKit(ClKA);
//Cargo los datos a la tabla temporal
ClKA.IdArticulo = 0;
ClKA.Articulo = "";
ClKA.Descripcion = "";
ClKA.Cantidad = 0;
ClKA.PrecioU = 0;
ClsKit.AddArtKit(ClKA, 2, Convert.ToInt32(this.textBox2.Text.Trim()));
//Cargo grid
ListKit = ClsKit.BuscaArti_Kit(Convert.ToInt32(this.textBox2.Text.Trim()));
ultraGrid2.DataSource = ListKit;
return;
}
DialogResult dr =
MessageBox.Show("Estas seguro de borrar el Registro ",
"AVISO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
ClsKit CA = (ClsKit)ClsBindingKit.Current;
//CA.Status = 0;
//ClsKit.DeleteartKit(CA);
ClsKit.DeleteKit(Convert.ToInt32(this.textBox2.Text.Trim()));
ClsBindingKit.RemoveCurrent();
MessageBox.Show("Registro Eliminado Satisfactoriamente...", "I n f o r m a c i ó n", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (ListKit.Count == 0)
{
AccionesNavigator(0);
}
}
catch (Exception Ex) { MessageBox.Show(Ex.Message); }
}
private void FrmKit_Load(object sender, EventArgs e)
{
//Cargo los datos a la tabla temporal
ClsKit CK = new ClsKit();
CK.IdArticulo = 0;
CK.Articulo = "";
CK.Descripcion = "";
CK.Cantidad = 0;
CK.PrecioU = 0;
ClsKit.AddArtKit(CK, 2, Convert.ToInt32(this.textBox2.Text.Trim()));
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
//Cargo de nuevo el grid
ultraGrid1.DataBind();
ListKit = ClsKit.BuscaArti_Kit(Convert.ToInt32(this.textBox2.Text.Trim()));
ultraGrid2.DataSource = ListKit;
//Cargo los datos a la tabla temporal
ClsKit CK = new ClsKit();
ClsKit.AddArtKit(CK, 2, Convert.ToInt32(this.textBox2.Text.Trim()));
}
private void button1_Click(object sender, EventArgs e)
{
ClsKit CK = new ClsKit();
CK.IdArticulo = 0;
//Borro el grid.
ClsKit.DeleteartKit(CK);
//Cargo de nuevo el grid.
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
//Cierro la forma.
this.Close();
}
//OPCIÓN CANCELAR
private void AccionCancelar()
{
ValAdd = false;
ClsBindingKit.Position = ClsBindingKit.Count;
ClsBindingKit.RemoveCurrent();
ClsBindingKit.ResetBindings(false);
if (BKit.Count == 0)
{
ClsKit cont = new ClsKit();
BKit.Add(cont);
//LArticulo.Add(cont);
ClsBindingKit.DataSource = BKit;
ClsBindingKit.ResetBindings(false);
AccionesNavigator(1);
}
else
{
AccionesNavigator(0);
}
}
private void btnAgregar_Click(object sender, EventArgs e)
{
ClsKit CK = new ClsKit();
try
{
if (ultraGrid1.Rows.Count == 0)
{
MessageBox.Show("Debe seleccionar articulos para agregar...", "MENSAJE DEL SISTEMA", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
foreach (Infragistics.Win.UltraWinGrid.UltraGridRow Rn in ultraGrid1.Rows)
{
if (Rn.Cells[9].Value != "" && Rn.Cells[9].Value != null && Rn.Cells[9].Text != "")
{
//table.Rows.Add(Rn.Cells[0].Value, Rn.Cells[1].Value, Rn.Cells[2].Value, Rn.Cells[3].Value, Rn.Cells[9].Value);
//ClsBindingArti.DataSource = table;
CK.IdArticulo = Convert.ToInt32(Rn.Cells[0].Value);
CK.Articulo = Convert.ToString(Rn.Cells[1].Value);
CK.Descripcion = Convert.ToString(Rn.Cells[2].Value);
CK.Cantidad = Convert.ToDouble(Rn.Cells[9].Value);
CK.PrecioU = Convert.ToDouble(Rn.Cells[3].Value);
ClsKit.AddArtKit(CK, 1, 0);
}
}
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
}
catch (Exception EX)
{
MessageBox.Show(EX.Message, "AVISO");
}
}
private void ultraGrid2_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
{
try
{
ClsKit CK = new ClsKit();
int Ren;
string Articulo = "";
Ren = Convert.ToInt32(e.Row.Cells[0].Text);
Articulo = Convert.ToString(e.Row.Cells[1].Text);
if (e.Row.Cells[7].Activated == true)
{
CK.IdArticulo = Ren;
CK.Articulo = Articulo;
DialogResult dr =
MessageBox.Show("Estas seguro de borrar el Articulo: " + CK.Articulo,
"AVISO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
//Borro el articulo seleccionado
ClsKit.DeleteartKit(CK);
//Llenamos de nuevo el Grid de Articulos que contiene el Kit
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
}
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (_Origen == "O")
{
LObra = ClsTraspaso.BuscaObra(1, 1, this.txtDatos.Text.Trim());
//this.clsObraBindig.DataSource = LObra;
this.clsbindingBuscar.DataSource = LObra;
this.ultraGrid1.Rows.ColumnFilters[13].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[14].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[15].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[16].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[0].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[1].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[2].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[3].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[4].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[5].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[6].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[9].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[10].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[11].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[12].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[17].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[18].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[7].Column.Header.Caption = "Clave";
this.ultraGrid1.Rows.ColumnFilters[8].Column.Header.Caption = "Vivienda";
this.ultraGrid1.Rows.ColumnFilters[7].Column.Width = 55;
this.ultraGrid1.Rows.ColumnFilters[8].Column.Width = 415;
}
if (_Origen == "P")
{
LObra = ClsTraspaso.BuscaProveedor(this.txtDatos.Text.Trim());
this.clsbindingBuscar.DataSource = LObra;
this.ultraGrid1.Rows.ColumnFilters[15].Column.Width = 55;
this.ultraGrid1.Rows.ColumnFilters[16].Column.Width = 415;
this.ultraGrid1.Rows.ColumnFilters[15].Column.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
this.ultraGrid1.Rows.ColumnFilters[16].Column.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
this.ultraGrid1.Rows.ColumnFilters[15].Column.Header.Caption = "Clave";
this.ultraGrid1.Rows.ColumnFilters[16].Column.Header.Caption = "Proveedor";
this.ultraGrid1.Rows.ColumnFilters[0].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[1].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[2].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[3].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[4].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[5].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[6].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[7].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[8].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[9].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[10].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[11].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[12].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[13].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[14].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[17].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[18].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[16].Column.Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Left;
}
if (_Origen == "T")
{
LObra = ClsTraspaso.BuscaObra(1, 1, this.txtDatos.Text.Trim());
this.clsbindingBuscar.DataSource = LObra;
this.ultraGrid1.Rows.ColumnFilters[15].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[16].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[17].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[18].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[0].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[1].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[2].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[3].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[4].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[5].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[6].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[14].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[13].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[12].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[11].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[10].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[9].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[7].Column.Width = 55;
this.ultraGrid1.Rows.ColumnFilters[8].Column.Width = 415;
this.ultraGrid1.Rows.ColumnFilters[7].Column.Header.Caption = "Clave";
this.ultraGrid1.Rows.ColumnFilters[8].Column.Header.Caption = "Vivienda";
}
if (_Origen == "A")
{
LKit = ClsKit.BuscaKit(3, 0, this.txtDatos.Text.Trim());
this.clsbindingBuscar.DataSource = LKit;
this.ultraGrid1.Rows.ColumnFilters[5].Column.Width = 55;
this.ultraGrid1.Rows.ColumnFilters[6].Column.Width = 415;
this.ultraGrid1.Rows.ColumnFilters[5].Column.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
this.ultraGrid1.Rows.ColumnFilters[6].Column.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
this.ultraGrid1.Rows.ColumnFilters[2].Column.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
this.ultraGrid1.Rows.ColumnFilters[0].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[1].Column.Hidden = true;
//this.ultraGrid1.Rows.ColumnFilters[2].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[3].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[4].Column.Hidden = true;
this.ultraGrid1.Rows.ColumnFilters[5].Column.Header.Caption = "Clave";
this.ultraGrid1.Rows.ColumnFilters[6].Column.Header.Caption = "Nombre Kit";
this.ultraGrid1.Rows.ColumnFilters[2].Column.Header.VisiblePosition = 7;
this.ultraGrid1.Rows.ColumnFilters[2].Column.Header.Caption = "Precio U.";
}
}
private void btnMas_Click(object sender, EventArgs e)
{
ClsKit.AddNewRowArtKitMan(3, 0, "", "", 0, 0);
ListKit = ClsKit.ListArtKit();
ultraGrid2.DataSource = ListKit;
}
private void BindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("Falta capturar el nombre del Kit...", "MENSAJE DEL SISTEMA", MessageBoxButtons.OK); this.textBox1.Focus();
}
this.BindingNavigator.Focus();
ClsKit CK = (ClsKit)ClsBindingKit.Current;
CK.NomKit = this.textBox1.Text.Trim();
if (CK.IdKit == 0) //Nuevo
{
if (Permiso == 3)
{
ClsKit ClKA = new ClsKit();
ClKA.IdArticulo = 0;
MessageBox.Show("No Tiene los privilegios que le \n Permitan Agregar Registros", "AVISO", MessageBoxButtons.OK, MessageBoxIcon.Stop);
//Borro tabla temporal
ClsKit.DeleteartKit(ClKA);
//Cargo los datos a la tabla temporal
ClKA.IdArticulo = 0;
ClKA.Articulo = "";
ClKA.Descripcion = "";
ClKA.Cantidad = 0;
ClKA.PrecioU = 0;
ClsKit.AddArtKit(ClKA, 2, Convert.ToInt32(this.textBox2.Text.Trim()));
ListKit = ClsKit.BuscaArti_Kit(Convert.ToInt32(this.textBox2.Text.Trim()));
ultraGrid2.DataSource = ListKit;
AccionesNavigator(0);
return;
}
ClsKit.AddKit(CK);
ClsKit.AddArti_Kit(CK, 2, 0);
MessageBox.Show("Registro agregado Satisfactoriamente...", "I n f o r m a c i ó n", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else //Modificacion
{
if (Permiso != 1)
{
ClsKit ClKA = new ClsKit();
ClKA.IdArticulo = 0;
MessageBox.Show("No Tiene los privilegios que le \n Permitan Modificar Registros", "AVISO", MessageBoxButtons.OK, MessageBoxIcon.Stop);
//Borro tabla temporal
ClsKit.DeleteartKit(ClKA);
//Cargo los datos a la tabla temporal
ClKA.IdArticulo = 0;
ClKA.Articulo = "";
ClKA.Descripcion = "";
ClKA.Cantidad = 0;
ClKA.PrecioU = 0;
ClsKit.AddArtKit(ClKA, 2, Convert.ToInt32(this.textBox2.Text.Trim()));
//Cargo grid
ListKit = ClsKit.BuscaArti_Kit(Convert.ToInt32(this.textBox2.Text.Trim()));
ultraGrid2.DataSource = ListKit;
AccionesNavigator(0);
return;
}
ClsKit.UpdateKit(CK.IdKit, this.textBox1.Text.Trim());
//foreach (Infragistics.Win.UltraWinGrid.UltraGridRow Rn in ultraGrid2.Rows)
//{
// ClsKit.AddNewRowArtKitMan(1, Convert.ToInt32(Rn.Cells[0].Value), Convert.ToString(Rn.Cells[1].Value), Convert.ToString(Rn.Cells[2].Value), Convert.ToInt32(Rn.Cells[3].Value),Convert.ToDouble(Rn.Cells[4].Value));
//}
ClsKit.AddArti_Kit(CK, 3, Convert.ToInt32(this.textBox2.Text.Trim()));
MessageBox.Show("Registro modificado Satisfactoriamente...", "I n f o r m a c i ó n", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
textBox2.Enabled = true;
BKit = ClsKit.BuscaKit(0, 0, "");
this.ClsBindingKit.DataSource = BKit;
AccionesNavigator(0);
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
