LYZHGD_3.0/还原代码/Common/GetTableName...

using System;

namespace Common
{
	public class GetTableNameByDate
	{
		public static string Get_T_OV_MeterOrigValue_ByDate(DateTime date, string type)
		{
			string name = "";
			string text = type.Trim();
			if (text != null)
			{
				if (!(text == "0"))
				{
					if (text == "1")
					{
						name = " ( SELECT dbo.[T_OV_MeterOrigValue_" + date.ToString("yyyy-MM-dd") + "].*, dbo.T_BD_BuildBaseInfo.F_DataCenterID, dbo.T_BD_BuildBaseInfo.F_BuildName, dbo.T_ST_MeterUseInfo.F_MeterName, dbo.T_ST_MeterParamInfo.F_MeterParamName ";
						string text2 = name;
						name = string.Concat(new string[]
						{
							text2,
							" FROM dbo.T_BD_BuildBaseInfo RIGHT OUTER JOIN dbo.[T_OV_MeterOrigValue_",
							date.ToString("yyyy-MM-dd"),
							"] LEFT OUTER JOIN dbo.T_ST_MeterParamInfo ON dbo.[T_OV_MeterOrigValue_",
							date.ToString("yyyy-MM-dd"),
							"].F_MeterParamID = dbo.T_ST_MeterParamInfo.F_MeterParamID "
						});
						text2 = name;
						name = string.Concat(new string[]
						{
							text2,
							" LEFT OUTER JOIN dbo.T_ST_MeterUseInfo ON dbo.[T_OV_MeterOrigValue_",
							date.ToString("yyyy-MM-dd"),
							"].F_MeterID = dbo.T_ST_MeterUseInfo.F_MeterID ON dbo.T_BD_BuildBaseInfo.F_BuildID = dbo.[T_OV_MeterOrigValue_",
							date.ToString("yyyy-MM-dd"),
							"].F_BuildID ) "
						});
					}
				}
				else
				{
					name = "[T_OV_MeterOrigValue_" + date.ToString("yyyy-MM-dd") + "]";
				}
			}
			return name;
		}

		public static string Get_T_EC_EnergyItemHourResult_ByDate(DateTime date, string type)
		{
			string name = "";
			string text = type.Trim();
			if (text != null)
			{
				if (!(text == "0"))
				{
					if (text == "1")
					{
						name = " ( SELECT dbo.[T_EC_EnergyItemHourResult_" + date.ToString("yyyy-MM") + "].* , dbo.T_BD_BuildBaseInfo.F_BuildName, dbo.T_BD_AreaInfo.F_AreaName, dbo.T_DT_EnergyItemDict.F_EnergyItemName";
						string text2 = name;
						name = string.Concat(new string[]
						{
							text2,
							" FROM dbo.[T_EC_EnergyItemHourResult_",
							date.ToString("yyyy-MM"),
							"] LEFT OUTER JOIN dbo.T_DT_EnergyItemDict ON dbo.[T_EC_EnergyItemHourResult_",
							date.ToString("yyyy-MM"),
							"].F_EnergyItemCode = dbo.T_DT_EnergyItemDict.F_EnergyItemCode LEFT OUTER JOIN dbo.T_BD_AreaInfo ON dbo.[T_EC_EnergyItemHourResult_",
							date.ToString("yyyy-MM"),
							"].F_AreaID = dbo.T_BD_AreaInfo.F_AreaID LEFT OUTER JOIN dbo.T_BD_BuildBaseInfo ON dbo.[T_EC_EnergyItemHourResult_",
							date.ToString("yyyy-MM"),
							"].F_BuildID = dbo.T_BD_BuildBaseInfo.F_BuildID ) "
						});
					}
				}
				else
				{
					name = "[T_EC_EnergyItemHourResult_" + date.ToString("yyyy-MM") + "]";
				}
			}
			return name;
		}

		public static string Get_T_EC_EnergyItemDayResult_ByDate(DateTime date, string type)
		{
			string name = "";
			string text = type.Trim();
			if (text != null)
			{
				if (!(text == "0"))
				{
					if (text == "1")
					{
						name = " ( SELECT dbo.[T_EC_EnergyItemDayResult_" + date.ToString("yyyy") + "].*, dbo.T_BD_BuildBaseInfo.F_BuildName, dbo.T_BD_AreaInfo.F_AreaName, dbo.T_DT_EnergyItemDict.F_EnergyItemName ";
						string text2 = name;
						name = string.Concat(new string[]
						{
							text2,
							" FROM dbo.[T_EC_EnergyItemDayResult_",
							date.ToString("yyyy"),
							"] LEFT OUTER JOIN dbo.T_DT_EnergyItemDict ON dbo.[T_EC_EnergyItemDayResult_",
							date.ToString("yyyy"),
							"].F_EnergyItemCode = dbo.T_DT_EnergyItemDict.F_EnergyItemCode LEFT OUTER JOIN "
						});
						text2 = name;
						name = string.Concat(new string[]
						{
							text2,
							" dbo.T_BD_AreaInfo ON dbo.[T_EC_EnergyItemDayResult_",
							date.ToString("yyyy"),
							"].F_AreaID = dbo.T_BD_AreaInfo.F_AreaID LEFT OUTER JOIN dbo.T_BD_BuildBaseInfo ON dbo.[T_EC_EnergyItemDayResult_",
							date.ToString("yyyy"),
							"].F_BuildID = dbo.T_BD_BuildBaseInfo.F_BuildID ) "
						});
					}
				}
				else
				{
					name = "[T_EC_EnergyItemDayResult_" + date.ToString("yyyy") + "]";
				}
			}
			return name;
		}
	}
}