/// <summary> /// 创建新的 TRANS_DETAIL 对象。 /// </summary> /// <param name="tRANS_ID">TRANS_ID 属性的初始值。</param> /// <param name="sTRATEGY_CODE">STRATEGY_CODE 属性的初始值。</param> /// <param name="sTOCK_CODE">STOCK_CODE 属性的初始值。</param> /// <param name="tRANS_DATETIME">TRANS_DATETIME 属性的初始值。</param> /// <param name="tRANS_DIRECTION">TRANS_DIRECTION 属性的初始值。</param> /// <param name="tRANS_TYPE">TRANS_TYPE 属性的初始值。</param> /// <param name="tRANS_VOLUME">TRANS_VOLUME 属性的初始值。</param> /// <param name="tRANS_PRICE">TRANS_PRICE 属性的初始值。</param> public static TRANS_DETAIL CreateTRANS_DETAIL(global::System.Int32 tRANS_ID, global::System.String sTRATEGY_CODE, global::System.String sTOCK_CODE, global::System.DateTime tRANS_DATETIME, global::System.String tRANS_DIRECTION, global::System.String tRANS_TYPE, global::System.Int32 tRANS_VOLUME, global::System.Decimal tRANS_PRICE) { TRANS_DETAIL tRANS_DETAIL = new TRANS_DETAIL(); tRANS_DETAIL.TRANS_ID = tRANS_ID; tRANS_DETAIL.STRATEGY_CODE = sTRATEGY_CODE; tRANS_DETAIL.STOCK_CODE = sTOCK_CODE; tRANS_DETAIL.TRANS_DATETIME = tRANS_DATETIME; tRANS_DETAIL.TRANS_DIRECTION = tRANS_DIRECTION; tRANS_DETAIL.TRANS_TYPE = tRANS_TYPE; tRANS_DETAIL.TRANS_VOLUME = tRANS_VOLUME; tRANS_DETAIL.TRANS_PRICE = tRANS_PRICE; return(tRANS_DETAIL); }
/// <summary> /// 用于向 TRANS_DETAILS EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToTRANS_DETAILS(TRANS_DETAIL tRANS_DETAIL) { base.AddObject("TRANS_DETAILS", tRANS_DETAIL); }
public static void DoTest() { Console.WriteLine("测试 Model First 的处理代码!"); using (ModelFirstContainer context = new ModelFirstContainer()) { // 新建股票. STOCK stock = new STOCK() { // 股票代码. STOCK_CODE = "IF1208", // 股票名称. STOCK_NAME = "沪深08(IF1208)", }; // 插入数据. context.STOCKS.AddObject(stock); // 新建策略. STRATEGY straegy = new STRATEGY() { // 策略代码. STRATEGY_CODE = "A", // 策略名. STRATEGY_NAME = "测试A", // 策略描述 STRATEGY_DESC = "Just For Test", }; // 插入数据. context.STRATEGYS.AddObject(straegy); // 新建交易记录. TRANS_DETAIL transDetail1 = new TRANS_DETAIL() { // 策略代码. STRATEGY_CODE = "A", // 股票代码. STOCK_CODE = "IF1208", // 成交日时. TRANS_DATETIME = new DateTime(2012,7,19,9,40,59), // 成交方向: 买入 TRANS_DIRECTION = "B", // 成交类型: 开仓 TRANS_TYPE = "O", // 成交数量 TRANS_VOLUME = 2, // 成交价位 TRANS_PRICE = 2426.4M, }; TRANS_DETAIL transDetail2 = new TRANS_DETAIL() { // 策略代码. STRATEGY_CODE = "A", // 股票代码. STOCK_CODE = "IF1208", // 成交日时. TRANS_DATETIME = new DateTime(2012, 7, 19, 10, 00, 59), // 成交方向: 卖出 TRANS_DIRECTION = "S", // 成交类型: 平仓 TRANS_TYPE = "C", // 成交数量 TRANS_VOLUME = 2, // 成交价位 TRANS_PRICE = 2426.6M, }; context.TRANS_DETAILS.AddObject(transDetail1); context.TRANS_DETAILS.AddObject(transDetail2); // 保存更改. context.SaveChanges(); } Console.WriteLine("测试 Model First 处理 完毕,请自行到数据库查询数据,并根据需要删除数据!"); }
/// <summary> /// 创建新的 TRANS_DETAIL 对象。 /// </summary> /// <param name="tRANS_ID">TRANS_ID 属性的初始值。</param> /// <param name="sTRATEGY_CODE">STRATEGY_CODE 属性的初始值。</param> /// <param name="sTOCK_CODE">STOCK_CODE 属性的初始值。</param> /// <param name="tRANS_DATETIME">TRANS_DATETIME 属性的初始值。</param> /// <param name="tRANS_DIRECTION">TRANS_DIRECTION 属性的初始值。</param> /// <param name="tRANS_TYPE">TRANS_TYPE 属性的初始值。</param> /// <param name="tRANS_VOLUME">TRANS_VOLUME 属性的初始值。</param> /// <param name="tRANS_PRICE">TRANS_PRICE 属性的初始值。</param> public static TRANS_DETAIL CreateTRANS_DETAIL(global::System.Int32 tRANS_ID, global::System.String sTRATEGY_CODE, global::System.String sTOCK_CODE, global::System.DateTime tRANS_DATETIME, global::System.String tRANS_DIRECTION, global::System.String tRANS_TYPE, global::System.Int32 tRANS_VOLUME, global::System.Decimal tRANS_PRICE) { TRANS_DETAIL tRANS_DETAIL = new TRANS_DETAIL(); tRANS_DETAIL.TRANS_ID = tRANS_ID; tRANS_DETAIL.STRATEGY_CODE = sTRATEGY_CODE; tRANS_DETAIL.STOCK_CODE = sTOCK_CODE; tRANS_DETAIL.TRANS_DATETIME = tRANS_DATETIME; tRANS_DETAIL.TRANS_DIRECTION = tRANS_DIRECTION; tRANS_DETAIL.TRANS_TYPE = tRANS_TYPE; tRANS_DETAIL.TRANS_VOLUME = tRANS_VOLUME; tRANS_DETAIL.TRANS_PRICE = tRANS_PRICE; return tRANS_DETAIL; }
public static void DoTest() { Console.WriteLine("测试 Model First 的处理代码!"); using (ModelFirstContainer context = new ModelFirstContainer()) { // 新建股票. STOCK stock = new STOCK() { // 股票代码. STOCK_CODE = "IF1208", // 股票名称. STOCK_NAME = "沪深08(IF1208)", }; // 插入数据. context.STOCKS.AddObject(stock); // 新建策略. STRATEGY straegy = new STRATEGY() { // 策略代码. STRATEGY_CODE = "A", // 策略名. STRATEGY_NAME = "测试A", // 策略描述 STRATEGY_DESC = "Just For Test", }; // 插入数据. context.STRATEGYS.AddObject(straegy); // 新建交易记录. TRANS_DETAIL transDetail1 = new TRANS_DETAIL() { // 策略代码. STRATEGY_CODE = "A", // 股票代码. STOCK_CODE = "IF1208", // 成交日时. TRANS_DATETIME = new DateTime(2012, 7, 19, 9, 40, 59), // 成交方向: 买入 TRANS_DIRECTION = "B", // 成交类型: 开仓 TRANS_TYPE = "O", // 成交数量 TRANS_VOLUME = 2, // 成交价位 TRANS_PRICE = 2426.4M, }; TRANS_DETAIL transDetail2 = new TRANS_DETAIL() { // 策略代码. STRATEGY_CODE = "A", // 股票代码. STOCK_CODE = "IF1208", // 成交日时. TRANS_DATETIME = new DateTime(2012, 7, 19, 10, 00, 59), // 成交方向: 卖出 TRANS_DIRECTION = "S", // 成交类型: 平仓 TRANS_TYPE = "C", // 成交数量 TRANS_VOLUME = 2, // 成交价位 TRANS_PRICE = 2426.6M, }; context.TRANS_DETAILS.AddObject(transDetail1); context.TRANS_DETAILS.AddObject(transDetail2); // 保存更改. context.SaveChanges(); } Console.WriteLine("测试 Model First 处理 完毕,请自行到数据库查询数据,并根据需要删除数据!"); }