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