private 券商 GetPageEntity() { var o = new Entity.券商(); o.IP = this.txtIP.Text; o.Port = short.Parse(this.txtPort.Text); o.版本号 = this.txt版本号.Text; o.登录帐号 = this.txt登录帐号.Text; o.交易服务器 = this.txt交易服务器.Text; o.交易密码 = this.txt交易密码.Text.Trim(); o.交易帐号 = this.txt交易帐号.Text; o.称 = this.txt名称.Text; o.启用 = this.ckIsEnable.IsChecked == true; o.通讯密码 = this.txt通讯密码.Text.Trim(); if (ckbIsEncrypcy.IsChecked != true) { o.交易密码 = Cryptor.MD5Encrypt(this.txt交易密码.Text.Trim()); o.通讯密码 = Cryptor.MD5Encrypt(this.txt通讯密码.Text.Trim()); } if (o.通讯密码 == "") { o.通讯密码 = Cryptor.MD5Encrypt(o.通讯密码); } o.营业部代码 = short.Parse(this.txt营业部代码.Text); return(o); }
private static bool SaveGroupDelivery(Entity.券商 groupItem, DateTime date) { var saveResult = false; var data = DataHelper.QueryHisDelivery(date, date, groupItem); if (data != null) { if (data.Rows.Count > 0) { DataHelper.StandardDeliveryDataTable(data, date); using (var db = new DataComparisionDataset()) { var oldData = db.交割单ds.Where(_ => _.交割日期 == date && _.组合号 == groupItem.称); if (oldData.Count() > 0) { db.交割单ds.RemoveRange(oldData); db.SaveChanges(); } } saveResult = DataHelper.WriteToDB(data, "交割单"); } else { saveResult = true; } } return(saveResult); }
private void Button_FileImport_Click(object sender, RoutedEventArgs e) { OpenFileDialog dialog = new OpenFileDialog() { CheckFileExists = true, Multiselect = false, Filter = "文本文件|*.txt" }; if (true == dialog.ShowDialog()) { try { var arr = File.ReadAllLines(dialog.FileName); List <Entity.券商> listImport = new List <券商>(); foreach (var item in arr) { if (item.StartsWith("名称") || string.IsNullOrWhiteSpace(item)) { continue; } var info = item.Split(new[] { ',', '\t' }); var o = new Entity.券商() { 称 = info[0], 启用 = bool.Parse(info[1]), 交易服务器 = info[2], IP = info[3], Port = short.Parse(info[4]), 版本号 = info[5], 营业部代码 = short.Parse(info[6]), 登录帐号 = info[7], 交易帐号 = info[8], 交易密码 = info[9], }; if (info.Length >= 11) { o.通讯密码 = info[10]; } listImport.Add(o); } if (listImport.Count > 0) { using (var db = new DataComparisionDataset()) { var listName = listImport.Select(_ => _.称); var old = db.券商ds.Where(_ => listName.Contains(_.称)).ToList(); if (old.Count > 0) { db.券商ds.RemoveRange(old); } db.券商ds.AddRange(listImport); db.SaveChanges(); MessageBox.Show(string.Format("导入完成,导入{0}个券商信息,覆盖{1}个,新增{2}个!", listImport.Count, old.Count, listImport.Count - old.Count)); } Init(); } else { MessageBox.Show("导入失败!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }