/// <summary>
/// 向down_files添加一个文件夹任务
/// </summary>
/// <param name="inf"></param>
/// <returns></returns>
public static int Add(ref DnFolderInf inf)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into down_files(");
sb.Append("f_uid");
sb.Append(",f_mac");
sb.Append(",f_pathLoc");
sb.Append(",f_fdID)");
sb.Append(" values(");
sb.Append("@f_uid");
sb.Append(",@f_mac");
sb.Append(",@f_pathLoc");
sb.Append(",@f_fdID);");
//
sb.Append("select @@IDENTITY");
DbHelper db = new DbHelper();
DbCommand cmd = db.GetCommand(sb.ToString());
db.AddInt(ref cmd, "@f_uid", inf.uid);
db.AddString(ref cmd, "@f_mac", inf.mac, 50);
db.AddString(ref cmd, "@f_pathLoc", inf.pathLoc, 255);
db.AddInt(ref cmd, "@f_fdID", inf.idSvr);
inf.idF = Convert.ToInt32(db.ExecuteScalar(ref cmd));
return(inf.idF);
}
/// <summary>
/// 从xdb_folders中复制数据到down_folders中
/// 从xdb_files中复制数据到down_files中
/// </summary>
/// <param name="fid">xdb_folders中的fd_id</param>
public static int Add(ref DnFolderInf dfi)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into down_folders(fd_name");
sb.Append(",fd_uid");
sb.Append(",fd_mac");
sb.Append(",fd_pathLoc");
sb.Append(",fd_id_old)");
//
sb.Append(" values(@fd_name");
sb.Append(",@fd_uid");
sb.Append(",@fd_mac");
sb.Append(",@fd_pathLoc");
sb.Append(",@fd_id_old)");
DbHelper db = new DbHelper();
DbCommand cmd = db.GetCommand(sb.ToString());
db.AddString(ref cmd, "@fd_name", dfi.name, 255);
db.AddInt(ref cmd, "@fd_uid", dfi.uid);
db.AddString(ref cmd, "@fd_mac", dfi.mac, 255);
db.AddString(ref cmd, "@fd_pathLoc", dfi.pathLoc, 255);
db.AddInt(ref cmd, "@fd_id_old", dfi.fdID);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
//获取新插入的ID
cmd.Parameters.Clear();
cmd.CommandText = "select @@IDENTITY;";
object fd_id = cmd.ExecuteScalar();
cmd.Connection.Close();
return(Convert.ToInt32(fd_id));
}
protected void Page_Load(object sender, EventArgs e)
{
string uid = Request.QueryString["uid"];
string fdID = Request.QueryString["fdid"]; //xdb_folders.fd_id
string mac = Request.QueryString["mac"];
string name = Request.QueryString["name"];
string pathLoc = Request.QueryString["pathLoc"]; //客户端使用的是encodeURIComponent编码，
string cbk = Request.QueryString["callback"]; //应用于jsonp数据
if (string.IsNullOrEmpty(uid) ||
string.IsNullOrEmpty(mac) ||
string.IsNullOrEmpty(pathLoc) ||
string.IsNullOrEmpty(name))
{
Response.Write("参数为空");
Response.End();
return;
}
DnFolderInf df = new DnFolderInf();
df.uid = int.Parse(uid);
df.mac = mac;
df.name = name;
df.pathLoc = pathLoc;
df.fdID = int.Parse(fdID);
df.idSvr = DnFolder.Add(ref df);
//添加到down_files表
df.idF = DnFile.Add(ref df);
string json = JsonConvert.SerializeObject(df);
json = HttpUtility.UrlEncode(json);
//UrlEncode会将空格解析成+号
json = json.Replace("+", "%20");
json = cbk + "(" + json + ")";//返回jsonp格式数据。
Response.Write(json);
}
