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