public int UpdateTak_Chee_Type(Tak_Chee_TypeEntity t_Tak_Chee_Type)
{
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@Tak_chee_type_id",t_Tak_Chee_Type.Tak_chee_type_id),
new OleDbParameter("@Tak_chee_type_name",t_Tak_Chee_Type.Tak_chee_type_name)
};
int i=OLEDBHelp.GetExecute("update Tak_Chee_Type set tak_chee_type_id=@Tak_chee_type_id,tak_chee_type_name=@Tak_chee_type_name where tak_chee_type_id=@Tak_chee_type_id", p) ;
return i;
}
//根据外键进行查询
//插入操作
public int InsertTak_Chee_Type(Tak_Chee_TypeEntity t_Tak_Chee_Type)
{
//定义插入数据的参数数组
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@Tak_chee_type_id",t_Tak_Chee_Type.Tak_chee_type_id),
new OleDbParameter("@Tak_chee_type_name",t_Tak_Chee_Type.Tak_chee_type_name)
};
int i=OLEDBHelp.GetExecute("insert into Tak_Chee_Type values (@Tak_chee_type_id,@Tak_chee_type_name)", p) ;
return i;
}
//根据外键进行查询
//插入操作
public static int InsertTak_Chee_Type(Tak_Chee_TypeEntity t_Tak_Chee_Type)
{
int i=-1;
//定义插入数据的参数数组
try
{
i=dal.InsertTak_Chee_Type(t_Tak_Chee_Type);
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
return i;
}
public Tak_Chee_TypeEntity SelectTak_Chee_TypeByID(int t_tak_chee_type_id)
{
Tak_Chee_TypeEntity t_Tak_Chee_Type= new Tak_Chee_TypeEntity();
OleDbDataReader sdr=null;
using(sdr=OLEDBHelp.GetReader("select * from Tak_Chee_Type where tak_chee_type_id="+t_tak_chee_type_id))
{
if(sdr.Read())
{
t_Tak_Chee_Type.Tak_chee_type_id=(int)sdr.GetValue(0);
t_Tak_Chee_Type.Tak_chee_type_name=(string)sdr.GetValue(1);
}
}
sdr.Close();
return t_Tak_Chee_Type;
}
//根据主键查询整个表
public IList<Tak_Chee_TypeEntity> GetAllTak_Chee_Type()
{
IList<Tak_Chee_TypeEntity> t_Tak_Chee_Types = new List<Tak_Chee_TypeEntity>();
OleDbDataReader sdr = null;
using(sdr=OLEDBHelp.GetReader("select * from Tak_Chee_Type"))
{
while(sdr.Read())
{
Tak_Chee_TypeEntity t_Tak_Chee_Type= new Tak_Chee_TypeEntity();
t_Tak_Chee_Type.Tak_chee_type_id=(int)sdr.GetValue(0);
t_Tak_Chee_Type.Tak_chee_type_name=(string)sdr.GetValue(1);
t_Tak_Chee_Types.Add(t_Tak_Chee_Type);
}
sdr.Close();
}
return t_Tak_Chee_Types;
}
