public DataSet QueryPage(string sql, int pageindex, int pagesize)
{
if (pageindex <= 0)
{
pageindex = 1;
}
pageindex--;
switch (this.ConnectionBasic.DataBaseType)
{
case DataBaseType.SQLServer:
{
DbHelperSQL rsql1 = new DbHelperSQL {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(rsql1.QueryPage(sql, pageindex, pagesize));
}
case DataBaseType.Oracle:
{
DbHelperOra ora1 = new DbHelperOra {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ora1.QueryPage(sql, pageindex, pagesize));
}
case DataBaseType.MySQL:
{
DbHelperMySQL ysql1 = new DbHelperMySQL {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ysql1.QueryPage(sql, pageindex, pagesize));
}
case DataBaseType.SyBase:
{
DbHelperSyBase base1 = new DbHelperSyBase {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(base1.QueryPage(sql, pageindex, pagesize));
}
case DataBaseType.SQLite:
{
DbHelperSQLiteEx ex1 = new DbHelperSQLiteEx {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ex1.QueryPage(sql, pageindex, pagesize));
}
}
return(new DataSet());
}
public object GetSingle(string sql)
{
switch (this.ConnectionBasic.DataBaseType)
{
case DataBaseType.SQLServer:
{
DbHelperSQL rsql1 = new DbHelperSQL {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(rsql1.GetSingle(sql));
}
case DataBaseType.Oracle:
{
DbHelperOra ora1 = new DbHelperOra {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ora1.GetSingle(sql));
}
case DataBaseType.MySQL:
{
DbHelperMySQL ysql1 = new DbHelperMySQL {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ysql1.GetSingle(sql));
}
case DataBaseType.SyBase:
{
DbHelperSyBase base1 = new DbHelperSyBase {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(base1.GetSingle(sql));
}
case DataBaseType.SQLite:
{
DbHelperSQLiteEx ex1 = new DbHelperSQLiteEx {
connectionString = DESEncrypt.Decrypt(this.ConnectionBasic.ConnectionString)
};
return(ex1.GetSingle(sql));
}
}
return(0);
}
public override string ToString() => (base.DataBaseType.ToString() + " " + DESEncrypt.Decrypt(this.DataSource));
public override string ToString()
{
string[] textArray1 = new string[] { base.DataBaseType.ToString(), " ", DESEncrypt.Decrypt(this.server), " ", DESEncrypt.Decrypt(this.database) };
return(string.Concat(textArray1));
}
public override string ToString()
{
string[] textArray1 = new string[] { base.DataBaseType.ToString(), " ", Path.GetFileNameWithoutExtension(DESEncrypt.Decrypt(this.DataSource)), " Version=", DESEncrypt.Decrypt(this.Version) };
return(string.Concat(textArray1));
}
