public AccountIndexModel(AccountSearch search, PagedList<Core.Business.Account> accounts)
{
this.Accounts = accounts;
this.Search = search;
}
public AccountIndexModel Search(AccountSearch packet)
{
if (packet == null)
{
throw new ArgumentException("packet for search is null!!!!");
}
IList<Core.Business.Account> accountlist = new List<Core.Business.Account>();
SqlServerUtility sql = new SqlServerUtility();
int start = packet.PageIndex.HasValue ? packet.PageIndex.Value - 1 : 0 * (packet.PageSize.HasValue ? packet.PageSize.Value : 10);
int end = start + (packet.PageSize.HasValue ? packet.PageSize.Value : 10);
sql.AddParameter("@Name", SqlDbType.NVarChar, !string.IsNullOrEmpty(packet.Name) ? (object)packet.Name : DBNull.Value, 30);
sql.AddParameter("@Gender", SqlDbType.Int, packet.Gender != Core.Business.Gender.Female && packet.Gender != Core.Business.Gender.Male ? DBNull.Value : (object)packet.Gender);
sql.AddParameter("@start", SqlDbType.Int, start);
sql.AddParameter("@end", SqlDbType.Int, end);
sql.AddOutputParameter("@totalCount", SqlDbType.Int);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSerchAccount);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Account account = new Core.Business.Account();
if (!reader.IsDBNull(0)) account.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) account.Status = reader.GetInt32(1);
if (!reader.IsDBNull(2)) account.Birthday = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) account.Gender = reader.GetDecimal(3);
if (!reader.IsDBNull(4)) account.Name = reader.GetString(4);
if (!reader.IsDBNull(5)) account.Telephone = reader.GetString(5);
if (!reader.IsDBNull(6)) account.Address = reader.GetString(6);
if (!reader.IsDBNull(7)) account.LoginName = reader.GetString(7);
if (!reader.IsDBNull(8)) account.Password = reader.GetString(8);
if (!reader.IsDBNull(9)) account.AvatarPath = reader.GetString(9);
account.MarkOld();
accountlist.Add(account);
}
reader.Close();
}
AccountIndexModel model = new AccountIndexModel(packet, new PagedList<Account>(accountlist, packet.PageIndex.Value, packet.PageSize.Value, 10));
return model;
}
public ActionResult Index(AccountSearch packet)
{
if (TempData["HintMessage"] != null)
{
ViewData["HintMessage"] = TempData["HintMessage"];
}
AccountIndexModel model = Core.Business.Account.Search(packet);
return View(model);
}
