/// <summary>
/// 获得湖库数据通用存储过程
/// </summary>
/// <param name="BeginDate">开始时间</param>
/// <param name="EndDate">结束时间</param>
/// <param name="DecCarry">平均值取值方法:0:四舍六入五单一、1:四舍五入、2:直接截断、5：对武汉项目特殊处理，氨氮和总磷按照有效位数修约</param>
/// <param name="AppriseID">0:针对单个断面评价、1：针对空间评价</param>
/// <param name="fldItemCode">因子代码</param>
/// <param name="fldLevel">级别</param>
/// <param name="fldRSC">水期</param>
/// <param name="fldLSCode">湖库+垂线代码</param>
/// <param name="fldStandardName">级别名称</param>
/// <param name="IsDetail">是否统计明细 </param>
/// <param name="IsPre">是否统计前期数据</param>
/// <param name="IsYear">是否统计同期数据</param>
/// <param name="Para1ID">湖库均值处理，0:默认值按行政区、1：按行政区前4位处理</param>
/// <param name="Para2ID">备用参数 </param>
/// <param name="STatType">1:年鉴表、2：项目超标情况表、3：综合评价表</param>
/// <param name="TimeType">时间类型</param>
/// <param name="IsTotal">是否统计平均值</param>
/// <param name="IsTLI">是否统计富营养化指数</param>
/// <param name="TLIType">富营养化计算时叶绿素a和透明度单位：0-mg/L,cm；1-mg/m^3,m</param>
/// <returns></returns>
public DataTable getreportdtlake_JZS(string BeginDate, string EndDate, string DecCarry, int AppriseID, string fldItemCode, short fldLevel
, string fldRSC, string fldLSCode, string fldStandardName, int IsDetail, int IsPre, int IsYear, int Para1ID, int Para2ID, int Source
, short STatType, string TimeType, int IsTotal, int IsTLI, int TLIType, int SpaceID)
{
try
{
DataTable dt = new DataTable();
usp_tblEQIW_RL_Report_Apprise usp = new usp_tblEQIW_RL_Report_Apprise();
usp.TimeType = TimeType;
usp.BeginDate = BeginDate;
usp.EndDate = EndDate;
usp.EBeginDate = "";
usp.EEndDate = "";
usp.fldRSC = fldRSC;
usp.fldRSCode = fldLSCode;
usp.fldStandardName = fldStandardName;
usp.fldLevel = fldLevel;
usp.fldItemCode = fldItemCode;
usp.DecCarry = DecCarry;
usp.IsPre = IsPre;
usp.IsYear = IsYear;
usp.IsTotal = IsTotal;
usp.IsDetail = IsDetail;
usp.IsTLI = IsTLI;
usp.TLIType = TLIType;
usp.AppriseID = AppriseID;
usp.SpaceID = SpaceID;
usp.STatType = STatType;
usp.Para1ID = Para1ID;
usp.Para2ID = Para2ID;
usp.Source = 0;
dt = usp.ExecDataTable(3);
return(dt);
}
catch (DBOpenException)
{
throw new GetListException("打开数据库连接失败", "RuletblEQI_publi", "getdt", "sql:");
}
catch (DBQueryException)
{
throw new GetListException("执行Sql语句失败", "RuletblEQI_publi", "getdt", "sql:");
}
catch (Exception e)
{
throw new GetListException(e.Message, "RuletblEQI_publi", "getdt", "sql:");
}
}
/// 功能描述 ： 地表水综合统计评价
/// 创建者 ： 都玉新
/// 创建日期 ： 2016-05-10
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="sTimeType">时间类型 </param>
/// <param name="sBeginDate">开始日期</param>
/// <param name="sEndDate">结束日期</param>
/// <param name="sEBeginDate">第二个时段开始时间</param>
/// <param name="sEEndDate">第二个时段结束时间</param>
/// <param name="sRSC">水期</param>
/// <param name="sPoint">断面代码</param>
/// <param name="sLStdName">湖库标准名称</param>
/// <param name="sLStdLevel">湖库标准级别</param>
/// <param name="ItemCode">项目代码</param>
/// <param name="cDecCarry">平均值取值方法</param>
/// <param name="IsPre">是否统计前期数据</param>
/// <param name="IsYear">是否统计同期数据</param>
/// <param name="IsTotal">是否统计平均值</param>
/// <param name="IsDetail">是否统计明细</param>
/// <param name="IsTLI">是否统计富营养化指数</param>
/// <param name="TLIType">富营养化计算时叶绿素a和透明度单位：0-mg/L,cm；1-mg/m^3,m</param>
/// mwpara.SpaceID = SpaceID;//0:流域-fldWaterArea、1:水系-fldRSWaterWork、2：河流-fldRCode、3：区县-fldRWTwon、4：设区市-fldSTCode
/// mwpara.AppriseID = 0;//0:针对单个断面评价、1：针对空间评价
/// mwpara.STatType = 1;//0:数据导出格式、1:年鉴格式、2：因子超标评价、3:断面或者河流综合评价、4：数据市站上报省站格
/// 90:综合指数秩相关、91：浓度秩相关、92：达标率秩相关、93：因子污染指数秩相关、94：各类达标率秩相关
/// mwpara.Para1ID=Para1ID;//湖库均值处理，0:默认值按行政区、1：按行政区前4位处理
/// mwpara.Para2ID=Para2ID;//基础信息参数，用于不同省份；0：通用、 1：江西增加信息 2：湖南
/// mwpara.Source =Source ;//数据类型，对应fldSource
/// <returns>DataTable</returns>
public DataTable GetRLDataInfo(string sTimeType, string sBeginDate, string sEndDate, string sRSC, string sPoint,
string sLStdName, short sLStdLevel, string sItem, string cDecCarry = "0", int IsPre = 0, int IsYear = 0, int IsTotal = 0, int IsDetail = 0,
int IsTLI = 0, int TLIType = 0, int iSpaceID = 0, int iAppriseID = 0, short sTatType = 2, int iPara1ID = 0, int iPara2ID = 0, int iSource = 0,
string sEBeginDate = "", string sEEndDate = "")
{
try
{
usp_tblEQIW_RL_Report_Apprise uspAnalyseData = new usp_tblEQIW_RL_Report_Apprise();
uspAnalyseData.TimeType = sTimeType;
uspAnalyseData.BeginDate = sBeginDate;
uspAnalyseData.EndDate = sEndDate;
uspAnalyseData.fldRSC = sRSC;
uspAnalyseData.fldRSCode = sPoint;
uspAnalyseData.fldStandardName = sLStdName;
uspAnalyseData.fldLevel = sLStdLevel;
uspAnalyseData.fldItemCode = sItem;
uspAnalyseData.DecCarry = cDecCarry;
uspAnalyseData.IsPre = IsPre;
uspAnalyseData.IsYear = IsYear;
uspAnalyseData.IsTotal = IsTotal;
uspAnalyseData.IsDetail = IsDetail;
uspAnalyseData.SpaceID = iSpaceID;
uspAnalyseData.AppriseID = iAppriseID;
uspAnalyseData.IsTLI = IsTLI;
uspAnalyseData.TLIType = TLIType;
uspAnalyseData.STatType = sTatType;
uspAnalyseData.Para1ID = iPara1ID;
uspAnalyseData.Para2ID = iPara2ID;
uspAnalyseData.Source = iSource;
uspAnalyseData.EBeginDate = sEBeginDate == null ? "" : sEBeginDate;
uspAnalyseData.EEndDate = sEEndDate == null ? "" : sEEndDate;
DataTable tblData = uspAnalyseData.ExecDataTable(3); //连接通用报表连接
if (tblData != null)
{
return(tblData);
}
else
{
throw new Exception("取得记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new GetByPKException("打开数据库连接失败", "RuletblEQIW_RL_Basedata", "GetRLDataInfoS", "sTimeType:" + sTimeType +
",sBeginDate:" + sBeginDate + ",sEndDate:" + sEndDate + ",sItem:" + sItem + ",sPoint:" + sPoint + ",sRSC:" + sRSC +
",sRIStdName:" + sLStdName + ",sRIStdLevel:" + sLStdLevel.ToString());
}
catch (DBQueryException e)
{
throw new GetByPKException("执行Sql语句失败" + e.Message, "RuletblEQIW_RL_Basedata", "GetRLDataInfoS", "sTimeType:" + sTimeType +
",sBeginDate:" + sBeginDate + ",sEndDate:" + sEndDate + ",sItem:" + sItem + ",sPoint:" + sPoint + ",sRSC:" + sRSC +
",sRIStdName:" + sLStdName + ",sRIStdLevel:" + sLStdLevel.ToString() + ",sLIStdLevel:"
);
}
catch (Exception e)
{
throw new GetByPKException(e.Message, "RuletblEQIW_RL_Basedata", "GetRLDataInfoS", "sTimeType:" + sTimeType +
",sBeginDate:" + sBeginDate + ",sEndDate:" + sEndDate + ",sItem:" + sItem + ",sPoint:" + sPoint + ",sRSC:" + sRSC +
",sRIStdName:" + sLStdName + ",sRIStdLevel:" + sLStdLevel.ToString() + ",sLIStdName:");
}
}
