private void mapControlToCommandGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
var Cell = mapControlToCommandGrid.Rows[e.RowIndex].Cells[e.ColumnIndex];
var Row = Cell.OwningRow;
var Col = Cell.OwningColumn;
if (Col.IsDataBound && Col.Name == "CatCmdIdColumn")
{
if (mapControlToCommandGrid.CurrentCell.EditType == typeof(DataGridViewComboBoxEditingControl))
{
DataGridViewComboBoxCell cb = (DataGridViewComboBoxCell)mapControlToCommandGrid[e.ColumnIndex, e.RowIndex];
cb.DataSource = catCmdsBindingSource;
}
}
else if (Col.IsDataBound && Col.Name == "midiControlTypeColumn")
{
ControlType ctrlType = (ControlType)Row.Cells["midiControlTypeColumn"].Value;
CatCmd CatCmdValue = (CatCmd)Row.Cells["CatCmdIdColumn"].Value;
var attr = CatCmdDb.Get(CatCmdValue);
if (attr.ControlType != ctrlType)
{
System.Data.DataRowView obj = (System.Data.DataRowView)mapControlToCommandGrid.CurrentRow.DataBoundItem;
obj.BeginEdit();
obj.Row["CatCmdId"] = 0;
obj.EndEdit();
}
}
}
public static void EditarDT(DataRowView vistaFilaActual, Ventas entidad)
{
vistaFilaActual.BeginEdit();
vistaFilaActual["IdPCVEN"] = entidad.IdPc.ToString();
vistaFilaActual["FechaMSTK"] = entidad.Fecha.ToString();
vistaFilaActual["IdClienteVEN"] = entidad.IdCliente.ToString();
vistaFilaActual.EndEdit();
}
private bool UpdateRtInStationHead(DataRowView drInStationHead, DataRow drStationHead, DataRowView drEmp, DateTime detctime, int inOutFlag, string strDirectional)
{
drInStationHead.BeginEdit();
drInStationHead["stationHeadID"] = drStationHead["stationHeadID"];
drInStationHead["CsSetID"] = drEmp["CsSetID"];
drInStationHead["CsTypeID"] = drEmp["CsTypeID"];
drInStationHead["UserID"] = drEmp["UserID"];
drInStationHead["InAntennaPlace"] = drStationHead["StationHeadPlace"];
drInStationHead["InStationHeadTime"] = detctime;
if (inOutFlag == 0)
{
drInStationHead["stationHeadTime"] = detctime;
}
drInStationHead["Directional"] = strDirectional;
drInStationHead["inOutFlag"] = inOutFlag;
drInStationHead.EndEdit();
return UpdateRtInStationHead(drInStationHead);
}
private void ResetForm()
{
if (string.IsNullOrEmpty(PK) && !formClosing)
{
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
lblNro.Text = clave.ToString();
rowView = null;
rowView = viewStockMov.AddNew();
rowView["IdMovMSTK"] = clave.ToString();
rowView["FechaMSTK"] = DateTime.Today;
rowView["OrigenMSTK"] = 1;
rowView["CompensaMSTK"] = 1;
rowView.EndEdit();
dateTimePicker1.DataBindings.Clear();
cmbOrigen.DataBindings.Clear();
cmbDestino.DataBindings.Clear();
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);
cargarCombos();
foreach (DataRow row in tblStockMovDetalle.Rows)
{
row.Delete();
}
tblStockMovDetalle.AcceptChanges();
cmbDestino.Focus();
}
if (!string.IsNullOrEmpty(PK)) Close();
}
private void frmStockMov_Load(object sender, EventArgs e)
{
this.CenterToScreen();
this.AutoValidate = System.Windows.Forms.AutoValidate.EnablePreventFocusChange;
instanciaStockComp = 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["OrigenMSTK"] = 1;
rowView["CompensaMSTK"] = 1;
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;
cmbDestino.SelectedIndexChanged -= new EventHandler(this.validarMaestro);
}
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;
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.AutoGenerateColumns = false;
AddColumns();
dgvDatos.DataSource = bindingSource1;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.EditMode = DataGridViewEditMode.EditOnKeystroke;
dgvDatos.Enabled = false;
cmbOrigen.Visible = false;
btnArticulos.Enabled = false;
this.dgvDatos.RowValidating += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.ValidarFila);
}
private void frmFondoCaja_Load(object sender, EventArgs e)
{
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
#region comboLocal
tblLocales = new DataTable();
DataColumn IdPc = new DataColumn();
IdPc.ColumnName = "IdPc";
tblLocales.Columns.Add(IdPc);
DataColumn NombreLOC = new DataColumn();
NombreLOC.ColumnName = "NombreLOC";
tblLocales.Columns.Add(NombreLOC);
DataRow row = tblLocales.NewRow();
row["IdPc"] = 1;
row["NombreLOC"] = "JESUS MARIA";
tblLocales.Rows.Add(row);
cmbLocal.ValueMember = "IdPC";
cmbLocal.DisplayMember = "NombreLOC";
cmbLocal.DropDownStyle = ComboBoxStyle.DropDownList;
cmbLocal.DataSource = tblLocales;
cmbLocal.SelectedValue = 1;
#endregion
fecha = dateTimePicker1.Value.ToString("yyyy-MM-dd");
dsFondoCaja = BL.FondoCajaBLL.CrearDataset(fecha, 1);
tblFondoCaja = dsFondoCaja.Tables[1];
viewFondoCaja = new DataView(tblFondoCaja);
if (viewFondoCaja.Count == 0)
{
viewFondoCaja.RowStateFilter = DataViewRowState.Added;
Random rand = new Random();
int clave = rand.Next(1, 2000000000);
lblClave.Text = clave.ToString();
lblClave.ForeColor = System.Drawing.Color.DarkRed;
rowView = viewFondoCaja.AddNew();
rowView["IdFondoFONP"] = clave;
rowView["FechaFONP"] = DateTime.Today;
rowView["IdPcFONP"] = 1; // Jesus Maria
rowView["ImporteFONP"] = 0;
rowView.EndEdit();
}
else
{
rowView = viewFondoCaja[0];
}
lblClave.DataBindings.Add("Text", rowView, "IdFondoFONP", false, DataSourceUpdateMode.OnPropertyChanged);
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaFONP", false, DataSourceUpdateMode.OnPropertyChanged);
cmbLocal.DataBindings.Add("SelectedValue", rowView, "IdPcFONP", false, DataSourceUpdateMode.OnPropertyChanged);
txtImporte.DataBindings.Add("Text", rowView, "ImporteFONP", false, DataSourceUpdateMode.OnPropertyChanged);
txtImporte.Focus();
txtImporte.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumerosConComa);
}
private void frmTesoreriaMov_Load(object sender, EventArgs e)
{
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
tblLocales = BL.LocalesBLL.CrearDataset();
viewLocal = new DataView(tblLocales);
viewLocal.RowFilter = "IdLocalLOC = '13'"; // Local 13 es Jesus Maria
lstLocales.ValueMember = "IdLocalLOC";
lstLocales.DisplayMember = "NombreLOC";
lstLocales.DataSource = viewLocal;
tblPcs = BL.PcsBLL.CrearDataset();
string local = lstLocales.SelectedValue.ToString();
viewPc = new DataView(tblPcs);
viewPc.RowFilter = "IdPC = '1'"; // Pc 1 es caja1 de Jesus Maria
viewPc.Sort = "Detalle ASC";
lstPc.ValueMember = "IdPC";
lstPc.DisplayMember = "Detalle";
lstPc.DataSource = viewPc;
this.lstLocales.SelectedValueChanged += new System.EventHandler(this.lstLocales_SelectedValueChanged);
dsTesoreriaMov = BL.TesoreriaMovimientosBLL.CrearDataset();
tblTesoreriaMov = dsTesoreriaMov.Tables[0];
viewTesoreria = new DataView(tblTesoreriaMov);
if (PK == "")
{
Random rand = new Random();
int clave = rand.Next(1, 2000000000);
lblClave.Text = clave.ToString();
lblClave.ForeColor = System.Drawing.Color.DarkRed;
viewTesoreria.RowStateFilter = DataViewRowState.Added;
rowView = viewTesoreria.AddNew();
rowView["IdMovTESM"] = clave.ToString();
rowView["FechaTESM"] = DateTime.Today;
rowView["IdPcTESM"] = 1;
rowView.EndEdit();
}
else
{
lstLocales.SelectedValue = idLocal;
lstPc.SelectedValue = idPc;
lblClave.Text = PK;
lblClave.ForeColor = System.Drawing.Color.DarkRed;
viewTesoreria.RowFilter = "IdMovTESM = '" + PK + "'";
rowView = viewTesoreria[0];
txtDetalle.Focus();
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaTESM", false, DataSourceUpdateMode.OnPropertyChanged);
lstPc.DataBindings.Add("SelectedValue", rowView, "IdPcTESM", false, DataSourceUpdateMode.OnPropertyChanged);
txtDetalle.DataBindings.Add("Text", rowView, "DetalleTESM", false, DataSourceUpdateMode.OnPropertyChanged);
txtImporte.DataBindings.Add("Text", rowView, "ImporteTESM", false, DataSourceUpdateMode.OnPropertyChanged);
txtImporte.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumerosConComa);
}
private void frmVentas_Load(object sender, EventArgs e)
{
this.StartPosition = FormStartPosition.CenterScreen;
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
instanciaVentas = this;
this.AutoValidate = System.Windows.Forms.AutoValidate.EnablePreventFocusChange;
this.ControlBox = true;
this.MaximizeBox = false;
this.CancelButton = btnSalir;
btnSalir.Visible = false;
dateTimePicker1.Visible = false;
lblFecha.Text = DateTime.Today.ToLongDateString();
lblTotal.ForeColor = System.Drawing.Color.DarkRed;
ToolTip tooltipClientes = new ToolTip();
tooltipClientes.SetToolTip(btnClientes, "Agregar nuevo cliente");
ToolTip tooltipCupones = new ToolTip();
tooltipCupones.SetToolTip(btnCupon, "Ingresar cupón de descuento");
dsForaneos = BL.VentasBLL.CrearDatasetForaneos();
tblLocales = dsForaneos.Tables[3];
tblPcs = dsForaneos.Tables[4];
CargarComboLocales();
tblArticulos = dsForaneos.Tables[0];
tblArticulos.TableName = "Articulos";
var source = new AutoCompleteStringCollection();
String[] stringArray =
Array.ConvertAll<DataRow, String>(tblArticulos.Select(), delegate(DataRow row) { return (String)row["IdArticuloART"]; });
source.AddRange(stringArray);
txtArticulo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtArticulo.AutoCompleteCustomSource = source;
txtArticulo.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtArticulo.BackColor = Color.White;
txtDescripcion.BackColor = Color.White;
txtDescripcion.TabStop = false;
txtDescripcion.ReadOnly = true;
txtCantidad.BackColor = Color.White;
txtPrecio.BackColor = Color.White;
tblFormasPago = dsForaneos.Tables[2];
tblFormasPago.TableName = "FormasPago";
cmbForma.ValueMember = "IdFormaPagoFOR";
cmbForma.DisplayMember = "DescripcionFOR";
cmbForma.DropDownStyle = ComboBoxStyle.DropDown;
cmbForma.DataSource = tblFormasPago;
cmbForma.SelectedValue = -1;
cmbForma.BackColor = Color.White;
AutoCompleteStringCollection formasColection = new AutoCompleteStringCollection();
foreach (DataRow row in tblFormasPago.Rows)
{
formasColection.Add(Convert.ToString(row["DescripcionFOR"]));
}
cmbForma.AutoCompleteCustomSource = formasColection;
cmbForma.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbForma.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtCosto.Visible = false;
grpInicial.CausesValidation = false;
grpBotonera.CausesValidation = false;
btnClientes.CausesValidation = false;
btnCupon.CausesValidation = false;
btnEditar.CausesValidation = false;
btnBorrar.CausesValidation = false;
btnArticulos.CausesValidation = false;
lblNro.ForeColor = System.Drawing.Color.DarkRed;
dsVentas = new DataSet();
dsVentas.DataSetName = "dsVentas";
if (tblVentas.DataSet == null)
{
dsVentas.Tables.Add(tblVentas);
dsVentas.Tables.Add(tblVentasDetalle);
}
tblVentasDetalle.PrimaryKey = new DataColumn[] { tblVentasDetalle.Columns["IdDVEN"] };
viewVentas = new DataView(tblVentas);
viewDetalle = new DataView(tblVentasDetalle);
bindingSource1.DataSource = viewDetalle;
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.ReadOnly = true;
dgvDatos.AllowUserToAddRows = false;
dgvDatos.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvDatos.DataSource = viewDetalle;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.Columns["IdDVEN"].Visible = false;
dgvDatos.Columns["IdVentaDVEN"].Visible = false;
dgvDatos.Columns["IdLocalDVEN"].Visible = false;
dgvDatos.Columns["PrecioCostoDVEN"].Visible = false;
dgvDatos.Columns["PrecioMayorDVEN"].Visible = false;
dgvDatos.Columns["IdFormaPagoDVEN"].Visible = false;
dgvDatos.Columns["NroCuponDVEN"].Visible = false;
dgvDatos.Columns["NroFacturaDVEN"].Visible = false;
dgvDatos.Columns["IdEmpleadoDVEN"].Visible = false;
dgvDatos.Columns["LiquidadoDVEN"].Visible = false;
dgvDatos.Columns["EsperaDVEN"].Visible = false;
dgvDatos.Columns["DescripcionDVEN"].HeaderText = "Descripción";
dgvDatos.Columns["CantidadDVEN"].Width = 55;
dgvDatos.Columns["CantidadDVEN"].HeaderText = "Cantidad";
dgvDatos.Columns["IdArticuloDVEN"].HeaderText = "Artículo";
dgvDatos.Columns["PrecioPublicoDVEN"].Width = 100;
dgvDatos.Columns["PrecioPublicoDVEN"].HeaderText = "Precio";
dgvDatos.Columns["NroFacturaDVEN"].Width = 100;
dgvDatos.Columns["NroFacturaDVEN"].HeaderText = "Nº fact.";
dgvDatos.Columns.Remove("DevolucionDVEN");
dgvDatos.Columns.Remove("IdFormaPagoDVEN");
cmbFormaPago = new DataGridViewComboBoxColumn();
cmbFormaPago.Name = "FormaPago";
cmbFormaPago.HeaderText = "Forma de pago";
cmbFormaPago.DataSource = tblFormasPago;
cmbFormaPago.ValueMember = "IdFormaPagoFOR";
cmbFormaPago.DisplayMember = "DescripcionFOR";
cmbFormaPago.DataPropertyName = "IdFormaPagoDVEN";
dgvDatos.Columns.Insert(7, cmbFormaPago);
chkDevolucion = new DataGridViewCheckBoxColumn();
chkDevolucion.Name = "DevolucionDVEN";
chkDevolucion.Width = 40;
chkDevolucion.HeaderText = "Dev.";
chkDevolucion.DataPropertyName = "DevolucionDVEN";
chkDevolucion.TrueValue = 1;
chkDevolucion.FalseValue = 0;
dgvDatos.Columns.Insert(12, chkDevolucion);
if (PK == "") //registro nuevo
{
tblVentas.PrimaryKey = new DataColumn[] { tblVentas.Columns["IdVentaVEN"] };
tblDetalleOriginal = tblVentasDetalle.Copy(); //tblDetalleOriginal se usa para controlar errores de guardado remoto por falta de internet
Random rand = new Random();
int clave = rand.Next(1, 2000000000);
bool existe = true;
while (existe == true)
{
DataRow foundRow = dsVentas.Tables["Ventas"].Rows.Find(clave);
if (foundRow == null)
{
existe = false;
}
else
{
clave = rand.Next(1, 2000000000);
}
}
lblNro.Text = clave.ToString();
viewVentas.RowStateFilter = DataViewRowState.Added;
viewDetalle.RowStateFilter = DataViewRowState.Added;
rowView = viewVentas.AddNew();
rowView["IdVentaVEN"] = clave.ToString();
rowView["FechaVEN"] = DateTime.Now;
rowView["IdPCVEN"] = 1;
rowView["NroCuponVEN"] = "00000000000";
rowView.EndEdit();
}
else // editar registros
{
tblDetalleOriginal = tblVentasDetalle.Copy(); //tblDetalleOriginal se usa para controlar errores de guardado remoto por falta de internet
viewVentas.RowFilter = "IdVentaVEN = '" + PK + "'";
rowView = viewVentas[0];
viewDetalle.RowFilter = "IdVentaDVEN = '" + PK + "'";
lblNro.Text = viewVentas[0][0].ToString();
cmbLocal.Enabled = false;
// viewDetalleOriginal se usa para registrar en tabla fallidas errores de guardado remoto por falta de internet
viewDetalleOriginal = new DataView(tblDetalleOriginal);
viewDetalleOriginal.RowFilter = "IdVentaDVEN = '" + PK + "'";
lblTotal.Text = "$" + CalcularTotalOk().ToString();
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaVEN", false, DataSourceUpdateMode.OnPropertyChanged);
cmbLocal.DataBindings.Add("SelectedValue", rowView, "IdPCVEN", false, DataSourceUpdateMode.OnPropertyChanged);
cmbCliente.DataBindings.Add("SelectedValue", rowView, "IdClienteVEN", false, DataSourceUpdateMode.OnPropertyChanged);
txtCupon.DataBindings.Add("Text", rowView, "NroCuponVEN", false, DataSourceUpdateMode.OnPropertyChanged);
rowView.CancelEdit();
cmbCliente.Validating += new System.ComponentModel.CancelEventHandler(BL.Utilitarios.ValidarComboBox);
txtPrecio.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumerosConComa);
txtCantidad.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumeros);
txtArticulo.Enter += new System.EventHandler(Utilitarios.SelTextoTextBox);
txtCantidad.Enter += new System.EventHandler(Utilitarios.SelTextoTextBox);
txtPrecio.Enter += new System.EventHandler(Utilitarios.SelTextoTextBox);
txtArticulo.KeyDown += new System.Windows.Forms.KeyEventHandler(Utilitarios.EnterTab);
txtCantidad.KeyDown += new System.Windows.Forms.KeyEventHandler(Utilitarios.EnterTab);
txtPrecio.KeyDown += new System.Windows.Forms.KeyEventHandler(Utilitarios.EnterTab);
cmbForma.KeyDown += new System.Windows.Forms.KeyEventHandler(Utilitarios.EnterTab);
cmbForma.Validating += new System.ComponentModel.CancelEventHandler(BL.Utilitarios.ValidarComboBox);
chkDev.KeyDown += new System.Windows.Forms.KeyEventHandler(Utilitarios.EnterTab);
if (!string.IsNullOrEmpty(PK)) //registro nuevo
{
tblVentas.AcceptChanges();
tblVentasDetalle.AcceptChanges();
}
SetStateForm(FormState.insercion);
}
private void frmFondoCaja_Load(object sender, EventArgs e)
{
this.Location = new Point(50, 50);
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
tblLocales = BL.GetDataBLL.Locales();
viewLocal = new DataView(tblLocales);
viewLocal.RowFilter = "IdLocalLOC <>'1' AND IdLocalLOC <>'2' AND IdLocalLOC <>'11' AND IdLocalLOC <>'12'";
lstLocales.ValueMember = "IdLocalLOC";
lstLocales.DisplayMember = "NombreLOC";
lstLocales.DataSource = viewLocal;
tblPcs = BL.GetDataBLL.Pc();
string local = lstLocales.SelectedValue.ToString();
viewPc = new DataView(tblPcs);
viewPc.RowFilter = "IdLocalPC = '" + local + "'";
viewPc.Sort = "Detalle ASC";
lstPc.ValueMember = "IdPC";
lstPc.DisplayMember = "Detalle";
lstPc.DataSource = viewPc;
viewFondoCaja = new DataView(tblFondoCaja);
if (tblFondoCaja.Rows.Count == 0)
{
rowView = viewFondoCaja.AddNew();
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
rowView["IdFondoFONP"] = clave;
rowView["FechaFONP"] = DateTime.Today;
rowView.EndEdit();
}
else
{
viewFondoCaja.RowFilter = "IdFondoFONP = '" + PK + "'";
rowView = viewFondoCaja[0];
lstLocales.SelectedValue = rowView["IdLocalLOC"];
lstPc.SelectedValue = rowView["IdPcFONP"];
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaFONP", false, DataSourceUpdateMode.OnPropertyChanged);
lstPc.DataBindings.Add("SelectedValue", rowView, "IdPcFONP", false, DataSourceUpdateMode.OnPropertyChanged);
txtImporte.DataBindings.Add("Text", rowView, "ImporteFONP", false, DataSourceUpdateMode.OnPropertyChanged);
if (lstPc.Items.Count > 0) lstPc.SetSelected(0, true);
this.lstLocales.SelectedValueChanged += new System.EventHandler(this.lstLocales_SelectedValueChanged);
this.AcceptButton = btnAceptar;
txtImporte.Focus();
}
private void frmProgress_FormClosed(object sender, FormClosedEventArgs e)
{
if (!grabacionCorrecta)
{
tblStockMovDetalle.RejectChanges();
Close();
return;
}
if (string.IsNullOrEmpty(PK) && !formClosing)
{
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
lblNro.Text = clave.ToString();
rowView = null;
rowView = viewStockMov.AddNew();
rowView["IdMovMSTK"] = clave.ToString();
rowView["FechaMSTK"] = DateTime.Today;
rowView["OrigenMSTK"] = -1;
rowView["DestinoMSTK"] = -1;
rowView["CompensaMSTK"] = 0;
rowView.EndEdit();
dateTimePicker1.DataBindings.Clear();
cmbOrigen.DataBindings.Clear();
cmbDestino.DataBindings.Clear();
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);
cmbOrigen.SelectedIndexChanged -= new EventHandler(ValidarOrigenDestino);
cmbDestino.SelectedIndexChanged -= new EventHandler(ValidarOrigenDestino);
cargarCombos();
foreach (DataRow row in tblStockMovDetalle.Rows)
{
row.Delete();
}
tblStockMovDetalle.AcceptChanges();
cmbOrigen.Focus();
cmbOrigen.DroppedDown = true;
}
if (!string.IsNullOrEmpty(PK)) Close();
}
/// <summary>
/// Запускает форму для редактирования строки.
/// </summary>
/// <param name="source"></param>
private void EditRow(DataRowView source)
{
source.BeginEdit();
Editor.ReBindControlsToDataRow(source);
if (Editor.ShowDialog() == DialogResult.OK)
{
source.EndEdit();
}
else
{
source.CancelEdit();
}
}
private void frmVentas_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencyDecimalSeparator = ",";
System.Globalization.CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator = ",";
this.CenterToScreen();
instanciaVentas = this;
this.AutoValidate = System.Windows.Forms.AutoValidate.EnablePreventFocusChange;
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
CargarComboLocales();
grpABM.Enabled = false;
tblArticulos = BL.GetDataBLL.Articulos();
tblArticulos.TableName = "Articulos";
var source = new AutoCompleteStringCollection();
String[] stringArray =
Array.ConvertAll<DataRow, String>(tblArticulos.Select(), delegate(DataRow row) { return (String)row["IdArticuloART"]; });
source.AddRange(stringArray);
txtArticulo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtArticulo.AutoCompleteCustomSource = source;
txtArticulo.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtArticulo.BackColor = Color.White;
txtDescripcion.BackColor = Color.White;
txtDescripcion.TabStop = false;
txtDescripcion.ReadOnly = true;
txtCantidad.BackColor = Color.White;
txtPrecio.BackColor = Color.White;
tblFormasPago = BL.GetDataBLL.FormasPago();
cmbForma.ValueMember = "IdFormaPagoFOR";
cmbForma.DisplayMember = "DescripcionFOR";
cmbForma.DropDownStyle = ComboBoxStyle.DropDown;
cmbForma.DataSource = tblFormasPago;
cmbForma.SelectedValue = -1;
cmbForma.BackColor = Color.White;
AutoCompleteStringCollection formasPagoColection = new AutoCompleteStringCollection();
foreach (DataRow row in tblFormasPago.Rows)
{
formasPagoColection.Add(Convert.ToString(row["DescripcionFOR"]));
}
cmbForma.AutoCompleteCustomSource = formasPagoColection;
cmbForma.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbForma.AutoCompleteSource = AutoCompleteSource.CustomSource;
cmbForma.Validating += new System.ComponentModel.CancelEventHandler(BL.Utilitarios.ValidarComboBox);
lblCosto.Visible = false;
txtCosto.Visible = false;
grpVentas.CausesValidation = false;
dateTimePicker1.CausesValidation = false;
cmbLocal.CausesValidation = false;
cmbCliente.CausesValidation = false;
btnClientes.CausesValidation = false;
btnEditar.CausesValidation = false;
btnBorrar.CausesValidation = false;
btnArticulos.CausesValidation = false;
dsVentas = new DataSet();
dsVentas.DataSetName = "dsVentas";
if (tblVentas.DataSet == null)
{
dsVentas.Tables.Add(tblVentas);
dsVentas.Tables.Add(tblVentasDetalle);
}
tblVentasDetalle.PrimaryKey = new DataColumn[] { tblVentasDetalle.Columns["IdDVEN"] };
viewVentas = new DataView(tblVentas);
viewDetalle = new DataView(tblVentasDetalle);
viewDetalle.Sort = "OrdenarDVEN ASC";
bindingSource1.DataSource = viewDetalle;
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.ReadOnly = true;
dgvDatos.AllowUserToAddRows = false;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.DataSource = bindingSource1;
dgvDatos.Columns["IdDVEN"].Visible = false;
dgvDatos.Columns["IdVentaDVEN"].Visible = false;
dgvDatos.Columns["IdLocalDVEN"].Visible = false;
dgvDatos.Columns["PrecioCostoDVEN"].Visible = false;
dgvDatos.Columns["PrecioMayorDVEN"].Visible = false;
dgvDatos.Columns["IdFormaPagoDVEN"].Visible = false;
dgvDatos.Columns["NroCuponDVEN"].Visible = false;
dgvDatos.Columns["IdEmpleadoDVEN"].Visible = false;
dgvDatos.Columns["LiquidadoDVEN"].Visible = false;
dgvDatos.Columns["EsperaDVEN"].Visible = false;
dgvDatos.Columns["OrdenarDVEN"].Visible = false;
dgvDatos.Columns["CantidadDVEN"].Width = 55;
dgvDatos.Columns["CantidadDVEN"].HeaderText = "Cantidad";
dgvDatos.Columns["IdArticuloDVEN"].HeaderText = "Artículo";
dgvDatos.Columns["DescripcionDVEN"].HeaderText = "Descripción";
dgvDatos.Columns["PrecioPublicoDVEN"].Width = 100;
dgvDatos.Columns["PrecioPublicoDVEN"].HeaderText = "Precio";
dgvDatos.Columns["PrecioPublicoDVEN"].DefaultCellStyle.Format = "C2";
dgvDatos.Columns["NroFacturaDVEN"].Width = 100;
dgvDatos.Columns["NroFacturaDVEN"].HeaderText = "Nº fact.";
dgvDatos.Columns.Remove("DevolucionDVEN");
dgvDatos.Columns.Remove("IdFormaPagoDVEN");
DataGridViewComboBoxColumn cmbFormaPago = new DataGridViewComboBoxColumn();
cmbFormaPago.Name = "FormaPago";
cmbFormaPago.HeaderText = "Forma de pago";
cmbFormaPago.DataSource = tblFormasPago;
cmbFormaPago.ValueMember = "IdFormaPagoFOR";
cmbFormaPago.DisplayMember = "DescripcionFOR";
cmbFormaPago.DataPropertyName = "IdFormaPagoDVEN";
dgvDatos.Columns.Insert(7, cmbFormaPago);
DataGridViewCheckBoxColumn chkDevolucion = new DataGridViewCheckBoxColumn();
chkDevolucion.Name = "DevolucionDVEN";
chkDevolucion.Width = 40;
chkDevolucion.HeaderText = "Dev.";
chkDevolucion.DataPropertyName = "DevolucionDVEN";
chkDevolucion.TrueValue = 1;
chkDevolucion.FalseValue = 0;
dgvDatos.Columns.Insert(12, chkDevolucion);
dgvDatos.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
lblTotal.Text = "$ 0";
if (PK == "") //registro nuevo
{
lblNro.ForeColor = System.Drawing.Color.DarkRed;
Random rand = new Random();
int clave = rand.Next(-2000000000, 2000000000);
lblNro.Text = clave.ToString();
rowView = viewVentas.AddNew();
rowView["IdVentaVEN"] = clave.ToString();
rowView["FechaVEN"] = dateTimePicker1.Value;
rowView.EndEdit();
// SetStateForm(FormState.inicial);
}
else // editar registros
{
viewVentas.RowFilter = "IdVentaVEN = '" + PK + "'";
rowView = viewVentas[0];
rowView.BeginEdit();
viewDetalle.RowFilter = "IdVentaDVEN = '" + PK + "'";
lblNro.Text = viewVentas[0][0].ToString();
cmbLocal.Enabled = false;
lblTotal.Text = "$ " + CalcularTotal();
dateTimePicker1.TabStop = false;
cmbLocal.TabStop = false;
cmbCliente.Focus();
SetStateForm(FormState.inicial);
}
dateTimePicker1.DataBindings.Add("Text", rowView, "FechaVEN", false, DataSourceUpdateMode.OnPropertyChanged);
cmbLocal.DataBindings.Add("SelectedValue", rowView, "IdPCVEN", false, DataSourceUpdateMode.OnPropertyChanged);
cmbCliente.DataBindings.Add("SelectedValue", rowView, "IdClienteVEN", false, DataSourceUpdateMode.OnPropertyChanged);
rowView.CancelEdit();
ToolTip tooltip = new ToolTip();
tooltip.SetToolTip(btnClientes, "Agregar nuevo cliente");
cmbLocal.SelectedIndexChanged += new EventHandler(this.ValidarMaestro);
cmbCliente.Validating += new System.ComponentModel.CancelEventHandler(BL.Utilitarios.ValidarComboBox);
txtPrecio.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumerosConComa);
txtCantidad.KeyPress += new KeyPressEventHandler(BL.Utilitarios.SoloNumeros);
txtArticulo.Enter += new System.EventHandler(BL.Utilitarios.SelTextoTextBox);
txtCantidad.Enter += new System.EventHandler(BL.Utilitarios.SelTextoTextBox);
txtPrecio.Enter += new System.EventHandler(BL.Utilitarios.SelTextoTextBox);
cmbForma.Enter += new System.EventHandler(BL.Utilitarios.SelTextoTextBox);
txtArticulo.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab);
txtCantidad.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab);
txtPrecio.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab);
cmbForma.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab);
chkDev.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab);
}
private void frmStockMov_Load(object sender, EventArgs e)
{
this.CenterToScreen();
System.Drawing.Icon ico = Properties.Resources.icono_app;
this.Icon = ico;
this.ControlBox = true;
this.MaximizeBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
tblStockMov = BL.StockMovBLL.GetTablaMov();
tblStockMovDetalle = BL.StockMovBLL.GetTablaDetalle();
DataColumn col = new DataColumn();
col.ColumnName = "Precio";
tblStockMovDetalle.Columns.Add(col);
dsStockMov = new DataSet();
dsStockMov.DataSetName = "dsStockMov";
dsStockMov.Tables.Add(tblStockMov);
dsStockMov.Tables.Add(tblStockMovDetalle);
tblStockEntradas = tblStockMov.Clone();
tblEntradasDetalle = tblStockMovDetalle.Clone();
viewStockMov = new DataView(tblStockEntradas);
viewStockMovDetalle = new DataView(tblEntradasDetalle);
lblNro.ForeColor = System.Drawing.Color.DarkRed;
Random rand = new Random();
idMov = rand.Next(-2000000000, 2000000000);
lblNro.Text = idMov.ToString();
viewStockMov.RowStateFilter = DataViewRowState.Added;
rowView = viewStockMov.AddNew();
rowView["IdMovMSTK"] = idMov.ToString();
rowView["OrigenMSTK"] = 1;
rowView["FechaMSTK"] = DateTime.Today;
rowView["CompensaMSTK"] = 0;
rowView.EndEdit();
dgvDatos.Enabled = false;
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;
bindingNavigator1.BindingSource = bindingSource1;
dgvDatos.DataSource = bindingSource1;
dgvDatos.AllowUserToOrderColumns = false;
dgvDatos.EditMode = DataGridViewEditMode.EditOnKeystroke;
dgvDatos.Columns["IdArticuloMSTKD"].HeaderText = "Código";
dgvDatos.Columns["IdArticuloMSTKD"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvDatos.Columns["DescripcionART"].HeaderText = "Descripción";
dgvDatos.Columns["DescripcionART"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvDatos.Columns["IdMovMSTKD"].Visible = false;
dgvDatos.Columns["IdMSTKD"].Visible = false;
dgvDatos.Columns["CompensaMSTKD"].Visible = false;
dgvDatos.Columns["OrigenMSTKD"].Visible = false;
dgvDatos.Columns["DestinoMSTKD"].Visible = false;
dgvDatos.Columns["Precio"].Visible = false;
dgvDatos.Columns["CantidadMSTKD"].Width = 100;
dgvDatos.Columns["CantidadMSTKD"].HeaderText = "Cantidad";
dgvDatos.Columns["CantidadMSTKD"].SortMode = DataGridViewColumnSortMode.NotSortable;
tblArticulos = BL.GetDataBLL.Articulos();
tblArticulos.TableName = "Articulos";
dgvDatos.Columns[3].Width = 500;
dgvDatos.Columns[3].ReadOnly = true;
dgvDatos.Enabled = false;
btnArticulos.Enabled = false;
cmbDestino.Focus();
}
