//删除文件 public String DeleteFile(int fid) { String result = "文件不存在"; DBService ds = new DBService(); DataTable dt = ds.Query("select * from Files where ID = " + fid); List <Models.MyFile> list = ToList(dt, dt.Rows.Count); if (list.Count != 0) { Models.MyFile mf = list[0]; result = ds.UpdateTable("delete from Files where ID = " + fid) ? "删除成功" : "删除失败"; String path = AppDomain.CurrentDomain.BaseDirectory + "data/" + mf.getPath(); if (File.Exists(path)) { File.Delete(path); } path = AppDomain.CurrentDomain.BaseDirectory + "dataout/" + Path.GetFileNameWithoutExtension(mf.getPath()) + ".swf"; if (File.Exists(path)) { File.Delete(path); } } ds.Close(); return(result); }
//将DataTable转为List<> public List <Models.MyFile> ToList(DataTable dt, int len) { int count = 1; List <Models.MyFile> list = new List <Models.MyFile>(); foreach (DataRow dr in dt.Rows) { if (count++ > len) { break; } Models.MyFile f = new Models.MyFile(); f.setID((int)dr["ID"]); f.setTitle((string)dr["title"]); f.setPath((string)dr["path"]); f.setDescription((string)dr["description"]); f.setTags((string)dr["tags"]); f.setUploadtime(Convert.ToString(dr["uploadtime"])); f.setIspublic((bool)dr["ispublic"]); f.setAuthor((string)dr["author"]); f.setVisits((int)dr["visits"]); list.Add(f); } return(list); }