public static DataSet GetTiposDeMovimientos(string IdTipo, System.Int16 signo)
{
DataSet data = new DataSet();
try
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "Pr_tfi_Cajas_TiposDeMovimientos");
SqlCommand cmd = new SqlCommand("Pr_tfi_Cajas_TiposDeMovimientos", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdTipo", SqlDbType.VarChar));
cmd.Parameters["@IdTipo"].Value = IdTipo;
cmd.Parameters.Add(new SqlParameter("@Signo", SqlDbType.SmallInt));
if (!(signo.Equals(System.Int16.MinValue)))
{
cmd.Parameters["@Signo"].Value = signo;
}
else
{
cmd.Parameters["@Signo"].Value = System.DBNull.Value;
}
adapter.SelectCommand = cmd;
adapter.Fill(data);
}
catch (Exception e) {; }
return(data);
}