/// <summary>
/// 查询评论:用户ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <Model.PictureTalk> QueryPictureTalkU_ID(int id)
{
string text = "select * from picturetalk where u_id=:id";
List <Model.PictureTalk> list = new List <Model.PictureTalk>();
OracleParameter[] pars = new OracleParameter[]
{
new OracleParameter("id", id)
};
OracleDataReader odr = OracleHelper.QueryMore(text, pars);
if (odr.HasRows)
{
while (odr.Read())
{
Model.PictureTalk pt = new Model.PictureTalk();
pt.pt_id = int.Parse(odr["pt_id"].ToString());
pt.p_id = int.Parse(odr["p_id"].ToString());
pt.u_id = int.Parse(odr["u_id"].ToString());
pt.u_name = odr["u_name"].ToString();
pt.u_text = odr["u_text"].ToString();
pt.u_date = odr["u_date"].ToString();
list.Add(pt);
}
}
odr.Close();
return(list);
}
public int AddPictureTalk(Model.PictureTalk pt)
{
string text = "insert into picturetalk(p_id,u_id,u_name,u_text,u_date) values(:p_id,:u_id,:name,:text,:date)";
OracleParameter[] pars = new OracleParameter[5]
{
new OracleParameter("p_id", pt.p_id),
new OracleParameter("name", pt.u_name),
new OracleParameter("u_id", pt.u_id),
new OracleParameter("text", pt.u_text),
new OracleParameter("date", pt.u_date)
};
return(OracleHelper.ExecuteNonQuery(text, pars));
}
public int AddPictureTalk(Model.PictureTalk pt)
{
return(pictureTalk.AddPictureTalk(pt));
}
