public IEnumerable<Document> GetDocument(StaffInfo staff, DocumentState state)
{
IList<Core.Business.Document> documentlist = new List<Core.Business.Document>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@id", SqlDbType.Int, staff.Id);
sql.AddParameter("@state", SqlDbType.Int, state.ToCode());
SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetDocument);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Document document = new Core.Business.Document();
if (!reader.IsDBNull(0)) document.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) document.Title = reader.GetString(1);
if (!reader.IsDBNull(2)) document.SubTitle = reader.GetString(2);
if (!reader.IsDBNull(3)) document.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) document.SendDate = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) document.State = reader.GetInt32(5);
if (!reader.IsDBNull(6)) document.Secret = reader.GetInt32(6);
if (!reader.IsDBNull(7)) document.Mergency = reader.GetInt32(7);
if (!reader.IsDBNull(8)) document.DraftDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) document.Sender = reader.GetInt32(9);
document.MarkOld();
documentlist.Add(document);
}
reader.Close();
}
return documentlist.AsEnumerable();
}
