//修改或添加作者专访
public int ModifyVisitAuthor(VisitAuthorInfo visit, bool b)
{
if (b)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@VisitId", visit.VisitId),
new SqlParameter("@VisitTitle", visit.VisitTitle),
new SqlParameter("@UserId", visit.UserId),
new SqlParameter("@Contents", visit.Contents),
new SqlParameter("@VisitDate", visit.VisitDate)
};
int i = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_UPDATEVISITAUTHOR, parms);
return(i);
}
else
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@VisitTitle", visit.VisitTitle),
new SqlParameter("@UserId", visit.UserId),
new SqlParameter("@Contents", visit.Contents),
new SqlParameter("@VisitDate", visit.VisitDate)
};
int i = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_ADDVISITAUTHOR, parms);
return(i);
}
}
//获取最新作者专访
/*
* 获取最新的作者专访，order by VisitId desc，然后top 1
*/
public List <Model.VisitAuthorInfo> getVisitAuthor()
{
List <Model.VisitAuthorInfo> VistList = new List <Model.VisitAuthorInfo>();
SqlParameter parm = new SqlParameter("@userSex", -1);
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_GETLASTVISITAUTHOR, parm))
{
while (dr.Read())
{
VisitAuthorInfo item = new VisitAuthorInfo();
item.UserId = Convert.ToInt32(dr["userId"]);
item.Contents = dr["contents"].ToString();
item.VisitDateString = Convert.ToDateTime(dr["visitDate"]).ToShortDateString();
item.VisitId = Convert.ToInt32(dr["visitID"]);
item.VisitTitle = dr["visitTitle"].ToString();
item.UserName = dr["UserName"].ToString();
item.UsetImage = dr["UsetImage"].ToString();
item.UserBrithdayString = Convert.ToDateTime(dr["UserBrithday"]).ToShortDateString();
item.UserSex = Convert.ToInt32(dr["UserSex"]);
item.userAddress = dr["userAddress"].ToString();
item.AuthorPhoto = dr["AuthorPhoto"].ToString();
VistList.Add(item);
}
}
return(VistList);
}
//获取所有作者专访
public List <VisitAuthorInfo> getVisitAuthor(int pageIndex, int PageSize, out int recordCount)
{
List <VisitAuthorInfo> list = new List <VisitAuthorInfo>();
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", PageSize),
new SqlParameter("@recordCount", SqlDbType.Int, 4)
};
parms[2].Direction = ParameterDirection.Output;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_GETVISITAUTHOR, parms))
{
while (dr.Read())
{
Model.VisitAuthorInfo item = new VisitAuthorInfo();
item.VisitId = Convert.ToInt32(dr["VisitId"]);
item.UserName = dr["UserName"].ToString();
item.UserId = Convert.ToInt32(dr["UserId"]);
item.VisitTitle = dr["VisitTitle"].ToString();
item.Contents = dr["Contents"].ToString();
item.VisitDate = Convert.ToDateTime(dr["VisitDate"]).ToShortDateString();
list.Add(item);
}
recordCount = Convert.ToInt32(parms[2].Value);
return(list);
}
}
//修改或添加作者专访
public int ModifyVisitAuthor(VisitAuthorInfo visit, bool b)
{
return(bll.ModifyVisitAuthor(visit, b));
}
