private TableInfo FillTable4() { TableInfo tableInfo = new TableInfo(); tableInfo.TableName = "TestTbl4"; tableInfo.Remarks = "测试表4"; ColumnInfo colInfo = new ColumnInfo(); colInfo.ColumnName = "Col1"; colInfo.IsPK = true; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "主键字段1"; colInfo.MaxLength = 40; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "FKCol1"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "外键1"; colInfo.MaxLength = 40; colInfo.IsFK = true; colInfo.RefTableName = "TestTbl2"; colInfo.RefColumnName = "Col1"; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "FKCol2"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "外键2"; colInfo.MaxLength = 40; colInfo.IsFK = true; colInfo.RefTableName = "TestTbl3"; colInfo.RefColumnName = "Col1"; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col3"; colInfo.IsUnique = true; colInfo.UniqueConstraintName = "Col34"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "唯一字段34"; colInfo.MaxLength = 40; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col4"; colInfo.IsUnique = true; colInfo.UniqueConstraintName = "Col34"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "唯一字段34"; colInfo.MaxLength = 40; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col5"; colInfo.DBType = DbType.DateTime; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段5"; colInfo.DefaultValue = "1753-01-01"; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col6"; colInfo.DBType = DbType.Int32; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段6"; colInfo.DefaultValue = 100; tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col7"; colInfo.DBType = DbType.Decimal; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段7"; colInfo.DefaultValue = 100.32; colInfo.Precision = 10; colInfo.Scale = 2; tableInfo.Columns.Add(colInfo); return tableInfo; }
public void DropColumnTest() { ColumnInfo colInfo = new ColumnInfo(); colInfo.ColumnName = "Col9"; colInfo.IsUnique = true; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段9"; colInfo.MaxLength = 40; colInfo.DefaultValue = "1134"; colInfo.UniqueConstraintName = "Col34"; NFramework.DBTool.Test.IDal.DalManager.DalFactory.DropColumn(tableInfo, colInfo); }
public void AddColumnTest() { // 增加一般字段 ColumnInfo colInfo = new ColumnInfo(); colInfo.ColumnName = "Col8"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段8"; colInfo.MaxLength = 40; colInfo.DefaultValue = "1134"; NFramework.DBTool.Test.IDal.DalManager.DalFactory.AddColumn(tableInfo, colInfo); tableInfo.Columns.Add(colInfo); // 已存在字段 try { colInfo = new ColumnInfo(); colInfo.ColumnName = "Col2"; colInfo.IsUnique = true; colInfo.UniqueConstraintName = "Col2"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "唯一字段1"; colInfo.MaxLength = 40; NFramework.DBTool.Test.IDal.DalManager.DalFactory.AddColumn(tableInfo, colInfo); Assert.IsTrue(false); } catch(Exception ex) { Assert.IsTrue(true); } // 增加同组唯一字段 colInfo = new ColumnInfo(); colInfo.ColumnName = "Col9"; colInfo.IsUnique = true; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段9"; colInfo.MaxLength = 40; colInfo.DefaultValue = "1134"; colInfo.UniqueConstraintName = "Col34"; NFramework.DBTool.Test.IDal.DalManager.DalFactory.AddColumn(tableInfo, colInfo); tableInfo.Columns.Add(colInfo); colInfo = new ColumnInfo(); colInfo.ColumnName = "Col10"; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "字段10"; colInfo.MaxLength = 40; colInfo.DefaultValue = "1010"; NFramework.DBTool.Test.IDal.DalManager.DalFactory.AddColumn(tableInfo, colInfo); tableInfo.Columns.Add(colInfo); // 增加主键字段 colInfo = new ColumnInfo(); colInfo.ColumnName = "Col111"; colInfo.IsPK = true; colInfo.DBType = DbType.AnsiString; colInfo.CurrTable = tableInfo; colInfo.Remarks = "主键字段111"; colInfo.MaxLength = 40; NFramework.DBTool.Test.IDal.DalManager.DalFactory.AddColumn(tableInfo, colInfo); tableInfo.Columns.Add(colInfo); }