/// <summary> /// 领取完成 /// 作者:郭明 /// 日期:2017年5月18日 /// </summary> /// <param name="args"></param> /// <returns></returns> public bool AcceptTextConsultCompletd(DoctorAcceptEvent args) { if (userOPDRegisterRepository.AcceptTaskDB(args)) { grabConsultService.StartTask(args.ServiceID, args.DoctorID); } else { grabConsultService.InvalidTask(args.ServiceID, args.DoctorID); throw new TaskConcurrentTakeException(); } return(true); }
/// <summary> /// 领取问题 更新数据库,并发控制 /// </summary> /// <param name="args"></param> /// <returns></returns> public bool AcceptTaskDB(DoctorAcceptEvent args) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["KMEHospEntities"].ConnectionString)) { SqlCommand cmd = new SqlCommand(@"update UserOPDRegisters set DoctorID=@DoctorID,ModifyUserID=@DoctorID,ModifyTime=@ModifyTime where UserOPDRegisters.OPDRegisterID=@OPDRegisterID"); cmd.Parameters.Add("@DoctorID", SqlDbType.VarChar).Value = args.DoctorID; cmd.Parameters.Add("@ModifyTime", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@OPDRegisterID", SqlDbType.VarChar).Value = args.ServiceID; int count = cmd.ExecuteNonQuery(); return(count > 0); } }