private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                string lvskey = Businessbp.executedb.paymentKey;
                string chuoidong;
                CheckMD5 a = new CheckMD5();
                string fromtime = dtFrom.Text + " " + tbFh.Text + ":" + tbFm.Text + ":" + tbFs.Text;
                string totime = dtTo.Text + " " + tbTh.Text + ":" + tbTm.Text + ":" + tbTs.Text;
                string userid = Businessbp.executedb.Usrid;
                string name = " " + Businessbp.executedb.owner + "proc_OutPayment";
                string[] InParaName = new string[3] { "infromdate", "intodate", "inuserid" };
                string[] OutParaName = new string[1] { "outret" };
                OleDbType[] InParaType = new OleDbType[3] { OleDbType.VarChar, OleDbType.VarChar, OleDbType.VarChar };
                OleDbType[] OutParaType = new OleDbType[1] { OleDbType.Numeric };

                string[] InParaValues = new string[3] { fromtime, totime, userid };
                string[] OutParaValues = new string[1];
                for (int i = 0; i < 1; i++)
                    OutParaValues[i] = "";
                int[] OutParaSize = new int[1] { 0 };
                string err = "";
                Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref  OutParaValues, ref  err);
                if (err != "")
                    MessageBox.Show(err);
                else
                {
                    if (OutParaValues[0].ToString() == "-2")
                    {
                        MessageBox.Show("File already extract.", "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);

                    }
                    else if (OutParaValues[0].ToString() == "-1")
                    {
                        MessageBox.Show("Extract file dispute unsuccessful.", "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);

                    }
                    else
                    {
                        string sql = "";
                        err = "";
                        //folder += DateTime.Now.Month.ToString()+ DateTime.Now.Day.ToString()+ DateTime.Now.Year.ToString() + "_ISS_DISP_NAB970428.dat";
                        folder += "I_" + DateTime.Now.ToString("yyyyMMdd") + "_970428_DISPUTE.dat";
                        sql = "select p.strdispute" +
                              " from  " + Businessbp.executedb.owner + "banknet_payment_dispute p" +
                            //" where p.transaction_local_date >= to_date('" + fromtime + "'," + "'mm/dd/yyyy hh24:mi:ss'" + ")" +
                            //" and p.transaction_local_date <= to_date('" + totime + "'," + "'mm/dd/yyyy hh24:mi:ss'" + ")" +
                              " where p.effdate = trunc(sysdate)" +
                              " order by p.record_seq";
                        DataTable dt = Businessbp.executedb.getTable(sql, ref err);
                        if (err != "")
                            MessageBox.Show(err);
                        else
                        {
                            if (dt.Rows.Count > 0)
                            {
                                FileStream ft = new FileStream(folder, FileMode.Create, FileAccess.Write, FileShare.None);
                                StreamWriter tw = new StreamWriter(ft);
                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    chuoidong = dt.Rows[i][0].ToString();
                                    // thuc hien cong checksum dong vao cuoi
                                    chuoidong += a.GetCS(chuoidong, lvskey);
                                    // ghi vao file
                                    tw.WriteLine(chuoidong);

                                }
                                tw.Flush();
                                ft.Close();
                            }
                            //-------- Successful
                            MessageBox.Show("Extract file dispute successful.", "Exclamation",
                            MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        button2.Enabled = false;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
 public static string GetMD5(string F64_Pri)
 {
     CheckMD5 a = new CheckMD5();
     return a.GetCS(F64_Pri, Key);
 }
 public static string Get_F128_Hash(string F128_Pri)
 {
     CheckMD5 a = new CheckMD5();
     return a.GetCS(F128_Pri, Key);
 }