private void cargar_lineasiLSI() { try { var BE = new tb_60linea(); var BL = new tb_60lineaBL(); BE.moduloid = modulo; BE.local = local; var table = BL.GetAllsiLSI(EmpresaID, BE).Tables[0]; cmblinea.DataSource = table; cmblinea.ValueMember = "lineaid"; cmblinea.DisplayMember = "lineaname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaLinea() { if (lineaid.Text.Trim().Length > 0 && ssModo == "NEW") { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); var dt = new DataTable(); BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } BE.lineaid = lineaid.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { lineaid.Text = dt.Rows[0]["lineaid"].ToString().Trim(); lineaname.Text = dt.Rows[0]["lineaname"].ToString().Trim(); generar_denominacion(); } else { lineaid.Text = string.Empty; lineaname.Text = string.Empty; generar_denominacion(); } } if (lineaid.Text.Trim().Length == 0 && ssModo == "NEW") { lineaid.Text = string.Empty; lineaname.Text = string.Empty; generar_denominacion(); } }
private void Data_cbo_tejidoid() { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); if (cboModuloID.SelectedIndex != -1) { BE.moduloid = cboModuloID.SelectedValue.ToString(); try { if (BE.moduloid.Length == 4 && BE.moduloid != "0200") { tejidoid.DataSource = BL.GetAll(EmpresaID, BE).Tables[0]; tejidoid.ValueMember = "lineaid"; tejidoid.DisplayMember = "lineaname"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private DataTable Movimiento_linea() { try { var TablaLinea = new DataTable("Linea"); var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = moduloid.Trim(); TablaLinea = BL.GetReport(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (TablaLinea != null) { return TablaLinea; } else { return null; } } catch (Exception ex) { return null; } }
private void Update() { try { if (tejidoid.Text.Trim().Length != 3) { MessageBox.Show("Falta Codigo Tejido !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (tejidoname.Text.Trim().Length == 0) { MessageBox.Show("Ingrese Nombre de Tejido", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = modulo.ToString(); BE.lineaid = tejidoid.Text.Trim().PadLeft(3, '0'); BE.lineaname = tejidoname.Text.ToUpper(); if (estructuraid.SelectedValue != null && estructuraid.Text.Trim().Length > 0) { BE.estructuraid = estructuraid.SelectedValue.ToString(); } BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Update(EmpresaID, BE)) { SEGURIDAD_LOG("M"); MessageBox.Show("Datos Modificado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaLinea() { if (serop_ini.Text.Trim().Length > 0) { tb_60lineaBL BL = new tb_60lineaBL(); tb_60linea BE = new tb_60linea(); DataTable dt = new DataTable(); BE.moduloid = modulo; BE.lineaid = serop_ini.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { serop_ini.Text = dt.Rows[0]["lineaid"].ToString().Trim(); numop_ini.Text = dt.Rows[0]["lineaname"].ToString().Trim(); } else { serop_ini.Text = ""; numop_ini.Text = ""; } } else { serop_ini.Text = ""; numop_ini.Text = ""; } }
private void Delete() { try { if (tejidoid.Text.Trim().Length != 3) { MessageBox.Show("Falta Codigo Tejido !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = modulo.ToString(); BE.lineaid = tejidoid.Text.Trim().PadLeft(3, '0'); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); form_bloqueado(false); data_Tablatejido(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cargar_linea() { try { var BE = new tb_60linea(); var BL = new tb_60lineaBL(); BE.moduloid = modulo; BE.local = local; var table = BL.GetAllnoLSI(EmpresaID, BE).Tables[0]; var rows = table.Rows; object[] cell; foreach (DataRow item in rows) { cell = item.ItemArray; list2List1.listaizquierda.Items.Add(cell[0].ToString() + " - " + cell[1].ToString()); cell = null; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void active_linea() { try { var path = string.Empty; var directorios = Application.StartupPath.Split('\\'); if (directorios.Length > 0) { path = directorios[0] + "\\" + directorios[1]; } var reportelinea = new CR_linea(); var BL = new tb_60lineaBL(); var BE = new tb_60linea(); var dt = new DataTable(); BE.moduloid = moduloid.ToString(); dt = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (dt.Rows.Count > 0) { reportelinea.DataDefinition.FormulaFields["empresaname"].Text = "'EMPRESA: " + VariablesPublicas.EmpresaName.Trim() + "'"; reportelinea.DataDefinition.FormulaFields["empresaruc"].Text = "'RUC: " + VariablesPublicas.EmpresaRuc.Trim() + "'"; reportelinea.SetDataSource(Movimiento_linea()); crystalReportViewer1.ReportSource = reportelinea; crystalReportViewer1.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_Tablatejido() { try { if (Tablatejido.Rows.Count > 0) { Tablatejido.Rows.Clear(); } var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = modulo; BE.lineaname = txt_criterio.Text.Trim().ToUpper(); Tablatejido = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablatejido.Rows.Count > 0) { btn_imprimir.Enabled = true; gridtejido.DataSource = Tablatejido; gridtejido.Rows[0].Selected = false; gridtejido.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_cbo_tejidoid() { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = "0320"; BE.estructuraid = estructuraid.SelectedValue.ToString(); try { tejidoid.DataSource = BL.GetAll(EmpresaID, BE).Tables[0]; tejidoid.ValueMember = "lineaid"; tejidoid.DisplayMember = "lineaname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Insert() { try { if (lineaid.Text.Trim().Length != 3) { MessageBox.Show("Falta Codigo linea !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (lineaname.Text.Trim().Length == 0) { MessageBox.Show("Ingrese nombre de línea", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = modulo; BE.lineaid = lineaid.Text.Trim().PadLeft(3, '0'); BE.lineaname = lineaname.Text.ToUpper(); if (estructuraid.SelectedValue != null && estructuraid.Text.Trim().Length > 0) { BE.estructuraid = estructuraid.SelectedValue.ToString(); } BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Insert(EmpresaID, BE)) { MessageBox.Show("Datos grabados correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Delete() { try { if (lineaid.Text.Trim().Length != 3) { MessageBox.Show("Falta Codigo linea !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = modulo; BE.lineaid = lineaid.Text.Trim().PadLeft(3, '0'); BE.lineaname = lineaname.Text.ToUpper(); if (estructuraid.SelectedValue != null && estructuraid.Text.Trim().Length > 0) { BE.estructuraid = estructuraid.SelectedValue.ToString(); } BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos eliminados correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); form_bloqueado(false); data_Tablalinea(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void CargarCmbLineaTela() { tb_60lineaBL BL = new tb_60lineaBL(); tb_60linea BE = new tb_60linea(); DataTable dt = new DataTable(); BE.moduloid = "0320"; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { cmb_lineatelaid.DataSource = dt; cmb_lineatelaid.ValueMember = "lineaid"; cmb_lineatelaid.DisplayMember = "lineaname"; } }
private void form_cargar_datos(String posicion) { try { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); var dt = new DataTable(); if (tejidoid.Text.Trim().Length > 0) { BE.lineaid = tejidoid.Text.Trim().PadLeft(3, '0'); } BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { limpiar_documento(); ssModo = "EDIT"; tejidoid.Text = dt.Rows[0]["lineaid"].ToString().Trim(); tejidoname.Text = dt.Rows[0]["lineaname"].ToString().Trim(); estructuraid.SelectedValue = dt.Rows[0]["estructuraid"].ToString().Trim(); btn_editar.Enabled = true; btn_eliminar.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_log.Enabled = true; btn_salir.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaLinea() { if (lineaid.Text.Trim().Length > 0) { var BL = new tb_60lineaBL(); var BE = new tb_60linea(); var dt = new DataTable(); BE.moduloid = modulo; BE.lineaid = lineaid.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { lineaid.Text = dt.Rows[0]["lineaid"].ToString().Trim(); lineaname.Text = dt.Rows[0]["lineaname"].ToString().Trim(); } else { lineaid.Text = string.Empty; lineaname.Text = string.Empty; } } else { lineaid.Text = string.Empty; lineaname.Text = string.Empty; } }
private void data_Tablalinea() { try { if (Tablalinea.Rows.Count > 0) { Tablalinea.Rows.Clear(); } var BL = new tb_60lineaBL(); var BE = new tb_60linea(); BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } BE.lineaname = txt_criterio.Text.Trim().ToUpper(); Tablalinea = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablalinea.Rows.Count > 0) { btn_imprimir.Enabled = true; gridlinea.DataSource = Tablalinea; gridlinea.Rows[0].Selected = false; gridlinea.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }