public static DataSet GetEnterpriseList(string logictablename, string Aenterprise) { DataSet re = null; DynamicUpdate.DynamicUpdateSqlite du = new DynamicUpdate.DynamicUpdateSqlite(connstr); if (Aenterprise == null || Aenterprise.Length == 0) { string sql = @"select distinct enterprise from wlt_license"; re = du.GetData(logictablename, sql); } else { string sql = @"select distinct enterprise from wlt_license where enterprise like ('%' || ? || '%')"; re = du.GetData(logictablename, sql, new object[] { Aenterprise }); } return re; }
public static void CheckDBVersion() { DynamicUpdate.DynamicUpdateSqlite du = new DynamicUpdate.DynamicUpdateSqlite(connstr); int dbversion = 0; DataSet dsX = du.GetData("sqlite_master", "select [sql] from sqlite_master where [type] = 'table' and lower(name) = ?", new object[] { "dbversion" }); bool has_dbversion = (dsX.Tables["sqlite_master"].Rows.Count > 0); if (has_dbversion) { dsX = du.GetData("dbversion", "select version from dbversion"); if (dsX.Tables["dbversion"].Rows.Count > 0) { dbversion = Convert.ToInt32(dsX.Tables["dbversion"].Rows[0]["version"]); } } int lastversioin = 0; for (int i = 0; i < DBInitSQL.InitSql.Length; ) { lastversioin = (int)DBInitSQL.InitSql[i]; if (dbversion < lastversioin) { i++; string[] sqls = (string[])DBInitSQL.InitSql[i]; for (int j = 0; j < sqls.Length; j++) { du.ExecSQL(sqls[j]); } } else { i++; } i++; } if (dbversion < lastversioin) { du.ExecSQL("delete from dbversion"); du.ExecSQL("insert into dbversion(version, note) values(?, ?)", new object[] { lastversioin, "" }); } }
public static DataSet GetNodeList(string logictablename, string ename) { DataSet re = null; DynamicUpdate.DynamicUpdateSqlite du = new DynamicUpdate.DynamicUpdateSqlite(connstr); string sql = @"select serial, enterprise, cluster_node_num, type, expiration, registration_code, signature from wlt_license where enterprise=?"; re = du.GetData(logictablename, sql, new object[] { ename }); return re; }
public static DataRow GetLicense(string AEnterprise, string ARegistrationCode) { DataRow re = null; DynamicUpdate.DynamicUpdateSqlite du = new DynamicUpdate.DynamicUpdateSqlite(connstr); string sql = @"select serial, enterprise, cluster_node_num, type, expiration, registration_code, signature from wlt_license where enterprise=? and registration_code=?"; DataSet dsA = du.GetData("wlt_license", sql, new object[] { AEnterprise, ARegistrationCode }); if (dsA != null && dsA.Tables["wlt_license"].Rows.Count > 0) re = dsA.Tables["wlt_license"].Rows[0]; return re; }