protected void Page_Load(object sender, EventArgs e) { string filecode = Request["filecode"]; //del isconvert string type = Request["Type"]; //0 1 2 3 if (filecode == null || type == null) { Error(); return; } else { SqlDataReader sdr = Conn.ExecuteReader("select * from ov_files where filecode='" + filecode + "'"); if (sdr != null) { if (sdr.Read()) { /////取出数据 string filedir = sdr["filedir"].ToString(); string truedir = sdr["truedir"].ToString(); string outfilename = sdr["outfilename"].ToString(); string prefilename = sdr["prefilename"].ToString(); string filename = sdr["filename"].ToString(); // string ext = filename.Substring(filename.LastIndexOf('.')); string path = ""; path = truedir + @"tmpfiles\" + filename; path = path.Replace(@"\\", @"\"); path = path.Replace(@"/", @"\"); path = path.Replace(@"\\", @"\"); Response.AddHeader("Content-type", "application/octet-stream"); Response.AddHeader("Content-Disposition", "attachment;filename=\"" + prefilename + "\""); Response.WriteFile(path); ////设置header /////输出文件 ...ok } else { Error(); } } else { Error(); } } }
//删除视频已上传未转吗的临时文件 private void clear_file() { string str = pagebase.Get("fcode"); SqlParameter parameter = Conn.MakeInParam("@fcode", SqlDbType.Char, 0x10, str); SqlDataReader sdr = Conn.ExecuteReader("select * from ov_files where filecode=@fcode", new SqlParameter[] { parameter }); if (sdr.Read()) { //如果转换完成,删除原先文件 try { if (sdr["stat"].ToString() == "1") { string filename = sdr["truedir"].ToString() + "tmpfiles\\" + sdr["filename"].ToString(); FileInfo fi = new FileInfo(filename); if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1) { fi.Attributes = FileAttributes.Normal; } File.Delete(filename); } } catch (Exception e) { base.Response.Write("0");//删除失败 } base.Response.Write("1");//删除成功 } else { base.Response.Write("1");//已经删除 } }
protected void Page_Load(object sender, EventArgs e) { Response.AddHeader("Access-Control-Allow-Origin", "*"); List <Dictionary <string, string> > list = new List <Dictionary <string, string> >(); string action = Request["action"]; //del isconvert string filecode = Request["filecode"]; //文件filecode filecode=xxx-xxx-xxx-xxx if (action == null || filecode == null) { Response.Write("非法访问!"); HttpContext.Current.Response.End(); } string[] codeArr = filecode.Split(new char[] { '-' }); //切分 string inFilecodes = ""; for (int i = 0; i < codeArr.Length - 1; i++) { codeArr[i] = ("'" + codeArr[i] + "'"); inFilecodes += (codeArr[i] + ","); } inFilecodes += "'" + codeArr[codeArr.Length - 1] + "'"; try { if (action == "isconvert") { SqlDataReader dr = Conn.ExecuteReader("select stat,filecode,times,autoimg,flvsize,filetype from ov_files where filecode in(" + inFilecodes + ")");//查询 if (dr.Read()) { Dictionary <string, string> dic = new Dictionary <string, string>();//json字典 if (dr["stat"].ToString() == "1") { dic.Add("result", "true"); dic.Add("filecode", dr["filecode"].ToString()); //filecode dic.Add("times", dr["times"].ToString()); dic.Add("autoimg", dr["autoimg"].ToString()); dic.Add("flvsize", dr["flvsize"].ToString()); dic.Add("filetype", dr["filetype"].ToString()); } else if (dr["stat"].ToString() == "0" || dr["stat"].ToString() == "2") { dic.Add("result", "false"); } else if (dr["stat"].ToString() == "4") { dic.Add("result", "failure"); } list.Add(dic); while (dr.Read()) { dic = new Dictionary <string, string>(); //json字典 if (dr["stat"].ToString() == "1") //转换成功 { dic.Add("result", "true"); dic.Add("filecode", dr["filecode"].ToString()); //filecode dic.Add("times", dr["times"].ToString()); dic.Add("autoimg", dr["autoimg"].ToString()); dic.Add("flvsize", dr["flvsize"].ToString()); dic.Add("filetype", dr["filetype"].ToString()); } else if (dr["stat"].ToString() == "0" || dr["stat"].ToString() == "2") { dic.Add("result", "false"); } else if (dr["stat"].ToString() == "3") { dic.Add("result", "failure"); } list.Add(dic); } //关闭链接,必须手工关闭 Conn.CloseConnectionReader(); Response.Write(vodfile.JsonStringModule.ToJsonString(list)); } else { Conn.CloseConnectionReader(); Response.Write("{result:'false',info:'文件不存在'}"); } } //[[add by 境界@20160820:增加接口处理delete file的请求 else if (action == "delete") { string perID = Request["perID"]; if (perID != "73d2428effef619d51d8bcca966f7d98") { Response.Write("perID Invalid"); //关闭链接,必须手工关闭 Conn.CloseConnectionReader(); } else { //从数据库的ov_files表中查询filecode对应的记录,记录项需要:filename, filedir , truedir, outfilename. //filename 是上传的源文件,需要删除;outfilename是转码完毕的目标文件,需要删除。还需要删除图标文件。还需要删除云存储上的文件。但此表中没有云存储的路径。 SqlDataReader dr = Conn.ExecuteReader("select filecode,filename,filedir,truedir, outfilename from ov_files where filecode in(" + inFilecodes + ")"); //查询 bool bDeleted = false; bool bFileNotexsit = true; bool brecodeExsit = false; if (dr.Read()) { bDeleted = true; bFileNotexsit = false; brecodeExsit = true; //删除本地文件 string strFileDir = dr["filedir"].ToString(); string strSrcFileName = dr["filename"].ToString(); string strDstFileName = dr["outfilename"].ToString(); string strTrueDir = dr["truedir"].ToString(); //拼接源文件路径 string strSrcPathName = strTrueDir + @"tmpfiles\" + strSrcFileName; strSrcPathName = strSrcPathName.Replace(@"\\", @"\"); strSrcPathName = strSrcPathName.Replace(@"/", @"\"); strSrcPathName = strSrcPathName.Replace(@"\\", @"\"); //删除源文件 if (System.IO.File.Exists(strSrcPathName)) { System.IO.File.Delete(strSrcPathName); } //拼接目标文件路径 string strDstPathName = strTrueDir + strFileDir + @"\" + strDstFileName; strDstPathName = strDstPathName.Replace(@"\\", @"\"); strDstPathName = strDstPathName.Replace(@"/", @"\"); strDstPathName = strDstPathName.Replace(@"\\", @"\"); //删除转码目标文件 if (System.IO.File.Exists(strDstPathName)) { System.IO.File.Delete(strDstPathName); } //删除图标文件 string strImgpath = strTrueDir + strFileDir + @"\img\"; strImgpath = strImgpath.Replace(@"\\", @"\"); strImgpath = strImgpath.Replace(@"/", @"\"); strImgpath = strImgpath.Replace(@"\\", @"\"); foreach (string FileName in System.IO.Directory.GetFiles(strImgpath, dr["filecode"].ToString() + @"_*.jpg")) { string strFile = System.IO.Path.GetFileName(FileName); if (System.IO.File.Exists(strFile)) { System.IO.File.Delete(strFile); } } while (dr.Read()) { //删除本地文件 strFileDir = dr["filedir"].ToString(); strSrcFileName = dr["filename"].ToString(); strDstFileName = dr["outfilename"].ToString(); strTrueDir = dr["truedir"].ToString(); //拼接源文件路径 strSrcPathName = strTrueDir + @"tmpfiles\" + strSrcFileName; strSrcPathName = strSrcPathName.Replace(@"\\", @"\"); strSrcPathName = strSrcPathName.Replace(@"/", @"\"); strSrcPathName = strSrcPathName.Replace(@"\\", @"\"); //删除源文件 if (System.IO.File.Exists(strSrcPathName)) { System.IO.File.Delete(strSrcPathName); } //拼接目标文件路径 strDstPathName = strTrueDir + strFileDir + @"\" + strDstFileName; strDstPathName = strDstPathName.Replace(@"\\", @"\"); strDstPathName = strDstPathName.Replace(@"/", @"\"); strDstPathName = strDstPathName.Replace(@"\\", @"\"); //删除转码目标文件 if (System.IO.File.Exists(strDstPathName)) { System.IO.File.Delete(strDstPathName); } //删除图标文件 strImgpath = strTrueDir + strFileDir + @"\img\"; strImgpath = strImgpath.Replace(@"\\", @"\"); strImgpath = strImgpath.Replace(@"/", @"\"); strImgpath = strImgpath.Replace(@"\\", @"\"); foreach (string FileName in System.IO.Directory.GetFiles(strImgpath, dr["filecode"].ToString() + @"_*.jpg")) { string strFile = System.IO.Path.GetFileName(FileName); if (System.IO.File.Exists(strFile)) { System.IO.File.Delete(strFile); } } } Response.Write(vodfile.JsonStringModule.ToJsonString(list)); } if (brecodeExsit) { //删除数据库记录 Conn.ExecuteNonQuery("delete from ov_files where filecode in filecode in(" + inFilecodes + ")"); } //回送结果 if (bDeleted || bFileNotexsit) { //已经删除,或者文件不存在 //回送结果 Response.Write("Delete File Done"); } //关闭数据库链接,必须手工关闭 Conn.CloseConnectionReader(); } } //]] } catch { Response.Write("{result:'false',info:'服务调用失败'}"); } }
protected void Page_Load(object sender, EventArgs e) { // Response.AddHeader("Access-Control-Allow-Origin", "*"); //获取一系列传入参数 string str = pagebase.Get("action"); this.filetype = func.GetInt(pagebase.Get("filetype")); //文件属性 this.fromApp = pagebase.Get("from"); //调用app this.md5 = pagebase.Get("md5"); //获取md5参数 if (md5 == string.Empty || str == string.Empty) { this.SendResponse("禁止非法调用上传服务!"); } else { ////////////////////////md5去重秒传/////////////////////////// ////查询ID 并且 写入md5 StringBuilder builder = new StringBuilder(); builder.Append("select VideoFileID from FileHash where FileHash ='"); builder.Append(md5); builder.Append("'"); SqlDataReader sdr = Conn.ExecuteReader(builder.ToString()); if (sdr.Read()) { string id = sdr["VideoFileID"].ToString(); //暂时不处理MD5 sdr.Close(); builder = new StringBuilder(); builder.AppendFormat("select * from ov_files where id={0}", id); sdr = Conn.ExecuteReader(builder.ToString()); if (sdr.Read()) { //秒传 string filedir = sdr["filedir"].ToString(); string oldfilename = sdr["outfilename"].ToString(); string prefilename = sdr["prefilename"].ToString(); ///原始文件的名字 string filename = sdr["filename"].ToString(); string filesize = sdr["filesize"].ToString(); string filecode = sdr["filecode"].ToString(); this.SendResponse("{\"status\":\"2\",\"md5\":\"" + md5 + "\",\"filedir\":\"" + filedir + "\",\"outfilename\":\"" + oldfilename + "\",\"oldname\":\"" + prefilename + "\",\"filcode\":\"" + filecode + "\",\"filename\":\"" + filename + "\",\"filesize\":\"" + filesize + "\"}"); } } //////////////////////////////////////////////////////// } if (str.IndexOf("save") >= 0) { //上传完成,返回后 this.fromApp = str.Substring(str.LastIndexOf("=") + 1);//返回调用app参数 this.save_upload(); } else { //第一次加载初次打开页面 //1、检验是否为允许上传服务器 //非法调用直接返回 if (!actCheck()) { this.SendResponse("禁止非法调用上传服务!"); } } }
/// <summary> /// 上传完成保存 /// </summary> protected void save_upload() { UpFiles files; files = new UpFiles { SavePath = "tmpfiles" }; //存储文件 files.SaveUploadFiles(); //写入数据库 if ((files.GetPromptMessage() != null) || (files.listFile.Count == 0))//文件 { base.Response.End(); } else { try { dic = new Dictionary <string, string>(); string fileName = files.listFile[0].fileName; int fileSize = files.listFile[0].fileSize; //文件标题名,不含扩展名 string oldname = files.listFile[0].oldname; string ext = files.listFile[0].fileExt; //文件代码 string fcode = func.GetRandomString(0x10).ToLower(); //[stat] 0 //对外访问路径 string filedir = func.GetFlvFolder(); //本地文件相对路径 string truedir = HttpContext.Current.Server.MapPath(".") + @"\"; if (!System.IO.Directory.Exists(@truedir + "tmpfiles\\")) { //目录不存在,建立目录 System.IO.Directory.CreateDirectory(@truedir + "tmpfiles\\"); } //对外文件名 string outfilename = getOutFileName(this.filetype); string webserver = System.Configuration.ConfigurationManager.AppSettings.Get("webserver").ToString(); //string webserver = ""; string ischange = System.Configuration.ConfigurationManager.AppSettings.Get("ischange").ToString(); dic.Add("filecode", fcode); dic.Add("filename", fileName); dic.Add("filesize", fileSize.ToString()); dic.Add("outfilename", outfilename); dic.Add("stat", ischange); dic.Add("addtime", DateTime.Now.ToString()); dic.Add("filedir", filedir); dic.Add("linkflv", "0"); dic.Add("truedir", truedir.Replace("\\", "\\\\")); dic.Add("webserver", webserver); dic.Add("filetype", "0"); dic.Add("prefilename", oldname + ext); dic.Add("addip", func.GetIp()); dic.Add("errcount", "0"); dic.Add("isdel", "0"); StringBuilder builder = new StringBuilder(); builder.Append("insert into ov_files ("); builder.Append("filecode,filename,filesize,outfilename,stat,addtime,filedir,linkflv,truedir,webserver,filetype,prefilename,addip,errcount,isdel)"); builder.Append("values ("); builder.AppendFormat("'{0}','{1}',{2},'{3}',{4},'{5}','{6}',{7},'{8}','{9}','{10}','{11}','{12}',{13},{14})", dic["filecode"].ToString(), dic["filename"].ToString(), dic["filesize"].ToString(), dic["outfilename"].ToString(), Convert.ToInt32(dic["stat"].ToString()), Convert.ToDateTime(dic["addtime"].ToString()), dic["filedir"].ToString(), Convert.ToInt32(dic["linkflv"].ToString()), Convert.ToString(dic["truedir"]), dic["webserver"].ToString(), dic["filetype"].ToString(), dic["prefilename"].ToString(), dic["addip"].ToString(), Convert.ToInt32(dic["errcount"]), Convert.ToInt32(dic["isdel"])); builder.Append(";"); int result = Conn.ExecuteNonQuery(builder.ToString()); if (result > 0) { //获取插入的id 插入md5 /////////////////////////////////////////////////// ////查询ID 并且 写入md5 //异常暂不处理 失败返回null builder = new StringBuilder(); builder.Append("select id from ov_files where filecode='"); builder.Append(dic["filecode"]); builder.Append("'"); SqlDataReader sdr = Conn.ExecuteReader(builder.ToString()); if (sdr.Read()) { string id = sdr["id"].ToString(); sdr.Close(); builder = new StringBuilder(); builder.AppendFormat("insert into FileHash(FileHash,VideoFileID) values('{0}','{1}')", this.md5, id); Conn.ExecuteNonQuery(builder.ToString()); } //////////////////////////////////////////////////////// HttpContext.Current.Response.Write("{\"status\":\"1\",\"md5\":\"" + md5 + "\",\"filedir\":\"" + filedir + "\",\"outfilename\":\"" + outfilename + "\",\"oldname\":\"" + oldname + ext + "\",\"filcode\":\"" + fcode + "\",\"filename\":\"" + fileName + "\",\"filesize\":\"" + fileSize + "\"}");//成功 } else { HttpContext.Current.Response.Write("上传失败");//成功 } } catch (Exception exception) { base.Response.Write(exception.ToString()); } base.Response.End(); } }