private NnReader() { #if (DEBUG) string path = ConfigurationManager.ConnectionStrings["nnstock_d"].ConnectionString;// 库存路径 string key = ConfigurationManager.AppSettings["nnkey"]; #else string path = ConfigurationManager.ConnectionStrings["nnstock"].ConnectionString;// 库存路径 string key = ConfigurationManager.AppSettings["nnkey"]; #endif if (path == null || key == null) { NnMessage.ShowMessage("配置文件错误", true); return; } int index = 12; while (index < 21) { try { mConnection = new OleDbConnection($"Provider=Microsoft.ACE.OLEDB.{index.ToString()}.0;Data Source={path};Persist Security Info=False;Jet OLEDB:Database Password={NnConnection.NnDecrypt(key)}"); mConnection.Open(); IsValid = true; return; } catch (Exception e) { ++index; Console.WriteLine(e.ToString()); } } NnMessage.ShowMessage("数据库错误!", true); }
/// <summary> /// 提交 /// </summary> /// <param name="o"></param> private void _submit(object o) { string value = o as string; if (string.IsNullOrEmpty(value)) { NnMessage.ShowMessage("上传数据为空!"); return; } Dispatcher.Invoke(() => ((Application.Current.MainWindow) as MainWindow)?.StatusBarState(true, "正在上传...")); List <Order> list = _getOrders(value); string erririnfo = _upload(list); if (!string.IsNullOrWhiteSpace(erririnfo)) { WarnWindow.ShowMessage(erririnfo); } Dispatcher.Invoke(() => { ((Application.Current.MainWindow) as MainWindow)?.StatusBarState(false, "标签已上传."); NAction?.Invoke("init"); }); }
// 搜索结束,善后工作 private void _end() { SearchProgress.complete(isContinue);// 如果这个值为false,表示任务没有完成 if (!isContinue) { return; } // 保存 try { if (configuration.getBool("issave", false)) { excelReader.Save(); } } catch { NnMessage.ShowMessage("无法保存 请确保文件可写", true); } foreach (NnSavePath path in NnConfig._nnConfig.SavePaths) { try { excelReader.SaveAs(path.Path + Path.GetFileNameWithoutExtension(url)); } catch { NnMessage.ShowMessage($"无法保存到 {path.Path}", true); } } configuration.set("scount", scount); configuration.set("stimes", stimes + 1); configuration.save(); }
private void init(string url) { this.url = url;// 注意,这里的url在传进来之前确保是excel文件,谁要作死传其他的我不管 if (!NnReader.Instance.IsValid) { isContinue = false; return; } try { configuration = new NnConfiguration(); // 初始化excel对应列 initColumn(); } catch (Exception e) { NnMessage.ShowMessage("配置文件读取错误!"); isContinue = false; Console.WriteLine(e.ToString()); return; } if (configuration != null) { stimes = configuration.getInt("stimes", 0) ?? 0; scount = configuration.getInt("scount", 0) ?? 0; } try { excelReader = new NnExcelReader(url); excelReader.ToOpen = configuration.getBool("toopen", false); } catch (Exception e) { NnMessage.ShowMessage("无excel组件或文件错误!"); isContinue = false; Console.WriteLine(e.ToString()); return; } }