public List <SourceDateEntity> GetCustomerSourceDate(EnumDateType type, string begintime, string endtime, string UserID, string TeamID, string agentid, string clientid)
{
List <SourceDateEntity> list = new List <SourceDateEntity>();
DataSet ds = CustomerRPTDAL.BaseProvider.GetCustomerSourceDate((int)type, begintime, endtime, UserID, TeamID, agentid, clientid);
var sources = SystemBusiness.BaseBusiness.GetCustomSources(agentid, clientid);
foreach (var source in sources)
{
SourceDateEntity model = new SourceDateEntity();
model.Name = source.SourceName;
model.Items = new List <SourceDateItem>();
DataRow[] drs = ds.Tables["SourceData"].Select("SourceID='" + source.SourceID + "'");
foreach (DataRow dr in ds.Tables["DateName"].Rows)
{
SourceDateItem item = new SourceDateItem();
item.Name = dr[0].ToString();
if (drs.Where(m => m["Name"].ToString() == item.Name).Count() > 0)
{
item.Value = Convert.ToInt32(drs.Where(m => m["Name"].ToString() == item.Name).FirstOrDefault()["Value"]);
}
else
{
item.Value = 0;
}
model.Items.Add(item);
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 根据类型获取日期
/// </summary>
/// <param name="dateType"></param>
/// <param name="number"></param>
/// <returns></returns>
public static DateTime GetDateTimeByType(EnumDateType dateType, int number)
{
switch (dateType)
{
case EnumDateType.Year:
return(DateTime.Now.AddYears(-number));
case EnumDateType.Month:
return(DateTime.Now.AddMonths(-number));
case EnumDateType.Day:
return(DateTime.Now.AddDays(-number));
case EnumDateType.Hour:
return(DateTime.Now.AddHours(-number));
case EnumDateType.Minute:
return(DateTime.Now.AddMinutes(-number));
case EnumDateType.Second:
return(DateTime.Now.AddSeconds(-number));
default:
return(DateTime.Now);
}
}
/// <summary>
/// 获取时间编码
/// </summary>
/// <param name="dateType"></param>
/// <returns></returns>
public static string GetDateFormatByDateType(EnumDateType dateType)
{
switch (dateType)
{
case EnumDateType.Year:
return(FORMAT_YEAR);
case EnumDateType.Month:
return(FORMAT_MONTH);
case EnumDateType.Day:
return(FORMAT_DAY);
case EnumDateType.Hour:
return(FORMAT_HOUR);
case EnumDateType.Minute:
return(FORMAT_MINUTE);
case EnumDateType.Second:
return(FORMAT_SECOND);
default:
return(string.Empty);
}
}
public List<SourceDateEntity> GetCustomerSourceDate(EnumDateType type, string begintime, string endtime, string UserID, string TeamID, string agentid, string clientid)
{
List<SourceDateEntity> list = new List<SourceDateEntity>();
DataSet ds = CustomerRPTDAL.BaseProvider.GetCustomerSourceDate((int)type, begintime, endtime, UserID, TeamID, agentid, clientid);
var sources = SystemBusiness.BaseBusiness.GetCustomSources(agentid, clientid);
foreach (var source in sources)
{
SourceDateEntity model = new SourceDateEntity();
model.Name = source.SourceName;
model.Items = new List<SourceDateItem>();
DataRow[] drs = ds.Tables["SourceData"].Select("SourceID='" + source.SourceID + "'");
foreach (DataRow dr in ds.Tables["DateName"].Rows)
{
SourceDateItem item = new SourceDateItem();
item.Name = dr[0].ToString();
if (drs.Where(m => m["Name"].ToString() == item.Name).Count() > 0)
{
item.Value = Convert.ToInt32(drs.Where(m => m["Name"].ToString() == item.Name).FirstOrDefault()["Value"]);
}
else
{
item.Value = 0;
}
model.Items.Add(item);
}
list.Add(model);
}
return list;
}
public JsonResult GetCustomerSourceDate(EnumDateType dateType, string beginTime, string endTime, string UserID, string TeamID)
{
var list = CustomerRPTBusiness.BaseBusiness.GetCustomerSourceDate(dateType, beginTime, endTime, UserID, TeamID, CurrentUser.AgentID, CurrentUser.ClientID);
JsonDictionary.Add("items", list);
return new JsonResult()
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
public JsonResult GetCustomerSourceDate(EnumDateType dateType, string beginTime, string endTime, string UserID, string TeamID)
{
var list = CustomerRPTBusiness.BaseBusiness.GetCustomerSourceDate(dateType, beginTime, endTime, UserID, TeamID, CurrentUser.AgentID, CurrentUser.ClientID);
JsonDictionary.Add("items", list);
return(new JsonResult()
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// 初始化时间
/// </summary>
/// <param name="dateTime"></param>
/// <param name="dateType"></param>
/// <returns></returns>
public static DateTime InitDateTime(DateTime dateTime, EnumDateType dateType)
{
var format = GetDateFormatByDateType(dateType);
return(ConvertStrToDatetime(dateTime.ToString(format), format));
}
