public DataTable GetDataSet()
{
//string m_strSQL = " SELECT * from vta_LAB_ImprimirTurno " +
// " WHERE idTurno=" + IdTurno;
DataSet Ds = new DataSet();
SqlConnection conn = (SqlConnection)NHibernateHttpModule.CurrentSession.Connection;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[LAB_ImprimirTurno]";
cmd.Parameters.Add("@idTurno", SqlDbType.NVarChar);
cmd.Parameters["@idTurno"].Value = IdTurno.ToString();
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(Ds);
//SqlDataAdapter adapter = new SqlDataAdapter();
//adapter.SelectCommand = new SqlCommand(m_strSQL, conn);
//adapter.Fill(Ds);
// conn.Close();
// adapter.Dispose();
return(Ds.Tables[0]);
}
public override string ToString()
{
char sep = SeparadorSplit;
return(IdTurno.ToString()
+ sep + HoraInicioTurno.ToString()
+ sep + HoraFimTurno.ToString());
}
