private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dt = e.Argument as DataTable;
SQLJobThread jobThread = new SQLJobThread(mv_dbUtil);
string af_pwd = textBox2.Text;
string seq = textBox1.Text;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (isStopIssued)
{
isStopIssued = false;
break;
}
DataRow dr = dt.Rows[i];
if (dr["OPER_YN"].ToString() != "1")
{
continue;
}
try
{
if (dr["PWD_TYP_CL_CD"].ToString() == "ENC")
{
dr["BF_PWD"] = Cipher.Decrypt(dr["BF_PWD"].ToString());
}
}
catch (Exception ex)
{
}
WorkResult result = new WorkResult();
result.PWD_CHG_OPER_SEQ = dr["PWD_CHG_OPER_SEQ"].ToString();
result.DB_ID = dr["DB_ID"].ToString();
result.ACNT_NM = dr["ACNT_NM"].ToString();
result.OP_RSLT = "Connecting...";
backgroundWorker1.ReportProgress(0, result);
string workresult = jobThread.TestConnection(dr["CONN_STR_CTT"].ToString(), dr["ACNT_NM"].ToString(), dr["BF_PWD"].ToString());
WorkResult result1 = new WorkResult();
result1.PWD_CHG_OPER_SEQ = dr["PWD_CHG_OPER_SEQ"].ToString();
result1.DB_ID = dr["DB_ID"].ToString();
result1.ACNT_NM = dr["ACNT_NM"].ToString();
result1.OP_RSLT = workresult;
backgroundWorker1.ReportProgress(0, result1);
//dr["OP_RSLT"] = result;
}
}
