void CargarCmbLinea() { tb_pt_lineaBL BL = new tb_pt_lineaBL(); tb_pt_linea BE = new tb_pt_linea(); DataTable dt = new DataTable(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { cmb_linea01.DataSource = dt; cmb_linea01.ValueMember = "lineaid"; cmb_linea01.DisplayMember = "lineaname"; cmb_linea01.SelectedIndex = -1; } }
// LINEAS private void data_gridLinea() { tb_pt_lineaBL BL = new tb_pt_lineaBL(); tb_pt_linea BE = new tb_pt_linea(); DataTable dt = new DataTable(); switch (cmb_lineas.SelectedValue) { case "01": BE.lineaid = txt_buscar3.Text.Trim().ToUpper(); break; case "02": BE.lineaname = txt_buscar3.Text.Trim().ToUpper(); break; default: //** break; } try { //Eliminar Columnas Actuales(Opcional): dgb_linea.Columns.Clear(); dgb_linea.Width = 535; //Objeto Columna: CommandField image; //Crear Columna: image = new CommandField(); image.ButtonType = ButtonType.Image; image.SelectImageUrl = "~/Images/go-search.png"; image.ShowSelectButton = true; image.ItemStyle.Width = 10; image.ItemStyle.Wrap = true; dgb_linea.Columns.Add(image); BoundField LINEAID; LINEAID = new BoundField(); LINEAID.DataField = "lineaid"; LINEAID.HeaderText = "CODIGO"; LINEAID.ItemStyle.Width = 50; dgb_linea.Columns.Add(LINEAID); BoundField LINEANAME; LINEANAME = new BoundField(); LINEANAME.DataField = "lineaname"; LINEANAME.HeaderText = "LINEA"; LINEANAME.ItemStyle.Width = 250; dgb_linea.Columns.Add(LINEANAME); dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0]; if (dt.Rows.Count > 0) { dgb_linea.DataSource = dt; dgb_linea.DataBind(); dgb_linea.Visible = true; } } catch (Exception ex) { throw ex;// ClientMessage(ex.Message); } }
private void Valida_Linea(String xcod) { var BE2 = new tb_pt_linea(); var BL2 = new tb_pt_lineaBL(); var dt2 = new DataTable(); BE2.lineaid = xcod.Trim(); dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; if (dt2.Rows.Count > 0) { if (dt2.Rows[0]["lineadescort"].ToString().Trim() != string.Empty) { _xlineadescort = dt2.Rows[0]["lineadescort"].ToString(); } else { _xlineadescort = dt2.Rows[0]["lineaname"].ToString(); } lineaid.Text = dt2.Rows[0]["lineaid"].ToString(); lineaname.Text = dt2.Rows[0]["lineaname"].ToString(); _xlineaidold = dt2.Rows[0]["lineaidold"].ToString(); } else { _xlineadescort = string.Empty; lineaid.Text = string.Empty; lineaname.Text = string.Empty; _xlineaidold = string.Empty; } }
private void btn_editar_Click(object sender, EventArgs e) { if (XNIVEL == "0" || XNIVEL == "1") { ssModo = "EDIT"; form_bloqueado(true); articname.Focus(); btn_cancelar.Enabled = true; btn_grabar.Enabled = true; btn_foto.Enabled = true; btnVer.Enabled = true; var BE = new tb_pt_marca(); var BL = new tb_pt_marcaBL(); var dt = new DataTable(); BE.marcaid = marcaid.Text.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; foreach (DataRow row in dt.Rows) { _xmarcadescort = row["marcadescort"].ToString(); } var BE2 = new tb_pt_linea(); var BL2 = new tb_pt_lineaBL(); var dt2 = new DataTable(); BE2.lineaid = lineaid.Text.Trim(); dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0]; foreach (DataRow row in dt2.Rows) { _xlineadescort = row["lineadescort"].ToString(); } var BE3 = new tb_pt_modelo(); var BL3 = new tb_pt_modeloBL(); var dt3 = new DataTable(); BE3.modeloid = modeloid.Text.Trim(); dt3 = BL3.GetAll(EmpresaID, BE3).Tables[0]; foreach (DataRow row in dt3.Rows) { _xmodelodescort = row["modelodescort"].ToString(); } if (XNIVEL == "1") { bloqueo_paneles(false); pnl_01.Enabled = true; pnl_03.Enabled = true; } else { bloqueo_paneles(true); pnl_02.Enabled = false; pnl_05.Enabled = false; pnl_06.Enabled = false; pnl_03.Enabled = true; } } }
private void data_Tablalinea() { try { if (Tablalinea.Rows.Count > 0) { Tablalinea.Rows.Clear(); } var BL = new tb_pt_lineaBL(); var BE = new tb_pt_linea(); BE.lineaname = txt_criterio.Text.Trim().ToUpper(); Tablalinea = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablalinea.Rows.Count > 0) { btn_excel.Enabled = true; gridlinea.DataSource = Tablalinea; gridlinea.Rows[0].Selected = false; gridlinea.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }