Esempio n. 1
0
        public bool IsExistOrganization(CoachOrganization obj)
        {
            string sql = "";

            sql = @"
SELECT * 
FROM dbo.CoachOrganization 
WHERE Name =@Name
";
            if (obj.RowState == RowState.Modified)
            {
                sql += " AND Id!=@Id";
            }

            var cmd = CommandHelper.CreateText <CoachOrganization>(FetchType.Fetch, sql);

            cmd.Params.Add("@Name", obj.Name);
            cmd.Params.Add("@Id", obj.Id);

            var result = DbContext.GetInstance().Execute(cmd);

            if (result.Entities.Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        public Response Execute(User currentUser, string request)
        {
            var               req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
            Response          rsp = ResultHelper.CreateResponse();
            CoachOrganization obj = new CoachOrganization();

            if (!string.IsNullOrEmpty(req.Filter.SealedOrganizationManagerId))
            {
                obj = getOrgByManagerId(req.Filter.SealedOrganizationManagerId);
            }
            if (!string.IsNullOrEmpty(req.Filter.CoachId))
            {
                obj = getOrgByCoachId(req.Filter.CoachId);
            }
            else if (!string.IsNullOrEmpty(req.Filter.SealedOrganizationId))
            {
                obj = getOrgById(req.Filter.SealedOrganizationId);
            }
            //人员统计
            SetCoachCount(obj);
            SetStudentCount(obj);
            SetCourseCount(obj);
            rsp.Entities.Add(obj);
            return(rsp);
        }
        public void SetCourseCount(CoachOrganization obj)
        {
            var sql = @"
SELECT 
	COUNT(Id) AS CourseCount
FROM dbo.CoachBootcampCourse  
WHERE SealedOrganizationId=@SealedOrganizationId

";
            var cmd = CommandHelper.CreateText <CoachOrganization>(FetchType.Fetch, sql);

            cmd.Params.Add("@SealedOrganizationId", obj.Id);
            var result   = DbContext.GetInstance().Execute(cmd);
            var objCount = result.FirstEntity <CoachOrganization>();

            obj.CourseCount = objCount.CourseCount;
        }