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