public void TestMethod2()
{
#region 用户统计
//新增
UsersStatSearchDTO searchdto = new UsersStatSearchDTO();
searchdto.page = 1;
searchdto.rows = 1;
testservice.GetUsersStatList(searchdto);
UsersStatOperateDTO adddto = new UsersStatOperateDTO();
adddto.UserID = 1;
adddto.UseModel = "单元测试模块";
adddto.UseModelTime = DateTime.Now;
var addresult = testservice.AddUsersStat(adddto);
searchdto.rows = 20;
var resultlist1 = testservice.GetUsersStatList(searchdto);
var target = resultlist1.Where(m => m.UseModel == "单元测试模块").FirstOrDefault();
Assert.IsNotNull(target);
//删除
UsersStatResultDTO deletedto = new UsersStatResultDTO();
deletedto.UsersStatID = target.UsersStatID;
var deleteresult = testservice.DeleteUsersStat(deletedto);
var resultlist3 = testservice.GetUsersStatList(searchdto);
target = resultlist3.Where(m => m.UsersStatID == target.UsersStatID).FirstOrDefault();
Assert.IsNull(target);
#endregion
}
public void TestMethod1()
{
//用户统计
//新增
UsersStatSearchDTO searchdto = new UsersStatSearchDTO();
searchdto.page = 1;
searchdto.rows = 1;
var searchdtostr = TransformHelper.ConvertDTOTOBase64JsonString(searchdto);
testcontroller.GetUsersStatList(searchdtostr);
UsersStatOperateDTO adddto = new UsersStatOperateDTO();
adddto.UseModel = "单元测试用户统计";
adddto.UseModelTime = DateTime.Now;
searchdto.rows = 20;
searchdtostr = TransformHelper.ConvertDTOTOBase64JsonString(searchdto);
var addresult = testcontroller.AddUsersStat(adddto);
var resultlist1 = JsonConvert.DeserializeObject <ResultDTO <List <UsersStatResultDTO> > >(testcontroller.GetUsersStatList(searchdtostr).Content.ReadAsStringAsync().Result).Object;
var target = resultlist1.Where(m => m.UseModel == "单元测试用户统计").FirstOrDefault();
Assert.IsNotNull(target);
//删除
UsersStatResultDTO deletedto = new UsersStatResultDTO();
deletedto.UsersStatID = target.UsersStatID;
var deletedtostr = TransformHelper.ConvertDTOTOBase64JsonString(deletedto);
var deleteresult = testcontroller.DeleteUsersStat(deletedtostr);
var resultlist3 = JsonConvert.DeserializeObject <ResultDTO <List <UsersStatResultDTO> > >(testcontroller.GetUsersStatList(searchdtostr).Content.ReadAsStringAsync().Result).Object;
target = resultlist3.Where(m => m.UsersStatID == target.UsersStatID).FirstOrDefault();
Assert.IsNull(target);
}
public HttpResponseMessage GetUsersStatList(string UsersStatSearchDTO)
{
UsersStatSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <UsersStatSearchDTO>(UsersStatSearchDTO);
ResultDTO <List <UsersStatResultDTO> > actionresult = new ResultDTO <List <UsersStatResultDTO> >();
try
{
actionresult.Object = _ISystemServices.GetUsersStatList(dto);
actionresult.SubmitResult = true;
actionresult.rows = dto.rows;
actionresult.page = dto.page;
actionresult.Count = dto.Count;
}
catch (Exception ex)
{
actionresult.SubmitResult = false;
actionresult.Message = ex.Message;
}
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
/// <summary>
/// 得到用户统计
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static ResultData <List <UsersStatModel> > GetUsersStatList(UsersStatSearchDTO dto)
{
ResultData <List <UsersStatModel> > result = null;
result = GetAPI <ResultData <List <UsersStatModel> > >(WebConfiger.MasterDataServicesUrl + "UsersStat?UsersStatSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(result);
}
/// <summary>
/// 得到用户统计
/// </summary>
/// <returns></returns>
public ActionResult GetUsersStatList(UsersStatSearchDTO dto)
{
ResultData <List <UsersStatModel> > result = new ResultData <List <UsersStatModel> >();
result = SystemProvider.GetUsersStatList(dto);
return(Json(new { total = result.Count, rows = result.Object }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 得到用户统计
/// </summary>
/// <returns></returns>
public List <UsersStatResultDTO> GetUsersStatList(UsersStatSearchDTO dto)
{
List <UsersStatResultDTO> result = null;
var tcdmse = SingleQueryObject.GetObj();
var pp = tcdmse.master_UsersStat.AsNoTracking().Where(p => p.UsersStatID != null);
if (!string.IsNullOrEmpty(dto.SearchText))
{
pp = pp.Where(p => p.master_UserInfo.master_DepartmentInfo.DepartName.Contains(dto.SearchText) ||
p.master_UserInfo.FullName.Contains(dto.SearchText) ||
p.master_UserInfo.PhoneNumber.Contains(dto.SearchText) ||
(dto.UserType != null && p.master_UserInfo.UserType == dto.UserType) ||
p.master_UserInfo.master_DistributorInfo.Any(m => m.DistributorName.Contains(dto.SearchText)));
}
dto.Count = pp.Count();
pp = pp.OrderByDescending(m => m.UseModelTime).ThenBy(m => m.UsersStatID).Skip((dto.page - 1) * dto.rows).Take(dto.rows);
result = Mapper.Map <List <master_UsersStat>, List <UsersStatResultDTO> >(pp.ToList());
return(result);
}
/// <summary>
/// 导出用户统计
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult ExportUsersStat(UsersStatSearchDTO dto)
{
string result = null;
dto.page = 1;
dto.rows = 10000000;
List <UsersStatModel> pp = null;
pp = SystemProvider.GetUsersStatList(dto).Object;
string strTemplateFile = Server.MapPath(@"~/TempLate/UsersStatTemplate.xlsx");
string strGenarateDir = Server.MapPath(@"~/TempFile");
string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx";
string strExportFile = strGenarateDir + "\\" + strGenarateFile;
List <object> ratelist = new List <object>();
pp.ForEach(g =>
{
Models.Model.Excel.ExcelUsersStat er = new Models.Model.Excel.ExcelUsersStat();
er.部门 = g.DepartName;
er.用户名称 = g.FullName;
er.用户类型 = g.UserTypeName;
er.手机号 = g.PhoneNumber;
er.经销商 = g.UserDistributorstr;
er.使用模块 = g.UseModel;
er.使用时间 = g.UseModelTime.HasValue?g.UseModelTime.Value.ToString("yyyy-MM-dd HH:mm:ss"):null;
ratelist.Add(er);
});
if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1"))
{
result = strGenarateFile;
}
return(Json(result));
}
