//未回复 public List <opinionModel> Didnotreturn() { string sql = "SELECT * FROM opinion,userpigfly WHERE userpigfly.uid=dbo.opinion.opinionUid AND opDelete=0 AND opBrowsed=0"; List <opinionModel> opinions = new List <opinionModel>(); SqlDataReader reader = SQLHelper.ExecuteReader(sql); if (reader.HasRows) { while (reader.Read()) { opinionModel model = new opinionModel(); model.opId = Convert.ToInt32(reader["opId"]); model.username = reader["username"].ToString(); model.uphone = reader["uphone"].ToString(); model.uemail = reader["uemail"].ToString(); model.opContent = reader["opContent"].ToString(); model.opTime = Convert.ToDateTime(reader["opTime"]); model.opBrowsed = Convert.ToInt32(reader["opBrowsed"]); model.opType = Convert.ToInt32(reader["opType"]); opinions.Add(model); } reader.Close(); } return(opinions); }
//查询 未完善 public List <opinionModel> Thequery(string opContent) { string sql = "SELECT * FROM opinion,userpigfly WHERE userpigfly.uid=dbo.opinion.opinionUid AND opDelete=0"; if (!string.IsNullOrWhiteSpace(opContent)) { sql += " and opContent like'%" + opContent + "%'"; } List <opinionModel> opinions = new List <opinionModel>(); SqlDataReader reader = SQLHelper.ExecuteReader(sql); if (reader.HasRows) { while (reader.Read()) { opinionModel model = new opinionModel(); model.opId = Convert.ToInt32(reader["opId"]); model.username = reader["username"].ToString(); model.uphone = reader["uphone"].ToString(); model.uemail = reader["uemail"].ToString(); model.opContent = reader["opContent"].ToString(); model.opTime = Convert.ToDateTime(reader["opTime"]); model.opBrowsed = Convert.ToInt32(reader["opBrowsed"]); model.opType = Convert.ToInt32(reader["opType"]); opinions.Add(model); } reader.Close(); } return(opinions); }
//投诉 public List <opinionModel> Complaints(int opBrowsed, int opType) { StringBuilder stringBuilder = new StringBuilder("SELECT * FROM opinion,userpigfly WHERE userpigfly.uid=dbo.opinion.opinionUid AND opDelete=0 AND "); List <SqlParameter> parameters = new List <SqlParameter>(); List <string> Wherelist = new List <string>(); Wherelist.Add("opBrowsed=@opBrowsed"); parameters.Add(new SqlParameter("@opBrowsed", opBrowsed)); Wherelist.Add("opType=@opType"); parameters.Add(new SqlParameter("@opType", opType)); if (Wherelist.Count > 0) { string pj = string.Join(" and ", Wherelist.ToArray()); stringBuilder.Append(pj); } List <opinionModel> opinions = new List <opinionModel>(); SqlDataReader reader = SQLHelper.ExecuteReader(stringBuilder.ToString(), parameters.ToArray()); if (reader.HasRows) { while (reader.Read()) { opinionModel model = new opinionModel(); model.opId = Convert.ToInt32(reader["opId"]); model.username = reader["username"].ToString(); model.uphone = reader["uphone"].ToString(); model.uemail = reader["uemail"].ToString(); model.opContent = reader["opContent"].ToString(); model.opTime = Convert.ToDateTime(reader["opTime"]); model.opBrowsed = Convert.ToInt32(reader["opBrowsed"]); model.opType = Convert.ToInt32(reader["opType"]); opinions.Add(model); } reader.Close(); } return(opinions); }