private void datosgeneral(String sqldata) { var conex = new ConexionDA(); var dt = new DataTable(); using (var cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = sqldata; try { cnx.Open(); using (var da = new SqlDataAdapter(cmd)) { da.Fill(dt); if (dt.Rows.Count > 0) { gridgeneral.AutoGenerateColumns = true; gridgeneral.DataSource = dt; } if (nameform == "color") { if (VariablesPublicas.Moduloid == "0500") { foreach (DataGridViewRow fila in gridgeneral.Rows) { var xproductidold = string.Empty; if (gridgeneral.ColumnCount >= 4) { if (gridgeneral.Columns[4].HeaderText == "productidold") { xproductidold = Convert.ToString(gridgeneral.Rows[fila.Index].Cells["productidold"].Value); if (xproductidold.Trim() != "0") { gridgeneral.Rows[fila.Index].DefaultCellStyle.BackColor = Color.MediumSeaGreen; gridgeneral.Rows[fila.Index].DefaultCellStyle.ForeColor = Color.White; } } } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void datosgeneral(String sqldata) { ConexionDA conex = new ConexionDA(); DataSet ds = new DataSet(); using (SqlConnection cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (SqlCommand cmd = new SqlCommand("gspHelpSQL", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = sqldata; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); if (ds.Tables[0].Rows.Count > 0 && gridgeneral.RowCount > 0) { this.gridgeneral.Focus(); this.gridgeneral.BeginEdit(false); } this.gridgeneral.AutoGenerateColumns = true; gridgeneral.DataSource = ds.Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private DataSet Consultas(String Query) { var conex = new ConexionDA(); using (var cnx = new SqlConnection(conex.empConexion(EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { var ds = new DataSet(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = Query; try { cnx.Open(); using (var da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private DataTable ProdMov(String Query) { var conex = new ConexionDA(); var dt = new DataTable(); using (var cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = Query; try { cnx.Open(); using (var da = new SqlDataAdapter(cmd)) { da.Fill(dt); return dt; } } catch (Exception ex) { throw ex; } } } }
private void datosgeneral(String sqldata) { var conex = new ConexionDA(); var dt = new DataTable(); using (var cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = sqldata; try { cnx.Open(); using (var da = new SqlDataAdapter(cmd)) { da.Fill(dt); if (dt.Rows.Count > 0) { gridgeneral.AutoGenerateColumns = true; gridgeneral.DataSource = dt; } if (VariablesPublicas.Moduloid == "0500") { foreach (DataGridViewRow fila in gridgeneral.Rows) { var x1 = Convert.ToString(gridgeneral.Rows[fila.Index].Cells["productid"].Value); var tipodoc = "VS"; var xxData = "SELECT top 1 * from tb_sm_movimientosdet where tipodoc = '" + tipodoc + "' and productid = '" + x1 + "' ORDER BY fechdoc DESC"; var dt2 = new DataTable(); dt2 = ProdMov(xxData); if (dt2.Rows.Count > 0) { var x2 = dt2.Rows[0]["productid"].ToString(); if (x1 == x2) { gridgeneral.Rows[fila.Index].DefaultCellStyle.BackColor = Color.MediumSeaGreen; gridgeneral.Rows[fila.Index].DefaultCellStyle.ForeColor = Color.White; } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private DataTable DatosSQL(String query) { var conex = new ConexionDA(); var dt = new DataTable(); using (var cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = query; try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } return dt; } catch (Exception ex) { throw new Exception(ex.Message); //MessageBox.Show(ex.Message, "Error"); } } } }
private void datosgeneral(String sqldata) { var conex = new ConexionDA(); var dt = new DataTable(); using (var cnx = new SqlConnection(conex.empConexion(VariablesPublicas.EmpresaID))) { using (var cmd = new SqlCommand("gspHelpSQL", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@sqlquery", SqlDbType.VarChar).Value = sqldata; try { cnx.Open(); using (var da = new SqlDataAdapter(cmd)) { da.Fill(dt); if (dt.Rows.Count > 0) { gridgeneral.AutoGenerateColumns = true; gridgeneral.DataSource = dt; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }