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)); }