/// <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); }
/// <summary> /// 挂单历史查询 /// </summary> /// <param name="Lqc">查询条件</param> /// <param name="pageindex">第几页,从1开始</param> /// <param name="pagesize">每页多少条</param> /// <param name="page">输出参数(总页数)</param> /// <returns>挂单历史记录</returns> public List <LTradeHoldOrder> GetLTradeHoldOrder(LQueryCon Lqc, int pageindex, int pagesize, ref int page) { List <LTradeHoldOrder> list = new List <LTradeHoldOrder>(); System.Data.Common.DbDataReader dbreader = null; TradeUser TdUser = new TradeUser(); System.Data.Common.DbParameter OutputParam = DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@PageCount", DbParameterType.String, 0, ParameterDirection.Output); try { string userId = string.Empty; string AndStr = string.Empty; string PartSearchCondition = string.Empty; string ParentOrgID = string.Empty; if (!ComFunction.ExistUserLoginID(Lqc.LoginID, ref TdUser)) { return(list); } if (UserType.NormalType == TdUser.UType) //普通用户 { AndStr += string.Format("and userid='{0}' ", TdUser.UserID); } else { if (UserType.OrgType == TdUser.UType && !string.IsNullOrEmpty(TdUser.OrgId)) { PartSearchCondition = " and orgid in (select orgid from #tmp) "; ParentOrgID = TdUser.OrgId; } if (!string.IsNullOrEmpty(Lqc.TradeAccount)) { AndStr += string.Format(" and userid='{0}' ", ComFunction.GetUserId(Lqc.TradeAccount)); } } if ("ALL" != Lqc.ProductName.ToUpper()) { AndStr += string.Format(" and ProductName='{0}'", Lqc.ProductName); } if ("ALL" != Lqc.OrderType.ToUpper()) { AndStr += string.Format(" and ordertype='{0}'", Lqc.OrderType); } string SubSelectList = "orgname,Account,ProductName,HoldOrderID,productCode,OrderType,HoldPrice,lossPrice,profitPrice,frozenMoney,validtime,ordertime,istrade,OrderID,quantity,tradetime "; string selectlist = "orgname,Account,ProductName,HoldOrderID,productCode,OrderType,HoldPrice,lossPrice,profitPrice,frozenMoney,validtime,ordertime,istrade,OrderID,quantity,tradetime "; string SearchCondition = string.Format("where tradetime >= '{0}' and tradetime <='{1}' {2} {3} ", Lqc.StartTime.ToString("yyyy-MM-dd HH:mm:ss.fff"), Lqc.EndTime.ToString("yyyy-MM-dd HH:mm:ss.fff"), AndStr, PartSearchCondition); dbreader = DbHelper.RunProcedureGetDataReader("GetRecordFromPageEx", new System.Data.Common.DbParameter[] { DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@selectlist", DbParameterType.String, selectlist, ParameterDirection.Input), DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@SubSelectList", DbParameterType.String, SubSelectList, ParameterDirection.Input), DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@TableSource", DbParameterType.String, "V_L_Trade_HoldOrder", ParameterDirection.Input), //表名或视图表 DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@TableOrder", DbParameterType.String, "a", ParameterDirection.Input), //排序后的表名称 即子查询结果集的别名 DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@SearchCondition", DbParameterType.String, SearchCondition, ParameterDirection.Input), DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@OrderExpression", DbParameterType.String, "order by tradetime desc", ParameterDirection.Input), //排序 表达式 DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@ParentOrgID", DbParameterType.String, ParentOrgID, ParameterDirection.Input), //父级组织ID DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@PageIndex", DbParameterType.Int, pageindex, ParameterDirection.Input), DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@PageSize", DbParameterType.Int, pagesize, ParameterDirection.Input), OutputParam }); while (dbreader.Read()) { LTradeHoldOrder ltradeHoldOrder = new LTradeHoldOrder(); ltradeHoldOrder.OrgName = System.DBNull.Value != dbreader["orgname"] ? dbreader["orgname"].ToString() : string.Empty; ltradeHoldOrder.TradeAccount = System.DBNull.Value != dbreader["Account"] ? dbreader["Account"].ToString() : string.Empty; ltradeHoldOrder.HoldOrderID = System.DBNull.Value != dbreader["HoldOrderID"] ? dbreader["HoldOrderID"].ToString() : string.Empty; ltradeHoldOrder.ProductName = System.DBNull.Value != dbreader["ProductName"] ? dbreader["ProductName"].ToString() : string.Empty; ltradeHoldOrder.ProductCode = System.DBNull.Value != dbreader["productCode"] ? dbreader["productCode"].ToString() : string.Empty; ltradeHoldOrder.OrderType = System.DBNull.Value != dbreader["OrderType"] ? dbreader["OrderType"].ToString() : string.Empty; ltradeHoldOrder.HoldPrice = System.DBNull.Value != dbreader["HoldPrice"] ? Convert.ToDouble(dbreader["HoldPrice"]) : 0; ltradeHoldOrder.LossPrice = System.DBNull.Value != dbreader["lossPrice"] ? Convert.ToDouble(dbreader["lossPrice"]) : 0; ltradeHoldOrder.ProfitPrice = System.DBNull.Value != dbreader["profitPrice"] ? Convert.ToDouble(dbreader["profitPrice"]) : 0; ltradeHoldOrder.FrozenMoney = System.DBNull.Value != dbreader["frozenMoney"] ? Convert.ToDouble(dbreader["frozenMoney"]) : 0; ltradeHoldOrder.ValidTime = System.DBNull.Value != dbreader["validtime"] ? Convert.ToDateTime(dbreader["validtime"]) : DateTime.MinValue; ltradeHoldOrder.OrderTime = System.DBNull.Value != dbreader["ordertime"] ? Convert.ToDateTime(dbreader["ordertime"]) : DateTime.MinValue; ltradeHoldOrder.State = System.DBNull.Value != dbreader["istrade"] ? dbreader["istrade"].ToString() : string.Empty; ltradeHoldOrder.OrderID = System.DBNull.Value != dbreader["OrderID"] ? dbreader["OrderID"].ToString() : string.Empty; ltradeHoldOrder.Quantity = System.DBNull.Value != dbreader["quantity"] ? Convert.ToDouble(dbreader["quantity"]) : 0; ltradeHoldOrder.TradeTime = System.DBNull.Value != dbreader["tradetime"] ? Convert.ToDateTime(dbreader["tradetime"]) : DateTime.MinValue; list.Add(ltradeHoldOrder); } } catch (Exception ex) { ComFunction.WriteErr(ex); if (null != list && list.Count > 0) { list.Clear(); } } finally { if (null != dbreader) { dbreader.Close(); dbreader.Dispose(); page = Convert.ToInt32(OutputParam.Value); } } return(list); }
/// <summary> /// 资金库存信息查询 /// </summary> /// <param name="account">要被查询的账号</param> /// <param name="LoginID">登陆标识</param> /// <returns>资金库存信息</returns> public MoneyInventory GetMoneyInventoryEx(string account, string LoginID) { MoneyInventory moneyInventory = new MoneyInventory(); moneyInventory.StorageQuantity = new Storagequantity(); moneyInventory.FdInfo = new Fundinfo(); System.Data.Common.DbDataReader dbreader = null; //bool IsGetMoney = false; try { string userId = string.Empty; moneyInventory.Result = false; //查看 logid在 数据库 存在否 //if (!ComFunction.ExistUserLoginID(LoginID)) //{ // moneyInventory.Result = false; // moneyInventory.ReturnCode = ResCode.UL003; // moneyInventory.Desc = ResCode.UL003Desc; // return moneyInventory; //} userId = ComFunction.GetUserId(account); if (string.IsNullOrEmpty(userId))//如果用户不存在 { moneyInventory.Result = false; moneyInventory.ReturnCode = ResCode.UL005; moneyInventory.Desc = ResCode.UL005Desc; return(moneyInventory); } string sql = "select DongJieMoney,money,frozenMoney,OccMoney,state,CashUser,SubUser,TanUser,ConBankType,OpenBank,BankAccount,AccountName,BankCard from Trade_FundInfo where state<>'4' and userId=@userId"; 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()) { moneyInventory.FdInfo.DongJieMoney = System.DBNull.Value != dbreader["DongJieMoney"] ? Convert.ToDouble(dbreader["DongJieMoney"]) : 0; moneyInventory.FdInfo.Money = System.DBNull.Value != dbreader["money"] ? Convert.ToDouble(dbreader["money"]) : 0; moneyInventory.FdInfo.FrozenMoney = System.DBNull.Value != dbreader["frozenMoney"] ? Convert.ToDouble(dbreader["frozenMoney"]) : 0; moneyInventory.FdInfo.OccMoney = System.DBNull.Value != dbreader["OccMoney"] ? Convert.ToDouble(dbreader["OccMoney"]) : 0; moneyInventory.FdInfo.State = System.DBNull.Value != dbreader["state"] ? dbreader["state"].ToString() : string.Empty; moneyInventory.FdInfo.CashUser = System.DBNull.Value != dbreader["CashUser"] ? dbreader["CashUser"].ToString() : string.Empty; moneyInventory.FdInfo.SubUser = System.DBNull.Value != dbreader["SubUser"] ? dbreader["SubUser"].ToString() : string.Empty; moneyInventory.FdInfo.TanUser = System.DBNull.Value != dbreader["TanUser"] ? dbreader["TanUser"].ToString() : string.Empty; moneyInventory.FdInfo.ConBankType = System.DBNull.Value != dbreader["ConBankType"] ? dbreader["ConBankType"].ToString() : string.Empty; moneyInventory.FdInfo.OpenBank = System.DBNull.Value != dbreader["OpenBank"] ? dbreader["OpenBank"].ToString() : string.Empty; moneyInventory.FdInfo.BankAccount = System.DBNull.Value != dbreader["BankAccount"] ? dbreader["BankAccount"].ToString() : string.Empty; moneyInventory.FdInfo.AccountName = System.DBNull.Value != dbreader["AccountName"] ? dbreader["AccountName"].ToString() : string.Empty; moneyInventory.FdInfo.BankCard = System.DBNull.Value != dbreader["BankCard"] ? dbreader["BankCard"].ToString() : string.Empty; //IsGetMoney = true; break; } //if (!IsGetMoney) //{ // return moneyInventory; //} //查询 库存 dbreader.Close(); //sqlcmd.CommandText = "select au,ag,pt,pd from Stock_BZJ where userId=@userId "; //sqldr = sqlcmd.ExecuteReader(); //if (sqldr.Read()) //{ // moneyInventory.StorageQuantity.xau = System.DBNull.Value != sqldr["au"] ? Convert.ToDouble(sqldr["au"]) : 0; // moneyInventory.StorageQuantity.xag = System.DBNull.Value != sqldr["ag"] ? Convert.ToDouble(sqldr["ag"]) : 0; // moneyInventory.StorageQuantity.xpt = System.DBNull.Value != sqldr["pt"] ? Convert.ToDouble(sqldr["pt"]) : 0; // moneyInventory.StorageQuantity.xpd = System.DBNull.Value != sqldr["pd"] ? Convert.ToDouble(sqldr["pd"]) : 0; //} moneyInventory.Result = true; } catch (Exception ex) { ComFunction.WriteErr(ex); moneyInventory.Result = false; } finally { if (null != dbreader) { dbreader.Close(); dbreader.Dispose(); } } return(moneyInventory); }