public ActionResult AgencyList()
{
T_AgencyBll bll = new T_AgencyBll();
var list = bll.GetList();
return(View(list));
}
public ActionResult AgencyAdd()
{
var model = new T_Agency();
var bll = new T_AgencyBll();
if (Request.QueryString["AgencyId"] != null)
{
model = bll.GetModel(int.Parse(Request.QueryString["AgencyId"].ToString()));
}
else
{
model.IsShow = 1;
}
return(View(model));
}
public Dictionary <string, object> IntoAgency()
{
T_AgencyBll bll = new T_AgencyBll();
string url = HttpContext.Current.Request.Form["url"].ToString();
string filename = HttpContext.Current.Request.Form["filename"].ToString();
DataSet ds = ExportFile.ExcelSqlConnection(HttpContext.Current.Server.MapPath(url), "Info"); //调用自定义方法
DataRow[] dr = ds.Tables[0].Select();
int successcount = 0;
int failcount = 0;
for (int i = 0; i < dr.Length; i++)
{
try
{
T_Agency model = new T_Agency();
model.AgencyName = dr[i][0].ToString();
model.CreateUserId = ManageProvider.Provider.Current().UserId;
model.CreateUserName = ManageProvider.Provider.Current().Account;
model.CreateTime = DateTime.Now;
model.IsDelete = 0;
model.IsShow = 1;
model.SortCode = 0;
if (bll.Add(model) > 0)
{
successcount++;
}
else
{
failcount++;
}
}
catch (Exception)
{
failcount++;
}
}
return(new Dictionary <string, object>
{
{ "code", "1" },
{ "successcount", successcount },
{ "failcount", failcount },
{ "filename", filename },
{ "count", dr.Length }
});
}
//全国经销商活动场次统计
public Dictionary <string, object> GetAgencyStatisticsList()
{
T_SaleActivityTypeBll typebll = new T_SaleActivityTypeBll();
T_AgencyBll t_agencybll = new T_AgencyBll();
T_ActivityAreaBll areabll = new T_ActivityAreaBll();
var arealist = areabll.GetList();
var typelist = typebll.GetList();
var agencylist = t_agencybll.GetList();
string begintime = HttpContext.Current.Request.Form["begintime"].ToString();
string endtime = HttpContext.Current.Request.Form["endtime"].ToString();
string areaid = HttpContext.Current.Request.Form["areaid"].ToString();
string strwhere = "IsDelete=0";
if (!string.IsNullOrEmpty(begintime))
{
strwhere += " and ActivityDate>='" + begintime + "'";
}
if (!string.IsNullOrEmpty(endtime))
{
strwhere += " and ActivityDate<='" + endtime + "'";
}
if (!string.IsNullOrEmpty(areaid))
{
strwhere += " and saleactivitytypeid=" + areaid;
}
else
{
strwhere += " and saleactivitytypeid=" + arealist[0];
}
string date = DateTime.Now.Year.ToString() + "-01-01";
int indexmonth = DateTime.Now.Month;
var listmonth = new List <int>();
for (int i = 1; i < indexmonth + 1; i++)
{
listmonth.Add(i);
}
var database = DataFactory.Database();
var dsaverage = database.FindDataSetBySql("select DATEPART(month, ActivityDate) as nmonth,agencyid,saleactivitytypeid from T_SaleActivity where datediff(year, ActivityDate, '" + date + "') = 0 group by AgencyId, DATEPART(month, ActivityDate),SaleActivityTypeId order by DATEPART(month, ActivityDate)");
List <AgencyStatisticsViewModel> listview = new List <AgencyStatisticsViewModel>();
foreach (var item in agencylist)
{
var model = new AgencyStatisticsViewModel();
model.AgencyName = item.AgencyName;
model.AgencyId = item.AgencyId;
List <Months> listmonthview = new List <Months>();
foreach (var item1 in listmonth)
{
var monthview = new Months();
monthview.Month = item1.ToString();
List <int> listid = new List <int>();
var dsselect = dsaverage.Tables[0].Select("nmonth=" + item1.ToString() + " and agencyid=" + item.AgencyId + "");
foreach (var item2 in dsselect)
{
if (!listid.Contains(int.Parse(item2["saleactivitytypeid"].ToString())))
{
listid.Add(int.Parse(item2["saleactivitytypeid"].ToString()));
}
}
monthview.SaleActivityTypeIdList = listid;
listmonthview.Add(monthview);
}
model.listmonth = listmonthview;
listview.Add(model);
}
return(new Dictionary <string, object>
{
{ "code", 1 },
{ "typelist", typelist.Select(a => new { saleactivitytypeid = a.SaleActivityTypeId, saleactivitytypename = a.SaleActivityTypeName }) },
{ "agencylist", agencylist.Select(a => new { agencyid = a.AgencyId, agencyname = a.AgencyName }) },
{ "list", listview },
{ "monthlist", listmonth },
{ "arealist", arealist }
});
}
// 经销商活动后续宣传发布统计
public Dictionary <string, object> GetEveryMonthPublishWayStatistics()
{
T_AgencyBll t_agencybll = new T_AgencyBll();
var agencylist = t_agencybll.GetList();
string date = DateTime.Now.Year.ToString() + "-01-01";
var database = DataFactory.Database();
int indexmonth = DateTime.Now.Month;
var listmonth = new List <int>();
for (int i = 1; i < indexmonth + 1; i++)
{
listmonth.Add(i);
}
var pubishwaylist = new Utilities.PublishWay().ToSelectListItem();
var listdic = new Dictionary <int, object>();
var dsaverage = database.FindDataSetBySql("select DATEPART(month,ActivityDate) as nmonth,PublishWay,AgencyId from T_SaleActivity where datediff(year,ActivityDate,'" + date + "')=0 group by DATEPART(month,ActivityDate),PublishWay,AgencyId order by DATEPART(month,ActivityDate)");
foreach (var item in agencylist)
{
List <PublishwayStatistics> listway = new List <PublishwayStatistics>();
foreach (var item1 in listmonth)
{
PublishwayStatistics model = new PublishwayStatistics();
var list = new List <int>();
model.Month = item1;
var result = dsaverage.Tables[0].Select($"AgencyId={item.AgencyId} and nmonth={item1}");
foreach (var item2 in result)
{
var PublishWay = item2["PublishWay"].ToString();
var arraypublishway = PublishWay.Split(',');
if (list.Count == pubishwaylist.Count())
{
break;
}
else
{
foreach (var item4 in arraypublishway)
{
if (!list.Contains(int.Parse(item4)))
{
list.Add(int.Parse(item4));
}
}
}
}
model.Publishwaylist = list;
listway.Add(model);
//if(result.Where(a=>a["PublishWay"])
}
listdic.Add(item.AgencyId, listway);
}
return(new Dictionary <string, object>
{
{ "code", 1 },
{ "agencylist", agencylist.Select(a => new { agencyid = a.AgencyId, agencyname = a.AgencyName }) },
{ "averagelist", listdic },
{ "monthlist", listmonth },
{ "pubishwaylist", pubishwaylist.Select(a => new { pubishwayid = a.Value, pubishwayname = a.Text }) }
});
}
