public IHttpActionResult Post(ServiceDepositGrant request)
{
var response = new BaseResponse <ServiceDepositGrant>();
response = service.SaveServiceDepositGrant(request);
return(Ok(response));
}
/// <summary>
/// 服务保证金拨付
/// </summary>
/// <param name="request">请求实体</param>
/// <returns>返回信息</returns>
public BaseResponse <ServiceDepositGrant> SaveServiceDepositGrant(ServiceDepositGrant request)
{
var response = new BaseResponse <ServiceDepositGrant>();
var now = DateTime.Now;
//unitOfWork.BeginTransaction();
#region 向保证金拨付表中增加一条记录
request.CreateBy = SecurityHelper.CurrentPrincipal.UserId.ToString();
request.CreateTime = DateTime.Now;
request.IsDelete = false;
response = base.Save <NCIP_SERVICEDEPOSITGRANT, ServiceDepositGrant>(request, (q) => q.SDGRANTID == request.SdGrantid);
#region 更新保证金表中的信息状态
var SerDepo = unitOfWork.GetRepository <NCIP_SERVICEDEPOSIT>().dbSet.Where(m => m.NSID == request.NsId && m.YEARMONTH.Contains(request.Year) && m.STATUS == 0 && m.ISDELETE == false);
if (SerDepo != null)
{
foreach (var sd in SerDepo)
{
sd.SDGRANTID = request.SdGrantid;
sd.STATUS = 1;
sd.UPDATEBY = SecurityHelper.CurrentPrincipal.UserId.ToString();
sd.UPDATETIME = DateTime.Now;
//unitOfWork.GetRepository<NCIP_SERVICEDEPOSIT>().Update(SerDepo);
}
}
unitOfWork.Save();
#endregion
//unitOfWork.Commit();
#endregion
return(response);
}
public object GetServiceDepositGrantByNsNo(string nsNo, int CurrentPage, int PageSize)
{
string months = "";
var org = unitOfWork.GetRepository <NCI_NURSINGHOME>().dbSet.Where(w => w.NSNO == nsNo).FirstOrDefault();
if (org == null)
{
return(null);
}
BaseResponse <IList <ServiceDepositGrant> > response = new BaseResponse <IList <ServiceDepositGrant> >();
Mapper.CreateMap <NCIP_SERVICEDEPOSITGRANT, ServiceDepositGrant>();
var q = from m in unitOfWork.GetRepository <NCIP_SERVICEDEPOSITGRANT>().dbSet
select m;
q = q.Where(m => m.ISDELETE != true);
if (Convert.ToInt32(org.NSID) != -1)
{
q = q.Where(m => m.NSID == org.NSID);
}
q = q.OrderByDescending(m => new { m.YEAR, m.CREATETIME });
response.RecordsCount = q.Count();
Action <IList> mapperResponse = (IList list) =>
{
response.Data = new List <ServiceDepositGrant>();
foreach (dynamic item in list)
{
months = "";
ServiceDepositGrant newItem = Mapper.DynamicMap <ServiceDepositGrant>(item);
var month = from m in unitOfWork.GetRepository <NCIP_SERVICEDEPOSIT>().dbSet
select m;
month = month.Where(m => m.SDGRANTID == newItem.SdGrantid);
foreach (var mon in month.ToList())
{
var monthList = mon.YEARMONTH.Split(new string[] { "-" }, StringSplitOptions.RemoveEmptyEntries).ToList();
months += monthList[1] + ",";
}
newItem.Months = months.TrimEnd(',');
response.Data.Add(newItem);
}
};
if (PageSize > 0)
{
var list = q.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList();
response.PagesCount = GetPagesCount(PageSize, response.RecordsCount);
mapperResponse(list);
}
else
{
var list = q.ToList();
mapperResponse(list);
}
return(response);
}
/// <summary>
///查询服务保证金拨付记录
/// </summary>
/// <param name="request">请求实体</param>
/// <returns>Response</returns>
public BaseResponse <IList <ServiceDepositGrant> > QueryServiceDepositGrantList(BaseRequest <ServiceDepositGrantFilter> request)
{
string months = "";
BaseResponse <IList <ServiceDepositGrant> > response = new BaseResponse <IList <ServiceDepositGrant> >();
Mapper.CreateMap <NCIP_SERVICEDEPOSITGRANT, ServiceDepositGrant>();
var q = from m in unitOfWork.GetRepository <NCIP_SERVICEDEPOSITGRANT>().dbSet
select m;
q = q.Where(m => m.ISDELETE != true);
if (Convert.ToInt32(request.Data.NSID) != -1)
{
q = q.Where(m => m.NSID == request.Data.NSID);
}
q = q.OrderByDescending(m => new { m.YEAR, m.CREATETIME });
response.RecordsCount = q.Count();
Action <IList> mapperResponse = (IList list) =>
{
response.Data = new List <ServiceDepositGrant>();
foreach (dynamic item in list)
{
months = "";
ServiceDepositGrant newItem = Mapper.DynamicMap <ServiceDepositGrant>(item);
var month = from m in unitOfWork.GetRepository <NCIP_SERVICEDEPOSIT>().dbSet
select m;
month = month.Where(m => m.SDGRANTID == newItem.SdGrantid);
foreach (var mon in month.ToList())
{
var monthList = mon.YEARMONTH.Split(new string[] { "-" }, StringSplitOptions.RemoveEmptyEntries).ToList();
months += monthList[1] + ",";
}
newItem.Months = months.TrimEnd(',');
response.Data.Add(newItem);
}
};
if (request != null && request.PageSize > 0)
{
var list = q.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList();
response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount);
mapperResponse(list);
}
else
{
var list = q.ToList();
mapperResponse(list);
}
return(response);
}
