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