private void Generate() { PSA_TYPE2.LoadMetaAttribute(); rtbT2TableSTG.Text = PSA_TYPE2.GenerateTableSTG(); rtbT2ViewMETA.Text = PSA_TYPE2.GenerateVIEWMTA(); rtbT2USPCDC.Text = PSA_TYPE2.GenerateUSPCDC(); rtbT2TableCDC.Text = PSA_TYPE2.GenerateTableCDC(); rtbT2TableLOG.Text = PSA_TYPE2.GenerateTableLOG(); rtbT2USPLOG.Text = PSA_TYPE2.GenerateUSPLOG(); rtbT2ViewCurrent.Text = PSA_TYPE2.GenerateVIEWCURRENT(); DATAVAULT.LoadMetaAttribute(); rtbDVTSAT.Text = DATAVAULT.GenerateTableSAT(); rtbDVTHUB.Text = DATAVAULT.GenerateTableHUB(); rtbDVTLINK.Text = DATAVAULT.GenerateTableLINK(); rtbDVUHUB.Text = DATAVAULT.GenerateUSPHUB(); rtbDVULINK.Text = DATAVAULT.GenerateUSPLINK(); rtbDVUSAT.Text = DATAVAULT.GenerateUSPSAT(); //rtbT1TableLanding.Text = PSA_TYPE1.GenerateLandingZone(); //rtbT1TableStage.Text = PSA_TYPE1.GenerateSTG(); //rtbT1USPStage.Text = PSA_TYPE1.GenerateUSPSTG(); //rtbT1TableHIS.Text = PSA_TYPE1.GenerateHIS(); //rtbT1USPHIS.Text = PSA_TYPE1.GenerateUSPHIS(); }
private void executePSA2DataFlowToolStripMenuItem_Click(object sender, EventArgs e) { //string strContent = PSA_TYPE2.GenerateExecuteFlow(); //rtbContent.Text = strContent; WF_METAScript frmScript = new WF_METAScript(); frmScript.Script = PSA_TYPE2.GenerateExecuteFlow(); frmScript.ShowDialog(); }
private void deployToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("Start to deploy META database?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPLOG()); MessageBox.Show("META database deploy done!"); } catch (Exception ex) { MessageBox.Show("META databse deploy Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void pSAType2FlowToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("Confirm to deploy PSA Type 2 data flow?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { //Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableSTG()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateVIEWMTA()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableCDC()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPCDC()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableLOG()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateVIEWCURRENT()); Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPLOG()); MessageBox.Show("PSA type 2 Data flow deploy done."); } catch (Exception ex) { MessageBox.Show("PSA type 2 Data flow deploy Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }