private void Main_Load(object sender, EventArgs e)
{
InitialTemplateInfo();
InitialSettingInfo();
if (TestConnection())
{
procMetaReader = new SqlServerProcMetaReader(txtCon.Text);
tableMetaReader = new SqlServerTableMetaReader(txtCon.Text);
InitialGvProcedures();
tables = tableMetaReader.GetTables("dbo");
InitialGvTables(tables);
InitialGvViews(tables);
}
}
private void BtnCon_Click(object sender, EventArgs e)
{
if (TestConnection())
{
MessageBox.Show("Successful connection!","Connection information");
procMetaReader = new SqlServerProcMetaReader(txtCon.Text);
tableMetaReader = new SqlServerTableMetaReader(txtCon.Text);
tables = tableMetaReader.GetTables("dbo");
InitialGvProcedures();
InitialGvTables(tables);
InitialGvViews(tables);
}
else
MessageBox.Show("Connection failed!");
}
private void InitialStoreProcedures(object state)
{
List<string> selectFiles = RetriveGridViewSelect(gvTemplate, "FullPath","ColCheck");
int i = 0;
for (i = 0; i < selectFiles.Count; i++)
{
if (Path.GetFileName(selectFiles[i]) != "Biz.tt" && Path.GetFileName(selectFiles[i]) != "Dal.tt" &&
Path.GetFileName(selectFiles[i]) != "CSProj.Enum.tt" && Path.GetFileName(selectFiles[i]) != "CSProj.Solution.tt" &&
Path.GetFileName(selectFiles[i]) != "Entity.tt" && Path.GetFileName(selectFiles[i]) != "EntityMapping.tt" &&
Path.GetFileName(selectFiles[i]) != "Enum.tt")
break;
}
if (i == selectFiles.Count)
{
InitailTables();
Process();
return;
}
SqlServerProcMetaReader procMetaReader = new SqlServerProcMetaReader(T4Parameters.Default.SqlConnectionString);
T4Parameters.Default.StoreProcedureParametersMeta = procMetaReader.SpParaMeta;
T4Parameters.Default.StoreProcedureResultMeta = procMetaReader.SpResultMeta;
if (procMetaReader.SpFailed.Count > 0)
{
StringBuilder spErrorBuilder = new StringBuilder();
spErrorBuilder.AppendLine(string.Format("{0} store procedure failed", procMetaReader.SpFailed.Count));
spErrorBuilder.AppendLine("**********************************************************************");
foreach (var item in procMetaReader.SpFailed)
{
spErrorBuilder.AppendLine(string.Format("Procedure name : {0}", item.Key));
}
spErrorBuilder.AppendLine("**********************************************************************");
OnSetLogHandler(this, new WorkEventArgs(WorkStage.DoWork, "") { ErrorInfo=spErrorBuilder.ToString() });
}
InitailTables();
Process();
}
public FormSPParameter(string connectionStr)
{
this.ConnectionStr = connectionStr;
reader = new SqlServerProcMetaReader(connectionStr);
InitializeComponent();
}