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; }