public List <feedbackEX> GetAllFeedback(string CID) { List <feedbackEX> feedbackList = new List <feedbackEX>(); StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select F.feedbackID,U.UserID as UserID,U.userName as userName,"); strSql.AppendLine("F.feedbackTime,C.categoryID as categoryID,C.category as category,"); strSql.AppendLine("F.Info,F.contact,F.isInvalid,F.solutionState,F.handler,F.remark"); strSql.AppendLine("from Feedback as F"); strSql.AppendLine("inner join Users as U on F.UserID=U.UserID"); strSql.AppendLine("inner join Category as C on F.categoryID=C.categoryID"); strSql.AppendFormat(" where F.isInvalid <>0 or F.isInvalid is null"); if (CID.Trim() != "") { strSql.AppendFormat(" and " + CID + " order by feedbackTime Desc"); } SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql.ToString()); while (reader.Read()) { #region 封装反馈对象 feedbackEX feedback = new feedbackEX(); feedback.feedbackID = int.Parse(reader["feedbackID"].ToString()); feedback.Info = reader["Info"].ToString(); feedback.contact = reader["contact"].ToString(); feedback.isInvalid = reader["isInvalid"].ToString(); feedback.solutionState = reader["solutionState"].ToString(); feedback.handler = reader["handler"].ToString(); feedback.remark = reader["remark"].ToString(); feedback.feedbackTime = DateTime.Parse(reader["feedbackTime"].ToString()); feedback.UserID = int.Parse(reader["UserID"].ToString()); Users users = new Users(); users.UserID = int.Parse(reader["UserID"].ToString()); users.userName = reader["userName"].ToString(); feedback.Users = users; feedback.categoryID = int.Parse(reader["categoryID"].ToString()); Category c = new Category(); c.categoryID = int.Parse(reader["categoryID"].ToString()); c.category = reader["category"].ToString(); feedback.Category = c; #endregion feedbackList.Add(feedback); } reader.Close(); return(feedbackList); }
///<summary> ///查看详情 /// </summary> /// public feedbackEX GetDetails(int id) { feedbackEX Details = new feedbackEX(); StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select F.feedbackID,U.UserID as UserID,U.userName as userName,"); strSql.AppendLine("F.feedbackTime,C.categoryID as categoryID,C.category as category,"); strSql.AppendLine("F.Info,F.contact,F.isInvalid,F.solutionState,F.handler,F.remark"); strSql.AppendLine("from Feedback as F"); strSql.AppendLine("inner join Users as U on F.UserID=U.UserID"); strSql.AppendLine("inner join Category as C on F.categoryID=C.categoryID"); strSql.AppendFormat(" where F.[feedbackID]={0}", id); SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql.ToString()); if (reader.Read()) { feedbackEX feedback = new feedbackEX(); feedback.feedbackID = int.Parse(reader["feedbackID"].ToString()); feedback.Info = reader["Info"].ToString(); feedback.contact = reader["contact"].ToString(); feedback.isInvalid = reader["isInvalid"].ToString(); feedback.solutionState = reader["solutionState"].ToString(); feedback.handler = reader["handler"].ToString(); feedback.remark = reader["remark"].ToString(); feedback.feedbackTime = DateTime.Parse(reader["feedbackTime"].ToString()); feedback.UserID = int.Parse(reader["UserID"].ToString()); Users users = new Users(); users.UserID = int.Parse(reader["UserID"].ToString()); users.userName = reader["userName"].ToString(); feedback.Users = users; feedback.categoryID = int.Parse(reader["categoryID"].ToString()); Category c = new Category(); c.categoryID = int.Parse(reader["categoryID"].ToString()); c.category = reader["category"].ToString(); feedback.Category = c; } return(Details); }