/// <summary>
/// 尝试数据库的访问和修改
/// </summary>
public static void CheckDB()
{
MoneyEntityEntities1 DbEntity = new MoneyEntityEntities1();
SG_TAOLI_OPEN_TABLE record = new SG_TAOLI_OPEN_TABLE()
{
SG_GUID = Guid.NewGuid(),
SG_ID = "Test",
SG_Contract = "test",
SG_OP_POINT = 0,
SG_HAND_NUM = 0,
SG_INDEX = 0,
SG_WEIGHT_LIST = "test",
SG_INIT_TRADE_LIST = "test",
SG_STATUS = 0,
SG_CREATE_TIME = DateTime.Now,
SG_LATEST_TRADE_LIST = "test",
SG_USER = "******",
};
DbEntity.SG_TAOLI_OPEN_TABLE.Add(record);
DbEntity.SaveChanges();
Thread.Sleep(10);
var _selectedItem = (from item in DbEntity.SG_TAOLI_OPEN_TABLE where item.SG_ID == "Test" select item);
DbEntity.SG_TAOLI_OPEN_TABLE.Remove((SG_TAOLI_OPEN_TABLE)_selectedItem.ToList()[0]);
DbEntity.SaveChanges();
Thread.Sleep(10);
SG_TAOLI_CLOSE_TABLE item2 = new SG_TAOLI_CLOSE_TABLE()
{
SG_GUID = Guid.NewGuid(),
SG_ID = "test",
SG_OPEN_ID = "test",
SG_INIT_POSITION_LIST = "test",
SG_LATEST_POSITION_LIST = "test",
SG_FUTURE_CONTRACT = "test",
SG_SHORT_POINT = 0,
SG_HAND = 0,
SG_COE = 0,
SG_SD = 0,
SG_SA = 0,
SG_PE = 0,
SG_BAS = 0,
SG_STATUS = 0,
SG_CREATE_TIME = DateTime.Now,
SG_USER = "******"
};
DbEntity.SG_TAOLI_CLOSE_TABLE.Add(item2);
DbEntity.SaveChanges();
var _selectedItem2 = (from item in DbEntity.SG_TAOLI_CLOSE_TABLE where item.SG_ID == "test" && item.SG_STATUS == 0 select item);
DbEntity.SG_TAOLI_CLOSE_TABLE.Remove(_selectedItem2.ToList()[0]);
DbEntity.SaveChanges();
SG_TAOLI_STATUS_TABLE item3 = new SG_TAOLI_STATUS_TABLE()
{
SG_GUID = Guid.NewGuid(),
SG_ID = "test",
SG_STATUS = 0,
SG_UPDATE_TIME = DateTime.Now
};
DbEntity.SG_TAOLI_STATUS_TABLE.Add(item3);
DbEntity.SaveChanges();
var _selectedItem3 = (from item in DbEntity.SG_TAOLI_STATUS_TABLE where item.SG_ID == "test" select item);
DbEntity.SG_TAOLI_STATUS_TABLE.Remove(_selectedItem3.ToList()[0]);
DbEntity.SaveChanges();
Thread.Sleep(10);
OL_TAOLI_LIST_TABLE item4 = new OL_TAOLI_LIST_TABLE()
{
OL_GUID = Guid.NewGuid(),
SG_ID = "test",
OL_LIST = "test",
OL_TIME = DateTime.Now
};
DbEntity.OL_TAOLI_LIST_TABLE.Add(item4);
DbEntity.SaveChanges();
Thread.Sleep(10);
var selected4 = (from item in DbEntity.OL_TAOLI_LIST_TABLE where item.SG_ID == "test" select item);
DbEntity.OL_TAOLI_LIST_TABLE.Remove(selected4.ToList()[0]);
DbEntity.SaveChanges();
Thread.Sleep(10);
ER_TAOLI_TABLE record5 = new ER_TAOLI_TABLE()
{
ER_GUID = Guid.NewGuid(),
ER_ID = "test",
//ER_STRATEGY = entrust.StrategyId,
ER_ORDER_TYPE = "test",
ER_ORDER_EXCHANGE_ID = "test",
//ER_CODE = entrust.Code,
//ER_DIRECTION = entrust.Direction
};
DbEntity.ER_TAOLI_TABLE.Add(record5);
DbEntity.SaveChanges();
Thread.Sleep(10);
var selected5 = (from item in DbEntity.ER_TAOLI_TABLE where item.ER_ID == "test" select item);
DbEntity.ER_TAOLI_TABLE.Remove(selected5.ToList()[0]);
DbEntity.SaveChanges();
Thread.Sleep(10);
DL_TAOLI_TABLE item6 = new DL_TAOLI_TABLE()
{
DL_GUID = Guid.NewGuid(),
DL_STRATEGY = "test",
DL_DIRECTION = 0,
DL_CODE = "test",
DL_NAME = "test",
DL_STATUS = "test",
DL_TYPE = "test",
DL_STOCK_AMOUNT = 0,
DL_BARGAIN_PRICE = 0,
DL_BARGAIN_MONEY = 0,
DL_BARGAIN_TIME = "test",
DL_NO = "test",
DL_LOAD = true
};
DbEntity.DL_TAOLI_TABLE.Add(item6);
DbEntity.SaveChanges();
Thread.Sleep(10);
var _selecteditem6 = (from item in DbEntity.DL_TAOLI_TABLE where item.DL_STRATEGY == "test" select item);
DbEntity.DL_TAOLI_TABLE.Remove(_selecteditem6.ToList()[0]);
DbEntity.SaveChanges();
Thread.Sleep(10);
CC_TAOLI_TABLE item7 = new CC_TAOLI_TABLE()
{
CC_CODE = "test",
CC_TYPE = "test",
CC_AMOUNT = 0,
CC_BUY_PRICE = 0,
CC_USER = "******"
};
DbEntity.CC_TAOLI_TABLE.Add(item7);
DbEntity.SaveChanges();
Thread.Sleep(10);
var _selecteditem7 = (from item in DbEntity.CC_TAOLI_TABLE where item.CC_CODE == "test" select item);
DbEntity.CC_TAOLI_TABLE.Remove(_selecteditem7.ToList()[0]);
DbEntity.SaveChanges();
}
/// <summary>
/// 单笔成交查询回报更新持仓文件
/// </summary>
/// <param name="v"></param>
public static void UpdateCCRecords(object v)
{
if (DBAccessLayer.DBEnable == false) { return; }
managedBargainreturnstruct bargin = (managedBargainreturnstruct)v;
if(bargin == null)
{
return;
}
string code = bargin.Security_code;
string type = bargin.OrderType.ToString();
int amount = bargin.stock_amount;
double price = bargin.bargain_price;
int direction = bargin.direction;
string user = string.Empty;
string strategy = bargin.strategyId;
var sg_open_li = (from item in DbEntity.SG_TAOLI_OPEN_TABLE where item.SG_ID == bargin.strategyId && item.SG_STATUS == 0 select item);
var sg_close_li = (from item in DbEntity.SG_TAOLI_CLOSE_TABLE where item.SG_ID == bargin.strategyId && item.SG_STATUS == 0 select item);
if(sg_open_li.Count() == 0 && sg_close_li.Count() == 0)
{
GlobalErrorLog.LogInstance.LogEvent("策略不存在--策略：" + bargin.strategyId + "， 当前交易代码：" + code + ", 买入：" + amount + "， 价格：" + price);
return;
}
if(sg_close_li.Count()!=0)
{
user = sg_close_li.ToList()[0].SG_USER;
}
else
{
user = sg_open_li.ToList()[0].SG_USER;
}
var selectedrecord = (from item in DbEntity.CC_TAOLI_TABLE where item.CC_CODE == code && item.CC_TYPE == type && item.CC_USER == user select item);
if(selectedrecord.Count() == 0)
{
//说明数据库中不存在当前票券的持仓
if (direction == (int)TradeDirection.Buy)
{
CC_TAOLI_TABLE record = new CC_TAOLI_TABLE()
{
CC_CODE = code,
CC_TYPE = type,
CC_AMOUNT = amount,
CC_BUY_PRICE = price,
CC_USER = user
};
DbEntity.CC_TAOLI_TABLE.Add(record);
Dbsavechage("UpdateCCRecords");
return;
}
else
{
//不可能持仓列表是负值，肯定有问题
GlobalErrorLog.LogInstance.LogEvent("对空仓卖出--策略：" + bargin.strategyId + "， 当前交易代码：" + code + ", 买入：" + amount + "， 价格：" + price);
return;
}
}
else
{
var record = selectedrecord.ToList()[0];
int? db_amount = record.CC_AMOUNT;
double? db_price = record.CC_BUY_PRICE;
if (db_amount == null || db_price == null)
{ return; }
//对该券有仓位
if(direction == (int)TradeDirection.Buy)
{
record.CC_BUY_PRICE = (db_amount * db_price + amount * price) / (db_amount + amount);
record.CC_AMOUNT = db_amount + amount;
Dbsavechage("UpdateCCRecords");
}
else
{
if (db_amount < amount)
{
GlobalErrorLog.LogInstance.LogEvent("持仓小于卖出--策略：" + bargin.strategyId + "， 当前交易代码：" + code + ", 买入：" + amount + "， 价格：" + price);
return;
}
else
{
record.CC_BUY_PRICE = (db_amount * db_price - amount * price) / (db_amount - amount);
record.CC_AMOUNT = db_amount - amount;
Dbsavechage("UpdateCCRecords");
return;
}
}
}
}