//插入操作 public int InsertLanded_Info(Landed_InfoEntity t_Landed_Info) { //定义插入数据的参数数组 OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Landed_info_id",t_Landed_Info.Landed_info_id), new OleDbParameter("@User_id",t_Landed_Info.User_id), new OleDbParameter("@Ip_address",t_Landed_Info.Ip_address), new OleDbParameter("@Landed_time",t_Landed_Info.Landed_time) }; int i=OLEDBHelp.GetExecute("insert into Landed_Info values (@Landed_info_id,@User_id,@Ip_address,@Landed_time)", p) ; return i; }
//根据外键进行查询 public IList<Landed_InfoEntity> GetAllLanded_InfoByuser_id(int t_user_id) { IList<Landed_InfoEntity> t_Landed_Infos = new List<Landed_InfoEntity>(); OleDbDataReader sdr = null; using(sdr=OLEDBHelp.GetReader("select * from Landed_Info where user_id="+t_user_id)) { while(sdr.Read()) { Landed_InfoEntity t_Landed_Info= new Landed_InfoEntity(); t_Landed_Info.Landed_info_id=(int)sdr.GetValue(0); t_Landed_Info.User_id=(int)sdr.GetValue(1); t_Landed_Info.Ip_address=(string)sdr.GetValue(2); t_Landed_Info.Landed_time=(DateTime)sdr.GetValue(3); t_Landed_Infos.Add(t_Landed_Info); } sdr.Close(); } return t_Landed_Infos; }
//插入操作 public static int InsertLanded_Info(Landed_InfoEntity t_Landed_Info) { int i=-1; //定义插入数据的参数数组 try { i=dal.InsertLanded_Info(t_Landed_Info); } catch(Exception ex) { throw new Exception(ex.Message); } return i; }
public Landed_InfoEntity SelectLanded_InfoByID(int t_landed_info_id) { Landed_InfoEntity t_Landed_Info= new Landed_InfoEntity(); OleDbDataReader sdr=null; using(sdr=OLEDBHelp.GetReader("select * from Landed_Info where landed_info_id="+t_landed_info_id)) { if(sdr.Read()) { t_Landed_Info.Landed_info_id=(int)sdr.GetValue(0); t_Landed_Info.User_id=(int)sdr.GetValue(1); t_Landed_Info.Ip_address=(string)sdr.GetValue(2); t_Landed_Info.Landed_time=(DateTime)sdr.GetValue(3); } } sdr.Close(); return t_Landed_Info; }
public int UpdateLanded_Info(Landed_InfoEntity t_Landed_Info) { OleDbParameter[] p=new OleDbParameter[]{ new OleDbParameter("@Landed_info_id",t_Landed_Info.Landed_info_id), new OleDbParameter("@User_id",t_Landed_Info.User_id), new OleDbParameter("@Ip_address",t_Landed_Info.Ip_address), new OleDbParameter("@Landed_time",t_Landed_Info.Landed_time) }; int i=OLEDBHelp.GetExecute("update Landed_Info set landed_info_id=@Landed_info_id,ip_address=@Ip_address,landed_time=@Landed_time where landed_info_id=@Landed_info_id", p) ; return i; }