//获取所有的领养宠物的文章列表，返回信息列表，分页的方式
public List<CVAdoptPet> GetAllAdoptPetListPerPage(int pageNumber, int NumberPerPage, out int howmanyPages)
{
SqlParameter[] adoptPetParams = null;
adoptPetParams = new SqlParameter[5];
adoptPetParams[0] = new SqlParameter("@IsAdopt", SqlDbType.Bit);
adoptPetParams[1] = new SqlParameter("@DescriptionLength", SqlDbType.Int);
adoptPetParams[2] = new SqlParameter("@PageNumber", SqlDbType.Int);
adoptPetParams[3] = new SqlParameter("@AdoptInfoPerPage", SqlDbType.Int);
adoptPetParams[0].Value = true;
adoptPetParams[1].Value = CPetCareConfiguration.ArticleBreviaryNum;
adoptPetParams[2].Value = pageNumber;
adoptPetParams[3].Value = NumberPerPage;
SqlParameter parameter = new SqlParameter();
parameter.DbType = DbType.Int16;
parameter.Direction = ParameterDirection.Output;
parameter.ParameterName = "@HowManyAdoptInfo";
adoptPetParams[4] = parameter;
List<CVAdoptPet> AdoptPetList = new List<CVAdoptPet>();
try
{
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proGetAdoptInfo", adoptPetParams))
{
while (reader.Read())
{
CVAdoptPet adoptPet = new CVAdoptPet();
adoptPet.AdoptID = reader["AdoptID"].ToString();
adoptPet.City = reader["City"].ToString();
adoptPet.Province = reader["Province"].ToString();
adoptPet.AdoptInfo = reader["AdoptInfo"].ToString();
adoptPet.AdoptTitle = reader["AdoptTitle"].ToString();
adoptPet.PetCategoryName = reader["PetCategoryName"].ToString();
adoptPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
adoptPet.UserName = reader["UserName"].ToString();
adoptPet.PicLocation = reader["PicLocation"].ToString();
adoptPet.Portrait = reader["Portrait"].ToString();
adoptPet.LinkUrl = reader["LinkUrl"].ToString();
adoptPet.UserWeiBo = reader["UserWeiBo"].ToString();
adoptPet.Status = reader["Status"].ToString();
bool tempIsAdopt = true;
adoptPet.IsAdopt = bool.TryParse(reader["IsAdopt"].ToString(), out tempIsAdopt) ? tempIsAdopt : true;
bool tempIsRecommand = true;
adoptPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true;
bool tempIsEssence = true;
adoptPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true;
DateTime tempLastEditTime = DateTime.Now;
tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now;
adoptPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss");
DateTime tempAdoptTime = DateTime.Now;
tempAdoptTime = DateTime.TryParse(reader["AdoptTime"].ToString(), out tempAdoptTime) ? tempAdoptTime : DateTime.Now;
adoptPet.AdoptTime = tempAdoptTime.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
adoptPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
int tempCommentCount = 0;
adoptPet.CommentCount = int.TryParse(reader["CommentCount"].ToString(), out tempCommentCount) ? tempCommentCount : 0;
AdoptPetList.Add(adoptPet);
}
reader.Close();
reader.Dispose();
int tempHowmanyPages = 0;
howmanyPages = int.TryParse(adoptPetParams[4].Value.ToString(), out tempHowmanyPages) ? tempHowmanyPages : 0;
}
}
catch(Exception ex)
{
throw;
}
return AdoptPetList;
}
//根据地区种类得到领养宠物的信息
public List<CVAdoptPet> GetAdoptPetListByAddressCategory(bool IsAdopt,string AddressID, string PetCategoryID, int pageNumber, int NumberPerPage, out int howmanyPages)
{
List<CVAdoptPet> AdoptPetList = new List<CVAdoptPet>();
SqlParameter[] adoptPetParams = null;
adoptPetParams = new SqlParameter[]
{
new SqlParameter("@IsAdopt",SqlDbType.Bit),
new SqlParameter("@AddressID",SqlDbType.NVarChar,20),
new SqlParameter("@PetCategoryID",SqlDbType.NVarChar,36),
new SqlParameter("@DescriptionLength",SqlDbType.Int),
new SqlParameter("@PageNumber",SqlDbType.Int),
new SqlParameter("@AdoptInfoPerPage",SqlDbType.Int),
new SqlParameter("@HowManyAdoptInfo",SqlDbType.Int,65535,ParameterDirection.Output,true,0,0,"",DataRowVersion.Default,0),
};
adoptPetParams[0].Value = IsAdopt;
adoptPetParams[1].Value = AddressID;
adoptPetParams[2].Value = PetCategoryID;
adoptPetParams[3].Value = CPetCareConfiguration.ArticleBreviaryNum;
adoptPetParams[4].Value = pageNumber;
adoptPetParams[5].Value = NumberPerPage;
try
{
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proSearchAllAdoptInfo", adoptPetParams))
{
while (reader.Read())
{
CVAdoptPet adoptPet = new CVAdoptPet();
adoptPet.AdoptID = reader["AdoptID"].ToString();
adoptPet.City = reader["City"].ToString();
adoptPet.Province = reader["Province"].ToString();
adoptPet.AdoptInfo = reader["AdoptInfo"].ToString();
adoptPet.AdoptTitle = reader["AdoptTitle"].ToString();
adoptPet.PetCategoryName = reader["PetCategoryName"].ToString();
adoptPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
adoptPet.UserName = reader["UserName"].ToString();
adoptPet.PicLocation = reader["PicLocation"].ToString();
adoptPet.Portrait = reader["Portrait"].ToString();
adoptPet.LinkUrl = reader["LinkUrl"].ToString();
adoptPet.UserWeiBo = reader["UserWeiBo"].ToString();
adoptPet.Status = reader["Status"].ToString();
bool tempIsAdopt = true;
adoptPet.IsAdopt = bool.TryParse(reader["IsAdopt"].ToString(), out tempIsAdopt) ? tempIsAdopt : true;
bool tempIsRecommand = true;
adoptPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true;
bool tempIsEssence = true;
adoptPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true;
DateTime tempLastEditTime = DateTime.Now;
tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now;
adoptPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss");
DateTime tempAdoptTime = DateTime.Now;
tempAdoptTime = DateTime.TryParse(reader["AdoptTime"].ToString(), out tempAdoptTime) ? tempAdoptTime : DateTime.Now;
adoptPet.AdoptTime = tempAdoptTime.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
adoptPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
int tempCommentCount = 0;
adoptPet.CommentCount = int.TryParse(reader["CommentCount"].ToString(), out tempCommentCount) ? tempCommentCount : 0;
AdoptPetList.Add(adoptPet);
}
}
}
catch (Exception ex)
{
}
howmanyPages = 1;
return AdoptPetList;
}