private void btnChangeDbInfo_Click(object sender, EventArgs e)
{
LvDestination.Items.Clear();
ClassDBInfo.OK = false;
FrmDestinationDbInfo frmdb = new FrmDestinationDbInfo();
frmdb.dbtype = CboDbType.Text.ToUpper();
frmdb.ShowDialog();
try
{
if (ClassDBInfo.OK == true)
{
Application.DoEvents();
FillDestinationFields();
if (LvDestination.Items.Count > 0)
{
btnmap.Enabled = true;
}
}
string path = Application.StartupPath + @"\FieldsMapping.xml";
if (File.Exists(path))
{
varTable = null;
if (varTable == null)
{
varTable = new DataTable();
varTable.TableName = "FieldsMapping";
varTable.Columns.Add("SourceColumn");
varTable.Columns.Add("DestinationColumn");
varTable.Columns.Add("ColumnDataType");
varTable.Columns.Add("ConType");
varTable.Columns.Add("TableNameSource");
varTable.Columns.Add("TableNameDestination");
varTable.AcceptChanges();
}
varTable.ReadXml(path);
FillLvMap();
}
}
catch (Exception ex)
{
WriteErrorLog(spath, ex.Message + " " + ex.ToString());
MessageBox.Show(ex.Message.ToString(), "btnChangeDbInfo_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CboDbType_SelectedIndexChanged(object sender, EventArgs e)
{
btnChangeDbInfo.Visible = false;
LvDestination.Items.Clear();
LvMap.Items.Clear();
try
{
if (CboDbType.SelectedIndex != 0)
{
string varpath = Application.StartupPath + @"\DbConInfo.xml";
if (File.Exists(varpath) == true)
{
DataTable table = new DataTable();
table.TableName = "TblConnection";
table.Columns.Add("ServerName");
table.Columns.Add("DbName");
table.Columns.Add("Uid");
table.Columns.Add("Pwd");
table.Columns.Add("Type");
table.ReadXml(varpath);
if (table.Rows.Count > 0)
{
if (table.Rows[0]["Type"].ToString().ToUpper() == CboDbType.Text.ToUpper())
{
btnChangeDbInfo.Visible = true;
ClassDBInfo.DBType = CboDbType.Text.ToUpper();
ClassDBInfo.Server = table.Rows[0]["ServerName"].ToString();
ClassDBInfo.DbName = table.Rows[0]["DbName"].ToString();
ClassDBInfo.UID = table.Rows[0]["Uid"].ToString();
ClassDBInfo.Pwd = table.Rows[0]["Pwd"].ToString();
ClassDBInfo.OK = true;
}
else
{
ClassDBInfo.OK = false;
FrmDestinationDbInfo frmdb = new FrmDestinationDbInfo();
frmdb.dbtype = CboDbType.Text.ToUpper();
frmdb.ShowDialog();
}
}
}
else
{
ClassDBInfo.OK = false;
FrmDestinationDbInfo frmdb = new FrmDestinationDbInfo();
frmdb.dbtype = CboDbType.Text.ToUpper();
frmdb.ShowDialog();
}
if (ClassDBInfo.OK == true)
{
Application.DoEvents();
FillDestinationTables();
if (LvDestination.Items.Count > 0)
{
btnmap.Enabled = true;
}
string path = Application.StartupPath + @"\FieldsMapping.xml";
if (File.Exists(path))
{
varTable = null;
if (varTable == null)
{
varTable = new DataTable();
varTable.TableName = "FieldsMapping";
varTable.Columns.Add("SourceColumn");
varTable.Columns.Add("DestinationColumn");
varTable.Columns.Add("ColumnDataType");
varTable.Columns.Add("ConType");
varTable.Columns.Add("TableNameSource");
varTable.Columns.Add("TableNameDestination");
varTable.AcceptChanges();
}
varTable.ReadXml(path);
if (varTable.Rows.Count > 0 && varTable.Rows[0]["ConType"].ToString().ToUpper() == CboDbType.Text.ToUpper())
{
FillLvMap();
}
else
{
varTable.Rows.Clear();
}
}
}
}
}
catch (Exception ex)
{
//WriteErrorLog(spath, ex.Message + " " + ex.ToString());
MessageBox.Show(ex.Message.ToString(), "CboDbType_SelectedIndexChanged", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}