/// <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(); }