/// <summary> /// 从up7_files表中加载所有已经上传完毕的文件 /// </summary> /// <param name="uid"></param> /// <returns></returns> public string all_complete(int uid) { List <DnFileInf> fs = new List <DnFileInf>(); StringBuilder sb = new StringBuilder(); sb.Append("select "); sb.Append(" f_id"); //0 sb.Append(",f_fdTask"); //1 sb.Append(",f_nameLoc"); //2 sb.Append(",f_sizeLoc"); //3 sb.Append(",f_lenSvr"); //4 sb.Append(",f_pathSvr"); //5 sb.Append(",f_blockPath"); //6 sb.Append(",fd_files"); //7 sb.Append(" from up7_files "); sb.Append(" left join up7_folders on up7_folders.fd_id=up7_files.f_id"); // sb.Append(" where f_uid=@f_uid and f_deleted=0 and f_complete=1 and f_merged=1 and f_fdChild=0"); DbHelper db = new DbHelper(); DbCommand cmd = db.GetCommand(sb.ToString()); db.AddInt(ref cmd, "@f_uid", uid); DbDataReader r = db.ExecuteReader(cmd); while (r.Read()) { DnFileInf f = new DnFileInf(); f.id = Guid.NewGuid().ToString("N"); f.f_id = r.GetString(0); f.fdTask = r.GetBoolean(1); f.nameLoc = r.GetString(2); f.sizeLoc = "0byte"; f.sizeSvr = r.GetString(3); f.lenSvr = r.GetInt64(4); f.pathSvr = r.GetString(5); f.blockPath = r.GetString(6); f.fileCount = r.IsDBNull(7) ? 0 : r.GetInt32(7); fs.Add(f); } r.Close(); if (fs.Count < 1) { return(string.Empty); } return(JsonConvert.SerializeObject(fs)); }
protected void Page_Load(object sender, EventArgs e) { string uid = Request.QueryString["uid"]; string id = Request.QueryString["id"]; string f_id = Request.QueryString["f_id"]; string nameLoc = Request.QueryString["nameLoc"]; //客户端使用的是encodeURIComponent编码, string pathLoc = Request.QueryString["pathLoc"]; //客户端使用的是encodeURIComponent编码, string fileUrl = Request.QueryString["fileUrl"]; string lenSvr = Request.QueryString["lenSvr"]; string sizeSvr = Request.QueryString["sizeSvr"]; string cbk = Request.QueryString["callback"]; //应用于jsonp数据 pathLoc = PathTool.url_decode(pathLoc); nameLoc = PathTool.url_decode(nameLoc); if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(pathLoc) || string.IsNullOrEmpty(fileUrl) || string.IsNullOrEmpty(lenSvr)) { Response.Write(cbk + "({\"value\":null})"); Response.End(); return; } DnFileInf inf = new DnFileInf(); inf.id = id; inf.f_id = f_id; inf.uid = int.Parse(uid); inf.nameLoc = nameLoc; inf.pathLoc = pathLoc;//记录本地存储位置 inf.fileUrl = fileUrl; inf.lenSvr = long.Parse(lenSvr); inf.sizeSvr = sizeSvr; DnFile df = new DnFile(); df.Add(ref inf); string json = JsonConvert.SerializeObject(inf); json = HttpUtility.UrlEncode(json); json = json.Replace("+", "%20"); json = cbk + "({\"value\":\"" + json + "\"})";//返回jsonp格式数据。 Response.Write(json); }
/// <summary> /// /// </summary> /// <param name="uid"></param> /// <returns></returns> public override string all_uncmp(int uid) { List <DnFileInf> files = new List <DnFileInf>(); StringBuilder sb = new StringBuilder(); sb.Append("select "); sb.Append(" f_id"); //0 sb.Append(",f_nameLoc"); //1 sb.Append(",f_pathLoc"); //2 sb.Append(",f_perLoc"); //3 sb.Append(",f_sizeSvr"); //7 sb.Append(",f_fdTask"); //10 // sb.Append(" from down_files"); // sb.Append(" where f_uid=? and f_complete=False"); DbHelper db = new DbHelper(); DbCommand cmd = db.GetCommand(sb.ToString()); db.AddInt(ref cmd, "@f_uid", uid); DbDataReader r = db.ExecuteReader(cmd); while (r.Read()) { DnFileInf f = new DnFileInf(); f.id = r.GetString(0); f.nameLoc = r.GetString(1); f.pathLoc = r.GetString(2); f.perLoc = r.GetString(3); f.sizeSvr = r.GetString(4); int ftk = r.GetInt32(5); if (ftk == 1) { f.fdTask = true; } files.Add(f); } r.Close(); if (files.Count > 0) { return(JsonConvert.SerializeObject(files)); } return(string.Empty); }
/// <summary> /// 从up6_files表中加载所有已经上传完毕的文件 /// </summary> /// <param name="uid"></param> /// <returns></returns> public override string all_complete(int uid) { List <DnFileInf> fs = new List <DnFileInf>(); StringBuilder sb = new StringBuilder(); sb.Append("select "); sb.Append(" f_id"); //0 sb.Append(",f_fdTask"); //1 sb.Append(",f_nameLoc"); //2 sb.Append(",f_sizeLoc"); //3 sb.Append(",f_lenSvr"); //4 sb.Append(",f_pathSvr"); //5 sb.Append(" from up6_files "); // sb.Append(" where f_uid=? and f_deleted=False and f_complete=TRUE and f_fdChild=FALSE and f_scan=TRUE"); DbHelper db = new DbHelper(); DbCommand cmd = db.GetCommand(sb.ToString()); db.AddInt(ref cmd, "@f_uid", uid); DbDataReader r = db.ExecuteReader(cmd); while (r.Read()) { DnFileInf f = new DnFileInf(); f.id = Guid.NewGuid().ToString("N"); f.f_id = r.GetString(0); var ftk = r.GetValue(1).ToString().ToLower(); if (ftk == "true" || ftk == "1") { f.fdTask = true; } f.nameLoc = r.GetString(2); f.sizeLoc = r.GetString(3); f.sizeSvr = r.GetString(3); f.lenSvr = r.GetInt64(4); f.pathSvr = r.GetString(5); fs.Add(f); } r.Close(); if (fs.Count < 1) { return(string.Empty); } return(JsonConvert.SerializeObject(fs)); }
/** * * @param pageIndex 页索引,基于1 */ public String read(String pageIndex, String id) { int pageSize = 100;//每页100条数据 int index = int.Parse(pageIndex); index = Math.Max(index, 1);//基于1 int pageStart = ((index - 1) * pageSize) + 1; int pageEnd = index * pageSize; string sql = string.Format(@"select * from ( select f_id,f_nameLoc,f_pathSvr,f_pathRel,f_lenLoc,f_sizeLoc,f_blockPath,f_blockSize,ROW_NUMBER() OVER(Order by (select null) ) as RowNumber from up7_files where f_pidRoot='{0}' )a where RowNumber BETWEEN {1} and {2} ", id, pageStart, pageEnd); List <DnFileInf> files = new List <DnFileInf>(); DbHelper db = new DbHelper(); using (var cmd = db.GetCommand(sql)) { using (var r = db.ExecuteReader(cmd)) { while (r.Read()) { var f = new DnFileInf(); f.id = Guid.NewGuid().ToString("N"); f.f_id = r.GetString(0); f.nameLoc = r.GetString(1);//f_nameLoc f.pathSvr = r.GetString(2); f.pathRel = r.GetString(3); f.lenSvr = r.GetInt64(4); f.sizeSvr = r.GetString(5); f.blockPath = r.GetString(6); f.blockSize = r.GetInt32(7); files.Add(f); } r.Close(); } } if (files.Count > 0) { return(JsonConvert.SerializeObject(files)); } return(""); }
public void Add(ref DnFileInf inf) { StringBuilder sql = new StringBuilder(); sql.Append("insert into down3_files("); sql.Append(" f_id"); sql.Append(",f_uid"); sql.Append(",f_mac"); sql.Append(",f_nameLoc"); sql.Append(",f_pathLoc"); sql.Append(",f_fileUrl"); sql.Append(",f_lenSvr"); sql.Append(",f_sizeLoc"); sql.Append(",f_sizeSvr"); sql.Append(",f_fdTask"); sql.Append(") values("); sql.Append(" @f_id"); sql.Append(",@f_uid"); sql.Append(",@f_mac"); sql.Append(",@f_nameLoc"); sql.Append(",@f_pathLoc"); sql.Append(",@f_fileUrl"); sql.Append(",@f_lenSvr"); sql.Append(",@f_sizeLoc"); sql.Append(",@f_sizeSvr"); sql.Append(",@f_fdTask"); sql.Append(");"); DbHelper db = new DbHelper(); DbCommand cmd = db.GetCommand(sql.ToString()); db.AddString(ref cmd, "@f_id", inf.id, 32); db.AddInt(ref cmd, "@f_uid", inf.uid); db.AddString(ref cmd, "@f_mac", inf.mac, 50); db.AddString(ref cmd, "@f_nameLoc", inf.nameLoc, 255); db.AddString(ref cmd, "@f_pathLoc", inf.pathLoc, 255); db.AddString(ref cmd, "@f_fileUrl", inf.fileUrl, 255); db.AddInt64(ref cmd, "@f_lenSvr", inf.lenSvr); db.AddString(ref cmd, "@f_sizeLoc", inf.sizeLoc, 10); db.AddString(ref cmd, "@f_sizeSvr", inf.sizeSvr, 10); db.AddBool(ref cmd, "@f_fdTask", inf.fdTask); db.ExecuteNonQuery(ref cmd); }
protected void Page_Load(object sender, EventArgs e) { string uid = Request.QueryString["uid"]; string cbk = Request.QueryString["callback"]; string id = Request.QueryString["id"]; string nameLoc = Request.QueryString["nameLoc"]; string pathLoc = Request.QueryString["pathLoc"]; string sizeSvr = Request.QueryString["sizeSvr"]; sizeSvr = PathTool.url_decode(sizeSvr); pathLoc = PathTool.url_decode(pathLoc); nameLoc = PathTool.url_decode(nameLoc); if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(nameLoc) || string.IsNullOrEmpty(pathLoc) ) { Response.Write(cbk + "(0)"); return; } DnFileInf fd = new DnFileInf(); fd.nameLoc = nameLoc; fd.pathLoc = pathLoc; fd.id = id; fd.sizeSvr = sizeSvr; fd.fdTask = true; DnFile db = new DnFile(); db.Add(ref fd); string json = JsonConvert.SerializeObject(fd); json = HttpUtility.UrlEncode(json); json = json.Replace("+", "%20"); json = cbk + "({\"value\":\"" + json + "\"})";//返回jsonp格式数据。 Response.Write(json); }