public IList<ResourceEntity> GetAllResourceByauditor_type_id(int t_auditor_type_id)
{
IList<ResourceEntity> t_Resources = new List<ResourceEntity>();
OleDbDataReader sdr = null;
using(sdr=OLEDBHelp.GetReader("select * from Resource where auditor_type_id="+t_auditor_type_id))
{
while(sdr.Read())
{
ResourceEntity t_Resource= new ResourceEntity();
t_Resource.Resource_id=(int)sdr.GetValue(0);
t_Resource.User_id=(int)sdr.GetValue(1);
t_Resource.Resource_type_id=(int)sdr.GetValue(2);
t_Resource.Resource_title=(string)sdr.GetValue(3);
t_Resource.Resource_description=(string)sdr.GetValue(4);
t_Resource.Resource_path=(string)sdr.GetValue(5);
t_Resource.Resource_publish_time=(DateTime)sdr.GetValue(6);
t_Resource.Resource_changed_time=(DateTime)sdr.GetValue(7);
t_Resource.Resource_traffic=(int)sdr.GetValue(8);
t_Resource.Resource_downloads=(int)sdr.GetValue(9);
t_Resource.Auditor_type_id=(int)sdr.GetValue(10);
t_Resource.Resource_like=(int)sdr.GetValue(11);
t_Resource.Grade_type_id=(int)sdr.GetValue(12);
t_Resource.Subject_type_id=(int)sdr.GetValue(13);
t_Resource.Stage_type_id=(int)sdr.GetValue(14);
t_Resource.Tak_chee_type_id=(int)sdr.GetValue(15);
t_Resources.Add(t_Resource);
}
sdr.Close();
}
return t_Resources;
}
public int UpdateResource(ResourceEntity t_Resource)
{
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@Resource_id",t_Resource.Resource_id),
new OleDbParameter("@User_id",t_Resource.User_id),
new OleDbParameter("@Resource_type_id",t_Resource.Resource_type_id),
new OleDbParameter("@Resource_title",t_Resource.Resource_title),
new OleDbParameter("@Resource_description",t_Resource.Resource_description),
new OleDbParameter("@Resource_path",t_Resource.Resource_path),
new OleDbParameter("@Resource_publish_time",t_Resource.Resource_publish_time),
new OleDbParameter("@Resource_changed_time",t_Resource.Resource_changed_time),
new OleDbParameter("@Resource_traffic",t_Resource.Resource_traffic),
new OleDbParameter("@Resource_downloads",t_Resource.Resource_downloads),
new OleDbParameter("@Auditor_type_id",t_Resource.Auditor_type_id),
new OleDbParameter("@Resource_like",t_Resource.Resource_like),
new OleDbParameter("@Grade_type_id",t_Resource.Grade_type_id),
new OleDbParameter("@Subject_type_id",t_Resource.Subject_type_id),
new OleDbParameter("@Stage_type_id",t_Resource.Stage_type_id),
new OleDbParameter("@Tak_chee_type_id",t_Resource.Tak_chee_type_id)
};
int i=OLEDBHelp.GetExecute("update Resource set resource_id=@Resource_id,resource_title=@Resource_title,resource_description=@Resource_description,resource_path=@Resource_path,resource_publish_time=@Resource_publish_time,resource_changed_time=@Resource_changed_time,resource_traffic=@Resource_traffic,resource_downloads=@Resource_downloads,resource_like=@Resource_like where resource_id=@Resource_id", p) ;
return i;
}
//插入操作
public int InsertResource(ResourceEntity t_Resource)
{
//定义插入数据的参数数组
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@Resource_id",t_Resource.Resource_id),
new OleDbParameter("@User_id",t_Resource.User_id),
new OleDbParameter("@Resource_type_id",t_Resource.Resource_type_id),
new OleDbParameter("@Resource_title",t_Resource.Resource_title),
new OleDbParameter("@Resource_description",t_Resource.Resource_description),
new OleDbParameter("@Resource_path",t_Resource.Resource_path),
new OleDbParameter("@Resource_publish_time",t_Resource.Resource_publish_time),
new OleDbParameter("@Resource_changed_time",t_Resource.Resource_changed_time),
new OleDbParameter("@Resource_traffic",t_Resource.Resource_traffic),
new OleDbParameter("@Resource_downloads",t_Resource.Resource_downloads),
new OleDbParameter("@Auditor_type_id",t_Resource.Auditor_type_id),
new OleDbParameter("@Resource_like",t_Resource.Resource_like),
new OleDbParameter("@Grade_type_id",t_Resource.Grade_type_id),
new OleDbParameter("@Subject_type_id",t_Resource.Subject_type_id),
new OleDbParameter("@Stage_type_id",t_Resource.Stage_type_id),
new OleDbParameter("@Tak_chee_type_id",t_Resource.Tak_chee_type_id)
};
int i=OLEDBHelp.GetExecute("insert into Resource values (@Resource_id,@User_id,@Resource_type_id,@Resource_title,@Resource_description,@Resource_path,@Resource_publish_time,@Resource_changed_time,@Resource_traffic,@Resource_downloads,@Auditor_type_id,@Resource_like,@Grade_type_id,@Subject_type_id,@Stage_type_id,@Tak_chee_type_id)", p) ;
return i;
}
public ResourceEntity SelectResourceByID(int t_resource_id)
{
ResourceEntity t_Resource= new ResourceEntity();
OleDbDataReader sdr=null;
using(sdr=OLEDBHelp.GetReader("select * from Resource where resource_id="+t_resource_id))
{
if(sdr.Read())
{
t_Resource.Resource_id=(int)sdr.GetValue(0);
t_Resource.User_id=(int)sdr.GetValue(1);
t_Resource.Resource_type_id=(int)sdr.GetValue(2);
t_Resource.Resource_title=(string)sdr.GetValue(3);
t_Resource.Resource_description=(string)sdr.GetValue(4);
t_Resource.Resource_path=(string)sdr.GetValue(5);
t_Resource.Resource_publish_time=(DateTime)sdr.GetValue(6);
t_Resource.Resource_changed_time=(DateTime)sdr.GetValue(7);
t_Resource.Resource_traffic=(int)sdr.GetValue(8);
t_Resource.Resource_downloads=(int)sdr.GetValue(9);
t_Resource.Auditor_type_id=(int)sdr.GetValue(10);
t_Resource.Resource_like=(int)sdr.GetValue(11);
t_Resource.Grade_type_id=(int)sdr.GetValue(12);
t_Resource.Subject_type_id=(int)sdr.GetValue(13);
t_Resource.Stage_type_id=(int)sdr.GetValue(14);
t_Resource.Tak_chee_type_id=(int)sdr.GetValue(15);
}
}
sdr.Close();
return t_Resource;
}
public static int UpdateResource(ResourceEntity t_Resource)
{
int i=-1;
//定义插入数据的参数数组
try
{
i=dal.UpdateResource(t_Resource);
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
return i;
}
