internal static PendingOrderData ToPendingOrderData(TradeHoldOrder order)
{
return(new PendingOrderData
{
OrderQuantity = order.Quantity,
FrozenDeposit = order.FrozenMoney,
ProductCode = order.ProductCode,
ProductName = order.ProductName,
OrderID = order.HoldOrderID,
OrderPrice = order.HoldPrice,
OrderTime = order.OrderTime,
OrderType = (TRANSACTION_TYPE)Enum.Parse(typeof(TRANSACTION_TYPE), order.OrderType),
StopLoss = order.LossPrice,
StopProfit = order.ProfitPrice,
DueDate = order.ValidTime
});
}
internal static PendingOrderData ToPendingOrderData(TradeHoldOrder order)
{
return new PendingOrderData
{
OrderQuantity = order.Quantity,
FrozenDeposit = order.FrozenMoney,
ProductCode = order.ProductCode,
ProductName = order.ProductName,
OrderID = order.HoldOrderID,
OrderPrice = order.HoldPrice,
OrderTime = order.OrderTime,
OrderType = (TRANSACTION_TYPE)Enum.Parse(typeof(TRANSACTION_TYPE), order.OrderType),
StopLoss = order.LossPrice,
StopProfit = order.ProfitPrice,
DueDate = order.ValidTime
};
}
/// <summary>
/// 挂单查询
/// </summary>
/// <param name="account">被查询的账号</param>
/// <param name="LoginID">登陆标识</param>
/// <returns>挂单记录</returns>
public List <TradeHoldOrder> GetTradeHoldOrderEx(string account, string LoginID)
{
List <TradeHoldOrder> list = new List <TradeHoldOrder>();
System.Data.Common.DbDataReader dbreader = null;
try
{
string userId = string.Empty;
if (!ComFunction.ExistUserLoginID(LoginID))
{
return(list);
}
userId = ComFunction.GetUserId(account);
if (string.IsNullOrEmpty(userId))//如果用户不存在
{
return(list);
}
string sql = "select c.account, a.HoldOrderID,b.ProductName, a.productcode,a.quantity,a.frozenMoney,a.OrderType,a.HoldPrice,a.profitPrice,a.lossPrice,a.validtime,a.ordertime " +
"from Trade_HoldOrder a,Trade_Product b,base_user c where a.userId=@userId and a.productcode=b.productcode and c.userid=a.userid and c.status='1' order by a.ordertime desc";
dbreader = DbHelper.ExecuteReader(sql,
new System.Data.Common.DbParameter[] { DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@userId", DbParameterType.String, userId, ParameterDirection.Input) });
while (dbreader.Read())
{
TradeHoldOrder thdr = new TradeHoldOrder();
thdr.TradeAccount = dbreader["account"].ToString();
thdr.HoldOrderID = dbreader["HoldOrderID"].ToString();
thdr.ProductName = dbreader["ProductName"].ToString();
thdr.ProductCode = dbreader["productcode"].ToString();
thdr.Quantity = Convert.ToDouble(dbreader["quantity"]);
thdr.FrozenMoney = Convert.ToDouble(dbreader["frozenMoney"]);
thdr.OrderType = dbreader["OrderType"].ToString();
thdr.HoldPrice = Convert.ToDouble(dbreader["HoldPrice"]);
thdr.ProfitPrice = Convert.ToDouble(dbreader["profitPrice"]);
thdr.LossPrice = Convert.ToDouble(dbreader["lossPrice"]);
thdr.ValidTime = Convert.ToDateTime(dbreader["validtime"]);
thdr.OrderTime = Convert.ToDateTime(dbreader["Ordertime"]);
list.Add(thdr);
}
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
if (null != list && list.Count > 0)
{
list.Clear();
}
}
finally
{
if (null != dbreader)
{
dbreader.Close();
dbreader.Dispose();
}
}
return(list);
}
