private void ValidaColor() { if (colorid.Text.Trim().Length > 0) { tb_60colorBL BL = new tb_60colorBL(); tb_60color BE = new tb_60color(); DataTable dt = new DataTable(); BE.moduloid = modulo; BE.colorid = colorid.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { colorid.Text = dt.Rows[0]["colorid"].ToString().Trim(); colorname.Text = dt.Rows[0]["colorname"].ToString().Trim(); generar_denominacion(); } else { colorid.Text = ""; colorname.Text = ""; generar_denominacion(); } } else { colorid.Text = ""; colorname.Text = ""; generar_denominacion(); } }
private void ValidaColor() { if (colorid.Text.Trim().Length > 0) { var BL = new tb_60colorBL(); var BE = new tb_60color(); var dt = new DataTable(); BE.moduloid = modulo; BE.colorid = colorid.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { colorid.Text = dt.Rows[0]["colorid"].ToString().Trim(); colorname.Text = dt.Rows[0]["colorname"].ToString().Trim(); } else { colorid.Text = string.Empty; colorname.Text = string.Empty; } } else { colorid.Text = string.Empty; colorname.Text = string.Empty; } }
private void data_Tablacolor() { try { if (Tablacolor.Rows.Count > 0) { Tablacolor.Rows.Clear(); } var BL = new tb_60colorBL(); var BE = new tb_60color(); BE.moduloid = modulo; BE.colorname = txt_criterio.Text.Trim().ToUpper(); Tablacolor = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablacolor.Rows.Count > 0) { btn_imprimir.Enabled = true; gridcolor.DataSource = Tablacolor; gridcolor.Rows[0].Selected = false; gridcolor.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaColor() { if (colorid.Text.Trim().Length > 0) { var BL = new tb_60colorBL(); var BE = new tb_60color(); var dt = new DataTable(); BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } BE.colorid = colorid.Text.Trim().PadLeft(3, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { colorid.Text = dt.Rows[0]["colorid"].ToString().Trim(); colorname.Text = dt.Rows[0]["colorname"].ToString().Trim(); generar_denominacion(); } else { colorid.Text = string.Empty; colorname.Text = string.Empty; generar_denominacion(); } } else { colorid.Text = string.Empty; colorname.Text = string.Empty; generar_denominacion(); } }
private void active_color() { try { var path = string.Empty; var directorios = Application.StartupPath.Split('\\'); if (directorios.Length > 0) { path = directorios[0] + "\\" + directorios[1]; } var reportecolor = new CR_color(); var BL = new tb_60colorBL(); var BE = new tb_60color(); var dt = new DataTable(); BE.moduloid = moduloid.ToString(); dt = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (dt.Rows.Count > 0) { reportecolor.DataDefinition.FormulaFields["empresaname"].Text = "'EMPRESA: " + VariablesPublicas.EmpresaName.Trim() + "'"; reportecolor.DataDefinition.FormulaFields["empresaruc"].Text = "'RUC: " + VariablesPublicas.EmpresaRuc.Trim() + "'"; reportecolor.SetDataSource(Movimiento_color()); crystalReportViewer1.ReportSource = reportecolor; crystalReportViewer1.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }