protected JsmxRow_SZ GetJsmxRow_SZ(DbDataReader reader) { JsmxRow_SZ row = new JsmxRow_SZ(); row.MXJSZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSZH))); row.MXBFZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBFZH))); row.MXSJLX = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSJLX))); row.MXYWLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLB))); row.MXZQDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM))); row.MXJYDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYDY))); row.MXTGDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY))); row.MXZQZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZH))); row.MXDDBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH))); row.MXYYB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYYB))); row.MXZXBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZXBH))); row.MXYWLSH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLSH))); row.MXCJSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJSL))); row.MXQSSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSSL))); row.MXCJJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJJG))); row.MXQSJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSJG))); row.MXXYJY = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXXYJY))); row.MXPCBS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPCBS))); row.MXZQLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQLB))); row.MXZQZL = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZL))); row.MXGFXZ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGFXZ))); row.MXJSFS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSFS))); row.MXHBDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXHBDH))); row.MXQSBJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSBJ))); row.MXYHS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYHS))); row.MXJYJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYJSF))); row.MXJGGF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJGGF))); row.MXGHF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGHF))); row.MXJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSF))); row.MXSXF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSXF))); row.MXQSYJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSYJ))); row.MXQTFY = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTFY))); row.MXZJJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZJJE))); row.MXSFJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSFJE))); row.MXCJRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJRQ))); row.MXQSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSRQ))); row.MXJSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSRQ))); row.MXFSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFSRQ))); row.MXQTRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTRQ))); row.MXSCDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSCDM))); row.MXJYFS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYFS))); row.MXZQDM2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM2))); row.MXTGDY2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY2))); row.MXDDBH2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH2))); row.MXCWDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCWDH))); row.MXPPHM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPPHM))); row.MXFJSM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFJSM))); row.MXBYBZ = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBYBZ))); return row; }
/// <summary> /// 获取多头空头状态; /// 0=多头;1=空头 /// </summary> private int GetSideFlag(JsmxRow_SZ row) { if (row.MXQSSL > 0) return 0; else return 1; }
public int GetDirection(JsmxRow_SZ row) { if (row.MXQSSL > 0) return DirectionCoding.GetDirectionCode(TradeType.TRADE_BUY); else return DirectionCoding.GetDirectionCode(TradeType.TRADE_SELL); }
public EEntrustType GetEntrustType(JsmxRow_SZ row) { if (row.MXQSSL >= 0) return EEntrustType.买入; else return EEntrustType.卖出; }
protected TradeRow GetTradeRow(JsmxRow_SZ row) { TradeRow data = new TradeRow(); // 02、成交日期:成交日期; data.Trade_Date = string.Empty; // 03、成交ID:可能为订单编号/申请单号、执行编号,对于其他渠道申请的委托,执行编号可能为空; data.Trade_Id = string.Empty; // 04、证券代码:深交所证券代码需要添加后缀".SZ"; data.Security_Id = this.ConvertSecurityId(row.MXZQDM); // 05、方向标志位: data.Direction = this.GetDirection(row); // 06、数量:数量暂时以成交数量为准; data.Volume = row.MXCJSL; // 07、合约乘数: data.Multiplier = 1; // 08、多头空头; data.Side = this.GetSideFlag(row); // 09、价格: data.Price = row.MXCJJG; // 10、金额: data.Balance = row.MXQSBJ; // 11、成交类型:9:30之前为集合竞价;9:30之后为连续竞价;默认为2; data.Trade_Type = 2; // 12、基金代码或内部融券标志位; data.Source_Type = 2; // 13、基金代码/账户信息; data.Source = row.MXZQZH; // 14、成交额: data.Turn_Over = data.Balance; // 15、前置编号; data.Front_Id = 0; // 16、回话编号; data.Session_Id = 0; // 17、本地委托编号; data.Local_Order_Id = string.Empty; // 18、项目代码; data.Xmdm = 0; // 19、资产单元; data.Zcdy = string.Empty; // 20、组合代码; data.Zhdm = string.Empty; // 21、策略号; data.Policy_Id = 0; // 22、委托日期:没有托管日期; data.Order_Date = string.Empty; // 23、委托编号:对应于结算明细表中的订单编号; data.Order_Id = string.Empty; // 24、交易通道: data.Trade_Route = string.Empty; // 25、经纪商席位代码; data.Seat_Id = string.Empty; // 26、投资者客户代码; data.Client_Id = string.Empty; // 27、系统成交日期; data.Sys_Trade_Date = row.MXCJRQ; // 28、系统成交结算编号; data.Sys_Trade_Settlement_Id = 0; // 29、系统成交ID:同成交ID,清算表中的数据均为系统生成的,但是在成交表中需要的是成交ID,所以将成交信息与系统成交信息设为相同的数据; data.Sys_Trade_Id = row.MXYWLSH; // 30、系统委托日期与系统成交日期为同一天; data.Sys_Order_Date = row.MXCJRQ; // 31、系统委托结算编号: data.Sys_Order_Settlement_Id = 0; // 32、系统委托日期; data.Sys_Order_Id = row.MXDDBH; // 33、成交时间:清算表中没有与时间相关的字段; data.Trade_Time = string.Empty; return data; }