public IList<Core.Business.Document> GetAllDocument()
{
IList<Core.Business.Document> documentlist = new List<Core.Business.Document>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectDocumentsAll");
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;
}
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();
}
public Core.Business.Document Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectDocument");
if (reader != null && !reader.IsClosed && 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);
reader.Close();
return document;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IEnumerable<Document> Search(DocumentSearch wrapper, CY.GFive.Core.Business.PagingInfo pageinfo)
{
if (wrapper == null || pageinfo == null)
throw new ArgumentNullException("wrapper and pageinfo is null");
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(wrapper.Title))
{
sql.AddParameter("@title", SqlDbType.NVarChar, wrapper.Title);
}
if (wrapper.State != null && wrapper.State.HasValue)
{
sql.AddParameter("@state", SqlDbType.Int, wrapper.State.Value);
}
if (wrapper.Secret != null && wrapper.Secret.HasValue)
{
sql.AddParameter("@secret", SqlDbType.Int, wrapper.Secret.Value);
}
if (wrapper.Mergency != null && wrapper.Mergency.HasValue)
{
sql.AddParameter("@mergency", SqlDbType.Int, wrapper.Mergency.Value);
}
if (wrapper.Sender != null && wrapper.Sender.HasValue)
{
sql.AddParameter("@sender", SqlDbType.Int, wrapper.Sender.Value);
}
if (wrapper.Reciever != null && wrapper.Reciever.HasValue)
{
sql.AddParameter("@reciever", SqlDbType.Int, wrapper.Reciever.Value);
}
if (wrapper.RecieverState != null && wrapper.RecieverState.HasValue)
{
sql.AddParameter("@desstate", SqlDbType.Int, wrapper.RecieverState.Value);
}
int lowBand = (pageinfo.CurrentPage - 1) * pageinfo.PageSize;
int highBand = pageinfo.CurrentPage * pageinfo.PageSize;
sql.AddParameter("@lowband", SqlDbType.Int, lowBand);
sql.AddParameter("@highband", SqlDbType.Int, highBand);
IList<Core.Business.Document> documentlist = new List<Core.Business.Document>();
SqlDataReader reader = sql.ExecuteSPReader("usp_SearchDocument");
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;
}
public IEnumerable<Document> GetRecycles(StaffInfo staff)
{
IList<Core.Business.Document> documentlist = new List<Core.Business.Document>();
SqlServerUtility sql = new SqlServerUtility();
//sql.AddParameter("@state1", SqlDbType.Int, (int)CY.GFive.Core.Business.DocumentState.Removed);
//sql.AddParameter("@state2", SqlDbType.Int, (int)CY.GFive.Core.Business.DocumentDepatcherState.Removed);
//sql.AddParameter("@id1", SqlDbType.Int, staff.Id);
//sql.AddParameter("@id2", SqlDbType.Int, staff.Id);
SqlDataReader reader = sql.ExecuteSqlReader(string.Format(Sql_GetRecycles, staff.Id, DocumentState.Removed.ToCode(), DocumentDepatcherState.Removed.ToCode()));
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;
}
public IEnumerable<Document> GetRecieved(StaffInfo staff)
{
if (staff == null)
throw new ArgumentNullException("staff is null");
IList<Core.Business.Document> documentlist = new List<Core.Business.Document>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@id", SqlDbType.Int, staff.Id);
SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetRecieved);
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);
//if (!reader.IsDBNull(10)) document.DispatchState = reader.GetInt32(10);
documentlist.Add(document);
}
reader.Close();
}
return documentlist.AsEnumerable();
}
