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); }
/// <summary> /// 批量添加文件 /// </summary> /// <param name="con"></param> protected virtual void save_files(DbHelper db) { StringBuilder sb = new StringBuilder(); sb.Append("insert into up6_files("); sb.Append(" f_id"); sb.Append(",f_pid"); sb.Append(",f_pidRoot"); sb.Append(",f_fdTask"); sb.Append(",f_fdChild"); sb.Append(",f_sizeLoc"); sb.Append(",f_uid"); sb.Append(",f_nameLoc"); sb.Append(",f_nameSvr"); sb.Append(",f_pathLoc"); sb.Append(",f_pathSvr"); sb.Append(",f_pathRel"); sb.Append(",f_md5"); sb.Append(",f_lenLoc"); sb.Append(",f_lenSvr"); sb.Append(",f_perSvr"); sb.Append(",f_complete"); sb.Append(") values ("); sb.Append(" @f_id"); sb.Append(",@f_pid"); sb.Append(",@f_pidRoot"); sb.Append(",@f_fdTask"); sb.Append(",@f_fdChild"); sb.Append(",@f_sizeLoc"); sb.Append(",@f_uid"); sb.Append(",@f_nameLoc"); sb.Append(",@f_nameSvr"); sb.Append(",@f_pathLoc"); sb.Append(",@f_pathSvr"); sb.Append(",@f_pathRel"); sb.Append(",@f_md5"); sb.Append(",@f_lenLoc"); sb.Append(",@f_lenSvr"); sb.Append(",@f_perSvr"); sb.Append(",@f_complete"); sb.Append(") ;"); var cmd = db.GetCommand(sb.ToString()); db.AddString(ref cmd, "@f_id", string.Empty, 32); db.AddString(ref cmd, "@f_pid", string.Empty, 32); db.AddString(ref cmd, "@f_pidRoot", string.Empty, 32); db.AddBool(ref cmd, "@f_fdTask", false); db.AddString(ref cmd, "@f_sizeLoc", string.Empty, 32); db.AddBool(ref cmd, "@f_fdChild", true); db.AddInt(ref cmd, "@f_uid", 0); db.AddString(ref cmd, "@f_nameLoc", string.Empty, 255); db.AddString(ref cmd, "@f_nameSvr", string.Empty, 255); db.AddString(ref cmd, "@f_pathLoc", string.Empty, 255); db.AddString(ref cmd, "@f_pathSvr", string.Empty, 255); db.AddString(ref cmd, "@f_pathRel", string.Empty, 255); db.AddString(ref cmd, "@f_md5", string.Empty, 40); db.AddInt64(ref cmd, "@f_lenLoc", 0); db.AddInt64(ref cmd, "@f_lenSvr", 0); db.AddString(ref cmd, "@f_perSvr", "100%", 6); db.AddBool(ref cmd, "@f_complete", true); cmd.Prepare(); foreach (var f in this.m_files) { cmd.Parameters["@f_id"].Value = f.id; cmd.Parameters["@f_pid"].Value = f.pid; cmd.Parameters["@f_pidRoot"].Value = f.pidRoot; cmd.Parameters["@f_sizeLoc"].Value = f.sizeLoc; cmd.Parameters["@f_uid"].Value = f.uid; cmd.Parameters["@f_nameLoc"].Value = f.nameLoc; cmd.Parameters["@f_nameSvr"].Value = f.nameSvr; cmd.Parameters["@f_pathLoc"].Value = f.pathLoc; cmd.Parameters["@f_pathSvr"].Value = f.pathSvr; cmd.Parameters["@f_pathRel"].Value = f.pathRel; cmd.Parameters["@f_md5"].Value = f.md5; cmd.Parameters["@f_lenLoc"].Value = f.lenLoc; cmd.Parameters["@f_lenSvr"].Value = f.lenSvr; cmd.ExecuteNonQuery(); } cmd.Dispose(); }