private void btRemove_Click(object sender, EventArgs e) { if (dgwLine.Rows.Count <= 1) { return; } foreach (DataGridViewRow row in dgwLine.SelectedRows) { if (row.Index == dgwLine.Rows.Count - 1) { continue; } string sStation = row.Cells[0].Value.ToString(); if (MessageBox.Show(string.Format(_gs.ControlGridRows(this.Name, dgwLine, "rest01") + "{0} ?", sStation), "Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { dgwLine.Rows.RemoveAt(row.Index); LineaRampeoLogica line = new LineaRampeoLogica(); line.CN = Globals._gsCompany; line.Estacion = sStation; LineaRampeoLogica.Eliminar(line); } else { continue; } } }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Globals._gsStation = Environment.MachineName.ToUpper(); LineaRampeoLogica line = new LineaRampeoLogica(); line.Estacion = Globals._gsStation; if (LineaRampeoLogica.VerificaCapturaHora(line)) { Application.Run(new wfLineHour()); } else { Application.Run(new wfLayout()); } }
private void btSave_Click(object sender, EventArgs e) { if (dgwLine.Rows.Count <= 1) { return; } Cursor = Cursors.WaitCursor; try { foreach (DataGridViewRow row in dgwLine.Rows) { if (row.Index == dgwLine.Rows.Count - 1) { continue; } string sStation = row.Cells[0].Value.ToString(); string sLine = row.Cells[1].Value.ToString(); decimal dFactor = 0; if (!decimal.TryParse(row.Cells[2].Value.ToString(), out dFactor)) { dFactor = 0; } LineaRampeoLogica line = new LineaRampeoLogica(); line.CN = Globals._gsCompany; line.Estacion = sStation; line.Linea = sLine; line.Factor = dFactor; line.Usuario = Globals._gsUser; LineaRampeoLogica.GuardarSP(line); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } Cursor = Cursors.Default; }
private void Inicio() { //load data try { _lsUsuario = System.Security.Principal.WindowsIdentity.GetCurrent().Name; _lsUsuario = _lsUsuario.Substring(_lsUsuario.IndexOf("\\") + 1).ToUpper(); cbxLang.SelectedIndex = 0; txtJornada.Clear(); txtHrDisp.Clear(); txtHori.Clear(); txtSegDisp.Clear(); txtCajas.Clear(); txtKitCaja.Clear(); txtKits.Clear(); txtTack.Clear(); txtTack80.Clear(); txtAssyTime.Clear(); txtMaxComp.Clear(); txtMesas.Clear(); txtMesaWrap.Clear(); txtMesaSub.Clear(); txtOperNA.Clear(); txtSurtidor.Clear(); txtInspSella.Clear(); txtSellador.Clear(); txtInspec.Clear(); txtVertical.Clear(); txtSobre.Clear(); txtHori.Clear(); txtNA.Clear(); txtTape.Clear(); txtDetroit.Clear(); txtMaxHC.Clear(); txtMinHC.Clear(); txtOutAdd.Clear(); chbBoxHr.Checked = false; chbCycleTimer.Checked = false; chbActive.Checked = false; ConfigLogica con = new ConfigLogica(); con.CN = Globals._gsCompany; DataTable data = ConfigLogica.Consultar(con); if (data.Rows.Count > 0) { if (!string.IsNullOrEmpty(data.Rows[0][1].ToString())) { txtJornada.Text = data.Rows[0][1].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][2].ToString())) { txtHrDisp.Text = data.Rows[0][2].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][3].ToString())) { txtSegDisp.Text = data.Rows[0][3].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][4].ToString())) { txtCajas.Text = data.Rows[0][4].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][5].ToString())) { txtKitCaja.Text = data.Rows[0][5].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][6].ToString())) { txtKits.Text = data.Rows[0][6].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][7].ToString())) { txtTack.Text = data.Rows[0][7].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][8].ToString())) { txtTack80.Text = data.Rows[0][8].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][9].ToString())) { txtAssyTime.Text = data.Rows[0][9].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][10].ToString())) { txtMaxComp.Text = data.Rows[0][10].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][11].ToString())) { txtMesas.Text = data.Rows[0][11].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][12].ToString())) { txtMesaWrap.Text = data.Rows[0][12].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][13].ToString())) { txtMesaSub.Text = data.Rows[0][13].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][14].ToString())) { txtOperNA.Text = data.Rows[0][14].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][15].ToString())) { txtSurtidor.Text = data.Rows[0][15].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][16].ToString())) { txtInspSella.Text = data.Rows[0][16].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][17].ToString())) { txtSellador.Text = data.Rows[0][17].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][18].ToString())) { txtInspec.Text = data.Rows[0][18].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][21].ToString())) { txtHori.Text = data.Rows[0][21].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][22].ToString())) { txtVertical.Text = data.Rows[0][22].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][23].ToString())) { txtSobre.Text = data.Rows[0][23].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][25].ToString())) { txtTape.Text = data.Rows[0][25].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0][24].ToString())) { txtNA.Text = data.Rows[0][24].ToString(); } if (!string.IsNullOrEmpty(data.Rows[0]["detroit"].ToString())) { txtDetroit.Text = data.Rows[0]["detroit"].ToString(); } cbxLang.SelectedValue = data.Rows[0]["lenguage"].ToString(); txtMaxHC.Text = data.Rows[0]["max_hc"].ToString(); txtMinHC.Text = data.Rows[0]["min_hc"].ToString(); txtOutAdd.Text = data.Rows[0]["out_addtime"].ToString(); if (data.Rows[0]["ind_boxhr"].ToString() == "1") { chbBoxHr.Checked = true; } if (data.Rows[0]["cycle_timer"].ToString() == "1") { chbCycleTimer.Checked = true; } if (data.Rows[0]["active"].ToString() == "1") { chbActive.Checked = true; } } LineaRampeoLogica lin = new LineaRampeoLogica(); lin.CN = Globals._gsCompany; dgwLine.DataSource = LineaRampeoLogica.Vista(lin); CargarColumnas(); _gs.ControlGridText(this.Name, dgwLine); Globals gs = new Globals(); gs.ControlText(this.Name, tabPage1); gs.ControlText(this.Name, tabPage2); gs.ControlText(this.Name, tabPage3); cbbClave.DataSource = LineaConfigLogica.Consultar(); cbbClave.ValueMember = "clave"; cbbClave.DisplayMember = "clave"; cbbClave.SelectedIndex = -1; Dictionary <string, string> List = new Dictionary <string, string>(); List.Add("CJ", "Cajas"); List.Add("KT", "Kits"); cbbMetaum.DataSource = new BindingSource(List, null); cbbMetaum.DisplayMember = "Value"; cbbMetaum.ValueMember = "Key"; cbbMetaum.SelectedIndex = 0; cbbTurno.DataSource = LineaConfigLogica.ConsultarTurnos(); cbbTurno.DisplayMember = "turno"; cbbTurno.ValueMember = "turno"; cbbTurno.SelectedValue = 0; dgwHrs.DataSource = null; dgwLineas.DataSource = null; txtJornada.Focus(); } catch (Exception ex) { MessageBox.Show("Error " + ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void Inicio() { //load data try { _lsProceso = "PRO020"; dgwLine.DataSource = null; CargarColumnas(); //1. find last folio from date //1.1 Load data from folio //1.2 Cursor on next hour row lblFecha.Text = DateTime.Today.ToShortDateString(); if (!string.IsNullOrEmpty(Globals._gsStation)) { LineaRampeoLogica lineR = new LineaRampeoLogica(); lineR.Estacion = Globals._gsStation; DataTable dtLR = LineaRampeoLogica.ConsultarEstacion(lineR); if (dtLR.Rows.Count > 0) { Globals._gsCompany = dtLR.Rows[0]["company"].ToString(); Globals._gsLineHr = dtLR.Rows[0]["linehr"].ToString(); } } lblLine.Text = Globals._gsLineHr; tssLine.Text = Globals._gsLineHr; LineaHoraLogica line = new LineaHoraLogica(); line.Linea = Globals._gsLineHr; DataTable data = LineaHoraLogica.ConsultarActual(line); if (data.Rows.Count > 0) { _llFolio = long.Parse(data.Rows[0]["folio"].ToString()); _ldMeta = decimal.Parse(data.Rows[0]["meta"].ToString()); _ldActualAc = decimal.Parse(data.Rows[0]["cant_total"].ToString()); _ldDefectosAc = decimal.Parse(data.Rows[0]["defectos"].ToString()); lblMeta.Text = _ldMeta.ToString(); lblActual.Text = _ldActualAc.ToString(); lblDefectos.Text = _ldDefectosAc.ToString(); //horario LineaHoraDetLogica lined = new LineaHoraDetLogica(); lined.Folio = _llFolio; DataTable dtH = LineaHoraDetLogica.VistaHorario(lined); dgwLine.DataSource = dtH; if (_ldActualAc > 0 && _ldActualAc < _ldMeta) { pnlActual.BackColor = Color.Red; lblActual.ForeColor = Color.White; } else { pnlActual.BackColor = Color.Green; lblActual.ForeColor = Color.DarkBlue; } } else { LineaConfigLogica con = new LineaConfigLogica(); con.Linea = Globals._gsLineHr; //2. Load line data //2.1 Load line setup DataTable confL = LineaConfigLogica.ConsultarConfLinea(con); if (confL.Rows.Count > 0) { con.Clave = confL.Rows[0]["clave"].ToString(); lblMeta.Text = confL.Rows[0]["meta"].ToString(); lblActual.Text = string.Empty; lblDefectos.Text = string.Empty; DataTable dataC = LineaConfigLogica.VistaHorarioLinea(con); dgwLine.DataSource = dataC; CargarColumnas(); } } if (dgwLine.Rows.Count > 0) { foreach (DataGridViewRow row in dgwLine.Rows) { string sOrden = row.Cells[7].Value.ToString(); if (!string.IsNullOrEmpty(sOrden) && !string.IsNullOrWhiteSpace(sOrden)) { int iWO = 0; if (!int.TryParse(sOrden, out iWO)) { iWO = 0; } if (iWO > 0) { lblOrden.Text = sOrden; } } string sActual = row.Cells[4].Value.ToString(); if (string.IsNullOrEmpty(sActual) || string.IsNullOrWhiteSpace(sActual) || sActual == "0") { dgwLine.CurrentCell = dgwLine[4, row.Index]; dgwLine.Focus(); break; } } } else { MessageBox.Show("La linea no se encuentra configurada en los parámetros del sistema.", Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Close(); return; } if (!string.IsNullOrEmpty(_lsOrden)) { lblOrden.Text = _lsOrden; CargaWO(); } } catch (Exception ex) { MessageBox.Show("Error " + ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }