コード例 #1
0
        private void btnRead_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                #region
                if (ListBox.Items.Count > 0)
                {
                    string destFolder   = txtPath.Text.Trim();
                    string sourceFolder = txtSourcePath.Text.Trim();
                    foreach (object t in ListBox.Items)
                    {
                        string file    = destFolder + t;
                        string pos     = t.ToString().Substring(0, 6);
                        string ngay    = t.ToString().Substring(7, 8);
                        string fileTxt = sourceFolder + pos + "_" + ngay + "_LEND30.txt";
                        //MessageBox.Show(file+"  "+fileTxt);
                        bll.Pdf2Text(file, fileTxt);
                    }
                    ListText.Items.Clear();
                    DirectoryInfo dir   = new DirectoryInfo(sourceFolder);
                    FileInfo[]    files = dir.GetFiles("*.txt*");
                    foreach (FileInfo file in files)
                    {
                        string ngay = file.Name.Trim().Substring(7, 8);
                        if (dtpNgay.SelectedDate != null && ngay == dtpNgay.SelectedDate.Value.ToString("ddMMyyyy"))
                        {
                            //MessageBox.Show(file.ToString());
                            ListText.Items.Add(file);
                        }
                    }
                    if (ListText.Items.Count == 0)
                    {
                        MessageBox.Show("Not Files found ! ", "Mess", MessageBoxButton.OK, MessageBoxImage.Warning);
                    }
                    else
                    {
                        cls.ClsConnect();
                        foreach (object t in ListText.Items)
                        {
                            string mato   = "";
                            string soku   = "";
                            string file   = sourceFolder + t;
                            string pos    = t.ToString().Substring(0, 6);
                            string ngay   = t.ToString().Substring(7, 8);
                            string ng     = dtpNgay.SelectedDate.Value.ToString("yyyy-MM-dd");
                            string sqlchk = "select top 1 * from PSPDF where NGAY='" + ng + "' and KU_MAPGD='" + pos + "'";
                            dt = cls.LoadDataText(sqlchk);
                            if (dt.Rows.Count > 0)
                            {
                                MessageBox.Show("Số liệu ngày : " + ng + "  Pos : " + pos + "   đã tồn tại", "Mess",
                                                MessageBoxButton.OK, MessageBoxImage.Information);
                            }
                            else
                            {
                                string   str    = bll.XoaKyTuTrang(File.ReadAllText(file));
                                string[] arrStr = str.Split(' ');
                                foreach (var item in arrStr)
                                {
                                    if ((item.Trim().Length == 8 && bll.Right(item.Trim(), 1) == ":") ||
                                        (item.Trim().Length == 16 && bll.Left(item.Trim(), 2) == "66"))
                                    {
                                        if (item.Trim().Length == 8 && bll.Right(item.Trim(), 1) == ":")
                                        {
                                            mato = bll.Left(item, 7);
                                        }
                                        if (item.Trim().Length == 16 && bll.Left(item.Trim(), 2) == "66")
                                        {
                                            soku = item.Trim();
                                            //MessageBox.Show(ng+"  "+pos+"   "+mato + "      " + soku);
                                            string sql = "insert into PSPDF (NGAY,KU_MAPGD,KU_MATO,KU_SOKU) values ('" +
                                                         ng + "','" + pos + "','" + mato + "','" + soku + "')";
                                            cls.UpdateDataText(sql);
                                        }
                                    }
                                }
                            }
                        }
                        cls.DongKetNoi();
                        MessageBox.Show("OK", "Mess", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }
                else
                {
                    MessageBox.Show("Không có file nào!", "Mess", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
                #region

                /*
                 * string[] files = Directory.GetFiles(destFolder);
                 * foreach (string file in files)
                 * {
                 *  string Ngay = file.Substring(14, 8);
                 *  if (dtpNgay.SelectedDate != null && Ngay == dtpNgay.SelectedDate.Value.ToString("ddMMyyyy"))
                 *  {
                 *      MessageBox.Show(file);
                 *  }
                 * }
                 */
                //MessageBox.Show(bll.PdfText(txtPath.Text.Trim()));
                //string str = bll.XoaKyTuTrang(bll.PdfText(txtPath.Text.Trim()));
                //MessageBox.Show(str);

                /*
                 * // MessageBox.Show(bll.XoaKyTuTrang(bll.pdfText(txtPath.Text.Trim())));
                 * for (int i = 0; i < ListBox.Items.Count; i++)
                 * {
                 *  string mato = "";
                 *  string soku = "";
                 *  string str = bll.XoaKyTuTrang(bll.pdfText(txtPath.Text.Trim()));
                 *  MessageBox.Show(str);
                 *
                 *  string[] arrStr = str.Split(' ');
                 *  foreach (var item in arrStr)
                 *  {
                 *      if ((item.Trim().Length == 8 && bll.Right(item.Trim(), 1) == ":") ||
                 *          (item.Trim().Length == 16 && bll.Left(item.Trim(), 2) == "66"))
                 *      {
                 *          if (item.Trim().Length == 8 && bll.Right(item.Trim(), 1) == ":")
                 *          {
                 *              //MessageBox.Show("Ma to "+bll.Left(item,7));
                 *              mato = bll.Left(item, 7);
                 *              //strmoi = strmoi + mato+" ";
                 *          }
                 *          if (item.Trim().Length == 16 && bll.Left(item.Trim(), 2) == "66")
                 *          {
                 *              //MessageBox.Show("soku " + item.Trim());
                 *              soku = item.Trim();
                 *              //strmoi = strmoi + soku+" ";
                 *              MessageBox.Show(mato + "      " + soku);
                 *          }
                 *      }
                 *  }
                 *  //MessageBox.Show(strmoi);
                 * }
                 */
                #endregion
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error + " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
            #endregion
            bll.DeleteAllFile(txtPath.Text.Trim());
            bll.DeleteAllFile(txtSourcePath.Text.Trim());
            ListBox.Items.Clear();
            ListText.Items.Clear();
        }