//查询RFC函数列表,本地已经保存所有的RFC函数列表, //根据函数名称可模糊查询函数,最后返回Json列表 public static string GetRFCList(string sysName, string fname) { var constr = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); netlib7 helper = new netlib7(constr); // var sqlstr = String.Format("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='{0}'", "RFC_FUNCTIONS"); var sqlstr = String.Format("SELECT count(*) FROM 'RFC_FUNCTIONS'"); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = String.Format("SELECT count(*) FROM RFC_FUNCTIONS"); } int isexist = Convert.ToInt32(helper.ExecScalar(sqlstr, null)); if (isexist <= 0) { return string.Empty; } //string _dbFile = "E:\\wangws"; //_dbFile = _dbFile + "\\" + "RFC_FUNCTIONS" + ".db"; //if (!File.Exists(_dbFile)) //{ // // SAPFunction.GetRFCfunctionListAndSaveToSqliteDb(sysName, ""); //} // SQLiteDBHelper helper = new SQLiteDBHelper(_dbFile); sqlstr = string.Format("select [FUNCNAME],[STEXT] from [RFC_FUNCTIONS] where funcname like '{0}' limit 10", fname); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = string.Format("select top 10 [FUNCNAME],[STEXT] from RFC_FUNCTIONS where FUNCNAME like '{0}%'", fname); } DataTable dt = helper.DataTableFill(sqlstr); var output = JsonConvert.SerializeObject(dt); return output; }
//查询RFC函数列表,本地已经保存所有的RFC函数列表, //根据函数名称可模糊查询函数,最后返回Json列表 public static string GetRFCList(string sysName, string fname) { var constr = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); netlib7 helper = new netlib7(constr); // var sqlstr = String.Format("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='{0}'", "RFC_FUNCTIONS"); var sqlstr = String.Format("SELECT count(*) FROM 'RFC_FUNCTIONS'"); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = String.Format("SELECT count(*) FROM RFC_FUNCTIONS"); } int isexist = Convert.ToInt32(helper.ExecScalar(sqlstr, null)); if (isexist <= 0) { return(string.Empty); } //string _dbFile = "E:\\wangws"; //_dbFile = _dbFile + "\\" + "RFC_FUNCTIONS" + ".db"; //if (!File.Exists(_dbFile)) //{ // // SAPFunction.GetRFCfunctionListAndSaveToSqliteDb(sysName, ""); //} // SQLiteDBHelper helper = new SQLiteDBHelper(_dbFile); sqlstr = string.Format("select [FUNCNAME],[STEXT] from [RFC_FUNCTIONS] where funcname like '{0}' limit 10", fname); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = string.Format("select top 10 [FUNCNAME],[STEXT] from RFC_FUNCTIONS where FUNCNAME like '{0}%'", fname); } DataTable dt = helper.DataTableFill(sqlstr); var output = JsonConvert.SerializeObject(dt); return(output); }
/// <summary> /// 用于读取特定分页的内容。 /// </summary> /// <param name="dbname">数据库名字</param> /// <param name="tableName">数据表名</param> /// <param name="page">页面</param> /// <param name="rows">行数</param> /// <returns></returns> public static string read(string fname, string tableName, int page, int rows) { tableName = fname + "_" + tableName; var constr = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); netlib7 helper = new netlib7(constr); // string _dbFile = DBLOCATION; // _dbFile = _dbFile + "\\" + dbname + ".db"; //if (File.Exists(_dbFile)) { // File.Delete(_dbFile); //} //if (!File.Exists(_dbFile)) //{ // return null; // // SQLiteConnection.CreateFile(_dbFile); //} // string sqlstr = ""; // SQLiteDBHelper helper = new SQLiteDBHelper(_dbFile); //检查表是否存在 // var sqlstr = String.Format("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='{0}'", tableName); var sqlstr = String.Format("SELECT count(*) FROM '{0}'", tableName); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = string.Format("SELECT count(*) FROM {0}", tableName); } else if (helper.ProviderType == netlib7.ProviderTypes.MySql) { sqlstr = string.Format("SELECT count(*) FROM {0}", tableName); } int isexist = Convert.ToInt32(helper.ExecScalar(sqlstr, null)); if (isexist <= 0) { return(""); } //计算行数与偏移 int total = Convert.ToInt32(helper.ExecScalar("select count(*) from " + tableName, null)); int offset = (page - 1) * rows; if (offset != 0) { // If a comma is used instead of the OFFSET keyword, then the offset is the first number and the limit is the second number. // sqlstr = "select * from {0} limit {1}, {2}"; // sqlstr = String.Format(sqlstr, tableName, offset,rows ); sqlstr = "select * from {0} limit {1} offset {2}"; if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = "SELECT top {1} * FROM ( SELECT * , ROW_NUMBER() OVER (ORDER BY ID) AS RowNum FROM {0} ) AS dt WHERE dt.RowNum > {2}"; } sqlstr = String.Format(sqlstr, tableName, rows, offset); } else { sqlstr = "select * from {0} limit {1}"; if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = "SELECT top {1} * FROM {0}"; } sqlstr = String.Format(sqlstr, tableName, rows); } DataTable dt = helper.DataTableFill(sqlstr); TableObject tr = new TableObject(); tr.total = total; tr.rows = dt; var output = JsonConvert.SerializeObject(tr); return(output); }
public IdocDb(String pConnectionName) { this.ConnectionName = pConnectionName; logicDb = new netlib7(ConnectionName); }
public IdocDb() { this.ConnectionName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); logicDb = new netlib7(ConnectionName); }
public void getDb(String dbName = null) { SqlDialectBase dialect = null; if (String.IsNullOrEmpty(dbName)) { dbname = ConfigFileTool.SAPGlobalSettings.GetCodeTemplateDb(); } else { dbname = dbName; } if (string.IsNullOrEmpty(dbname)) { throw new Exception("Con't get the db connection"); } netlib = new netlib7(dbname); connection = netlib.CreateConnection(); switch (netlib.ProviderType) { case netlib7.ProviderTypes.Oracle: break; case netlib7.ProviderTypes.SqlServer: dialect = new SqlServerDialect(); break; case netlib7.ProviderTypes.MsAccess: dialect = new SqlCeDialect(); break; case netlib7.ProviderTypes.MySql: dialect = new MySqlDialect(); break; case netlib7.ProviderTypes.PostgreSQL: break; case netlib7.ProviderTypes.OleDB: dialect = new SqlCeDialect(); break; case netlib7.ProviderTypes.SQLite: dialect = new SqliteDialect(); break; case netlib7.ProviderTypes.Unknown: break; default: break; } var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper <>), new List <Assembly>(), dialect); var sqlGenerator = new SqlGeneratorImpl(config); Db = new Database(connection, sqlGenerator); }
public void getDb(String dbName = null) { SqlDialectBase dialect = null; if (String.IsNullOrEmpty(dbName)) { dbname = ConfigFileTool.SAPGlobalSettings.GetCodeTemplateDb(); } else { dbname = dbName; } if (string.IsNullOrEmpty(dbname)) { throw new Exception("Con't get the db connection"); } netlib = new netlib7(dbname); connection = netlib.CreateConnection(); switch (netlib.ProviderType) { case netlib7.ProviderTypes.Oracle: break; case netlib7.ProviderTypes.SqlServer: dialect = new SqlServerDialect(); break; case netlib7.ProviderTypes.MsAccess: dialect = new SqlCeDialect(); break; case netlib7.ProviderTypes.MySql: dialect = new MySqlDialect(); break; case netlib7.ProviderTypes.PostgreSQL: break; case netlib7.ProviderTypes.OleDB: dialect = new SqlCeDialect(); break; case netlib7.ProviderTypes.SQLite: dialect = new SqliteDialect(); break; case netlib7.ProviderTypes.Unknown: break; default: break; } var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper<>), new List<Assembly>(), dialect); var sqlGenerator = new SqlGeneratorImpl(config); Db = new Database(connection, sqlGenerator); }
/// <summary> /// 用于读取特定分页的内容。 /// </summary> /// <param name="dbname">数据库名字</param> /// <param name="tableName">数据表名</param> /// <param name="page">页面</param> /// <param name="rows">行数</param> /// <returns></returns> public static string read(string fname, string tableName, int page, int rows) { tableName = fname + "_" + tableName; var constr = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); netlib7 helper = new netlib7(constr); // string _dbFile = DBLOCATION; // _dbFile = _dbFile + "\\" + dbname + ".db"; //if (File.Exists(_dbFile)) { // File.Delete(_dbFile); //} //if (!File.Exists(_dbFile)) //{ // return null; // // SQLiteConnection.CreateFile(_dbFile); //} // string sqlstr = ""; // SQLiteDBHelper helper = new SQLiteDBHelper(_dbFile); //检查表是否存在 // var sqlstr = String.Format("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='{0}'", tableName); var sqlstr = String.Format("SELECT count(*) FROM '{0}'", tableName); if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = string.Format("SELECT count(*) FROM {0}",tableName); } else if (helper.ProviderType == netlib7.ProviderTypes.MySql) { sqlstr = string.Format("SELECT count(*) FROM {0}",tableName); } int isexist = Convert.ToInt32(helper.ExecScalar(sqlstr, null)); if (isexist <= 0) { return ""; } //计算行数与偏移 int total = Convert.ToInt32(helper.ExecScalar("select count(*) from " + tableName, null)); int offset = (page - 1) * rows; if (offset != 0) { // If a comma is used instead of the OFFSET keyword, then the offset is the first number and the limit is the second number. // sqlstr = "select * from {0} limit {1}, {2}"; // sqlstr = String.Format(sqlstr, tableName, offset,rows ); sqlstr = "select * from {0} limit {1} offset {2}"; if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = "SELECT top {1} * FROM ( SELECT * , ROW_NUMBER() OVER (ORDER BY ID) AS RowNum FROM {0} ) AS dt WHERE dt.RowNum > {2}"; } sqlstr = String.Format(sqlstr, tableName, rows, offset); } else { sqlstr = "select * from {0} limit {1}"; if (helper.ProviderType == netlib7.ProviderTypes.SqlServer) { sqlstr = "SELECT top {1} * FROM {0}"; } sqlstr = String.Format(sqlstr, tableName, rows); } DataTable dt = helper.DataTableFill(sqlstr); TableObject tr = new TableObject(); tr.total = total; tr.rows = dt; var output = JsonConvert.SerializeObject(tr); return output; }
public DbUtil(String dbConnectionName) { db2 = new netlib7(dbConnectionName); }
public DbUtil() { String defaultConnection = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); db2 = new netlib7(defaultConnection); }
public CodeGerneratorHelper(String dbConnectionName) { db2 = new netlib7(dbConnectionName); }
public CodeGerneratorHelper() { String defaultConnection = ConfigFileTool.SAPGlobalSettings.GetSettingsFromDb(); db2 = new netlib7(defaultConnection); }