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