/// <summary>
/// 添加一条影评
/// </summary>
/// <param name="movieID">电影的ID</param>
/// <param name="userName">用户名</param>
/// <param name="comment">评论内容</param>
/// <returns>成功返回true，否则false</returns>
public bool addCinecism(int movieID,string userName,string comment)
{
Model.Cinecism Cinecism = new Model.Cinecism()
{
UserName = userName,
Comment = comment,
MovieID = movieID
};
IDAL.ICinecism ICinecism = DALFactory.DataAccess.createDalCinecism();
return ICinecism.addCinecism(Cinecism);
}
public List<Model.Cinecism> getCinecismList(int movieID)
{
List<Model.Cinecism> lst = new List<Model.Cinecism>();
DataTable dt = DBUtility.SqlHelper.executeTable("select * from Cinecisms where MovieID="+movieID+" ORDER BY CommTime DESC", CommandType.Text, null);
foreach (DataRow item in dt.Rows)
{
Model.Cinecism emp = new Model.Cinecism() { CinecismID = int.Parse(item[0].ToString()), UserName = item[1].ToString(), CommTime = DateTime.Parse(item[3].ToString()), MovieID = int.Parse(item[4].ToString()), Comment = item[2].ToString() };
lst.Add(emp);
}
return lst;
// throw new NotImplementedException();
}
