public void TestMethod1()
{
#region 短信统计
//新增
MessageSearchDTO searchdto = new MessageSearchDTO();
searchdto.page = 1;
searchdto.rows = 1;
testservice.GetMessageStatList(searchdto);
List <MessageOperateDTO> dtolist = new List <MessageOperateDTO>();
dtolist.Add(new MessageOperateDTO
{
MessageType = -1,
SendTime = DateTime.Now,
UserID = 1
});
var addresult = testservice.AddMessageStat(dtolist);
searchdto.rows = 20;
var resultlist1 = testservice.GetMessageStatList(searchdto);
var target = resultlist1.Where(m => m.MessageType == -1).FirstOrDefault();
Assert.IsNotNull(target);
//删除
MessageResultDTO deletedto = new MessageResultDTO();
deletedto.MessageStatID = target.MessageStatID;
var deleteresult = testservice.DeleteMessageStat(deletedto);
var resultlist3 = testservice.GetMessageStatList(searchdto);
target = resultlist3.Where(m => m.MessageStatID == target.MessageStatID).FirstOrDefault();
Assert.IsNull(target);
#endregion
}
public HttpResponseMessage GetMessageStatList(string MessageSearchDTO)
{
MessageSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <MessageSearchDTO>(MessageSearchDTO);
ResultDTO <List <MessageResultDTO> > actionresult = new ResultDTO <List <MessageResultDTO> >();
try
{
actionresult.Object = _ISystemServices.GetMessageStatList(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 <MessageStatModel> > GetMessageStatList(MessageSearchDTO dto)
{
ResultData <List <MessageStatModel> > result = null;
result = GetAPI <ResultData <List <MessageStatModel> > >(WebConfiger.MasterDataServicesUrl + "MessageStat?MessageSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(result);
}
/// <summary>
/// 得到短信统计
/// </summary>
/// <returns></returns>
public ActionResult GetMessageStatList(MessageSearchDTO dto)
{
ResultData <List <MessageStatModel> > result = new ResultData <List <MessageStatModel> >();
result = SystemProvider.GetMessageStatList(dto);
return(Json(new { total = result.Count, rows = result.Object }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 得到短信统计
/// </summary>
/// <returns></returns>
public List <MessageResultDTO> GetMessageStatList(MessageSearchDTO dto)
{
List <MessageResultDTO> result = null;
var tcdmse = SingleQueryObject.GetObj();
var pp = tcdmse.master_MessageStat.AsNoTracking().Where(p => p.MessageStatID != 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) ||
p.master_UserInfo.master_DistributorInfo.Any(m => m.DistributorName.Contains(dto.SearchText)));
}
dto.Count = pp.Count();
pp = pp.OrderByDescending(m => m.SendTime).ThenBy(m => m.MessageStatID).Skip((dto.page - 1) * dto.rows).Take(dto.rows);
result = Mapper.Map <List <master_MessageStat>, List <MessageResultDTO> >(pp.ToList());
return(result);
}
public void TestMethod1()
{
//短信统计
//新增
MessageSearchDTO searchdto = new MessageSearchDTO();
searchdto.page = 1;
searchdto.rows = 1;
var searchdtostr = TransformHelper.ConvertDTOTOBase64JsonString(searchdto);
testcontroller.GetMessageStatList(searchdtostr);
List <MessageOperateDTO> dtolist = new List <MessageOperateDTO>();
dtolist.Add(new MessageOperateDTO
{
MessageType = -1,
SendTime = DateTime.Now,
UserID = 1
});
var addresult = testcontroller.AddMessageStat(dtolist);
searchdto.rows = 20;
var resultlist1 = JsonConvert.DeserializeObject <ResultDTO <List <MessageResultDTO> > >(testcontroller.GetMessageStatList(searchdtostr).Content.ReadAsStringAsync().Result).Object;
var target = resultlist1.Where(m => m.MessageType == -1).FirstOrDefault();
Assert.IsNotNull(target);
//删除
MessageResultDTO deletedto = new MessageResultDTO();
deletedto.MessageStatID = target.MessageStatID;
var deletedtostr = TransformHelper.ConvertDTOTOBase64JsonString(deletedto);
var deleteresult = testcontroller.DeleteMessageStat(deletedtostr);
var resultlist3 = JsonConvert.DeserializeObject <ResultDTO <List <MessageResultDTO> > >(testcontroller.GetMessageStatList(searchdtostr).Content.ReadAsStringAsync().Result).Object;
target = resultlist3.Where(m => m.MessageStatID == target.MessageStatID).FirstOrDefault();
Assert.IsNull(target);
}
/// <summary>
/// 导出短信统计
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult ExportMessageStat(MessageSearchDTO dto)
{
string result = null;
dto.page = 1;
dto.rows = 10000000;
List <MessageStatModel> pp = null;
pp = SystemProvider.GetMessageStatList(dto).Object;
string strTemplateFile = Server.MapPath(@"~/TempLate/MessageStatTemplate.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.ExcelMessageStat er = new Models.Model.Excel.ExcelMessageStat();
er.部门 = g.DepartName;
er.用户名称 = g.FullName;
er.用户类型 = g.UserTypeName;
er.手机号 = g.PhoneNumber;
er.经销商 = g.UserDistributorstr;
er.短信分类 = g.MessageTypeStr;
er.发送日期 = g.SendTime.HasValue ? g.SendTime.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));
}
