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); }