/// <summary> /// 保存实体数据(新增、修改) /// <param name="keyValue">主键</param> /// <summary> /// <returns></returns> public void SaveEntity(int keyValue, dm_taskEntity entity) { try { if (keyValue > 0) { entity.Modify(keyValue); this.BaseRepository("dm_data").Update(entity); } else { entity.Create(); this.BaseRepository("dm_data").Insert(entity); } } catch (Exception ex) { if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } }
public void UpdateSortValue(int task_id, int sort_value) { try { dm_taskEntity dm_TaskEntity = this.BaseRepository("dm_data").FindEntity <dm_taskEntity>(task_id); if (dm_TaskEntity.IsEmpty()) { throw new Exception("异常任务!"); } dm_TaskEntity.sort = sort_value; dm_TaskEntity.Modify(task_id); this.BaseRepository("dm_data").Update(dm_TaskEntity); } catch (Exception ex) { if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } }
/// <summary> /// web端发布任务不用扣除余额,直接发就好 /// </summary> /// <param name="entity"></param> public void ReleaseTaskByWeb(dm_taskEntity entity) { try { if (entity.singlecommission <= 0) { throw new Exception("任务佣金不能小于0!"); } if (entity.needcount <= 0) { throw new Exception("任务参与数不能小于0!"); } if (entity.id > 0) { entity.Modify(entity.id); this.BaseRepository("dm_data").Update(entity); } else { UserInfo userInfo = LoginUserInfo.Get(); entity.totalcommission = entity.singlecommission * entity.needcount; //需要从用户账户扣除的金额 dm_basesettingEntity dm_BaseSettingEntity = dm_BaseSettingService.GetEntityByCache(userInfo.companyId); entity.seniorcommission = Math.Round((entity.singlecommission * dm_BaseSettingEntity.task_do_senior) / 100, 2); //高级代理佣金 entity.juniorcommission = Math.Round((entity.singlecommission * dm_BaseSettingEntity.task_do_junior) / 100, 2); //初级代理佣金 entity.servicefee = Math.Round((entity.singlecommission * dm_BaseSettingEntity.task_servicefee) / 100, 2); //任务服务费(奖励在服务费中分发) entity.task_no = DateTime.Now.ToString("yyyyMMddHHmmssfff") + entity.user_id.ToString().PadLeft(6, '0'); entity.sort = GetSort(null, entity.totalcommission); entity.appid = userInfo.companyId; entity.Create(); entity.plaform = 0; entity.task_status = 0; this.BaseRepository("dm_data").Insert(entity); } } catch (Exception ex) { if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } }
public void CancelByReleasePerson(int task_id) { IRepository db = null; try { DM_Task_ReviceService dm_Task_ReviceService = new DM_Task_ReviceService(); IEnumerable <dm_task_reviceEntity> dm_Task_ReviceEntities = dm_Task_ReviceService.GetReviceListByTaskID(task_id); if (dm_Task_ReviceEntities.Where(t => t.status == 1).Count() > 0) { throw new Exception("存在正在进行中的记录,当前任务无法取消!"); } if (dm_Task_ReviceEntities.Where(t => t.status == 2).Count() > 0) { throw new Exception("当前存在未审核的资料,任务无法取消,请审核之后重试!"); } dm_taskEntity dm_TaskEntity = GetEntity(task_id); if (dm_TaskEntity.task_status == 2) { throw new Exception("该任务已取消!"); } if (dm_TaskEntity.task_status == 1 || dm_TaskEntity.finishcount == dm_TaskEntity.needcount) { throw new Exception("该任务已完成!"); } if (dm_TaskEntity.finishcount > dm_TaskEntity.needcount) { throw new Exception("错误码:1001--任务存在异常记录,请联系管理员!"); } //取消任务 dm_TaskEntity.task_status = 2; dm_userEntity dm_UserEntity = dm_UserService.GetEntity(dm_TaskEntity.user_id); #region 存在两种退款 1、全部退 2部分退 decimal caclePrice = 0; if (dm_TaskEntity.finishcount == 0) {//全部退 caclePrice = dm_TaskEntity.totalcommission; } else {//部分退 caclePrice = Math.Round((dm_TaskEntity.needcount - dm_TaskEntity.finishcount) * dm_TaskEntity.singlecommission, 2); } dm_UserEntity.accountprice += caclePrice; #endregion dm_accountdetailEntity dm_AccountdetailEntity = new dm_accountdetailEntity { createtime = DateTime.Now, remark = "取消发布任务" + dm_TaskEntity.task_no, stepvalue = caclePrice, currentvalue = dm_UserEntity.accountprice, title = "取消发布任务", type = 13, profitLoss = CommonHelper.GetProfitLoss(13), user_id = dm_TaskEntity.user_id }; db = BaseRepository("dm_data").BeginTrans(); dm_UserEntity.Modify(dm_UserEntity.id); db.Update(dm_UserEntity); dm_TaskEntity.Modify(dm_TaskEntity.id); db.Update(dm_TaskEntity); db.Insert(dm_AccountdetailEntity); db.Commit(); } catch (Exception ex) { if (db != null) { db.Rollback(); } if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } }
public dm_task_reviceEntity AuditTask(int revice_id) { lock (_object) { IRepository db = null; try { /* * 任务审核(任务审核成功) * 1、更改任务接受表的状态 * 2、更改任务主表的完成数量 * 3、向任务接受人发送消息记录 * 4、执行返佣 */ decimal do_task_commission = 0, one_agent_commission = 0, two_agent_commission = 0, one_partners_commission = 0, two_partners_commission = 0; dm_userEntity currentUser = null, one_User = null, two_User = null, one_partners = null, two_partners = null; string currentNickName = ""; dm_task_reviceEntity dm_Task_ReviceEntity = GetEntity(revice_id); if (dm_Task_ReviceEntity.status == 4) { throw new Exception("该任务已取消,审核失败!"); } if (dm_Task_ReviceEntity.status == 1) { throw new Exception("该任务未提交资料,审核失败!"); } if (dm_Task_ReviceEntity.status == 3) { throw new Exception("该任务已审核通过,请勿重复审核!"); } dm_Task_ReviceEntity.status = 3; dm_Task_ReviceEntity.check_time = DateTime.Now; #region 修改任务主表数据 dm_taskEntity dm_TaskEntity = dm_TaskService.GetEntity(dm_Task_ReviceEntity.task_id); if (dm_TaskEntity.task_status == 2) { throw new Exception("该任务已取消,审核失败!"); } dm_TaskEntity.finishcount += 1; if (dm_TaskEntity.finishcount >= dm_TaskEntity.needcount) { dm_TaskEntity.task_status = 1; } dm_TaskEntity.Modify(dm_TaskEntity.id); #endregion if (dm_TaskEntity.isactivity == 0) { #region 任务审核消息 dm_messagerecordEntity dm_MessagerecordEntity = new dm_messagerecordEntity { isread = 0, user_id = dm_Task_ReviceEntity.user_id, messagetitle = "任务审核通过", messagecontent = "您接受的任务编号:" + dm_TaskEntity.task_no + "已审核通过,请及时查看!", messagetype = 3, createtime = DateTime.Now }; #endregion #region 执行返佣 /*做任务人根据等级返佣金*/ /*上级从服务费中计算佣金*/ //获取上下级关系 IEnumerable <dm_user_relationEntity> userRelationList = dM_UserRelationService.GetParentRelation(dm_Task_ReviceEntity.user_id); ///获取上下级关系的用户信息 IEnumerable <dm_userEntity> userList = dM_UserService.GetParentUser(dm_Task_ReviceEntity.user_id); #region 做任务人返佣 currentUser = userList.Where(t => t.id == dm_Task_ReviceEntity.user_id).FirstOrDefault(); currentNickName = currentUser.nickname;//记录下接单人的昵称 防止丢失 if (currentUser.IsEmpty()) { throw new Exception("用户信息异常!"); } if (currentUser.userlevel == 0) { throw new Exception("用户等级异常,返佣失败!"); } else if (currentUser.userlevel == 1) { do_task_commission = dm_TaskEntity.juniorcommission; } else if (currentUser.userlevel == 2) { do_task_commission = dm_TaskEntity.seniorcommission; } else { throw new Exception("用户无等级,返佣失败!"); } dm_basesettingEntity dm_BasesettingEntity = dM_BaseSettingService.GetEntityByCache(dm_TaskEntity.appid); dm_basesetting_tipEntity dm_Basesetting_TipEntity = dm_Basesetting_TipService.GetEntityByAppID(dm_TaskEntity.appid); if (do_task_commission > 0) { dm_Task_ReviceEntity.comissionamount = do_task_commission; currentUser = CalculateComission(currentUser.id, do_task_commission, currentUser.accountprice); dm_AccountdetailEntities.Add(GeneralAccountDetail(currentUser.id, 14, dm_Basesetting_TipEntity.task_do_tip, "您接受的任务编号" + dm_TaskEntity.task_no + "已返佣到账,请及时查收!", do_task_commission, currentUser.accountprice)); } #endregion dm_Task_ReviceEntity.Modify(dm_Task_ReviceEntity.id);//由于需要修改任务所得佣金 故修改放到此处 #region 更改一级账户余额及明细 dm_user_relationEntity dm_User_RelationEntity_one = userRelationList.Where(t => t.user_id == dm_Task_ReviceEntity.user_id).FirstOrDefault(); if (!dm_User_RelationEntity_one.IsEmpty()) { one_User = userList.Where(t => t.id == dm_User_RelationEntity_one.parent_id).FirstOrDefault(); if (!one_User.IsEmpty()) { if (one_User.userlevel == 1 || one_User.userlevel == 2 || one_User.partnersstatus == 2) {//做任务人为代理身份才会返佣 one_agent_commission = ConvertComission(dm_BasesettingEntity.task_one * dm_TaskEntity.servicefee); if (one_agent_commission > 0) { one_User = CalculateComission(one_User.id, one_agent_commission, one_User.accountprice); dm_AccountdetailEntities.Add(GeneralAccountDetail(one_User.id, 15, dm_Basesetting_TipEntity.task_one_tip, "您的" + dm_Basesetting_TipEntity.task_one_tip + "《" + currentNickName + "》任务已完成,奖励已发放到您的账户,继续努力哟!", one_agent_commission, one_User.accountprice)); } #region 更改二级账户余额及明细 dm_user_relationEntity dm_User_RelationEntity_two = userRelationList.Where(t => t.user_id == one_User.id).FirstOrDefault(); if (!dm_User_RelationEntity_two.IsEmpty()) { two_User = userList.Where(t => t.id == dm_User_RelationEntity_two.parent_id).FirstOrDefault(); if (!two_User.IsEmpty()) { if (two_User.userlevel == 1 || two_User.userlevel == 2 || two_User.partnersstatus == 2) { two_agent_commission = ConvertComission(dm_BasesettingEntity.task_two * dm_TaskEntity.servicefee); if (two_agent_commission > 0) { two_User = CalculateComission(two_User.id, two_agent_commission, two_User.accountprice); dm_AccountdetailEntities.Add(GeneralAccountDetail(two_User.id, 16, dm_Basesetting_TipEntity.task_two_tip, "您的" + dm_Basesetting_TipEntity.task_two_tip + "《" + currentNickName + "》任务已完成,奖励已发放到您的账户,继续努力哟!", two_agent_commission, two_User.accountprice)); } } } } #endregion } } } #endregion #region 获取当前用户所属合伙人(一级合伙人) one_partners = dM_UserService.GetUserByPartnersID(dm_User_RelationEntity_one.partners_id); if (!one_partners.IsEmpty()) { one_partners_commission = ConvertComission(dm_BasesettingEntity.task_one_partners * dm_TaskEntity.servicefee); if (one_partners_commission > 0) { one_partners = CalculateComission(one_partners.id, one_partners_commission, one_partners.accountprice); dm_AccountdetailEntities.Add(GeneralAccountDetail(one_partners.id, 17, dm_Basesetting_TipEntity.task_parners_one_tip, "您的" + dm_Basesetting_TipEntity.task_parners_one_tip + "《" + currentNickName + "》任务已完成,奖励已发放到您的账户,继续努力哟!", one_partners_commission, one_partners.accountprice)); } #region 二级合伙人 dm_user_relationEntity dm_User_RelationEntity_one_partners = dM_UserRelationService.GetEntityByUserID(one_partners.id); two_partners = dM_UserService.GetEntityByCache(dm_User_RelationEntity_one_partners.parent_id); //two_partners = dM_UserService.GetUserByPartnersID(dm_User_RelationEntity_one_partners.partners_id); if (!two_partners.IsEmpty()) { if (two_partners.partnersstatus == 2) {//二级用户为合伙人时才进行返利 two_partners_commission = ConvertComission(dm_BasesettingEntity.task_two_partners * dm_TaskEntity.servicefee); if (two_partners_commission > 0) { two_partners = CalculateComission(two_partners.id, two_partners_commission, two_partners.accountprice); dm_AccountdetailEntities.Add(GeneralAccountDetail(two_partners.id, 18, dm_Basesetting_TipEntity.task_parners_two_tip, "您的" + dm_Basesetting_TipEntity.task_parners_two_tip + "《" + currentNickName + "》任务已完成,奖励已发放到您的账户,继续努力哟!", two_partners_commission, two_partners.accountprice)); } } } #endregion } #endregion #endregion if (calculateComissionEntities.Count > 0) { //必须加上这个变量,用于清除当前返利账户的余额 foreach (var item in calculateComissionEntities) { item.Modify(item.id); } db = BaseRepository("dm_data").BeginTrans(); db.Update(dm_Task_ReviceEntity); //更改接单表信息 db.Update(dm_TaskEntity); //更改任务主表信息 db.Insert(dm_MessagerecordEntity); //增加任务审核消息(发给接受任务的人) db.Insert(dm_MessagerecordEntity); //增加消息记录 db.Insert(dm_AccountdetailEntities); //增加账户余额明细 db.Update(calculateComissionEntities); //批量修改用户信息 db.Commit(); } } else { currentUser = dM_UserService.GetEntity(dm_Task_ReviceEntity.user_id); if (currentUser.IsEmpty()) { throw new Exception("用户信息异常!"); } dm_activity_manageEntity dm_Activity_ManageEntity = new dm_activity_manageService().GetActivityInfo(); if (dm_Activity_ManageEntity.IsEmpty()) { throw new Exception(CommonConfig.NoActivityTip); } dm_activity_recordEntity dm_Activity_RecordEntity = new dm_activity_recordService().GetEntityByUserID((int)dm_Task_ReviceEntity.user_id, dm_Activity_ManageEntity.f_id); if (dm_Activity_RecordEntity.IsEmpty()) { throw new Exception("未找到对应的加入活动任务信息!"); } if (dm_Activity_ManageEntity.ActivityType == 0) { #region 初始用红包类型的任务 #region 活动账户增加金额 currentUser.activityprice += dm_TaskEntity.singlecommission; #endregion /*判断当前所有任务是否都已完成*/ List <dm_task_reviceEntity> dm_Task_ReviceEntities = this.BaseRepository("dm_data").FindList <dm_task_reviceEntity>(t => t.user_id == dm_Task_ReviceEntity.user_id && t.status != 3 && t.status != 4 && t.activitycode == dm_Activity_ManageEntity.f_id).ToList(); if (dm_Task_ReviceEntities.Count() <= 0 || (dm_Task_ReviceEntities.Count() == 1 && dm_Task_ReviceEntities[0].id == dm_Task_ReviceEntity.id)) {//活动任务已全部完成 currentUser.accountprice += currentUser.activityprice; dm_AccountdetailEntities.Add(new dm_accountdetailEntity { createtime = DateTime.Now, remark = "活动奖励" + dm_Activity_ManageEntity.ActivityCode, stepvalue = currentUser.activityprice, currentvalue = currentUser.accountprice, title = "活动奖励", type = 24, user_id = dm_Task_ReviceEntity.user_id, profitLoss = 1 }); #region 级用户返利 dm_user_relationEntity parnetUserRelation = dM_UserRelationService.GetEntityByUserID(dm_Task_ReviceEntity.user_id); if (!parnetUserRelation.IsEmpty()) { one_User = dM_UserService.GetEntity(parnetUserRelation.parent_id); if (!one_User.IsEmpty()) { decimal next_user_activity_commission = Math.Round((decimal)currentUser.activityprice * 0.2M, 2); one_User.accountprice += next_user_activity_commission; dm_AccountdetailEntities.Add(new dm_accountdetailEntity { createtime = DateTime.Now, remark = "活动奖励" + dm_Activity_ManageEntity.ActivityCode, stepvalue = next_user_activity_commission, currentvalue = one_User.accountprice, title = "下级完成活动任务奖励", type = 25, user_id = one_User.id, profitLoss = 1 }); } } #endregion dm_Activity_RecordEntity.finishtime = DateTime.Now;//设置活动任务完成时间 } db = BaseRepository("dm_data").BeginTrans(); db.Update(currentUser); db.Update(dm_TaskEntity); db.Update(dm_Task_ReviceEntity); if (dm_AccountdetailEntities.Count > 0) { db.Insert(dm_AccountdetailEntities); } if (!one_User.IsEmpty()) { db.Update(one_User); } db.Update(dm_Activity_RecordEntity); db.Commit(); #endregion } else { List <dm_task_reviceEntity> dm_Task_ReviceEntities = this.BaseRepository("dm_data").FindList <dm_task_reviceEntity>(t => t.user_id == dm_Task_ReviceEntity.user_id && t.status != 3 && t.status != 4 && t.activitycode == dm_Activity_ManageEntity.f_id).ToList(); db = BaseRepository("dm_data").BeginTrans(); db.Update(dm_TaskEntity); db.Update(dm_Task_ReviceEntity); if (dm_Task_ReviceEntities.Count() <= 0 || (dm_Task_ReviceEntities.Count() == 1 && dm_Task_ReviceEntities[0].id == dm_Task_ReviceEntity.id)) {//活动任务已全部完成 decimal?activityprice = dm_Activity_ManageEntity.RewardPrice; currentUser.accountprice += activityprice; //currentUser.activityprice += activityprice; dm_AccountdetailEntities.Add(new dm_accountdetailEntity { createtime = DateTime.Now, remark = "活动奖励" + dm_Activity_ManageEntity.ActivityCode, stepvalue = activityprice, currentvalue = currentUser.accountprice, title = "活动奖励", type = 24, user_id = dm_Task_ReviceEntity.user_id, profitLoss = 1 }); dm_Activity_RecordEntity.finishtime = DateTime.Now;//设置活动任务完成时间 db.Update(currentUser); if (dm_AccountdetailEntities.Count > 0) { db.Insert(dm_AccountdetailEntities); } db.Update(dm_Activity_RecordEntity); } db.Commit(); } } return(dm_Task_ReviceEntity); } catch (Exception ex) { if (db != null) { db.Rollback(); } if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } } }
public dm_task_reviceEntity CancelByRevicePerson(int revice_id, int IsPubCancel = 0) { IRepository db = null; try { /* 取消任务 * 1、更改接受任务表的任务状态 * 2、修改任务主表的接单人数 * 3、向任务发布人增加取消任务通知 */ dm_task_reviceEntity dm_Task_ReviceEntity = GetEntity(revice_id); #region 更改接受任务表状态 if (dm_Task_ReviceEntity.IsEmpty()) { throw new Exception("接受任务记录异常!"); } if (dm_Task_ReviceEntity.status == 2) { throw new Exception("任务正在审核中,取消任务失败!"); } if (dm_Task_ReviceEntity.status == 3) { throw new Exception("任务已完成,取消任务失败!"); } if (dm_Task_ReviceEntity.status == 4) { throw new Exception("任务已取消,请勿重复提交!"); } dm_taskEntity dm_TaskEntity = dm_TaskService.GetEntity(dm_Task_ReviceEntity.task_id); if (dm_TaskEntity.isactivity == 1) { throw new Exception("活动任务不能取消哟!"); } if (IsPubCancel == 1) { DateTime diffTime = ((DateTime)dm_Task_ReviceEntity.revice_time).AddHours(dm_TaskEntity.task_time_limit); if (DateTime.Now < diffTime) { throw new Exception("该用户提交资料未超过设定时间,无法取消任务,您可在" + diffTime.ToString("yyyy-MM-dd HH:mm:ss") + "重试操作!"); } } dm_Task_ReviceEntity.status = 4; dm_Task_ReviceEntity.canceltime = DateTime.Now; dm_Task_ReviceEntity.Modify(dm_Task_ReviceEntity.id); #endregion #region 修改任务主表数据 dm_TaskEntity.revicecount -= 1; dm_TaskEntity.Modify(dm_TaskEntity.id); #endregion #region 增加消息记录 dm_messagerecordEntity dm_MessagerecordEntity = new dm_messagerecordEntity { isread = 0, user_id = dm_TaskEntity.user_id, messagetitle = "接单人取消", messagecontent = "您发布的任务编号:" + dm_TaskEntity.task_no + "接单人已取消,请及时查看!", messagetype = 2, createtime = DateTime.Now }; #endregion db = BaseRepository("dm_data").BeginTrans(); db.Update(dm_Task_ReviceEntity); db.Update(dm_TaskEntity); db.Insert(dm_MessagerecordEntity); db.Commit(); return(dm_Task_ReviceEntity); } catch (Exception ex) { if (db != null) { db.Rollback(); } if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } }
public dm_task_reviceEntity ReviceTask(dm_task_reviceEntity dm_Task_ReviceEntity, string appid) { lock (_object) { IRepository db = null; try { dm_basesettingEntity dm_BasesettingEntity = dM_BaseSettingService.GetEntityByCache(appid); if (dm_BasesettingEntity.IsEmpty()) { throw new Exception("配置信息获取错误!"); } dm_taskEntity dm_TaskEntity = dm_TaskService.GetEntity(dm_Task_ReviceEntity.task_id); if (dm_TaskEntity.IsEmpty()) { throw new Exception("任务id错误!"); } if (dm_TaskEntity.task_status == -2) { throw new Exception("任务正在审核中,暂时无法接受!"); } if (dm_TaskEntity.task_status == 1) { throw new Exception("您来晚了一步,当前任务已抢光!"); } if (dm_TaskEntity.task_status == 2) { throw new Exception("当前任务已取消,您可接受其他任务!"); } if (dm_TaskEntity.task_status == 3) { throw new Exception("当前任务已下架,您可接受其他任务!"); } if (dm_TaskEntity.revicecount >= dm_TaskEntity.needcount) { throw new Exception("您来晚了一步,当前任务已抢光!"); } /*一个任务可重复接受 2020-07-27*/ dm_task_reviceEntity reviceEntity = GetReviceEntity(dm_Task_ReviceEntity.user_id, dm_Task_ReviceEntity.task_id); if (!reviceEntity.IsEmpty()) { //throw new Exception("请勿重复接受该任务!"); throw new Exception("您已接受该任务,请勿重复接受!!"); } dm_userEntity dm_UserEntity = dM_UserService.GetEntity(dm_Task_ReviceEntity.user_id); if (dm_UserEntity.userlevel != 1 && dm_UserEntity.userlevel != 2) { throw new Exception("当前等级无法接受任务,请升级后重试!"); } //判断当前未在审核状态的任务数量 int noFinishCount = BaseRepository("dm_data").IQueryable <dm_task_reviceEntity>(t => (t.status == 1 || t.status == 2) && t.user_id == dm_Task_ReviceEntity.user_id).Count(); if (noFinishCount >= dm_BasesettingEntity.revicetaskcountlimit) { throw new Exception("同时接单任务数已达到上限,请先完成其他任务后再来接单!"); } dm_Task_ReviceEntity.revice_time = DateTime.Now; dm_Task_ReviceEntity.status = 1; dm_Task_ReviceEntity.Create(); dm_TaskEntity.revicecount += 1; dm_TaskEntity.Modify(dm_TaskEntity.id); db = BaseRepository("dm_data").BeginTrans(); db.Update(dm_TaskEntity); db.Insert(dm_Task_ReviceEntity); db.Commit(); return(dm_Task_ReviceEntity); } catch (Exception ex) { if (db != null) { db.Rollback(); } if (ex is ExceptionEx) { throw; } else { throw ExceptionEx.ThrowServiceException(ex); } } } }