public IList<Like_NumEntity> GetAllLike_NumByuser_id(int t_user_id) { IList<Like_NumEntity> t_Like_Nums = new List<Like_NumEntity>(); OleDbDataReader sdr = null; using(sdr=OLEDBHelp.GetReader("select * from Like_Num where user_id="+t_user_id)) { while(sdr.Read()) { Like_NumEntity t_Like_Num= new Like_NumEntity(); t_Like_Num.Like_id=(int)sdr.GetValue(0); t_Like_Num.Resource_id=(int)sdr.GetValue(1); t_Like_Num.User_id=(int)sdr.GetValue(2); t_Like_Nums.Add(t_Like_Num); } sdr.Close(); } return t_Like_Nums; }
//根据主键查询整个表 public IList<Like_NumEntity> GetAllLike_Num() { IList<Like_NumEntity> t_Like_Nums = new List<Like_NumEntity>(); SqlDataReader sdr = null; using(sdr=SqlDBHelp.GetReader("select * from Like_Num")) { while(sdr.Read()) { Like_NumEntity t_Like_Num= new Like_NumEntity(); t_Like_Num.Like_id=(int)sdr.GetValue(0); t_Like_Num.Resource_id=(int)sdr.GetValue(1); t_Like_Num.User_id=(int)sdr.GetValue(2); t_Like_Nums.Add(t_Like_Num); } sdr.Close(); } return t_Like_Nums; }
//插入操作 public int InsertLike_Num(Like_NumEntity t_Like_Num) { //定义插入数据的参数数组 OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Like_id",t_Like_Num.Like_id), new OleDbParameter("@Resource_id",t_Like_Num.Resource_id), new OleDbParameter("@User_id",t_Like_Num.User_id) }; int i=OLEDBHelp.GetExecute("insert into Like_Num values (@Like_id,@Resource_id,@User_id)", p) ; return i; }
public int UpdateLike_Num(Like_NumEntity t_Like_Num) { OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Like_id",t_Like_Num.Like_id), new OleDbParameter("@Resource_id",t_Like_Num.Resource_id), new OleDbParameter("@User_id",t_Like_Num.User_id) }; int i=OLEDBHelp.GetExecute("update Like_Num set like_id=@Like_id where like_id=@Like_id", p) ; return i; }
public Like_NumEntity SelectLike_NumByID(int t_like_id) { Like_NumEntity t_Like_Num= new Like_NumEntity(); OleDbDataReader sdr=null; using(sdr=OLEDBHelp.GetReader("select * from Like_Num where like_id="+t_like_id)) { if(sdr.Read()) { t_Like_Num.Like_id=(int)sdr.GetValue(0); t_Like_Num.Resource_id=(int)sdr.GetValue(1); t_Like_Num.User_id=(int)sdr.GetValue(2); } } sdr.Close(); return t_Like_Num; }
public static int UpdateLike_Num(Like_NumEntity t_Like_Num) { int i=-1; //定义插入数据的参数数组 try { i=dal.UpdateLike_Num(t_Like_Num); } catch(Exception ex) { throw new Exception(ex.Message); } return i; }