Exemplo n.º 1
0
        private void GenerateJobList()
        {
            try
            {
                isStopIssued = false;
                AddLog("패스워드변경대상 갖고오기 시작");
                SQLJobThread jobThread = new SQLJobThread(mv_dbUtil);


                DataTable dt = jobThread.CreatePasswordChangeJob(mv_dbUtil);

                DataColumn[] keys = new DataColumn[3];
                keys[0] = dt.Columns["PWD_CHG_OPER_SEQ"];
                keys[1] = dt.Columns["DB_ID"];
                keys[2] = dt.Columns["ACNT_NM"];

                dt.PrimaryKey = keys;


                dataGridView1.DataSource = dt;


                if (dt.Rows.Count > 0)
                {
                    textBox1.Text = dt.Rows[0]["PWD_CHG_OPER_SEQ"].ToString();
                }


                textBox2.Text = "da_" + StringUtil.GeneratePassword(14, 4, 5);


                button5.Enabled = true;
                button3.Enabled = true;
            }
            catch (Exception ex)
            {
                AddLog("패스워드변경대상 갖고오기 실패");
                AddLog(ex.Message);
            }
        }