//删除文件
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);
}
