public string GetCreateClassScript(DataTableForCreateScript _dt)
{
string result;
try
{
if (_dt == null)
{
throw new Exception("GetCreateClassScript:传入_dt为空");
}
StringBuilder stringBuilder = new StringBuilder();
for (int i = 0; i < _dt.Rows.Count; i++)
{
stringBuilder.AppendLine(this.MakePropertyInfo(_dt.Rows[i]));
}
string text = stringBuilder.ToString();
result = text;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public string GetCreateTableScript(DataTableForCreateScript _dt)
{
string result;
try
{
if (_dt == null)
{
throw new Exception("GetCreateTableScript:传入_dt为空");
}
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringBuilder2 = new StringBuilder();
StringBuilder stringBuilder3 = new StringBuilder();
for (int i = 0; i < _dt.Rows.Count; i++)
{
string text = "";
string text2 = "";
string text3 = "";
this.MakeTableInfo(_dt.Rows[i], out text, out text2, out text3);
if (!(text.Trim() == ""))
{
if (stringBuilder.Length != 0)
{
stringBuilder.AppendLine(",");
}
stringBuilder.Append(text);
if (text2.Trim() != "")
{
if (stringBuilder2.Length != 0)
{
stringBuilder2.Append(",");
}
stringBuilder2.Append(text2);
}
if (text3.Trim() != "")
{
stringBuilder3.AppendLine(text3);
}
}
}
StringBuilder stringBuilder4 = new StringBuilder();
stringBuilder4.AppendLine(string.Format("CREATE TABLE {0} ", ORMScriptTempletInfo.TablenamePlaceholder));
stringBuilder4.AppendLine("(");
stringBuilder4.AppendLine(stringBuilder.ToString());
stringBuilder4.Append(")");
stringBuilder4.AppendLine(";");
if (stringBuilder2.Length != 0)
{
stringBuilder2.Insert(0, string.Concat(new string[]
{
"alter table ",
ORMScriptTempletInfo.TablenamePlaceholder,
" add constraint PK_",
ORMScriptTempletInfo.TablenamePlaceholder,
" primary key ("
}));
stringBuilder2.Append(")");
stringBuilder2.Append(";");
stringBuilder4.AppendLine(stringBuilder2.ToString());
}
if (stringBuilder3.Length != 0)
{
stringBuilder4.AppendLine(stringBuilder3.ToString());
}
string text4 = stringBuilder4.ToString();
result = text4;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
