private void OrderScanMain(object obj) { string table = @"order_updates.dbf"; int lastOrderNum = 0; while (true) { try { var dt = OledbAdapter.GetDataTable("select * from " + table); if (dtOrderNewst == null || dtOrderNewst.Rows.Count < dt.Rows.Count) { dtOrderNewst = dt; needRefreshOrder = true; isUpdatingOrder = true; } for (int i = lastOrderNum; i < dt.Rows.Count; i++) { UpdateOrderRow(dt.Rows[i]); } lastOrderNum = dt.Rows.Count; isUpdatingOrder = false; } catch (Exception ex) { Utils.logger.LogInfo("OrderScanMain Exception, Message:{0}", ex.Message); } Thread.Sleep(100); } }
public bool ExistDBFData() { var insTable = OledbAdapter.GetInstruction("select * from instructions.dbf"); if (insTable != null && insTable.Rows.Count > 0) { return(true); } var ordTable = OledbAdapter.GetDataTable("select * from order_updates.dbf"); if (ordTable != null && ordTable.Rows.Count > 0) { return(true); } return(false); }
private void ASSetScanMain() { string table = @"asset.dbf"; while (true) { try { OledbAdapter o = new OledbAdapter(); var dt = OledbAdapter.GetDataTable("select * from " + table); if (FSetTable == null) { FSetTable = dt.Copy(); } if (PSetTable == null) { PSetTable = dt.Copy(); } PSetTable.Clear(); FSetTable.Clear(); if (dt.Rows.Count > 0) { //将两种数据分别记录到两个表中 foreach (DataRow row in dt.Rows) { var type = row["a_type"].ToString(); if (type == "F") { FSetTable.ImportRow(row); } else if (type == "P") { PSetTable.ImportRow(row); } } } } catch (Exception ex) { Utils.logger.LogInfo("ASSetScanMain Exception, Message:{0}", ex.Message); } Thread.Sleep(1000); } }