public string AddColumnSql(FapColumn fapColumn)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine($"alter table {fapColumn.TableName} add {CreateColumnSql(fapColumn)} ;");
//if (HasDefaultValueConstraint(fapColumn))
//{
// stringBuilder.AppendLine(string.Format("ALTER TABLE {0} ADD CONSTRAINT DF_{0}_{1} DEFAULT ('{2}') FOR {1};", fapColumn.TableName, fapColumn.ColName, fapColumn.ColDefault));
//}
stringBuilder.AppendLine(MakeColumnCommentSql(fapColumn));
if (fapColumn.IsMultiLang == 1) //多语
{
var languageList = typeof(MultiLanguage.MultiLanguageEnum).EnumItems();
foreach (var item in languageList)
{
FapColumn mf = (FapColumn)fapColumn.Clone();
mf.ColName = fapColumn.ColName + item.Value;
mf.ColComment = fapColumn.ColComment + item.Description;
mf.IsMultiLang = 0;
stringBuilder.AppendLine($"alter table {mf.TableName} add {CreateColumnSql(mf)} ;");
stringBuilder.Append(MakeColumnCommentSql(mf)).AppendLine();
}
}
return(stringBuilder.ToString());
}
public string AlterMultiLangColumnSql(FapColumn fapColumn)
{
StringBuilder builder = new StringBuilder();
var languageList = typeof(MultiLanguage.MultiLanguageEnum).EnumItems();
foreach (var lang in languageList)
{
FapColumn column = (FapColumn)fapColumn.Clone();
column.ColName = fapColumn.ColName + lang.Value;
column.ColComment = fapColumn.ColComment + lang.Description;
column.IsMultiLang = 0;
builder.AppendLine($"alter table {fapColumn.TableName} alter column {CreateColumnSql(column)};");
}
return(builder.ToString());
}
public string RenameMultilangColumnSql(FapColumn newColumn, string oldName)
{
StringBuilder builder = new StringBuilder();
var languageList = typeof(MultiLanguage.MultiLanguageEnum).EnumItems();
foreach (var lang in languageList)
{
FapColumn column = (FapColumn)newColumn.Clone();
column.ColName = newColumn.ColName + lang.Value;
column.ColComment = newColumn.ColComment + lang.Description;
column.IsMultiLang = 0;
string oldLangName = oldName + lang.Value;
builder.AppendLine($"alter table {newColumn.TableName} change column {oldLangName} {CreateColumnSql(column)};");
}
return(builder.ToString());
}
public string RenameMultilangColumnSql(FapColumn newColumn, string oldName)
{
StringBuilder builder = new StringBuilder();
var languageList = typeof(MultiLanguage.MultiLanguageEnum).EnumItems();
foreach (var lang in languageList)
{
FapColumn column = (FapColumn)newColumn.Clone();
column.ColName = newColumn.ColName + lang.Value;
column.ColComment = newColumn.ColComment + lang.Description;
column.IsMultiLang = 0;
string oldLangName = oldName + lang.Value;
builder.AppendLine($"EXEC sp_rename '{column.TableName}.{oldLangName}', '{column.ColName}' , 'COLUMN';");
builder.AppendLine(AlterColumnSql(column));
}
return(builder.ToString());
}
