/// <summary> /// 添加评价 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_EvaluateTableData(Evaluate_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@U_id", obj.U_id), new SqlParameter("@P_id", obj.P_id), new SqlParameter("@Eva_Datetime", obj.Eva_Datetime), new SqlParameter("@Eva_Content", obj.Eva_Content) })); }
/// <summary> /// 获取全部的评价 /// </summary> /// <returns></returns> public List <Evaluate_Table> GetEvaluateTableAll() { List <Evaluate_Table> list = new List <Evaluate_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { Evaluate_Table obj = new Evaluate_Table() { Eva_Content = dr["Eva_Content"].ToString(), Eva_Datetime = Convert.ToDateTime(dr["Eva_Datetime"]), Eva_id = Convert.ToInt32(dr["Eva_id"]), P_id = Convert.ToInt32(dr["P_id"]), U_id = Convert.ToInt32(dr["U_id"]) }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询评价信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public Evaluate_Table GetEvaluateTableByConn(string con) { Evaluate_Table obj = null; SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from Evaluate_Table where Eva_id=@Eva_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@Eva_id", con) }); if (dr.Read()) { obj = new Evaluate_Table() { Eva_Content = dr["Eva_Content"].ToString(), Eva_Datetime = Convert.ToDateTime(dr["Eva_Datetime"]), Eva_id = Convert.ToInt32(dr["Eva_id"]), P_id = Convert.ToInt32(dr["P_id"]), U_id = Convert.ToInt32(dr["U_id"]) }; } dr.Close(); return(obj); }
/// <summary> /// 更改评价信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_EvaluateTableData(Evaluate_Table obj) { return(relevanceClass.Update_EvaluateTableData(obj)); }
/// <summary> /// 添加评价信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_EvaluateTableData(Evaluate_Table obj) { return(relevanceClass.Insert_EvaluateTableData(obj)); }