/// <summary>
/// 基础的统计对象的虚拟表
/// </summary>
/// <returns></returns>
public static DataTable CreateDateValueTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Starttime", ColType.NTSString);
Dir.Add("Endtime", ColType.NTSString);
Dir.Add("CountValue", ColType.NTSDecimal);
return(TableTool.CreateTable(Dir));
}
/// <summary>
/// add by jy
/// add at 2014-3-23
/// note: 导出对比对象列表列表。
/// </summary>
/// <returns></returns>
public static DataTable CreateContrastDataTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Date", ColType.NTSString);
Dir.Add("Object", ColType.NTSString);
Dir.Add("ItemCode", ColType.NTSString);
Dir.Add("EneryValue", ColType.NTSString);
return(TableTool.CreateTable(Dir));
}
public static DataTable CreateFee_ForecastDataTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Date", ColType.NTSString);
Dir.Add("Yuce", ColType.NTSString);
Dir.Add("History", ColType.NTSString);
Dir.Add("PianCha", ColType.NTSString);
Dir.Add("Pecent", ColType.NTSString);
return(TableTool.CreateTable(Dir));
}
public static DataTable CreateFee_ApportionDataTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Date", ColType.NTSString);
Dir.Add("Object", ColType.NTSString);
Dir.Add("FeeBefore", ColType.NTSDecimal);
Dir.Add("FeeAfter", ColType.NTSDecimal);
Dir.Add("FeeALL", ColType.NTSDecimal);
return(TableTool.CreateTable(Dir));
}
public static DataTable CreateSysLogDataTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Number", ColType.NTSString);
Dir.Add("ModelName", ColType.NTSString);
Dir.Add("LogContent", ColType.NTSString);
Dir.Add("LogTime", ColType.NTSString);
Dir.Add("OpType", ColType.NTSString);
Dir.Add("USerName", ColType.NTSString);
return(TableTool.CreateTable(Dir));
}
/// <summary>
/// 基础的统计对象的虚拟表
/// </summary>
/// <returns></returns>
public static DataTable CreateBaseDataTable()
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("Date", ColType.NTSString);
Dir.Add("ObjectID", ColType.NTSString);
Dir.Add("ObjectName", ColType.NTSString);
Dir.Add("Starttime", ColType.NTSString);
Dir.Add("Endtime", ColType.NTSString);
Dir.Add("ItemCode", ColType.NTSString);
Dir.Add("EneryValue", ColType.NTSString);
return(TableTool.CreateTable(Dir));
}
public static DataTable CreateCostQueryDataTable(ResultCostQuery result)
{
Dictionary <string, ColType> Dir = new Dictionary <string, ColType>();
Dir.Add("时间", ColType.NTSString);
Dir.Add(string.Format("{0}量总值({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("{0}费总值(元)", result.FeeTbl.EneType), ColType.NTSString);
switch ((FeeType)Enum.Parse(typeof(FeeType), result.FeeType))
{
case FeeType.分时计费:
Dir.Add(string.Format("尖时{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("尖时{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
Dir.Add(string.Format("峰时{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("峰时{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
Dir.Add(string.Format("平时{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("平时{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
Dir.Add(string.Format("谷时{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("谷时{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
break;
case FeeType.阶梯计费:
if (result.StepSettingID.Contains(4))
{
Dir.Add(string.Format("第四档{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("第四档{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
}
if (result.StepSettingID.Contains(1))
{
Dir.Add(string.Format("第一档{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("第一档{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
}
if (result.StepSettingID.Contains(2))
{
Dir.Add(string.Format("第二档{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("第二档{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
}
if (result.StepSettingID.Contains(3))
{
Dir.Add(string.Format("第三档{0}量({1})", result.FeeTbl.EneType, result.Unit), ColType.NTSString);
Dir.Add(string.Format("第三档{0}费(元)", result.FeeTbl.EneType), ColType.NTSString);
}
break;
}
return(TableTool.CreateTable(Dir));
}