/// <summary> /// 批量添加目录 /// </summary> /// <param name="con"></param> protected override void save_folders(DbHelper db) { StringBuilder sb = new StringBuilder(); sb.Append("insert into up6_folders("); sb.Append(" f_id"); sb.Append(",f_pid"); sb.Append(",f_pidRoot"); sb.Append(",f_uid"); sb.Append(",f_nameLoc"); sb.Append(",f_pathLoc"); sb.Append(",f_pathSvr"); sb.Append(",f_pathRel"); sb.Append(",f_complete"); sb.Append(") values ("); sb.Append(" :f_id"); sb.Append(",:f_pid"); sb.Append(",:f_pidRoot"); sb.Append(",:f_uid"); sb.Append(",:f_nameLoc"); sb.Append(",:f_pathLoc"); sb.Append(",:f_pathSvr"); sb.Append(",:f_pathRel"); sb.Append(",:f_complete"); sb.Append(")"); var cmd = db.connection.CreateCommand(); cmd.CommandText = sb.ToString(); cmd.CommandType = System.Data.CommandType.Text; 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.AddInt(ref cmd, ":f_uid", 0); db.AddString(ref cmd, ":f_nameLoc", 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.AddBool(ref cmd, ":f_complete", true); cmd.Prepare(); foreach (var f in this.m_folders) { cmd.Parameters[":f_id"].Value = f.id; cmd.Parameters[":f_pid"].Value = f.pid; cmd.Parameters[":f_pidRoot"].Value = f.pidRoot; cmd.Parameters[":f_uid"].Value = f.uid; cmd.Parameters[":f_nameLoc"].Value = f.nameLoc; cmd.Parameters[":f_pathLoc"].Value = f.pathLoc; cmd.Parameters[":f_pathSvr"].Value = f.pathSvr; cmd.Parameters[":f_pathRel"].Value = f.pathRel; cmd.ExecuteNonQuery(); } cmd.Dispose(); }
/// <summary> /// 批量添加目录 /// </summary> /// <param name="con"></param> protected virtual void save_folders(DbHelper db) { StringBuilder sb = new StringBuilder(); sb.Append("insert into up6_folders("); sb.Append(" f_id"); sb.Append(",f_pid"); sb.Append(",f_pidRoot"); sb.Append(",f_uid"); sb.Append(",f_nameLoc"); sb.Append(",f_pathLoc"); sb.Append(",f_pathSvr"); sb.Append(",f_pathRel"); sb.Append(",f_complete"); sb.Append(") values ("); sb.Append(" @f_id"); sb.Append(",@f_pid"); sb.Append(",@f_pidRoot"); sb.Append(",@f_uid"); sb.Append(",@f_nameLoc"); sb.Append(",@f_pathLoc"); sb.Append(",@f_pathSvr"); sb.Append(",@f_pathRel"); 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.AddInt(ref cmd, "@f_uid", 0); db.AddString(ref cmd, "@f_nameLoc", 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.AddBool(ref cmd, "@f_complete", true); cmd.Prepare(); foreach (var f in this.m_folders) { cmd.Parameters["@f_id"].Value = f.id; cmd.Parameters["@f_pid"].Value = f.pid; cmd.Parameters["@f_pidRoot"].Value = f.pidRoot; cmd.Parameters["@f_uid"].Value = f.uid; cmd.Parameters["@f_nameLoc"].Value = f.nameLoc; cmd.Parameters["@f_pathLoc"].Value = f.pathLoc; cmd.Parameters["@f_pathSvr"].Value = f.pathSvr; cmd.Parameters["@f_pathRel"].Value = f.pathRel; cmd.ExecuteNonQuery(); } cmd.Dispose(); }
public virtual JToken page2(string table, string primaryKey, string fields, int pageSize, int pageIndex, string where = "", string sort = "") { ConfigReader cr = new ConfigReader(); var database = cr.module(string.Format("database.{0}", table)); //加载结构 var table_fields = database.SelectToken("fields"); var fields_arr = fields.Split(',').ToList(); var field_sels = (from f in fields_arr join tf in table_fields on f equals tf["name"].ToString() select tf).ToArray(); //选择所有字段 if (fields.Trim() == "*") { field_sels = table_fields.ToArray(); fields_arr = (from f in field_sels select f["name"].ToString()).ToList(); fields = string.Join(",", fields_arr.ToArray()); } DbHelper db = new DbHelper(); var cmd = db.GetCommandStored("spPager"); db.AddString(ref cmd, "@table", table, 200); db.AddString(ref cmd, "@primarykey", primaryKey, 50); db.AddInInt32(cmd, "@pagesize", pageSize); db.AddInInt32(cmd, "@pageindex", pageIndex); db.AddBool(ref cmd, "@docount", false); db.AddString(ref cmd, "@where", where, 1000); db.AddString(ref cmd, "@sort", sort, 50); db.AddString(ref cmd, "@fields", fields, 500); var r = db.ExecuteReader(cmd); JArray a = new JArray(); SqlCmdReader scr = new SqlCmdReader(); while (r.Read()) { int index = 1;//从1开始,0是行号 var o = new JObject(); foreach (var field in fields_arr) { var fd = field_sels[index - 1]; var fd_type = fd["type"].ToString().ToLower(); o[field] = scr[fd_type](r, index++); } a.Add(o); } r.Close(); return(JToken.FromObject(a)); }
/// <summary> /// /// </summary> /// <param name="table"></param> /// <param name="primaryKey"></param> /// <param name="where">name=1</param> /// <returns></returns> public virtual int count(string table, string primaryKey, string where = "") { DbHelper db = new DbHelper(); var cmd = db.GetCommandStored("spPager"); db.AddString(ref cmd, "@table", table, 50); db.AddString(ref cmd, "@primarykey", primaryKey, 50); db.AddInInt32(cmd, "@pagesize", 0); db.AddInInt32(cmd, "@pageindex", 0); db.AddBool(ref cmd, "@docount", true); db.AddString(ref cmd, "@where", where, 1000); db.AddString(ref cmd, "@sort", string.Empty, 50); db.AddString(ref cmd, "@fields", string.Empty, 100); var obj = db.ExecuteScalar(cmd); return(Convert.ToInt32(obj)); }
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); }