/// <summary> /// 根据用户ID获取库存信息 /// </summary> /// <param name="userId">用户ID</param> /// <returns>库存信息</returns> public static MoneyInventory GetMoneyInventoryByUserId(string userId) { MoneyInventory moneyInventory = new MoneyInventory(); moneyInventory.StorageQuantity = new Storagequantity(); moneyInventory.FdInfo = new Fundinfo(); SqlConnection sqlconn = null; SqlCommand sqlcmd = null; SqlDataReader sqldr = null; try { moneyInventory.Result = false; bool IsGetMoney = false; sqlconn = new SqlConnection(SqlConnectionString); sqlconn.Open(); sqlcmd = sqlconn.CreateCommand(); sqlcmd.CommandText = "select DongJieMoney,money,frozenMoney,OccMoney,state,CashUser,SubUser,TanUser,ConBankType,OpenBank,BankAccount,AccountName,BankCard from Trade_FundInfo where state<>'4' and userId=@userId"; SqlParameter lh = new SqlParameter(); lh.ParameterName = "@userId"; lh.DbType = DbType.String; lh.Value = userId; sqlcmd.Parameters.Add(lh); sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { moneyInventory.FdInfo.DongJieMoney = System.DBNull.Value != sqldr["DongJieMoney"] ? Convert.ToDouble(sqldr["DongJieMoney"]) : 0; moneyInventory.FdInfo.Money = System.DBNull.Value != sqldr["money"] ? Convert.ToDouble(sqldr["money"]) : 0; moneyInventory.FdInfo.FrozenMoney = System.DBNull.Value != sqldr["frozenMoney"] ? Convert.ToDouble(sqldr["frozenMoney"]) : 0; moneyInventory.FdInfo.OccMoney = System.DBNull.Value != sqldr["OccMoney"] ? Convert.ToDouble(sqldr["OccMoney"]) : 0; moneyInventory.FdInfo.State = System.DBNull.Value != sqldr["state"] ? sqldr["state"].ToString() : string.Empty; moneyInventory.FdInfo.CashUser = System.DBNull.Value != sqldr["CashUser"] ? sqldr["CashUser"].ToString() : string.Empty; moneyInventory.FdInfo.SubUser = System.DBNull.Value != sqldr["SubUser"] ? sqldr["SubUser"].ToString() : string.Empty; moneyInventory.FdInfo.TanUser = System.DBNull.Value != sqldr["TanUser"] ? sqldr["TanUser"].ToString() : string.Empty; moneyInventory.FdInfo.ConBankType = System.DBNull.Value != sqldr["ConBankType"] ? sqldr["ConBankType"].ToString() : string.Empty; moneyInventory.FdInfo.OpenBank = System.DBNull.Value != sqldr["OpenBank"] ? sqldr["OpenBank"].ToString() : string.Empty; moneyInventory.FdInfo.BankAccount = System.DBNull.Value != sqldr["BankAccount"] ? sqldr["BankAccount"].ToString() : string.Empty; moneyInventory.FdInfo.AccountName = System.DBNull.Value != sqldr["AccountName"] ? sqldr["AccountName"].ToString() : string.Empty; moneyInventory.FdInfo.BankCard = System.DBNull.Value != sqldr["BankCard"] ? sqldr["BankCard"].ToString() : string.Empty; IsGetMoney = true; break; } ////没有获取资金 //if (!IsGetMoney) //{ // return moneyInventory; //} ////查询 库存 //sqldr.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; //} } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { if (null != sqlconn) { sqlconn.Close(); } if (null != sqldr) { sqldr.Close(); } } moneyInventory.Result = true; return moneyInventory; }
/// <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; }