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);
}
}
