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;
}
