//插入操作
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;
}
