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