private void insertTableStructure(string tableName)
{
DataTable dt = GetDataTable(txtTemplageFile.Text);
if (scripts.Count(it => it.TableName == tableName) == 0)
{
// 创建表
TableDAL.CreateTable(tableName, dt);
// 添加主键
//TableDAL.SetPrimary(txtTableName.Text, "ID");
// 添加扩展列
TableDAL.AddAttribute(tableName, 20);
int count = ObjtableInfoDAL.Count(tableName.ToUpper());
if (count == 0)
{
ObjtableInfo oinfo = new ObjtableInfo();
oinfo.FID = Guid.NewGuid().ToString().Replace("-", "");
oinfo.CreatedBy = MainWindow.UserID;
oinfo.LastUpdatedBy = MainWindow.UserID;
oinfo.ObjectTableCode = tableName.ToUpper();
oinfo.ObjectTableName = tableName.ToUpper();
oinfo.Status = "02";
oinfo.Version = 1;
oinfo.LastUpdateIp = "127.0.0.1";
oinfo.LastUpdateDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
oinfo.CreationDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
ObjtableInfoDAL.Insert(oinfo);
}
}
else
{
// 追加表结构
TableDAL.CreateTable(tableName, dt);
}
DataScriptMapDAL.AutoScriptMap(FID, dt, tableName, MainWindow.UserID);
}
