private void btnSearch_Click(object sender, EventArgs e) { YCTBlacklistSearchCondition con = null; if (chkCatched.Checked) { con = new YCTBlacklistSearchCondition(); con.OnlyCatched = true; } List <YCTBlacklist> bls = new YCTBlacklistBll(AppSettings.CurrentSetting.MasterParkConnect).GetItems(con).QueryObjects; if (!string.IsNullOrEmpty(txtCardID.Text)) { bls = bls.Where(it => it.LCN.Contains(txtCardID.Text)).ToList(); } dataGridView1.Rows.Clear(); foreach (var bl in bls) { int row = dataGridView1.Rows.Add(); dataGridView1.Rows[row].Cells["colLCN"].Value = bl.LCN; dataGridView1.Rows[row].Cells["colFCN"].Value = bl.FCN; dataGridView1.Rows[row].Cells["colReason"].Value = GetReason(bl.Reason); dataGridView1.Rows[row].Cells["colCatchAt"].Value = bl.CatchAt; dataGridView1.Rows[row].Cells["colUploadFile"].Value = bl.UploadFile; } lblMsg.Text = string.Format("共有 {0} 项", bls != null ? bls.Count : 0); }
protected override List <YCTBlacklist> GetingItems(ParkDataContext parking, SearchCondition search) { IQueryable <YCTBlacklist> result = parking.GetTable <YCTBlacklist>(); if (search is YCTBlacklistSearchCondition) { YCTBlacklistSearchCondition con = search as YCTBlacklistSearchCondition; if (con.WalletType != null) { result = result.Where(item => item.WalletType == con.WalletType.Value); } if (con.OnlyCatched) { result = result.Where(item => item.CatchAt != null); } if (con.OnlyUnUploaded) { result = result.Where(item => item.CatchAt != null && item.UploadFile == null); } } return(result.ToList()); }
private void SyncUploadFiles(FtpClient ftp, YCTSetting yct) { //DateTime dt = DateTime.Now; DateTime dt = DateTime.Today.AddMilliseconds(-1); string m1Zip = string.Format("XF{0}{1}{2}.ZIP", yct.ServiceCode.ToString().PadLeft(4, '0'), yct.ReaderCode.ToString().PadLeft(4, '0'), dt.ToString("yyyyMMdd")); string cpuZip = string.Format("CX{0}{1}{2}.ZIP", yct.ServiceCode.ToString().PadLeft(4, '0'), yct.ReaderCode.ToString().PadLeft(4, '0'), dt.ToString("yyyyMMddHH")); InsertMsg("定位到: " + _WriteFolder); ftp.SetWorkingDirectory(_WriteFolder); var items = ftp.GetListing(_WriteFolder, FtpListOption.NoPath); if (items == null && items.Length == 0 || items.Count(it => it.Name == m1Zip) == 0) { YCTPaymentRecordSearchCondition con = new YCTPaymentRecordSearchCondition() //获取所有钱包类型为M1钱包且未上传的记录 { WalletType = 1, State = (int)YCTPaymentRecordState.PaidOk, UnUploaded = true, PaymentDateTimeRange = new DateTimeRange(new DateTime(2010, 1, 1), dt) }; List <YCTPaymentRecord> records = new YCTPaymentRecordBll(AppSettings.CurrentSetting.MasterParkConnect).GetItems(con).QueryObjects; if (records != null && records.Count > 0) { YCTBlacklistSearchCondition ycon = new YCTBlacklistSearchCondition(); ycon.WalletType = 1; //M ycon.OnlyCatched = true; ycon.OnlyUnUploaded = true; List <YCTBlacklist> blacks = new YCTBlacklistBll(AppSettings.CurrentSetting.MasterParkConnect).GetItems(ycon).QueryObjects; string zip = YCTUploadFileFactory.CreateM1UploadFile(dt, m1Zip, records, blacks); if (!string.IsNullOrEmpty(zip)) { InsertMsg("上传文件" + m1Zip); using (FileStream fs = new FileStream(zip, FileMode.Open, FileAccess.Read)) { ftp.Upload(m1Zip, fs); new YCTPaymentRecordBll(AppSettings.CurrentSetting.MasterParkConnect).BatchChangeUploadFile(records, m1Zip); if (blacks != null && blacks.Count > 0) { new YCTBlacklistBll(AppSettings.CurrentSetting.MasterParkConnect).BatchChangeUploadFile(blacks, m1Zip); } } } } } if (items == null && items.Length == 0 || items.Count(it => it.Name == cpuZip) == 0) { YCTPaymentRecordSearchCondition con = new YCTPaymentRecordSearchCondition() //获取所有钱包类型为CPU钱包且未上传的记录 { WalletType = 2, State = (int)YCTPaymentRecordState.PaidOk, UnUploaded = true, PaymentDateTimeRange = new DateTimeRange(new DateTime(2010, 1, 1), dt) }; List <YCTPaymentRecord> records = new YCTPaymentRecordBll(AppSettings.CurrentSetting.MasterParkConnect).GetItems(con).QueryObjects; if (records != null && records.Count > 0) { YCTBlacklistSearchCondition ycon = new YCTBlacklistSearchCondition(); ycon.WalletType = 2; //cpu ycon.OnlyCatched = true; ycon.OnlyUnUploaded = true; List <YCTBlacklist> blacks = new YCTBlacklistBll(AppSettings.CurrentSetting.MasterParkConnect).GetItems(ycon).QueryObjects; string zip = YCTUploadFileFactory.CreateCPUUploadFile(dt, cpuZip, records, blacks); if (!string.IsNullOrEmpty(zip)) { InsertMsg("上传文件" + cpuZip); using (FileStream fs = new FileStream(zip, FileMode.Open, FileAccess.Read)) { ftp.Upload(cpuZip, fs); new YCTPaymentRecordBll(AppSettings.CurrentSetting.MasterParkConnect).BatchChangeUploadFile(records, cpuZip); if (blacks != null && blacks.Count > 0) { new YCTBlacklistBll(AppSettings.CurrentSetting.MasterParkConnect).BatchChangeUploadFile(blacks, cpuZip); } } } } } }