public void CreateTable(RelationModel relation)
{
var a = SQL.CreateTable.CreateTb(relation.TbName);
foreach (var c in relation.Columns)
{
a.AddColumn(c.ColumnName, c.TypeName, c.Size, c.ConstraintsStr);
}
SqlScript sql = a.ToSql();
DbServerProvider.ExcuteNonQuery(CommandType.Text, sql.ToString());
}
/// <summary>
/// 处理数据库异常
/// </summary>
/// <param name="ex"></param>
/// <returns>处理成功返回true，否则返回false</returns>
private bool ProcessSqlException(Exception ex)
{
SqlException sqlEx = DbServerProvider.ConvertToSqlException(ex);
switch (sqlEx.Number)
{
case 4060:
CreateDb(DbServerProvider.DataBase);
return(true);
default:
return(false);
}
}
public bool IsTableExist(string tableName)
{
string sql = string.Format("select count(1) from sys.objects where name = '{0}'", tableName);
int res = (int)DbServerProvider.ExcuteScalar(CommandType.Text, sql);
if (res == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public DataSet GetDataSet(SqlScript sql)
{
var res = DbServerProvider.ExcuteDataSet(CommandType.Text, sql.ToString());
return(res);
}
public void CreateDb(string dataBaseName)
{
DbServerProvider.ExcuteNonQuery(CommandType.Text, CreateDB.CreateDb(dataBaseName).ToSql().ToString());
}
