private void button1_Click(object sender, EventArgs e)
{
DataConnectionDialog dialog = new DataConnectionDialog();
//添加数据源列表，可以向窗口中添加自己程序所需要的数据源类型
dialog.DataSources.Add(DataSource.SqlDataSource);
// dialog.DataSources.Add(DataSource.OdbcDataSource);
// DataSource.AddStandardDataSources(dialog);
dialog.SelectedDataSource = DataSource.SqlDataSource;
dialog.SelectedDataProvider = DataProvider.SqlDataProvider;
if (!(string.IsNullOrEmpty(txtConnectionString.Text)))
{
dialog.ConnectionString = txtConnectionString.Text;
}
//只能够通过DataConnectionDialog类的静态方法Show出对话框
//不同使用dialog.Show()或dialog.ShowDialog()来呈现对话框
if (DataConnectionDialog.Show(dialog, this) == DialogResult.OK)
{
AzBaseSet baseSet = AzNormalSet.GetAzNormalSet().AzBase;// AzBaseSet.GetBaseSet();
baseSet.AzConnectionString = dialog.ConnectionString;
AzBaseSet.AzSetBaseCnns(baseSet);
txtConnectionString.Text = dialog.ConnectionString;
//AzDataSourceSet.AzSetConnectionString(dialog.ConnectionString);
}
}
public static string GetCurrentTemplatePath()
{
var azset = AzNormalSet.GetAzNormalSet().AzBase;
string filspath = azset.AzTemplateFolder + @"\";
return(filspath);
}
// private string currentObjType = "TABLE";
public AzCdgnDBSchema()
{
InitializeComponent();
//
treeView1.Nodes.Add(tablesNode);
treeView1.Nodes.Add(customTablesNode);
treeView1.Nodes.Add(viewsNode);
//treeView1.Nodes.Add(customViewsNode);
treeView1.Nodes.Add(childViewsNode);
treeView1.Nodes.Add(storedProcedureNode);
listNodes.Add(tablesNode);
listNodes.Add(customTablesNode);
listNodes.Add(viewsNode);
//listNodes.Add(customViewsNode);
listNodes.Add(childViewsNode);
listNodes.Add(storedProcedureNode);
tablesNode.ExpandAll();
atkTreeView = treeView1;
if (DesignMode)
{
return;
}
if (string.Compare(System.Diagnostics.Process.GetCurrentProcess().ProcessName, "devenv") == 0)
{
return;
}
WorkObjModeInit();
this.labAppNameDisplay.Text = AzNormalSet.GetAzNormalSet().AzBase.AzNick;
}
public static void SaveCodeToFile(string dir, string floder, string fildName, string codes, string ext = ".cs")
{
string codepath = AzNormalSet.GetAzNormalSet().AzBase.AzSaveCodeFileFloder;
if (string.IsNullOrEmpty(codepath))
{
dir = currentDir + @"\生成的代码\" + dir + @"\" + floder;
}
else
{
dir = codepath + @"\生成的代码\" + dir + @"\" + floder;
}
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
using (FileStream file = new System.IO.FileStream(dir + @"\" + fildName + ext, System.IO.FileMode.Create, System.IO.FileAccess.Write))
{
using (System.IO.TextWriter text = new System.IO.StreamWriter(file, System.Text.Encoding.UTF8))
{
text.Write(codes);
}
}
}
public AzDataBSetEdit()
{
InitializeComponent();
AzBaseSet baseSet = AzNormalSet.GetAzNormalSet().AzBase; //AzBaseSet.GetBaseSet();
txtConnectionString.Text = baseSet.AzConnectionString;//.AzGetConnectionString();
f_Progress = new F_Progress(backgroundWorker1);
}
public AtkForm()
{
var azNormal = AzNormalSet.GetAzNormalSet();
if (azNormal != null)
{
azNormalSet = azNormal;
}
}
private void BaseSetValueLoad()
{
azBaseSet = AzNormalSet.GetAzNormalSet().AzBase;// AzBaseSet.GetBaseSet();
textAzClassPrefix.Text = azBaseSet.AzClassPrefix;
textAzDbSqlConnectionName.Text = azBaseSet.AzDbSqlConnectionName;
textAzNick.Text = azBaseSet.AzNick;
textAzProjectName.Text = azBaseSet.AzProjectName;
textAzProjectSpace.Text = azBaseSet.AzProjectSpace;
textAzTablePrefix.Text = azBaseSet.AzTablePrefix;
textAzTemplateFolder.Text = azBaseSet.AzTemplateFolder;
textAzToolTable.Text = azBaseSet.AzToolTable;
textSaveCodeFileFloder.Text = azBaseSet.AzSaveCodeFileFloder;
}
private void azCdgnDBSchema1_Load(object sender, EventArgs e)
{
if (DesignMode)
{
return;
}
if (string.Compare(System.Diagnostics.Process.GetCurrentProcess().ProcessName, "devenv") == 0)
{
return;
}
azCdgnMasterDisplay1.SetAzSaveCodeFileFloder(AzNormalSet.GetAzNormalSet().AzBase.AzSaveCodeFileFloder);
}
public static List <string> GetDBList()
{
string dbConnectionString = AzNormalSet.GetAzNormalSet().AzConnectionString;
using (SqlConnection cn = new SqlConnection(dbConnectionString))
{
cn.Open();
List <string> list = new List <string>();
DataTable allTablesSchemaTable = cn.GetSchema("Tables");
list = ShowDataTableName(allTablesSchemaTable);
DataTable allViewSchemaTable = cn.GetSchema("Views");
list.AddRange(ShowDataTableName(allViewSchemaTable));
return(list);
}
}
public void ClearMasterInfo()
{
if (GeneralHelpler.ConfirmQuestionOperate("确定清除当前主信息吗？") == DialogResult.Cancel)
{
return;
}
azClassCreatProperty = new AzClassCreatProperty();
azClassCreatProperty.ClassName = azMetaTable.ClassName.Replace(' ', '_');
azClassCreatProperty.DisplayName = azMetaTable.ClassDisPlay;
azClassCreatProperty.CurrentSelect = azMetaTable.SchemaName;
azClassCreatProperty.NameSpace = AzNormalSet.GetAzNormalSet().AzBase.AzProjectSpace;
azClassCreatProperty.ProjectName = AzNormalSet.GetAzNormalSet().AzBase.AzProjectName;
azClassCreatProperty.Nick = AzNormalSet.GetAzNormalSet().AzBase.AzNick;
propertyGrid1.SelectedObject = azClassCreatProperty;
SaveMasterInfo();
}
public static DataTable LookDbData(string tableName, int top = 100)
{
string dbConnectionString = AzNormalSet.GetAzNormalSet().AzConnectionString;
string querystr = $"select top {top} * from [{tableName}] ";
using (SqlConnection cn = new SqlConnection(dbConnectionString))
{
cn.Open();
using (SqlCommand cmd = new SqlCommand(querystr, cn))
{
SqlDataReader dataReader = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(dataReader);
return(dataTable);
}
}
}
/// <summary>
/// 数据表是否存在
/// </summary>
/// <param name="tableName">表名</param>
/// <returns></returns>
public static bool DbTableNameExist(string tableName)
{
string dbConnectionString = AzNormalSet.GetAzNormalSet().AzConnectionString;
using (SqlConnection cn = new SqlConnection(dbConnectionString))
{
cn.Open();
DataTable allSchemaTable = cn.GetSchema("Tables");
DataTable allSchemaView = cn.GetSchema("Views");
bool tablesCount = (from d in allSchemaTable.AsEnumerable()
where d.Field <string>("TABLE_NAME") == tableName
select d.Field <string>("TABLE_NAME")).Count <string>() > 0;
bool viewsCount = (from d in allSchemaView.AsEnumerable()
where d.Field <string>("TABLE_NAME") == tableName
select d.Field <string>("TABLE_NAME")).Count <string>() > 0;
return(tablesCount || viewsCount);
}
}
private void SaveMasterInfo()
{
JavaScriptSerializer js = new JavaScriptSerializer();
if (string.IsNullOrWhiteSpace(azClassCreatProperty.ObjPresentation.UpdateTableName))
{
azClassCreatProperty.ObjPresentation.UpdateTableName = azMetaTable.SchemaName;
}
azMetaTable.CodeSetVales = js.Serialize(azClassCreatProperty);
if (azMetaTable.ComeFrom == 1)
{
azMetaTable.ObjModeType = 1;
azMetaTable.AppName = MetadataOperate.GetDefAppNameUpdate(AzNormalSet.GetAzNormalSet().AzBase.AzTablePrefix);
azMetaTable = AzMetaTableHandle.Handle().Insert(azMetaTable);
return;
}
AzMetaTableHandle.Handle().Updata(azMetaTable);
SetSelectedObject(azMetaTable);
OnMasterSaveNotification?.Invoke();
}
private void ACM_Save_Click(object sender, EventArgs e)
{
if (VerificationText())
{
return;
}
AzBaseSet azBaseSetedit = AzNormalSet.GetAzNormalSet().AzBase;
azBaseSetedit.AzClassPrefix = textAzClassPrefix.Text;
azBaseSetedit.AzDbSqlConnectionName = textAzDbSqlConnectionName.Text;
azBaseSetedit.AzNick = textAzNick.Text;
azBaseSetedit.AzProjectName = textAzProjectName.Text;
azBaseSetedit.AzProjectSpace = textAzProjectSpace.Text;
azBaseSetedit.AzTablePrefix = textAzTablePrefix.Text;
azBaseSetedit.AzTemplateFolder = textAzTemplateFolder.Text;
azBaseSetedit.AzToolTable = textAzToolTable.Text;
azBaseSetedit.AzSaveCodeFileFloder = textSaveCodeFileFloder.Text;
AzBaseSet.AzSetBase(azBaseSetedit);
GeneralHelpler.SomethingDoSuccess();
}
public static string ReplacContext(string codeStr, AzMetaTableEntity azMetaTable)
{
var aznormalset = AzNormalSet.GetAzNormalSet();
var azbase = aznormalset.AzBase;
codeStr = codeStr.ReaplaceTemplateForWord("Ai_Project_NameSpace", azbase.AzProjectSpace)
.ReaplaceTemplateForWord("Ai_Project_UI_FullNameSpace", azbase.AzProjectSpace + @".WebUI")
.ReaplaceTemplateForWord("Ai_Bll_ClassName", azMetaTable.ClassName)
.ReaplaceTemplateForWord("Ai_Bll_Edit_ClassName", azMetaTable.ClassName)
.ReaplaceTemplateForWord("Ai_Object_ChineseName", string.IsNullOrWhiteSpace(azMetaTable.ClassDisPlay) ? azMetaTable.ClassName : azMetaTable.ClassDisPlay)
.ReaplaceTemplateForWord("Ai_Bll_List_ClassName", azMetaTable.ClassName + "List")
.ReaplaceTemplateForWord("Ai_ProjectName", azbase.AzProjectName)
.ReaplaceTemplateForWord("Ai_SqlDB_ConnectionString", azMetaTable.ClassName + "List")
.ReaplaceTemplateForWord("Ai_Bll_List_ClassName", azMetaTable.ClassName + "List")
.ReaplaceTemplateForWord("Ai_Bll_List_ClassName", azMetaTable.ClassName + "List")
.ReaplaceTemplateForWord("Ai_Bll_List_ClassName", azMetaTable.ClassName + "List")
.ReaplaceTemplateForWord("Ai_Bll_List_ClassName", azMetaTable.ClassName + "List");
return(codeStr);
}
public void SetSelectedObject(AzMetaTableEntity azMetaTableEntity = null)
{
azMetaTable = azMetaTableEntity;
if (azMetaTableEntity == null)
{
AzNodeLevel0Property azNodeLevel0Property = new AzNodeLevel0Property
{
NameSpace = AzNormalSet.GetAzNormalSet().AzBase.AzProjectSpace,
ProjectName = AzNormalSet.GetAzNormalSet().AzBase.AzProjectName,
Nick = AzNormalSet.GetAzNormalSet().AzBase.AzNick
};
toolStripButton1.Enabled = false;
propertyGrid1.SelectedObject = azNodeLevel0Property;
azClassCreatProperty = null;
}
else
{
toolStripButton1.Enabled = true;
azClassCreatProperty = GetItemClassCreatProperty(azMetaTableEntity);// new AzClassCreatProperty();
SetClassCreatPropertyTrue();
if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_tables ||
azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_customTables)
{
List <string> listp = new List <string> {
"HasBussniesJson", "HasBigText", "HasExec", "HasSpClass"
};
PropertyHelper.AddAttribute(typeof(AzClassCreatProperty), listp, BrowsableFalse);
List <string> listfalseObj = new List <string> {
"IsSchemaForOther", "UpdateTableName", "StoreProcedureQuery"
};
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), listfalseObj, BrowsableFalse);
//PropertyHelper.AddAttribute(typeof(SpecialitySet), "BigText", BrowsableFalse);
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), "ObjDataType", ReadOnlyTrue);
}
else
if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_views ||
azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_customViews)
{
List <string> listp = new List <string> {
"HasBussniesJson", "HasBigText", "HasExec", "HasSpClass"
};
PropertyHelper.AddAttribute(typeof(AzClassCreatProperty), listp, BrowsableFalse);
List <string> listfalseObj = new List <string> {
"StoreProcedureQuery"
};
if (azClassCreatProperty.ObjPresentation.IsSchemaForOther)
{
listfalseObj = new List <string> {
"UpdateTableName", "StoreProcedureQuery"
};
}
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), listfalseObj, BrowsableFalse);
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), "UpdateTableName", ReadOnlyFalse);
PropertyHelper.AddAttribute(typeof(SpecialitySet), "BigText", BrowsableFalse);
}
else
if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_FuncstoredProcedure)
{
List <string> listp = new List <string> {
"HasBussniesJson", "HasBigText", "HasViewDetail",
"HasViewEdit", "HasViewDelete", "HasViewAdd", "HasControllerAsynPage", "HasSpClass",
"HasControllerList", "HasControllerDetail", "HasControllerEdit", "HasControllerDelete",
"HasControllerAdd", "HasDtoConstruction", "HasBussniesList", "HasBussniesDetail",
"HasBussniesEdit", "HasBussniesDelete", "HasBussniesAdd"
};
PropertyHelper.AddAttribute(typeof(AzClassCreatProperty), listp, BrowsableFalse);
List <string> listfalseObj = new List <string> {
"IsSchemaForOther", "UpdateTableName"
};
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), listfalseObj, BrowsableFalse);
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), "UpdateTableName", ReadOnlyFalse);
PropertyHelper.AddAttribute(typeof(SpecialitySet), "BigText", BrowsableFalse);
}
else if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_QuerystoredProcedure)
{
List <string> listp = new List <string> {
"HasBussniesJson", "HasBigText", "HasViewDetail",
"HasViewEdit", "HasViewDelete", "HasViewAdd", "HasExec",
"HasControllerDetail", "HasControllerEdit", "HasControllerDelete",
"HasControllerAdd", "HasDtoConstruction", "HasBussniesDetail",
"HasBussniesEdit", "HasBussniesDelete", "HasBussniesAdd", "HasControllerAsynPage"
};
PropertyHelper.AddAttribute(typeof(AzClassCreatProperty), listp, BrowsableFalse);
List <string> listfalseObj = new List <string> {
"IsSchemaForOther", "UpdateTableName"
};
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), listfalseObj, BrowsableFalse);
PropertyHelper.AddAttribute(typeof(ObjDataPresentation), "UpdateTableName", ReadOnlyFalse);
PropertyHelper.AddAttribute(typeof(SpecialitySet), "BigText", BrowsableFalse);
}
propertyGrid1.SelectedObject = azClassCreatProperty;
propertyGrid1.ExpandAllGridItems();
}
}
public static AzClassCreatProperty GetItemClassCreatProperty(AzMetaTableEntity azMetaTableEntity)
{
AzClassCreatProperty azClassCreatProperty = new AzClassCreatProperty();
if (!string.IsNullOrWhiteSpace(azMetaTableEntity.CodeSetVales))
{
JavaScriptSerializer js = new JavaScriptSerializer();
azClassCreatProperty = js.Deserialize <AzClassCreatProperty>(azMetaTableEntity.CodeSetVales);
}
azClassCreatProperty.ClassName = azMetaTableEntity.ClassName.Replace(' ', '_');
azClassCreatProperty.DisplayName = azMetaTableEntity.ClassDisPlay;
azClassCreatProperty.CurrentSelect = azMetaTableEntity.SchemaName;
azClassCreatProperty.NameSpace = AzNormalSet.GetAzNormalSet().AzBase.AzProjectSpace;
azClassCreatProperty.ProjectName = AzNormalSet.GetAzNormalSet().AzBase.AzProjectName;
azClassCreatProperty.Nick = AzNormalSet.GetAzNormalSet().AzBase.AzNick;
if (azMetaTableEntity.ObjModeType == 1)
{
switch (azMetaTableEntity.ObjDataType)
{
case 1:
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_tables;
break;
case 2:
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_views;
break;
case 3:
if (string.IsNullOrWhiteSpace(azClassCreatProperty.ObjPresentation.StoreProcedureQuery))
{
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_FuncstoredProcedure;
}
else
{
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_QuerystoredProcedure;
}
break;
}
}
else
{
switch (azMetaTableEntity.ObjDataType)
{
case 1:
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_customTables;
break;
case 2:
azClassCreatProperty.ObjPresentation.ObjDataType = ObjDataTypeEnum.atk_customViews;
break;
}
}
//确保IsSchemaForOther设置正确
if (azClassCreatProperty.ObjPresentation.IsSchemaForOther)
{
if (!(azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_views ||
azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_customViews))
{
azClassCreatProperty.ObjPresentation.IsSchemaForOther = false;
}
}
if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_tables ||
azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_customTables)
{
azClassCreatProperty.HasBussniesJson = false;
azClassCreatProperty.HasBigText = false;
azClassCreatProperty.HasExec = false;
azClassCreatProperty.HasSpClass = false;
azClassCreatProperty.ObjPresentation.IsSchemaForOther = false;
azClassCreatProperty.ObjPresentation.UpdateTableName = "";
azClassCreatProperty.ObjPresentation.StoreProcedureQuery = "";
}
else
if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_views ||
azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_customViews)
{
azClassCreatProperty.HasBussniesJson = false;
azClassCreatProperty.HasBigText = false;
azClassCreatProperty.HasExec = false;
azClassCreatProperty.HasSpClass = false;
if (azClassCreatProperty.ObjPresentation.IsSchemaForOther)
{
azClassCreatProperty.ObjPresentation.UpdateTableName = "";
}
}
else if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_FuncstoredProcedure)
{
azClassCreatProperty.HasBussniesJson = false;
azClassCreatProperty.HasBigText = false;
azClassCreatProperty.HasViewDetail = false;
azClassCreatProperty.HasViewEdit = false;
azClassCreatProperty.HasViewDelete = false;
azClassCreatProperty.HasViewAdd = false;
azClassCreatProperty.HasControllerAsynPage = false;
azClassCreatProperty.HasControllerList = false;
azClassCreatProperty.HasControllerDetail = false;
azClassCreatProperty.HasControllerEdit = false;
azClassCreatProperty.HasControllerDelete = false;
azClassCreatProperty.HasControllerAdd = false;
azClassCreatProperty.HasControllerDelete = false;
azClassCreatProperty.HasDtoConstruction = false;
azClassCreatProperty.HasBussniesDetail = false;
azClassCreatProperty.HasBussniesEdit = false;
azClassCreatProperty.HasBussniesDelete = false;
azClassCreatProperty.HasBussniesAdd = false;
azClassCreatProperty.ObjPresentation.IsSchemaForOther = false;
azClassCreatProperty.ObjPresentation.UpdateTableName = "";
}
else if (azClassCreatProperty.ObjPresentation.ObjDataType == ObjDataTypeEnum.atk_QuerystoredProcedure)
{
azClassCreatProperty.HasBussniesJson = false;
azClassCreatProperty.HasBigText = false;
azClassCreatProperty.HasViewDetail = false;
azClassCreatProperty.HasViewEdit = false;
azClassCreatProperty.HasViewDelete = false;
azClassCreatProperty.HasViewAdd = false;
azClassCreatProperty.HasExec = false;
azClassCreatProperty.HasControllerDetail = false;
azClassCreatProperty.HasControllerEdit = false;
azClassCreatProperty.HasControllerDelete = false;
azClassCreatProperty.HasControllerAdd = false;
azClassCreatProperty.HasControllerDelete = false;
azClassCreatProperty.HasDtoConstruction = false;
azClassCreatProperty.HasBussniesDetail = false;
azClassCreatProperty.HasBussniesEdit = false;
azClassCreatProperty.HasBussniesDelete = false;
azClassCreatProperty.HasBussniesAdd = false;
azClassCreatProperty.HasControllerAsynPage = false;
azClassCreatProperty.ObjPresentation.IsSchemaForOther = false;
azClassCreatProperty.ObjPresentation.UpdateTableName = "";
}
azClassCreatProperty.ObjPresentation.UpdateTableName = azMetaTableEntity.SchemaName;
return(azClassCreatProperty);
}
protected AtkHandle()
{
azNormalSet = AzNormalSet.GetAzNormalSet();
repository = RepoFactory.Create <TEntity>();
}
public static string CreateDBObject(AzMetaTableEntity azMetaTable, IEnumerable <AzMetaCustomCloumEntity> azCloumListEntity)
{
if (azMetaTable == null)
{
throw new Exception(" 元数主表类为null，不能生成！");
}
if (azCloumListEntity == null)
{
throw new Exception(" 元数属性null，不能生成！");
}
string createSql = $" CREATE TABLE [dbo].[{azMetaTable.SchemaName}](";
string identitySql = " [{0}] [{1}] IDENTITY(1,1) NOT NULL,";
string normalSql = " [{0}] [{1}] {2},";
string haveLenSql = " [{0}] [{1}] ({2}) {3},";
string constraintSql = " CONSTRAINT [PK_{0}] PRIMARY KEY CLUSTERED({1})) ON [PRIMARY]";
string nullstr = "";
string keyid = "";
string tempstr = "";
int idCount = 0;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(createSql);
foreach (var item in azCloumListEntity)
{
nullstr = item.IsNullable ?? true ? " Not NULL" : " NULL";
if (item.IsKeyField ?? true)
{
keyid = (string.IsNullOrWhiteSpace(keyid)) ? keyid = $" {item.FldName} ASC" : $"{keyid},{item.FldName} ASC";
}
if (item.FldType.ToLower().Contains("char"))
{
tempstr = string.Format(haveLenSql, item.FldName, item.FldType, item.FldLen, nullstr);
}
else
{
if (item.IsIdentity ?? true)
{
tempstr = string.Format(identitySql, item.FldName, item.FldType);
idCount += 1;
if (idCount > 1)
{
throw new Exception(string.Format(" '{0}'有多个自增字段，不能生成！", azMetaTable.ClassName));
}
}
else
{
tempstr = string.Format(normalSql, item.FldName, item.FldType, nullstr);
}
}
stringBuilder.Append(tempstr);
}
if (string.IsNullOrWhiteSpace(keyid))
{
throw new Exception(string.Format(" '{0}'没有设置关键字段，不能生成！", azMetaTable.ClassName));
}
tempstr = string.Format(constraintSql, azMetaTable.SchemaName, keyid);
stringBuilder.Append(tempstr);
stringBuilder.Append($"; UPDATE [dbo].[{AzNormalSet.GetAzNormalSet().AzMetaCloumName}] SET TpyeId=1 where TableName='{azMetaTable.SchemaName}'");
return(stringBuilder.ToString());
}
