public DbHelper(SqlInfor model)
{
if (model.DbType == 1)
{
ConnectionString = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", model.Server, model.DbName, model.UserCard, model.UserPwd);
this.DatabaseTypeEnumParse("System.Data.SqlClient");
}
else if (model.DbType == 0)
{
ConnectionString = string.Format("Data Source={0};User ID={1};Password={2 };", model.Server, model.UserCard, model.UserPwd);
this.DatabaseTypeEnumParse("System.Data.OracleClient");
}
DbParmChar = DbFactory.CreateDbParmCharacter();
}
public void GetTable(HttpRequest Request)
{
SqlInfor db = new SqlInfor();
db.Server = "LocalHost"; //Request["Server"];
db.DbName = "Doc"; // Request["DbName"];
db.UserCard = "sa"; // Request["UserCard"];
db.UserPwd = "12345"; // Request["UserPwd"];
string tableName = Request["TbName"];
DbHelper dbhelper = new DbHelper(db);
string sql = string.Format("select * from {0} where 1 = 2", tableName);
DataTable dt = dbhelper.GetDataTable(CommandType.Text, sql);
foreach (DataColumn col in dt.Columns)
{
json += col.ColumnName + ",";
}
}
public void MakeTem(Tem model, SqlInfor db)
{
throw new NotImplementedException();
}
public void MakeTem(Tem model, SqlInfor db)
{
}
