public int InsertActionSreens(int cod_accion, int cod_pantalla, int permiso_pantalla, int cod_rol, int cod_modulo) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_insertActionsScreens"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_accion", cod_accion); command.Parameters.AddWithValue("@cod_pantalla", cod_pantalla); command.Parameters.AddWithValue("@permiso_pantalla", permiso_pantalla); command.Parameters.AddWithValue("@cod_rol", cod_rol); command.Parameters.AddWithValue("@cod_modulo", cod_modulo); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { return(Convert.ToInt32(dr["ID"])); } } catch (Exception err) { throw err; } finally { sqlC.Close(); } return(-1); }
public String DeleteCodigoBarras(String id) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_CodigoBarras_Del"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@id", id); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { return(dr[0].ToString()); } } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } return("La operacion no se pudo completar."); }
public String GenerateReplacementCodes(int cod_reemplazo, int cod_detenido) { String ret = ""; SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_GenerateReplacementCodes"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CodPiezaReemplazo", cod_reemplazo); command.Parameters.AddWithValue("@CodPiezaDetenido", cod_detenido); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { ret = dr[0].ToString(); } } catch (Exception err) { ret = "Hubo un problema al generar la accion, intente nuevamente"; } finally { sqlC.Close(); dr.Close(); } return(ret); }
public DataTable InventarioEnProcesoDetalle(int id) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spInventarioProcesoDetalle"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@ID", id); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } }
public DataTable Get_MoldeCbo(int cod_tipo_articulo) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_Molde_Cbo"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CodTipoArticulo", cod_tipo_articulo); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable GetDetaineesCodes(int planta, int process, int article_type, int model) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_getDetaineesCodes"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@Planta", planta); command.Parameters.AddWithValue("@Proceso", process); command.Parameters.AddWithValue("@TipoArticulo", article_type); command.Parameters.AddWithValue("@Modelo", model); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } }
public String DesactivarConfigBanco(int codConfigBanco) { String msg = ""; SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_DesactivarConfigBanco"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@codConfigBanco", codConfigBanco); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { msg = dr[0].ToString(); } } catch (Exception err) { msg = err.Message; } finally { sqlC.Close(); dr.Close(); } return(msg); }
public Boolean HasScreenPermision(int cod_rol, String uri) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_getScreenPermision"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_rol", cod_rol); command.Parameters.AddWithValue("@uri", uri); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { return(true); } } catch (Exception err) { throw err; } finally { sqlC.Close(); } return(false); }
public int DeleteActionSreens(int cod_rol, int cod_modulo) { SqlConnection sqlC = new SqlConnection(); try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_deleteActionsScreens"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_rol", cod_rol); command.Parameters.AddWithValue("@cod_modulo", cod_modulo); DataTable dt = new DataTable(); sqlC.Open(); command.ExecuteReader(); return(1); } catch (Exception err) { throw err; } finally { sqlC.Close(); } }
public int ObtenerNumImpresionesMolde(int codMolde) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_GetNumeroImpresionesMolde"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_molde", codMolde); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { return(Convert.ToInt32(dr[0])); } } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } return(0); }
public DataTable ObtenerProcesoDestino(int iCodigoProcesoOrigen) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spObtenerProcesoDestinoSel"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CodigoProcesoOrigen", iCodigoProcesoOrigen); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ObtenerProveedores() { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spObtenerProveedores"; command.CommandType = System.Data.CommandType.StoredProcedure; DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ObtenerCodigoBarras(int planta, int centroTrabajo, int codigoProceso, int banco, int empleado) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_Codigo_Barras_Lis"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@planta", planta); command.Parameters.AddWithValue("@centroTrabajo", centroTrabajo); command.Parameters.AddWithValue("@banco", banco); command.Parameters.AddWithValue("@empleado", empleado); command.Parameters.AddWithValue("@CodigoProceso", codigoProceso); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } }
public String InventarioEnProcesoGenerar(int userId, int iPlanta) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; String result = "Hubo un problema al generar el Inventario, intente nuevamente."; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spInventarioProcesoGenera"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@Usuario", userId); command.Parameters.AddWithValue("@Planta", iPlanta); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { result = dr[0].ToString(); } } catch (Exception err) { result = err.Message; } finally { sqlC.Close(); dr.Close(); } return(result); }
public DataTable ObtenerArea(int iCentroTrabajo, int iPlanta, int iProceso) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spObtenerArea"; command.CommandType = System.Data.CommandType.StoredProcedure; if (iCentroTrabajo > 0) { command.Parameters.AddWithValue("@CodigoCentroTrabajo", iCentroTrabajo); } if (iPlanta > 0) { command.Parameters.AddWithValue("@CodigoPlanta", iPlanta); } if (iProceso > 0) { command.Parameters.AddWithValue("@CodigoProceso", iProceso); } DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ListDefectosDetalles(int planta, int proceso, int tipo_articulo, int modelo, int color, DateTime fechaIni, DateTime fechaFin, int vaciador, int estado, int defecto, int zona) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_Inventario_Defecto3"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_planta", planta); command.Parameters.AddWithValue("@cod_proceso", proceso); command.Parameters.AddWithValue("@cod_tipo_articulo", tipo_articulo); command.Parameters.AddWithValue("@cod_modelo", modelo); command.Parameters.AddWithValue("@cod_color", color); command.Parameters.AddWithValue("@fecha_ini", fechaIni); command.Parameters.AddWithValue("@fecha_fin", fechaFin); command.Parameters.AddWithValue("@vaciador", vaciador); command.Parameters.AddWithValue("@estado", estado); command.Parameters.AddWithValue("@cod_defecto", defecto); command.Parameters.AddWithValue("@cod_zona", zona); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ObtenerMaquinaCbo(int codArea, int codCT, int?iCodigoPlanta, int?iCodigoProceso) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_Maquina_Lis"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_area", codArea); command.Parameters.AddWithValue("@cod_centro_trabajo", codCT); if (iCodigoPlanta.HasValue) { command.Parameters.AddWithValue("@CodigoPlanta", iCodigoPlanta.Value); } if (iCodigoProceso.HasValue) { command.Parameters.AddWithValue("@CodigoProceso", iCodigoProceso.Value); } DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public Usuario GetUser(int cod_user) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; Usuario user = new Usuario(); try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_getUsuario"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@codUsuario", cod_user); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { user.CodUsuario = cod_user; user.CodEmpleado = Convert.ToInt32(dr["CodEmpleado"]); user.NombreUsuario = dr["NombreUsuario"].ToString(); user.Nombre = dr["Nombre"].ToString(); user.APaterno = dr["APaterno"].ToString(); user.AMaterno = dr["AMaterno"].ToString(); user.Email = dr["Email"].ToString(); user.CodRol = Convert.ToInt32(dr["CodRol"]); user.DesRol = dr["DesRol"].ToString(); user.Bloqueado = Convert.ToBoolean(Convert.ToByte(dr["bloqueado"])); user.FechaRegistro = Convert.ToDateTime(dr["FechaRegistro"]); user.FechaVigPassword = Convert.ToDateTime(dr["FechaVigPassword"]); } } catch (Exception err) { throw err; } finally { sqlC.Close(); } return(user); }
public List <ScreenPermission> GetActionBySreen(int cod_rol, String localPath) { String uri = localPath.Substring(1); uri = uri.Substring(uri.IndexOf("/")); SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_getActionsByScreen"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@cod_rol", cod_rol); command.Parameters.AddWithValue("@uri", uri); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); List <ScreenPermission> spl = new List <ScreenPermission>(); ScreenPermission sp; while (dr.Read()) { sp = new ScreenPermission(); sp.ActionCode = Convert.ToInt32(dr["cod_accion"]); sp.ScreenCode = Convert.ToInt32(dr["cod_pantalla"]); sp.DescriptionAction = dr["Descripcion"].ToString(); spl.Add(sp); } return(spl); } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } return(null); }
public String getUsuarios(String nick, String pass) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; sqlC.Open(); command.CommandText = "getUsuarios"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@nick", nick); command.Parameters.AddWithValue("@contraseña", pass); dr = command.ExecuteReader(); if (dr.Read()) { return("Ok"); } return("Error"); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public String InsertCodigoBarras(String id, string planta, string centroTrabajo, string banco, string empleado, String cod_desde, String cod_hasta) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_CodigoBarras_Ins"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@id", id); command.Parameters.AddWithValue("@cod_planta", planta); command.Parameters.AddWithValue("@cod_ct", centroTrabajo); command.Parameters.AddWithValue("@cod_maquina", banco); command.Parameters.AddWithValue("@cod_empleado", empleado); command.Parameters.AddWithValue("@cod_desde", cod_desde); command.Parameters.AddWithValue("@cod_hasta", cod_hasta); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); if (dr.Read()) { return(dr[0].ToString()); } } catch (Exception err) { throw err; } finally { sqlC.Close(); dr.Close(); } return("La operacion no se pudo completar."); }
public DataTable getCetroTrabajo(int planta, int proceso) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "sp_centrotrabajo_cbo"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@planta", planta); command.Parameters.AddWithValue("@proceso", proceso); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ListDefectosExcel(int planta, int proceso, int tipo_articulo, int modelo, int color, int iCodEstadoDefecto, int iCentroTrabajo, DateTime dtFechaIni, DateTime dtFechaFin) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spReporteAdministracionDefectoExportar"; command.CommandType = System.Data.CommandType.StoredProcedure; if (planta > 0) { command.Parameters.AddWithValue("@CodigoPlanta", planta); } if (proceso > 0) { command.Parameters.AddWithValue("@CodigoProceso", proceso); } if (tipo_articulo > 0) { command.Parameters.AddWithValue("@CodigoTipoArticulo", tipo_articulo); } if (modelo > 0) { command.Parameters.AddWithValue("@CodigoArticulo", modelo); } if (color > 0) { command.Parameters.AddWithValue("@CodigoColor", color); } if (iCodEstadoDefecto > 0) { command.Parameters.AddWithValue("@CodigoEstadoDefecto", iCodEstadoDefecto); } if (iCentroTrabajo > 0) { command.Parameters.AddWithValue("@CodigoCentroTrabajo", iCentroTrabajo); } command.Parameters.AddWithValue("@FechaIni", dtFechaIni); command.Parameters.AddWithValue("@FechaFin", dtFechaFin); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); dt.Load(dr); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable Pisos(int planta, int tipo_articulo, int modelo, int iCentroTrabajo, DateTime dtFechaIni, DateTime dtFechaFin) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandText = "spReporteAdministracionPlanta"; command.CommandType = System.Data.CommandType.StoredProcedure; if (planta > 0) { command.Parameters.AddWithValue("@CodigoPlanta", planta); } if (tipo_articulo > 0) { command.Parameters.AddWithValue("@CodigoTipoArticulo", tipo_articulo); } if (modelo > 0) { command.Parameters.AddWithValue("@CodigoArticulo", modelo); } if (iCentroTrabajo > 0) { command.Parameters.AddWithValue("@CodigoCentroTrabajo", iCentroTrabajo); } command.Parameters.AddWithValue("@FechaIni", dtFechaIni); command.Parameters.AddWithValue("@FechaFin", dtFechaFin); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); DataSet dsResult = new DataSet(); while (!dr.IsClosed) { DataTable dtContenedor = new DataTable(); dtContenedor.Clear(); dtContenedor.Load(dr); dsResult.Tables.Add(dtContenedor); } if (dsResult.Tables.Count < 2) { return(dt); } dt = dsResult.Tables[0]; if (dt.Rows.Count < 1) { return(dt); } DataRow drTotal = dt.NewRow(); int columnIni = (dt.Columns.Count - dsResult.Tables[1].Columns.Count) - 1; drTotal[columnIni++] = "Total:"; for (int i = 0; i < dsResult.Tables[1].Columns.Count; i++) { drTotal[columnIni++] = dsResult.Tables[1].Rows[0][i]; } dt.Rows.Add(drTotal); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }
public DataTable ControlDePisos(int iCodigoPlanta, int iCodigoTurno, int iCodigoProcesoOrigen, int iCodigoProcesoDestino, int iCodigoTipoArticulo, int iCodigoModelo, int iCodigoCentroTrabajo, DateTime dtFechaInicial, DateTime dtFechaFinal) { SqlConnection sqlC = new SqlConnection(); SqlDataReader dr = null; try { sqlC = ConnectionLamosa.getConnection(); SqlCommand command = new SqlCommand(); command.Connection = sqlC; command.CommandTimeout = 180; command.CommandText = "spReporteAdministracionProduccionPiso"; command.CommandType = System.Data.CommandType.StoredProcedure; if (iCodigoPlanta > 0) { command.Parameters.AddWithValue("@CodigoPlanta", iCodigoPlanta); } if (iCodigoTurno > 0) { command.Parameters.AddWithValue("@CodigoTurno", iCodigoTurno); } command.Parameters.AddWithValue("@CodigoProcesoOrigen", iCodigoProcesoOrigen); command.Parameters.AddWithValue("@CodigoProcesoDestino", iCodigoProcesoDestino); if (iCodigoTipoArticulo > 0) { command.Parameters.AddWithValue("@CodigoTipoArticulo", iCodigoTipoArticulo); } if (iCodigoModelo > 0) { command.Parameters.AddWithValue("@CodigoArticulo", iCodigoModelo); } if (iCodigoCentroTrabajo > 0) { command.Parameters.AddWithValue("@CodigoCentroTrabajo", iCodigoCentroTrabajo); } command.Parameters.AddWithValue("@FechaIni", dtFechaInicial); command.Parameters.AddWithValue("@FechaFin", dtFechaFinal); DataTable dt = new DataTable(); sqlC.Open(); dr = command.ExecuteReader(); DataSet dsResult = new DataSet(); while (!dr.IsClosed) { DataTable dtContenedor = new DataTable(); dtContenedor.Clear(); dtContenedor.Load(dr); dsResult.Tables.Add(dtContenedor); } if (dsResult.Tables.Count < 2) { return(dt); } dt = dsResult.Tables[0]; if (dt.Rows.Count < 1) { return(dt); } dt.Columns[0].AllowDBNull = true; dt.Columns[2].AllowDBNull = true; DataRow drTotal = dt.NewRow(); //drTotal[4] = Convert.ToString(((Convert.ToInt32(drTotal[3]) * 100) / Convert.ToInt32(drTotal[2]))); //dsResult.Tables[1].Rows[0][2] = Convert.ToInt32(((Convert.ToInt32(dsResult.Tables[1].Rows[0][1]) * 100) / Convert.ToInt32(dsResult.Tables[1].Rows[0][0]))); //drTotal[7] = Convert.ToString(((Convert.ToInt32(drTotal[6]) * 100) / Convert.ToInt32(drTotal[5]))); //dsResult.Tables[1].Rows[0][5] = Convert.ToInt32(((Convert.ToInt32(dsResult.Tables[1].Rows[0][4]) * 100) / Convert.ToInt32(dsResult.Tables[1].Rows[0][3]))); //drTotal[8] = Convert.ToInt32(((Convert.ToInt32(drTotal[3]) + Convert.ToInt32(drTotal[6])) * 100) / Convert.ToInt32(drTotal[5])); //dsResult.Tables[1].Rows[0][6] = Convert.ToInt32(((Convert.ToInt32(dsResult.Tables[1].Rows[0][1]) + Convert.ToInt32(dsResult.Tables[1].Rows[0][4])) * 100) / Convert.ToInt32(dsResult.Tables[1].Rows[0][0])); int columnIni = (dt.Columns.Count - dsResult.Tables[1].Columns.Count) - 1; drTotal[columnIni++] = "Total:"; for (int i = 0; i < dsResult.Tables[1].Columns.Count; i++) { drTotal[columnIni++] = dsResult.Tables[1].Rows[0][i]; } dt.Rows.Add(drTotal); return(dt); } catch (Exception err) { throw err; } finally { if (sqlC != null) { sqlC.Close(); } if (dr != null) { dr.Close(); } } }