//插入操作 public int InsertSearch(SearchEntity t_Search) { //定义插入数据的参数数组 OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Search_id",t_Search.Search_id), new OleDbParameter("@User_id",t_Search.User_id), new OleDbParameter("@Search_text",t_Search.Search_text) }; int i=OLEDBHelp.GetExecute("insert into Search values (@Search_id,@User_id,@Search_text)", p) ; return i; }
//根据外键进行查询 public IList<SearchEntity> GetAllSearchByuser_id(int t_user_id) { IList<SearchEntity> t_Searchs = new List<SearchEntity>(); OleDbDataReader sdr = null; using(sdr=OLEDBHelp.GetReader("select * from Search where user_id="+t_user_id)) { while(sdr.Read()) { SearchEntity t_Search= new SearchEntity(); t_Search.Search_id=(int)sdr.GetValue(0); t_Search.User_id=(int)sdr.GetValue(1); t_Search.Search_text=(string)sdr.GetValue(2); t_Searchs.Add(t_Search); } sdr.Close(); } return t_Searchs; }
//根据主键查询整个表 public IList<SearchEntity> GetAllSearch() { IList<SearchEntity> t_Searchs = new List<SearchEntity>(); SqlDataReader sdr = null; using(sdr=SqlDBHelp.GetReader("select * from Search")) { while(sdr.Read()) { SearchEntity t_Search= new SearchEntity(); t_Search.Search_id=(int)sdr.GetValue(0); t_Search.User_id=(int)sdr.GetValue(1); t_Search.Search_text=(string)sdr.GetValue(2); t_Searchs.Add(t_Search); } sdr.Close(); } return t_Searchs; }
public SearchEntity SelectSearchByID(int t_search_id) { SearchEntity t_Search= new SearchEntity(); OleDbDataReader sdr=null; using(sdr=OLEDBHelp.GetReader("select * from Search where search_id="+t_search_id)) { if(sdr.Read()) { t_Search.Search_id=(int)sdr.GetValue(0); t_Search.User_id=(int)sdr.GetValue(1); t_Search.Search_text=(string)sdr.GetValue(2); } } sdr.Close(); return t_Search; }
public int UpdateSearch(SearchEntity t_Search) { OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Search_id",t_Search.Search_id), new OleDbParameter("@User_id",t_Search.User_id), new OleDbParameter("@Search_text",t_Search.Search_text) }; int i=OLEDBHelp.GetExecute("update Search set search_id=@Search_id,search_text=@Search_text where search_id=@Search_id", p) ; return i; }
//插入操作 public static int InsertSearch(SearchEntity t_Search) { int i=-1; //定义插入数据的参数数组 try { i=dal.InsertSearch(t_Search); } catch(Exception ex) { throw new Exception(ex.Message); } return i; }