private void movimientosToolStripMenuItem_Click(object sender, EventArgs e)
{
frmStockMov newMDIChild = new frmStockMov();
newMDIChild.MdiParent = this;
newMDIChild.Show();
}
private void btnModifcar_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(articulo) || !string.IsNullOrEmpty(descripcion))
{
MessageBox.Show("Las opciones 'Modificar' y/o 'Borrar' no están disponibles cuando se usaron criterios de búsqueda",
"Trend Gestión", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dsStockMov.Tables[0].Rows.Count == 0)
{
return;
}
if (tipo == "movimientos")
{
frmStockMov frm = new frmStockMov(dsStockMov);
frm.PK = dgvStockMov.CurrentRow.Cells["IdMovMSTK"].Value.ToString();
frm.ShowDialog();
}
else
{
frmStockComp frm = new frmStockComp(dsStockMov);
frm.PK = dgvStockMov.CurrentRow.Cells["IdMovMSTK"].Value.ToString();
frm.ShowDialog();
}
}
public frmArticulos(ref frmStockMov f, DataTable tblArticulos)
{
InitializeComponent();
formStockMov = f;
this.tblArticulos = tblArticulos;
btnBorrar.Enabled = false;
btnEditar.Enabled = false;
btnGenerar.Enabled = false;
}
// Constructor para frmStockMov
public frmProgress(DataSet dt, string origen, string accion, frmStockMov instanciaStockMov)
: this()
{
if (dt.DataSetName == "dsStockMov")
{
this.dsStockMov = dt;
this.origen = origen;
this.accion = accion;
this.instanciaStockMov = instanciaStockMov;
}
}
private void movimientosToolStripMenuItem_Click(object sender, EventArgs e)
{
frmStockMov newMDIChild = new frmStockMov();
newMDIChild.MdiParent = this;
newMDIChild.Show();
}
private void frmStockMov_Load(object sender, EventArgs e)
{
this.CenterToScreen();
this.AutoValidate = System.Windows.Forms.AutoValidate.EnablePreventFocusChange;
instanciaStockMov = this;
grabacionCorrecta = true;
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.CausesValidation = true;
dgvDatos.ShowCellErrors = true;
cargarCombos();
tblArticulos = BL.GetDataBLL.Articulos();
tblArticulos.TableName = "Articulos";
if (PK == "") //registro nuevo
{
tblStockMov = BL.StockMovBLL.GetTablaMov();
tblStockMovDetalle = BL.StockMovBLL.GetTablaDetalle();
tblStockMovDetalle.PrimaryKey = new DataColumn[] { tblStockMovDetalle.Columns["IdMSTKD"] };
dsStockMov = new DataSet();
dsStockMov.DataSetName = "dsStockMov";
dsStockMov.Tables.Add(tblStockMov);
dsStockMov.Tables.Add(tblStockMovDetalle);
viewStockMov = new DataView(tblStockMov);
viewStockMovDetalle = new DataView(tblStockMovDetalle);
lblNro.ForeColor = System.Drawing.Color.DarkRed;
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
lblNro.Text = clave.ToString();
rowView = viewStockMov.AddNew();
rowView["IdMovMSTK"] = clave.ToString();
rowView["FechaMSTK"] = DateTime.Today;
rowView["CompensaMSTK"] = 0;
rowView.EndEdit();
}
else // editar registros
{
tblStockMov = dsStockMov.Tables[0];
tblStockMovDetalle = dsStockMov.Tables[1];
tblStockMovDetalle.PrimaryKey = new DataColumn[] { tblStockMovDetalle.Columns["IdMSTKD"] };
viewStockMov = new DataView(tblStockMov);
viewStockMovDetalle = new DataView(tblStockMovDetalle);
viewStockMov.RowFilter = "IdMovMSTK = '" + PK + "'";
rowView = viewStockMov[0];
viewStockMovDetalle.RowFilter = "IdMovMSTKD = '" + PK + "'";
lblNro.Text = viewStockMov[0]["IdMovMSTK"].ToString();
cmbOrigen.Enabled = false;
cmbDestino.Enabled = false;
dgvDatos.Enabled = true;
cmbOrigen.SelectedIndexChanged -= new EventHandler(this.ValidarOrigenDestino);
cmbDestino.SelectedIndexChanged -= new EventHandler(this.ValidarOrigenDestino);
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
cmbOrigen.DataBindings.Add("SelectedValue", rowView, "OrigenMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
cmbDestino.DataBindings.Add("SelectedValue", rowView, "DestinoMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
rowView.CancelEdit();
bindingSource1.DataSource = viewStockMovDetalle;
// bindingSource1.Sort = "ordenar ASC";
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.AutoGenerateColumns = false;
dgvDatos.DataSource = bindingSource1;
AddColumns();
dgvDatos.Columns["ordenar"].Visible = false;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.EditMode = DataGridViewEditMode.EditOnKeystroke;
dgvDatos.Enabled = false;
btnArticulos.Enabled = false;
this.dgvDatos.RowValidating += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.ValidarFila);
}
// Constructor para frmStockMov
public frmProgress(DataSet dt, string origen, string accion, frmStockMov instanciaStockMov)
: this()
{
if (dt.DataSetName == "dsStockMov")
{
this.dsStockMov = dt;
this.origen = origen;
this.accion = accion;
this.instanciaStockMov = instanciaStockMov;
}
}
private void frmStockMov_Load(object sender, EventArgs e)
{
this.CenterToScreen();
this.AutoValidate = System.Windows.Forms.AutoValidate.EnablePreventFocusChange;
instanciaStockMov = this;
grabacionCorrecta = true;
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.CausesValidation = true;
dgvDatos.ShowCellErrors = true;
cargarCombos();
tblArticulos = BL.GetDataBLL.Articulos();
tblArticulos.TableName = "Articulos";
if (PK == "") //registro nuevo
{
tblStockMov = BL.StockMovBLL.GetTablaMov();
tblStockMovDetalle = BL.StockMovBLL.GetTablaDetalle();
tblStockMovDetalle.PrimaryKey = new DataColumn[] { tblStockMovDetalle.Columns["IdMSTKD"] };
dsStockMov = new DataSet();
dsStockMov.DataSetName = "dsStockMov";
dsStockMov.Tables.Add(tblStockMov);
dsStockMov.Tables.Add(tblStockMovDetalle);
viewStockMov = new DataView(tblStockMov);
viewStockMovDetalle = new DataView(tblStockMovDetalle);
lblNro.ForeColor = System.Drawing.Color.DarkRed;
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
lblNro.Text = clave.ToString();
rowView = viewStockMov.AddNew();
rowView["IdMovMSTK"] = clave.ToString();
rowView["FechaMSTK"] = DateTime.Today;
rowView["CompensaMSTK"] = 0;
rowView.EndEdit();
}
else // editar registros
{
tblStockMov = dsStockMov.Tables[0];
tblStockMovDetalle = dsStockMov.Tables[1];
tblStockMovDetalle.PrimaryKey = new DataColumn[] { tblStockMovDetalle.Columns["IdMSTKD"] };
viewStockMov = new DataView(tblStockMov);
viewStockMovDetalle = new DataView(tblStockMovDetalle);
viewStockMov.RowFilter = "IdMovMSTK = '" + PK + "'";
rowView = viewStockMov[0];
viewStockMovDetalle.RowFilter = "IdMovMSTKD = '" + PK + "'";
lblNro.Text = viewStockMov[0]["IdMovMSTK"].ToString();
cmbOrigen.Enabled = false;
cmbDestino.Enabled = false;
dgvDatos.Enabled = true;
cmbOrigen.SelectedIndexChanged -= new EventHandler(this.ValidarOrigenDestino);
cmbDestino.SelectedIndexChanged -= new EventHandler(this.ValidarOrigenDestino);
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
cmbOrigen.DataBindings.Add("SelectedValue", rowView, "OrigenMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
cmbDestino.DataBindings.Add("SelectedValue", rowView, "DestinoMSTK", false, DataSourceUpdateMode.OnPropertyChanged);
rowView.CancelEdit();
bindingSource1.DataSource = viewStockMovDetalle;
// bindingSource1.Sort = "ordenar ASC";
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.AutoGenerateColumns = false;
dgvDatos.DataSource = bindingSource1;
AddColumns();
dgvDatos.Columns["ordenar"].Visible = false;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.EditMode = DataGridViewEditMode.EditOnKeystroke;
dgvDatos.Enabled = false;
btnArticulos.Enabled = false;
this.dgvDatos.RowValidating += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.ValidarFila);
}
private void btnModifcar_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(articulo) || !string.IsNullOrEmpty(descripcion))
{
MessageBox.Show("Las opciones 'Modificar' y/o 'Borrar' no están disponibles cuando se usaron criterios de búsqueda",
"Trend Gestión", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dsStockMov.Tables[0].Rows.Count == 0) return;
if (tipo == "movimientos")
{
frmStockMov frm = new frmStockMov(dsStockMov);
frm.PK = dgvStockMov.CurrentRow.Cells["IdMovMSTK"].Value.ToString();
frm.ShowDialog();
}
else
{
frmStockComp frm = new frmStockComp(dsStockMov);
frm.PK = dgvStockMov.CurrentRow.Cells["IdMovMSTK"].Value.ToString();
frm.ShowDialog();
}
}
