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