//public static DataTable PageQuery(string needfields, string fromcondition,string keyfields ,string keyfieldsdeclare, int pagesize, int pages, out int counts, string db)
//{
// string sqlCreate = "declare @indextable table(indextableid int identity(1,1) PRIMARY KEY," + keyfieldsdeclare + ") ;";
// string KeySql = "select "+keyfields+" from "+fromcondition+" ";
// string sqlKeyinsert = "insert into @indextable(" + keyfields + ") " + KeySql + ";";
// string sqlCt = "select recrowcount= @@rowcount;";
// string[] needf = needfields.Split(new char[] { ',' });
// for (int i = 0; i < needf.Length; i++)
// {
// needf[i] = "t1."+needf[i].ToString();
// }
// string sqlSearch = "select "+string.Join(",",needf)+" from @indextable t0,(" + orgSql + ") t1 where t0.indextableid>=" + ((page - 1) * pageSize + 1).ToString() + " and t0.indextableid<" + (page * pageSize + 1).ToString() + tempKey3;
//}
/// <summary>
/// 执行Sql语句返回影响条数
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="dbName">操作的数据库名</param>
/// <returns>SQL语句影响条数</returns>
public static int ProcessSqlNonQuery(string sql, string dbName)
{
PersistenceBroker broker = PersistenceBroker.Instance();
IDbCommand cmd = broker.GetCommand(dbName);
cmd.CommandText = sql;
Logger.Write(sql); //add by duhu
return(broker.Execute(dbName, cmd));
}
