public async Task <APIResult> GetAllDoItemList(string userId, string searchdate)
{
//日历
string spName1 = @"up_RMMT_CAL_GetCalenderPlansListAllWeb_R02";
DynamicParameters dp1 = new DynamicParameters();
dp1.Add("@Date", searchdate, DbType.String);
dp1.Add("@UserId", userId, DbType.Int64);
//待办事项
string spName2 = @"up_RMMT_Home_GetAllDoItemList_R";
DynamicParameters dp2 = new DynamicParameters();
dp2.Add("@InUserId", userId, DbType.Int64);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
try
{
//日历
IEnumerable <EachDayTypeDto> calenderListAllDtolist = await conn.QueryAsync <EachDayTypeDto>(spName1, dp1, null, null, CommandType.StoredProcedure);
//待办事项
var itemManys = await conn.QueryMultipleAsync(spName2, dp2, null, null, CommandType.StoredProcedure);
ItemResultDto dto = itemManys.ReadFirstOrDefault <ItemResultDto>();
if (dto == null)
{
dto = new ItemResultDto();
}
var firstList = itemManys.Read <DoItemDto>();
var secondList = itemManys.Read <DoItemDto>();
dto.FirstItemList.AddRange(calenderListAllDtolist);
dto.SecondItemList.AddRange(firstList);
dto.ThirdItemList.AddRange(secondList);
APIResult result = new APIResult {
Body = CommonHelper.EncodeDto <ItemResultDto>(dto), ResultCode = ResultType.Success, Msg = ""
};
return(result);
}
catch (Exception ex)
{
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
}
}
private async Task <List <MessageDto> > GetMessageData2()
{
try
{
var result = await _noticeMngService.AllItemsForMobile(CommonContext.Account.UserId);
if (result.ResultCode == Module.ResultType.Success)
{
ItemResultDto dto = CommonHelper.DecodeString <ItemResultDto>(result.Body);
List <MessageDto> list = new List <MessageDto>();
if (dto != null)
{
foreach (var item in dto.SecondItemList)
{
if (!string.IsNullOrEmpty(item.Title))
{
list.Add(new MessageDto()
{
MessageContent = "[" + item.TypeName + "]" + item.Title, Id = item.Id, Status = item.Status, DataType = item.DataType
});
}
}
foreach (var item in dto.ThirdItemList)
{
if (!string.IsNullOrEmpty(item.Title))
{
list.Add(new MessageDto()
{
MessageContent = "[未读通知]" + item.Title.Substring(item.Title.IndexOf(',') + 1), Id = item.Id, Status = item.Status, DataType = item.DataType
});
}
}
}
int i = 1;
list.Select(c => { c.SeqNo = i++; return(c); }).ToList();
return(list);
}
}
catch (Exception)
{
}
return(null);
}
public async Task <APIResult> GetAllDoItemListForMobile(string userId)
{
//待办事项
string spName = @"up_RMMT_Home_GetAllDoItemListForMobile_R";
DynamicParameters dp = new DynamicParameters();
dp.Add("@InUserId", userId, DbType.Int64);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
try
{
//待办事项
var itemManys = await conn.QueryMultipleAsync(spName, dp, null, null, CommandType.StoredProcedure);
ItemResultDto dto = itemManys.ReadFirstOrDefault <ItemResultDto>();
if (dto == null)
{
dto = new ItemResultDto();
}
var firstList = itemManys.Read <DoItemDto>();
var secondList = itemManys.Read <DoItemDto>();
dto.SecondItemList.AddRange(firstList);
dto.ThirdItemList.AddRange(secondList);
APIResult result = new APIResult {
Body = CommonHelper.EncodeDto <ItemResultDto>(dto), ResultCode = ResultType.Success, Msg = ""
};
return(result);
}
catch (Exception ex)
{
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
}
}
