public long m_lngUpdateStatisticMode(string p_strStasticID,string p_strQueryID,string p_strXmlContent,string p_strSelectedFiledsIndexes,string p_strModeDesc)
{
clsStatisticsService m_objService =
(clsStatisticsService)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsStatisticsService));
long lngRes = 0;
try
{
lngRes =(m_objService.m_lngUpdateStatisticMode (p_strStasticID ,p_strQueryID ,p_strXmlContent ,p_strSelectedFiledsIndexes ,p_strModeDesc));
}
finally
{
////m_objService.Dispose();
}
return lngRes;
}
public long m_lngAddNewStatisticMode(clsStatisticQueryModeValue p_objStatisticQueryModeValue, out string p_strQueryID)
{
clsStatisticsService m_objService =
(clsStatisticsService)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsStatisticsService));
long lngRes = 0;
try
{
lngRes =(m_objService.m_lngAddNewStatisticMode (p_objStatisticQueryModeValue, out p_strQueryID));
}
finally
{
////m_objService.Dispose();
}
return lngRes;
}
public long m_lngGetAllStatisticDefinition(out clsStatisticDefinitionValue [] p_objStatisticDefinitionValue)
{
clsStatisticsService m_objService =
(clsStatisticsService)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsStatisticsService));
long lngRes = 0;
try
{
lngRes =(m_objService.m_lngGetAllStatisticDefinition(out p_objStatisticDefinitionValue ));
}
finally
{
////m_objService.Dispose();
}
return lngRes;
}
public long m_lngGetStatisticQueryMode(string p_strStatisticID,out clsStatisticQueryModeValue [] p_objStatisticQueryModeValue)
{
clsStatisticsService m_objService =
(clsStatisticsService)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsStatisticsService));
long lngRes = 0;
try
{
lngRes =m_objService.m_lngGetStatisticQueryMode (p_strStatisticID ,out p_objStatisticQueryModeValue );
}
finally
{
////m_objService.Dispose();
}
return lngRes;
}
/// <summary>
/// 执行SQL查询
/// </summary>
/// <param name="p_strStatisticSqlTemplate">Sql语句模板的String 格式:Select [SelectedFields] from T1,T2 Where [FixedSystems] and [UserCondiction]</param>
/// <param name="p_strSelectedFields">用户选择实际显示的字段</param>
/// <param name="p_strXmlWhereStruction">Where语句的XML结构,包含FixedSystems和UserCondiction</param>
/// <param name="p_strRowValues">返回二维String数组</param>
/// <returns></returns>
public long m_lngPerformSqlQuery(string p_strStatisticSqlTemplate,string p_strOpenClassParameters, string p_strSelectedFields,XmlDocument p_objXmlDocment,out string [,] p_strRowValues)
{
clsStatisticsService m_objService =
(clsStatisticsService)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsStatisticsService));
long lngRes = 0;
try
{
string strSqlStatement = p_strStatisticSqlTemplate;
strSqlStatement = strSqlStatement.Replace("[SelectedFields]", p_strOpenClassParameters + "," + p_strSelectedFields);
s_strFixedSystemSQL = "";
s_strUserCondictionSQL = "";
m_mthReadFixedSystemSQL(p_objXmlDocment.DocumentElement.ChildNodes[0]);
m_blnReadUserCondictionSQL(p_objXmlDocment.DocumentElement.ChildNodes[1]);
strSqlStatement = strSqlStatement.Replace("[FixedSystems]", s_strFixedSystemSQL);
strSqlStatement = strSqlStatement.Replace("[UserCondiction]", s_strUserCondictionSQL);
lngRes = (m_objService.m_lngPerformSqlQuery(strSqlStatement, out p_strRowValues));
}
finally
{
////m_objService.Dispose();
}
return lngRes;
}
