Example #1
0
        private void TransferTo202_Click(object sender, EventArgs e)
        {
            int StationID = Convert.ToInt32(lounge_site.SelectedValue);

            logger.Debug(String.Format("Begin transfer data from site>", lounge_site.Text));
            TransactionDao dao = new TransactionDao();

            String cri = "where date(create_date) = date('" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + "') and LoungePlace=" + StationID + " order by update_date desc";

            List <ModelTransaction> lists = dao.Select61(cri, StationID);
            int result = 0;

            if (lists.Count > 0)
            {
                foreach (ModelTransaction m in lists)
                {
                    result += (dao.Insert(m, StationID))? result++:0;
                }
            }

            logger.Debug(String.Format("Result of transafer total{0} success{1} record(s)", lists.Count, result));
        }