public ActionResult GetReportByPhone(string phoneNumber)
{
var usage = dataContext.Usage.FirstOrDefault(us => us.PhoneNumber == phoneNumber);
UserReportModel usrRpt = new UserReportModel();
if (usage != null)
{
var user = usage.user;
usrRpt.CompanyName = dataContext.Company.FirstOrDefault(com => com.Id == user.CompanyId).CompanyName;
usrRpt.UserName = user.Name;
double?totalCost = 0;
var lstContracts = new List <UserContracts>();
foreach (var usr in user.ContractUsageList)
{
var ctr = new UserContracts();
ctr.ContractName = usr.Contract.ContractName;
ctr.Cost = usr.Cost;
totalCost = totalCost + usr.Cost;
ctr.DataTransfer = usr.DataTransferInMb;
ctr.Minutes = usr.Minutes;
ctr.PackageUsagePercentage = usr.PackageUsagePercentage;
ctr.PhoneNumber = usr.PhoneNumber;
ctr.Quantity = usr.Quantity;
lstContracts.Add(ctr);
}
usrRpt.TotalCost = totalCost;
usrRpt.UserUsage = lstContracts;
return(View("UserReport", usrRpt));
}
else
{
return(View("UserReport", usrRpt));
}
}
/// <summary>
/// 添加用户工作汇报
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public static int AddAppUserReport(UserReportModel model)
{
using (var dal = FactoryDispatcher.UserFactory())
{
return(dal.AddAppUserReport(model));
}
}
public void Report(int skillId, string level)
{
int rate = 1;
switch (level)
{
case "Novice":
rate = 1; break;
case "Intermediate":
rate = 2; break;
case "Advanced":
rate = 3;
break;
}
var ratings = _ratingService.GetSkillRatings(skillId).Where(r => r.Value == rate);
var ratingEntities = ratings as IList <RatingEntity> ?? ratings.ToList();
var users = new List <UserReportModel>();
foreach (var rating in ratingEntities)
{
var user = _userService.GetUserEntity(rating.UserId);
var userReport = new UserReportModel()
{
Login = user.Login,
Email = user.Email,
Level = rating.Value
};
users.Add(userReport);
}
RT.ViewPDF(new ReportTableLayout(users), "KnowledgeManagerReport.pdf");
}
protected void userReportsControl_OnAddChild(object sender, GenericEventArgs <Guid> e)
{
mainUserReportControl.Visible = false;
subUserReportControl.Visible = true;
var model = new UserReportModel
{
ParentID = e.Value
};
subUserReportControl.Model = model;
mpeAddEdit.Show();
}
public ApiResponse GetIndex()
{
int pageSize = 5;
UserReportModel report = userBll.GetUserReport(GetCurrentUserId());
List <Notice> noticeList = ncBase.CurrentEntities.Notice.Where(n => n.Type != 0).OrderByDescending(n => n.CreateTime).Take(pageSize).ToList();
var list = new
{
Report = report,
NoticeList = noticeList != null?noticeList.Select(s => new {
s.NoticeId,
NoticeContent = "http://" + HttpContext.Current.Request.Url.Host + "/notice/phoneview?noticeId=" + s.NoticeId,
s.Title,
CreateTime = DateTimeUtility.ToUnixTime(Convert.ToDateTime(s.CreateTime))
}) : null,
};
return(new ApiResponse(Metas.SUCCESS, list));
}
//用户报表(饼图)
public UserReportModel GetUserReport()
{
UserReportModel userReportModel = new UserReportModel();
DataTable dtList = userInfoDAL.GetUserGenderGroup();
userReportModel.title = new TitleAttribute()
{
text = "用户性别比例", x = "center"
};
userReportModel.tooltip = new TooltipAttribute()
{
formatter = "{b} : {c} ({d}%)"
};
userReportModel.legend = new LegendAttribute()
{
data = new List <string> {
"男", "女"
}, left = "left", orient = "vertical"
};
userReportModel.series = new List <SeriesAttribute>()
{
new SeriesAttribute()
{
type = "pie",
data = new List <SeriesDataAttribute>()
{
new SeriesDataAttribute()
{
value = (dtList.Select("gender = 0").Count() > 0)?Convert.ToInt32(dtList.Select("gender = 0")[0]["GenderCount"]):0,
name = "女"
},
new SeriesDataAttribute()
{
value = (dtList.Select("gender = 1").Count() > 0)?Convert.ToInt32(dtList.Select("gender = 1")[0]["GenderCount"]):0,
name = "男"
}
}
}
};
return(userReportModel);
}
/// <summary>
/// 使用简报
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public virtual UserReportModel GetUserReport(int userId)
{
DbCommand cmd = GetStoredProcCommand("P_Api_GetUserReport");
AddInParameter(cmd, "@userId", DbType.Int32, userId);
DataSet ds = ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
UserReportModel report = new UserReportModel()
{
ErrorUserSiteCount = To <Int32>(ds.Tables[0].Rows[0], "ErrorUserSiteCount"),
HouseCount = To <Int32>(ds.Tables[0].Rows[0], "HouseCount"),
TodayHouseCount = To <Int32>(ds.Tables[0].Rows[0], "TodayHouseCount"),
TodayPostCount = To <Int32>(ds.Tables[0].Rows[0], "TodayPostCount"),
UserSiteCount = To <Int32>(ds.Tables[0].Rows[0], "UserSiteCount"),
};
return(report);
}
return(new UserReportModel());
}
public async Task SearchForUser(string username)
{
UserReport = null;
UserReportLookupError = "";
var qParam = new QueryParam("username", username);
try
{
UserReport = await apiGateway.Get <UserReportModel>("UserReports", queryParams : qParam).ConfigureAwait(false);
if (UserReport == null)
{
UserReportLookupError = "No user found with this name";
}
}
catch (Exception ex)
{
UserReportLookupError = ex.Message;
}
NotifyStateChanged();
}
public ActionResult UseReport()
{
UserReportModel report = userBll.GetUserReport(this.GetLoginUser().UserID);
return(View(report));
}
public ActionResult GetCompanyReport(int IdCompany, int IdContract, int IdUser)
{
if (IdUser == 0)
{
List <CompanyContracts> allContracts;
var company = dataContext.Company.FirstOrDefault(com => com.Id == IdCompany);
if (IdContract == 0)
{
allContracts = company.CompanyContractList.ToList();
}
else
{
allContracts = company.CompanyContractList.Where(c => c.ContractId == IdContract).ToList();
}
var lstContratcs = new List <ContractWiseReport>();
for (int i = 0; i < allContracts.Count; i++)
{
var con = allContracts[i];
var contractGroup = new ContractWiseReport();
contractGroup.CompanyName = company.CompanyName;
contractGroup.ContractName = con.Contract.ContractName;
var lstUsage = dataContext.Usage.Where(usa => usa.ContractId == con.Id).ToList();
var lstUsers = new List <ContractUserGroup>();
double?totalCost = 0;
foreach (var usag in lstUsage)
{
var usr = new ContractUserGroup();
usr.UserName = usag.user.Name;
usr.PhoneNumber = usag.PhoneNumber;
usr.CompanyName = dataContext.Company.FirstOrDefault(c => c.Id == usag.CompanyId).CompanyName;
usr.Cost = usag.Cost;
totalCost = totalCost + usag.Cost;
lstUsers.Add(usr);
}
contractGroup.ContractUserList = lstUsers;
contractGroup.TotalCostByContract = double.Parse(totalCost.ToString());
lstContratcs.Add(contractGroup);
}
return(View("GetContractReport", lstContratcs));
}
else
{
UserReportModel usrRpt = new UserReportModel();
var user = dataContext.User.FirstOrDefault(u => u.Id == IdUser);
usrRpt.CompanyName = dataContext.Company.FirstOrDefault(com => com.Id == IdCompany).CompanyName;
usrRpt.UserName = user.Name;
double?totalCost = 0;
var lstContracts = new List <UserContracts>();
foreach (var usr in user.ContractUsageList)
{
var ctr = new UserContracts();
ctr.ContractName = usr.Contract.ContractName;
ctr.Cost = usr.Cost;
totalCost = totalCost + usr.Cost;
ctr.DataTransfer = usr.DataTransferInMb;
ctr.Minutes = usr.Minutes;
ctr.PackageUsagePercentage = usr.PackageUsagePercentage;
ctr.PhoneNumber = usr.PhoneNumber;
ctr.Quantity = usr.Quantity;
lstContracts.Add(ctr);
}
usrRpt.TotalCost = totalCost;
usrRpt.UserUsage = lstContracts;
return(View("UserReport", usrRpt));
}
}
