// 获取本志愿者针对该互助信息 上传结果信息 （互助ID标识ContentID、志愿者唯一VID、擅长技能TypeID为空不传参数 ）
public List <VHA_HandleGetMyResModel> GetMyHandleInfo(string VID, string ContentID)
{
List <VHA_HandleGetMyResModel> MyList = new List <VHA_HandleGetMyResModel>();
List <VHA_Handle> handleList = _IVHA_HandleRepository.GetMyHandle(VID, ContentID);
foreach (var itme in handleList)
{
VHA_HandleGetMyResModel resModel = new VHA_HandleGetMyResModel();
List <VAttachment> list = _IVAttachmentRepository.GetMyList(itme.ID);
List <VAttachmentAddViewModel> newlist = _IMapper.Map <List <VAttachment>, List <VAttachmentAddViewModel> >(list);
//获取审核 信息
VHA_Sign res = _IVHA_SignRepository.GetMySign(itme.ID);
resModel.opinion = res.opinion;
resModel.opinionTime = res.UpdateDate.ToString();
resModel.contents = itme.Results;
resModel.time = itme.CreateDate.ToString();
resModel.VAttachmentList = newlist;
MyList.Add(resModel);
}
return(MyList);
}
public ActionResult <VHA_HandleGetListResModel> GetHandleInfo(SearchByContentIDModel idModel)
{
//查找到 最新的一条 结果记录
VHA_Sign sign = _VHelpAreaByVService.GetVHandleList(idModel.ContentID, "2");
VHA_HandleGetListResModel MyResModel = new VHA_HandleGetListResModel();
MyResModel.isSuccess = true;
if (sign != null && sign.ID != null)
{
MyResModel.Signtime = DateTime.Parse(sign.CreateDate.ToString());
//获取 查看该互助信息对应的认领人 的具体信息
VHA_SignInfoMiddle infoMiddle = _VHelpAreaByVService.GetVDetail(sign.VID);
MyResModel.middle = infoMiddle;
MyResModel.List = _VHelpAreaByVService.GetMyHandleInfo(sign.VID, idModel.ContentID);
MyResModel.TotalNum = MyResModel.List.Count();
}
else
{
MyResModel.Signtime = DateTime.Now;
}
MyResModel.baseViewModel.Message = "请求正常";
MyResModel.baseViewModel.ResponseCode = 200;
return(MyResModel);
}
//志愿者互助信息退出功能 （互助ID标识ContentID、志愿者唯一VID、擅长技能TypeID为空不传参数）
public string SetStatusBack(string VID, string ContentID)
{
string status = string.Empty;
VHA_Sign res = new VHA_Sign();
//查询条件
var predicate = WhereExtension.True <VHA_Sign>();//初始化where表达式
if (!String.IsNullOrEmpty(VID))
{
predicate = predicate.And(p => p.VID.Equals(VID));
}
if (!String.IsNullOrEmpty(ContentID))
{
predicate = predicate.And(p => p.ContentID.Equals(ContentID));
}
var result = DbSet.Where(predicate).OrderByDescending(o => o.CreateDate).ToList();
if (result.Count > 0)
{
res = result.First();
res.Status = "3";
Update(res);
int a = SaveChanges();
if (a > 0)
{
status = "success";
}
else
{
status = "fail";
}
}
return(status);
}
//发布者审核 认领人上传的 处理结果信息 审核不通过，志愿者重新上传处理结果
public BaseViewModel SetSignReturn(ContentIDandVIDModel model)
{
BaseViewModel result = new BaseViewModel();
//该互助信息
VHelpArea area = _IVHelpAreaRepository.SearchInfoByID(model.ContentID);
//获取 志愿者 上传的 处理结果的信息进行审核
List <VHA_Sign> list = _IVHA_SignRepository.GetByContentID(model.ContentID, "2");
VHA_Sign item = list.First();
item.opinion = "审核不通过，志愿者重新上传处理结果";
item.Status = "2";
item.UpdateUser = area.CreateUser;
item.UpdateDate = DateTime.Now;
_IVHA_SignRepository.Update(item);
int a = _IVHA_SignRepository.SaveChanges();
//本次处理结果 审核信息通过
VHA_Handle modelHandle = _IVHA_HandleRepository.GetVolunteerHandle(item.bak1);
modelHandle.Status = "2";
modelHandle.UpdateUser = area.CreateUser;
modelHandle.UpdateDate = DateTime.Now;
_IVHA_HandleRepository.Update(modelHandle);
int b = _IVHA_HandleRepository.SaveChanges();
if (b > 0)
{
//提示信息：您认领标题为XXX互助信息，互助信息，处理审核不通过，请重新上传处理结果
Volunteer_MessageMiddle middle = new Volunteer_MessageMiddle();
middle.Contents = "您认领标题为 " + area.Title + " 互助信息，处理审核不通过，请重新上传处理结果";
Volunteer_Info volunteer_Info = _IVolunteerInfoRepository.SearchInfoByID(model.VID);
middle.Name = volunteer_Info.Name;
middle.VID = volunteer_Info.ID;
middle.VNO = volunteer_Info.VNO;
Volunteer_Message message = _IMapper.Map <Volunteer_MessageMiddle, Volunteer_Message>(middle);
message.ID = Guid.NewGuid().ToString();
message.CreateDate = DateTime.Now;
message.CreateUser = model.VID;
message.Status = "0";
_IVolunteer_MessageRepository.Add(message);
int f = _IVolunteer_MessageRepository.SaveChanges();
result.ResponseCode = 200;
result.Message = "操作成功";
}
else
{
result.ResponseCode = 400;
result.Message = "操作失败";
}
return(result);
}
// 获取 查看该互助信息对应的认领人 上传结果列表
public VHA_Sign GetVHandleList(string ContentID, string status)
{
VHA_Sign resModel = new VHA_Sign();
List <VHA_Sign> list = _IVHA_SignRepository.GetByContentID(ContentID, status);
if (list.Count > 0)
{
resModel = list.First();
}
return(resModel);
}
//通过 handle 查找 sign记录表里的 opinion 审核意见
public VHA_Sign GetMySign(string handleID)
{
VHA_Sign res = new VHA_Sign();
//查询条件
var predicate = WhereExtension.True <VHA_Sign>();//初始化where表达式
if (!String.IsNullOrEmpty(handleID))
{
predicate = predicate.And(p => p.bak1.Equals(handleID));
}
var result = DbSet.Where(predicate).ToList();
if (result.Count > 0)
{
res = result.First();
}
return(res);
}
public ActionResult <VHA_SignInfoMiddle> GetVDetail(ContentIDandVIDModel vidModel)
{
VHA_SignInfoMiddle model = new VHA_SignInfoMiddle();
model = _VHelpAreaByVService.GetVDetail(vidModel.VID);
//查找到 最新的一条 结果记录
VHA_Sign sign = _VHelpAreaByVService.GetVHandleList(vidModel.ContentID, "1");
if (sign != null && sign.ID != null)
{
model.Signtime = DateTime.Parse(sign.CreateDate.ToString());
}
else
{
model.Signtime = DateTime.Now;
}
return(model);
}
//查看 认领人上传的 处理结果信息
public List <VHA_HandleGetMyResModel> GetMyHandleInfo(string VID, string ContentID)
{
List <VHA_HandleGetMyResModel> MyList = new List <VHA_HandleGetMyResModel>();
List <VHA_Handle> handleList = _IVHA_HandleRepository.GetMyHandle(VID, ContentID);
//获取 志愿者 上传的 处理结果的信息进行审核
List <VHA_Sign> listSign = _IVHA_SignRepository.GetByContentID(ContentID, "2");
List <VHA_Sign> newSign = new List <VHA_Sign>();
foreach (var itme in handleList)
{
newSign = listSign.Where(o => o.bak1.Equals(itme.ID)).ToList();
VHA_Sign middle = new VHA_Sign();
if (newSign.Count > 0)
{
middle = newSign.First();
}
VHA_HandleGetMyResModel resModel = new VHA_HandleGetMyResModel();
List <VAttachment> list = _IVAttachmentRepository.GetMyList(itme.ID);
List <VAttachmentAddViewModel> newlist = _IMapper.Map <List <VAttachment>, List <VAttachmentAddViewModel> >(list);
resModel.contents = itme.Results;
resModel.time = itme.CreateDate.ToString();
if (middle == null || middle.ID == null)
{
resModel.opinion = "";
resModel.opinionTime = "";
}
else
{
resModel.opinion = middle.opinion;
resModel.opinionTime = middle.UpdateDate.ToString();
}
resModel.VAttachmentList = newlist;
MyList.Add(resModel);
}
return(MyList);
}
//根据 contentID，VID 获取 该志愿者针对该互助信息 最新状态
public VHA_Sign GetNewSign(string VID, string ContentID)
{
VHA_Sign res = new VHA_Sign();
//查询条件
var predicate = WhereExtension.True <VHA_Sign>();//初始化where表达式
if (!String.IsNullOrEmpty(VID))
{
predicate = predicate.And(p => p.VID.Equals(VID));
}
if (!String.IsNullOrEmpty(ContentID))
{
predicate = predicate.And(p => p.ContentID.Equals(ContentID));
}
var result = DbSet.Where(predicate).OrderByDescending(o => o.CreateDate).ToList();
if (result.Count > 0)
{
res = result.First();
}
return(res);
}
//获取本志愿者针对该互助信息 所有状态 （互助ID标识ContentID、志愿者唯一VID、擅长技能TypeID为空不传参数 ）
public BaseViewModel GetVHAStatus(string VID, string ContentID)
{
BaseViewModel result = new BaseViewModel();
VHA_Sign res = _IVHA_SignRepository.GetNewSign(VID, ContentID);
if (!String.IsNullOrEmpty(res.ID))
{
if (res.flag.Equals("1"))
{
if (res.Status.Equals("0"))
{
result.ResponseCode = 1;
result.Message = "认领审核中";
}
else if (res.Status.Equals("1"))
{
result.ResponseCode = 2;
result.Message = "认领审核通过，上传处理结果";
}
else if (res.Status.Equals("2"))
{
result.ResponseCode = 3;
result.Message = "认领审核不通过";
}
else if (res.Status.Equals("3"))
{
result.ResponseCode = 4;
result.Message = "认领审核通过，志愿者主动退回，该志愿者本次互助任务终止";
}
}
else if (res.flag.Equals("2"))
{
if (res.Status.Equals("0"))
{
result.ResponseCode = 5;
result.Message = "处理结果审核中";
}
else if (res.Status.Equals("1"))
{
result.ResponseCode = 6;
result.Message = "处理结果审核通过，任务完结";
}
else if (res.Status.Equals("2"))
{
result.ResponseCode = 7;
result.Message = "处理结果审核不通过，请志愿者重新上传";
}
else if (res.Status.Equals("3"))
{
if (!String.IsNullOrEmpty(res.opinion))
{
result.ResponseCode = 8;
result.Message = "处理结果审核不通过，发布者退回，该志愿者本次互助任务终止";
}
else
{
result.ResponseCode = 9;
result.Message = "处理结果审核不通过，志愿者主动退回，该志愿者本次互助任务终止";
}
}
}
}
else
{
VHelpArea item = _IVHelpAreaRepository.SearchInfoByID(ContentID);
if (!String.IsNullOrEmpty(item.ID))
{
if (item.Status.Equals("0"))
{
result.ResponseCode = 11;
result.Message = "未认领";
}
else if (item.Status.Equals("1"))
{
result.ResponseCode = 12;
result.Message = "已认领";
}
else if (item.Status.Equals("2"))
{
result.ResponseCode = 13;
result.Message = "已完结";
}
}
else
{
result.ResponseCode = 10;
result.Message = "该互助信息有问题，请联系志愿者后台调整。";
}
}
return(result);
}
//志愿者上传互助信息处理结果
public int HandleAdd(VHA_HandleAddModel AddViewModel)
{
int a = 0;
var VolunteerInfo = _IVolunteerInfoRepository.SearchInfoByID(AddViewModel.VID);
if (VolunteerInfo == null)
{
a = 9;
return(a);
}
var model = _IMapper.Map <VHA_HandleAddModel, VHA_Handle>(AddViewModel);
model.ID = Guid.NewGuid().ToString();
model.VNO = VolunteerInfo.VNO;
model.Participant = VolunteerInfo.Name;
model.Status = "0";
model.CreateUser = VolunteerInfo.ID;
model.CreateDate = DateTime.Now;
_IVHA_HandleRepository.Add(model);
a = _IVHA_HandleRepository.SaveChanges();
int c = 0;
var AttachmentInfo = _IMapper.Map <List <VAttachmentAddViewModel>, List <VAttachment> >(AddViewModel.VAttachmentAddList);
foreach (var item in AttachmentInfo)
{
item.ID = Guid.NewGuid().ToString();
item.formid = model.ID;
item.type = "HZJG";
item.Status = "0";
item.CreateUser = AddViewModel.VID;
item.CreateDate = DateTime.Now;
_IVAttachmentRepository.Add(item);
c = _IVAttachmentRepository.SaveChanges() + c;
}
VHA_Sign vha_Sign = new VHA_Sign();
vha_Sign.ID = Guid.NewGuid().ToString();
vha_Sign.ContentID = AddViewModel.ContentID;
vha_Sign.VID = AddViewModel.VID;
vha_Sign.VNO = VolunteerInfo.VNO;
vha_Sign.Participant = VolunteerInfo.Name;
vha_Sign.Status = "0";
vha_Sign.flag = "2";
vha_Sign.CreateUser = VolunteerInfo.ID;
vha_Sign.CreateDate = DateTime.Now;
vha_Sign.bak1 = model.ID;
_IVHA_SignRepository.Add(vha_Sign);
int d = _IVHA_SignRepository.SaveChanges();
///获取本次互助任务信息
VHelpArea area = _IVHelpAreaRepository.SearchInfoByID(AddViewModel.ContentID);
//提示信息：您已上传标题为XXX互助信息的处理结果，等待审核
Volunteer_MessageMiddle middle = new Volunteer_MessageMiddle();
middle.Contents = "您已上传标题为 " + area.Title + " 互助信息的处理结果，等待审核";
middle.Name = VolunteerInfo.Name;
middle.VID = VolunteerInfo.ID;
middle.VNO = VolunteerInfo.VNO;
Volunteer_Message message = _IMapper.Map <Volunteer_MessageMiddle, Volunteer_Message>(middle);
message.ID = Guid.NewGuid().ToString();
message.CreateDate = DateTime.Now;
message.CreateUser = model.VID;
message.Status = "0";
_IVolunteer_MessageRepository.Add(message);
int f = _IVolunteer_MessageRepository.SaveChanges();
return(a);
}
//发布者审核 认领人上传的 处理结果信息 审核通过任务完结
public BaseViewModel SetSignPass(ContentIDandVIDModel model)
{
BaseViewModel result = new BaseViewModel();
var VolunteerInfo = _IVolunteerInfoRepository.SearchInfoByID(model.VID);
if (VolunteerInfo == null)
{
result.ResponseCode = 400;
result.Message = "操作失败";
return(result);
}
//该互助信息 更新状态为 已完结 2
VHelpArea area = _IVHelpAreaRepository.SearchInfoByID(model.ContentID);
//获取 志愿者 上传的 处理结果的信息进行审核
List <VHA_Sign> list = _IVHA_SignRepository.GetByContentID(model.ContentID, "2");
VHA_Sign item = list.First();
item.opinion = "审核通过，任务完结";
item.Status = "1";
item.UpdateUser = area.CreateUser;
item.UpdateDate = DateTime.Now;
_IVHA_SignRepository.Update(item);
int a = _IVHA_SignRepository.SaveChanges();
//本次处理结果 审核信息通过
VHA_Handle modelHandle = _IVHA_HandleRepository.GetVolunteerHandle(item.bak1);
modelHandle.Status = "1";
modelHandle.UpdateUser = area.CreateUser;
modelHandle.UpdateDate = DateTime.Now;
_IVHA_HandleRepository.Update(modelHandle);
int b = _IVHA_HandleRepository.SaveChanges();
area.Status = "2";
area.UpdateUser = area.CreateUser;
area.UpdateDate = DateTime.Now;
_IVHelpAreaRepository.Update(area);
int c = _IVHelpAreaRepository.SaveChanges();
if (c > 0)
{
string id = Guid.NewGuid().ToString();
//插入积分表
Volunteer_Score score = new Volunteer_Score();
score.ID = id;
score.ContentID = model.ContentID;
score.tableName = "VHelpArea";
score.VID = model.VID;
score.type = "done";
score.Score = double.Parse(area.Score);
score.CreateUser = model.VID;
score.CreateDate = DateTime.Now;
_IVolunteer_ScoreRepository.Add(score);
int n = _IVolunteer_ScoreRepository.SaveChanges();
if (n > 0)
{
//插入到 泰便利积分表 20200622
ET_points ipointMiddle = new ET_points();
ipointMiddle.ID = id;
ipointMiddle.uid = VolunteerInfo.ID;
ipointMiddle.points = double.Parse(area.Score);
ipointMiddle.type = "VolunteerHelp";
ipointMiddle.tableName = "TedaVolunteerDB.dbo.Volunteer_Score";
ipointMiddle.CreateUser = VolunteerInfo.ID;
ipointMiddle.CreateDate = DateTime.Now;
eT_PointsRepository.Add(ipointMiddle);
int j = eT_PointsRepository.SaveChanges();
}
//提示信息：您认领标题为XXX互助信息，互助信息，处理审核通过，任务完结
Volunteer_MessageMiddle middle = new Volunteer_MessageMiddle();
middle.Contents = "您认领标题为 " + area.Title + " 互助信息，处理审核通过，任务完结";
Volunteer_Info volunteer_Info = _IVolunteerInfoRepository.SearchInfoByID(model.VID);
middle.Name = volunteer_Info.Name;
middle.VID = volunteer_Info.ID;
middle.VNO = volunteer_Info.VNO;
Volunteer_Message message = _IMapper.Map <Volunteer_MessageMiddle, Volunteer_Message>(middle);
message.ID = Guid.NewGuid().ToString();
message.CreateDate = DateTime.Now;
message.CreateUser = model.VID;
message.Status = "0";
_IVolunteer_MessageRepository.Add(message);
int f = _IVolunteer_MessageRepository.SaveChanges();
result.ResponseCode = 200;
result.Message = "操作成功";
}
else
{
result.ResponseCode = 400;
result.Message = "操作失败";
}
return(result);
}
public virtual void Update(VHA_Sign obj)
{
DbSet.Update(obj);
}
public virtual void Add(VHA_Sign obj)
{
DbSet.Add(obj);
}
