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