public static void GetTradeJuJianList(JJQueryCon JJqc, string ParentOrgID, ref TradeJuJianInfo TdInfo)
{
System.Data.Common.DbDataReader dbreader = null;
try
{
string orgname = string.Empty;
if (!string.IsNullOrEmpty(JJqc.OrgName))
{
orgname = JJqc.OrgName;
}
dbreader = DbHelper.RunProcedureGetDataReader("GetJujianDataEx",
new System.Data.Common.DbParameter[]{
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ParentOrgID",DbParameterType.String,ParentOrgID,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@OrgID",DbParameterType.String,orgname,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@StartTime",DbParameterType.String,JJqc.StartTime.ToString("yyyy-MM-dd"),ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@EndTime",DbParameterType.String,JJqc.EndTime.ToString("yyyy-MM-dd"),ParameterDirection.Input)});
while (dbreader.Read())
{
TradeJuJian tdjj = new TradeJuJian();
tdjj.OrgName = System.DBNull.Value != dbreader["orgname"] ? dbreader["orgname"].ToString() : string.Empty;
tdjj.qichu = System.DBNull.Value != dbreader["qichu"] ? Convert.ToDouble(dbreader["qichu"]) : 0;
tdjj.qimo = System.DBNull.Value != dbreader["qimo"] ? Convert.ToDouble(dbreader["qimo"]) : 0;
tdjj.rujin = System.DBNull.Value != dbreader["rujin"] ? Convert.ToDouble(dbreader["rujin"]) : 0;
tdjj.chujin = System.DBNull.Value != dbreader["chujin"] ? Convert.ToDouble(dbreader["chujin"]) : 0;
tdjj.Manual_rujin = System.DBNull.Value != dbreader["manual_rujin"] ? Convert.ToDouble(dbreader["manual_rujin"]) : 0;
tdjj.Manual_chujin = System.DBNull.Value != dbreader["manual_chujin"] ? Convert.ToDouble(dbreader["manual_chujin"]) : 0;
tdjj.Money = System.DBNull.Value != dbreader["money"] ? Convert.ToDouble(dbreader["money"]) : 0;
tdjj.Hisyingkui = System.DBNull.Value != dbreader["hisyingkui"] ? Convert.ToDouble(dbreader["hisyingkui"]) : 0;
tdjj.tradefee = System.DBNull.Value != dbreader["tradefee"] ? Convert.ToDouble(dbreader["tradefee"]) : 0;
tdjj.storagefee = System.DBNull.Value != dbreader["storagefee"] ? Convert.ToDouble(dbreader["storagefee"]) : 0;
tdjj.KC_Copper_20t_Num = System.DBNull.Value != dbreader["KC_Copper_20t_Num"] ? Convert.ToDouble(dbreader["KC_Copper_20t_Num"]) : 0;
tdjj.KC_Copper_50t_Num = System.DBNull.Value != dbreader["KC_Copper_50t_Num"] ? Convert.ToDouble(dbreader["KC_Copper_50t_Num"]) : 0;
tdjj.KC_UKOil_100_Num = System.DBNull.Value != dbreader["KC_UKOil_100_Num"] ? Convert.ToDouble(dbreader["KC_UKOil_100_Num"]) : 0;
tdjj.KC_UKOil_20_Num = System.DBNull.Value != dbreader["KC_UKOil_20_Num"] ? Convert.ToDouble(dbreader["KC_UKOil_20_Num"]) : 0;
tdjj.KC_UKOil_50_Num = System.DBNull.Value != dbreader["KC_UKOil_50_Num"] ? Convert.ToDouble(dbreader["KC_UKOil_50_Num"]) : 0;
tdjj.KC_XAG_100kg_Num = System.DBNull.Value != dbreader["KC_XAG_100kg_Num"] ? Convert.ToDouble(dbreader["KC_XAG_100kg_Num"]) : 0;
tdjj.KC_XAG_20kg_Num = System.DBNull.Value != dbreader["KC_XAG_20kg_Num"] ? Convert.ToDouble(dbreader["KC_XAG_20kg_Num"]) : 0;
tdjj.KC_XAG_50kg_Num = System.DBNull.Value != dbreader["KC_XAG_50kg_Num"] ? Convert.ToDouble(dbreader["KC_XAG_50kg_Num"]) : 0;
tdjj.KC_XAU_1000g_Num = System.DBNull.Value != dbreader["KC_XAU_1000g_Num"] ? Convert.ToDouble(dbreader["KC_XAU_1000g_Num"]) : 0;
tdjj.KC_XPD_1000g_Num = System.DBNull.Value != dbreader["KC_XPD_1000g_Num"] ? Convert.ToDouble(dbreader["KC_XPD_1000g_Num"]) : 0;
tdjj.KC_XPT_1000g_Num = System.DBNull.Value != dbreader["KC_XPT_1000g_Num"] ? Convert.ToDouble(dbreader["KC_XPT_1000g_Num"]) : 0;
tdjj.XAG_100kg_Num = System.DBNull.Value != dbreader["XAG_100kg_Num"] ? Convert.ToDouble(dbreader["XAG_100kg_Num"]) : 0;
tdjj.XAG_20kg_Num = System.DBNull.Value != dbreader["XAG_20kg_Num"] ? Convert.ToDouble(dbreader["XAG_20kg_Num"]) : 0;
tdjj.XAG_50kg_Num = System.DBNull.Value != dbreader["XAG_50kg_Num"] ? Convert.ToDouble(dbreader["XAG_50kg_Num"]) : 0;
tdjj.XAU_1000g_Num = System.DBNull.Value != dbreader["XAU_1000g_Num"] ? Convert.ToDouble(dbreader["XAU_1000g_Num"]) : 0;
tdjj.XPD_1000g_Num = System.DBNull.Value != dbreader["XPD_1000g_Num"] ? Convert.ToDouble(dbreader["XPD_1000g_Num"]) : 0;
tdjj.XPT_1000g_Num = System.DBNull.Value != dbreader["XPT_1000g_Num"] ? Convert.ToDouble(dbreader["XPT_1000g_Num"]) : 0;
tdjj.Copper_20t_Num = System.DBNull.Value != dbreader["Copper_20t_Num"] ? Convert.ToDouble(dbreader["Copper_20t_Num"]) : 0;
tdjj.Copper_50t_Num = System.DBNull.Value != dbreader["Copper_50t_Num"] ? Convert.ToDouble(dbreader["Copper_50t_Num"]) : 0;
tdjj.UKOil_100_Num = System.DBNull.Value != dbreader["UKOil_100_Num"] ? Convert.ToDouble(dbreader["UKOil_100_Num"]) : 0;
tdjj.UKOil_50_Num = System.DBNull.Value != dbreader["UKOil_50_Num"] ? Convert.ToDouble(dbreader["UKOil_50_Num"]) : 0;
tdjj.UKOil_20_Num = System.DBNull.Value != dbreader["UKOil_20_Num"] ? Convert.ToDouble(dbreader["UKOil_20_Num"]) : 0;
tdjj.XAUUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["XAUUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["XAUUSD_DHAVG_PRICE"]) : 0;
tdjj.XAGUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["XAGUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["XAGUSD_DHAVG_PRICE"]) : 0;
tdjj.XPDUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["XPDUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["XPDUSD_DHAVG_PRICE"]) : 0;
tdjj.XPTUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["XPTUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["XPTUSD_DHAVG_PRICE"]) : 0;
tdjj.Copper_DHAVG_PRICE = System.DBNull.Value != dbreader["Copper_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["Copper_DHAVG_PRICE"]) : 0;
tdjj.UKOil_DHAVG_PRICE = System.DBNull.Value != dbreader["UKOil_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["UKOil_DHAVG_PRICE"]) : 0;
tdjj.EURGBP_DHAVG_PRICE = System.DBNull.Value != dbreader["EURGBP_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["EURGBP_DHAVG_PRICE"]) : 0;
tdjj.GBPUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["GBPUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["GBPUSD_DHAVG_PRICE"]) : 0;
tdjj.EURUSD_DHAVG_PRICE = System.DBNull.Value != dbreader["EURUSD_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["EURUSD_DHAVG_PRICE"]) : 0;
tdjj.USDJPY_DHAVG_PRICE = System.DBNull.Value != dbreader["USDJPY_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["USDJPY_DHAVG_PRICE"]) : 0;
tdjj.USDCHF_DHAVG_PRICE = System.DBNull.Value != dbreader["USDCHF_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["USDCHF_DHAVG_PRICE"]) : 0;
tdjj.USDOLLAR_DHAVG_PRICE = System.DBNull.Value != dbreader["USDOLLAR_DHAVG_PRICE"] ? Convert.ToDouble(dbreader["USDOLLAR_DHAVG_PRICE"]) : 0;
tdjj.XAUUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["XAUUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["XAUUSD_HSAVG_PRICE"]) : 0;
tdjj.XAGUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["XAGUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["XAGUSD_HSAVG_PRICE"]) : 0;
tdjj.XPDUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["XPDUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["XPDUSD_HSAVG_PRICE"]) : 0;
tdjj.XPTUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["XPTUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["XPTUSD_HSAVG_PRICE"]) : 0;
tdjj.Copper_HSAVG_PRICE = System.DBNull.Value != dbreader["Copper_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["Copper_HSAVG_PRICE"]) : 0;
tdjj.UKOil_HSAVG_PRICE = System.DBNull.Value != dbreader["UKOil_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["UKOil_HSAVG_PRICE"]) : 0;
tdjj.EURGBP_HSAVG_PRICE = System.DBNull.Value != dbreader["EURGBP_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["EURGBP_HSAVG_PRICE"]) : 0;
tdjj.GBPUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["GBPUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["GBPUSD_HSAVG_PRICE"]) : 0;
tdjj.EURUSD_HSAVG_PRICE = System.DBNull.Value != dbreader["EURUSD_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["EURUSD_HSAVG_PRICE"]) : 0;
tdjj.USDJPY_HSAVG_PRICE = System.DBNull.Value != dbreader["USDJPY_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["USDJPY_HSAVG_PRICE"]) : 0;
tdjj.USDCHF_HSAVG_PRICE = System.DBNull.Value != dbreader["USDCHF_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["USDCHF_HSAVG_PRICE"]) : 0;
tdjj.USDOLLAR_HSAVG_PRICE = System.DBNull.Value != dbreader["USDOLLAR_HSAVG_PRICE"] ? Convert.ToDouble(dbreader["USDOLLAR_HSAVG_PRICE"]) : 0;
tdjj.XAUUSD_DH_NUM = System.DBNull.Value != dbreader["XAUUSD_DH_NUM"] ? Convert.ToDouble(dbreader["XAUUSD_DH_NUM"]) : 0;
tdjj.XAGUSD_DH_NUM = System.DBNull.Value != dbreader["XAGUSD_DH_NUM"] ? Convert.ToDouble(dbreader["XAGUSD_DH_NUM"]) : 0;
tdjj.XPDUSD_DH_NUM = System.DBNull.Value != dbreader["XPDUSD_DH_NUM"] ? Convert.ToDouble(dbreader["XPDUSD_DH_NUM"]) : 0;
tdjj.XPTUSD_DH_NUM = System.DBNull.Value != dbreader["XPTUSD_DH_NUM"] ? Convert.ToDouble(dbreader["XPTUSD_DH_NUM"]) : 0;
tdjj.Copper_DH_NUM = System.DBNull.Value != dbreader["Copper_DH_NUM"] ? Convert.ToDouble(dbreader["Copper_DH_NUM"]) : 0;
tdjj.UKOil_DH_NUM = System.DBNull.Value != dbreader["UKOil_DH_NUM"] ? Convert.ToDouble(dbreader["UKOil_DH_NUM"]) : 0;
tdjj.EURGBP_DH_NUM = System.DBNull.Value != dbreader["EURGBP_DH_NUM"] ? Convert.ToDouble(dbreader["EURGBP_DH_NUM"]) : 0;
tdjj.GBPUSD_DH_NUM = System.DBNull.Value != dbreader["GBPUSD_DH_NUM"] ? Convert.ToDouble(dbreader["GBPUSD_DH_NUM"]) : 0;
tdjj.EURUSD_DH_NUM = System.DBNull.Value != dbreader["EURUSD_DH_NUM"] ? Convert.ToDouble(dbreader["EURUSD_DH_NUM"]) : 0;
tdjj.USDJPY_DH_NUM = System.DBNull.Value != dbreader["USDJPY_DH_NUM"] ? Convert.ToDouble(dbreader["USDJPY_DH_NUM"]) : 0;
tdjj.USDCHF_DH_NUM = System.DBNull.Value != dbreader["USDCHF_DH_NUM"] ? Convert.ToDouble(dbreader["USDCHF_DH_NUM"]) : 0;
tdjj.USDOLLAR_DH_NUM = System.DBNull.Value != dbreader["USDOLLAR_DH_NUM"] ? Convert.ToDouble(dbreader["USDOLLAR_DH_NUM"]) : 0;
tdjj.XAUUSD_HS_NUM = System.DBNull.Value != dbreader["XAUUSD_HS_NUM"] ? Convert.ToDouble(dbreader["XAUUSD_HS_NUM"]) : 0;
tdjj.XAGUSD_HS_NUM = System.DBNull.Value != dbreader["XAGUSD_HS_NUM"] ? Convert.ToDouble(dbreader["XAGUSD_HS_NUM"]) : 0;
tdjj.XPDUSD_HS_NUM = System.DBNull.Value != dbreader["XPDUSD_HS_NUM"] ? Convert.ToDouble(dbreader["XPDUSD_HS_NUM"]) : 0;
tdjj.XPTUSD_HS_NUM = System.DBNull.Value != dbreader["XPTUSD_HS_NUM"] ? Convert.ToDouble(dbreader["XPTUSD_HS_NUM"]) : 0;
tdjj.Copper_HS_NUM = System.DBNull.Value != dbreader["Copper_HS_NUM"] ? Convert.ToDouble(dbreader["Copper_HS_NUM"]) : 0;
tdjj.UKOil_HS_NUM = System.DBNull.Value != dbreader["UKOil_HS_NUM"] ? Convert.ToDouble(dbreader["UKOil_HS_NUM"]) : 0;
tdjj.EURGBP_HS_NUM = System.DBNull.Value != dbreader["EURGBP_HS_NUM"] ? Convert.ToDouble(dbreader["EURGBP_HS_NUM"]) : 0;
tdjj.GBPUSD_HS_NUM = System.DBNull.Value != dbreader["GBPUSD_HS_NUM"] ? Convert.ToDouble(dbreader["GBPUSD_HS_NUM"]) : 0;
tdjj.EURUSD_HS_NUM = System.DBNull.Value != dbreader["EURUSD_HS_NUM"] ? Convert.ToDouble(dbreader["EURUSD_HS_NUM"]) : 0;
tdjj.USDJPY_HS_NUM = System.DBNull.Value != dbreader["USDJPY_HS_NUM"] ? Convert.ToDouble(dbreader["USDJPY_HS_NUM"]) : 0;
tdjj.USDCHF_HS_NUM = System.DBNull.Value != dbreader["USDCHF_HS_NUM"] ? Convert.ToDouble(dbreader["USDCHF_HS_NUM"]) : 0;
tdjj.USDOLLAR_HS_NUM = System.DBNull.Value != dbreader["USDOLLAR_HS_NUM"] ? Convert.ToDouble(dbreader["USDOLLAR_HS_NUM"]) : 0;
TdInfo.TdJuJianList.Add(tdjj);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if (null != dbreader)
{
dbreader.Close(); dbreader.Dispose();
}
}
}
/// <summary>
/// 居间管理
/// </summary>
/// <param name="JJqc">查询条件</param>
/// <returns></returns>
public TradeJuJianInfo GetTradeJuJianInfo(JJQueryCon JJqc)
{
TradeJuJianInfo TdInfo = new TradeJuJianInfo();
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(JJqc.LoginID, ref TdUser))
{
TdInfo.Result = false;
TdInfo.Desc = ResCode.UL003Desc;
return TdInfo;
}
if (UserType.NormalType == TdUser.UType)
{
TdInfo.Result = false;
TdInfo.Desc = ComFunction.NotRightUser;
return TdInfo;
}
#endregion
string ParentOrgID = string.Empty;
if (UserType.OrgType == TdUser.UType && !string.IsNullOrEmpty(TdUser.OrgId))
{
ParentOrgID = TdUser.OrgId;
}
TdInfo.TdJuJianList = new List<TradeJuJian>();
ComFunction.GetTradeJuJianList(JJqc, ParentOrgID, ref TdInfo);
TdInfo.Result = true;
TdInfo.Desc = "查询成功";
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
TdInfo.Result = false;
TdInfo.Desc = "查询居间管理失败";
}
return TdInfo;
}