public override void Add(ref model.DnFileInf inf) { DBConfig cfg = new DBConfig(); var se = cfg.se(); se.insert("down_files", new SqlParam[] { new SqlParam("f_id", inf.id), new SqlParam("f_uid", inf.uid), new SqlParam("f_nameLoc", inf.nameLoc), new SqlParam("f_pathLoc", inf.pathLoc), new SqlParam("f_fileUrl", inf.fileUrl), new SqlParam("f_lenSvr", inf.lenSvr), new SqlParam("f_sizeSvr", inf.sizeSvr), new SqlParam("f_fdTask", inf.fdTask), }); }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["id"]; string uid = Request.QueryString["uid"]; string fdTask = Request.QueryString["fdTask"]; string nameLoc = Request.QueryString["nameLoc"]; //客户端使用的是encodeURIComponent编码, string pathLoc = Request.QueryString["pathLoc"]; //客户端使用的是encodeURIComponent编码, string lenSvr = Request.QueryString["lenSvr"]; string sizeSvr = Request.QueryString["sizeSvr"]; string cbk = Request.QueryString["callback"]; //应用于jsonp数据 pathLoc = HttpUtility.UrlDecode(pathLoc); //utf-8解码 nameLoc = HttpUtility.UrlDecode(nameLoc); sizeSvr = HttpUtility.UrlDecode(sizeSvr); if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(pathLoc) || string.IsNullOrEmpty(lenSvr)) { this.toContentJson(cbk + "({\"value\":null})"); return; } model.DnFileInf inf = new model.DnFileInf(); inf.id = id; inf.uid = int.Parse(uid); inf.nameLoc = nameLoc; inf.pathLoc = pathLoc;//记录本地存储位置 inf.lenSvr = long.Parse(lenSvr); inf.sizeSvr = sizeSvr; inf.fdTask = fdTask == "1"; DBConfig cfg = new DBConfig(); DnFile db = cfg.downF(); db.Add(ref inf); string json = JsonConvert.SerializeObject(inf); json = HttpUtility.UrlEncode(json); json = json.Replace("+", "%20"); json = cbk + "({\"value\":\"" + json + "\"})";//返回jsonp格式数据。 this.toContentJson(json); }
public override void Add(ref model.DnFileInf inf) { StringBuilder sql = new StringBuilder(); sql.Append("insert into down_files("); sql.Append(" f_id"); sql.Append(",f_uid"); sql.Append(",f_nameLoc"); sql.Append(",f_pathLoc"); sql.Append(",f_fileUrl"); sql.Append(",f_lenSvr"); sql.Append(",f_sizeSvr"); sql.Append(",f_fdTask"); sql.Append(") values("); sql.Append(" :f_id"); sql.Append(",:f_uid"); sql.Append(",:f_nameLoc"); sql.Append(",:f_pathLoc"); sql.Append(",:f_fileUrl"); sql.Append(",:f_lenSvr"); 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_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_sizeSvr", inf.sizeSvr, 10); db.AddBool(ref cmd, ":f_fdTask", inf.fdTask); db.ExecuteNonQuery(ref cmd); }