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