public ActionResult LearnOnLineEvaluatePreviewView() { #region 获取[课程评价]题目信息 var List_Class_TraningCommentQuestion = new List<Class_TraningCommentQuestion>(); var TraningCommentBll = new Class_TraningCommentQuestionBLL(); var stbSqlWhere = new StringBuilder(); stbSqlWhere.Append("Display = 1 AND Delflag = 0"); List_Class_TraningCommentQuestion = TraningCommentBll.GetListModel(stbSqlWhere.ToString()); ViewBag.List_Class_TraningCommentQuestion = List_Class_TraningCommentQuestion; #endregion #region 获取 Traning_Detail Title //根据 TrainingId 获取 Title int iTrainingId = 0, iClassId = 0; var DetailBll = new Traning_DetailBLL(); int.TryParse(Convert.ToString(Request["TrainingId"]) == "" ? "0" : QueryString.Decrypt(Request["TrainingId"]), out iTrainingId); int.TryParse(Convert.ToString(Request["ClassId"]) == "" ? "0" : QueryString.Decrypt(Request["ClassId"]), out iClassId);//获取 ClassId var Model_Traning_Detail = DetailBll.GetModel(iTrainingId, string.Empty); ViewBag.ClassId = iClassId; ViewBag.TrainingId = iTrainingId; ViewBag.TraningDetailTitle = Model_Traning_Detail.Title; #endregion return View(); }
public ActionResult ClassAuditDetail(string id, string doaction) { var param_id = Dianda.Common.QueryString.Decrypt(id); string param_doaction = ""; if (doaction != null) param_doaction = Dianda.Common.QueryString.Decrypt(doaction); var fkBll = new Traning_InfoFkBLL(); var traningBll = new Training_PlanBLL(); var traningDBll = new Traning_DetailBLL(); var bll = new Class_DetailBLL(); var model = bll.GetModel(param_id.ToInt()); var organ = new Organ_DetailBLL().GetModel(SiteCache.Instance.ManageOrganId); if (organ.OType == 1)//培训机构职能选择自己机构开设的课程 { ViewBag.CourseList = traningDBll.GetList(" OrganId =" + organ.Id + " and Delflag=0 and Display=1 ", ""); } else//进修学院则可以选择自己机构开设的课程,也可以选择自己机构所属的区县下的所有课程。通过Traning_Detail.ParentOrganId。如果Range=2,则表面是市级共享课程。则可以无条件选择。 { ViewBag.CourseList = traningDBll.GetList(" ((OrganId =" + organ.Id + " or ParentOrganId=" + organ.Id + ") or Range=2 ) and Delflag=0 and Display=1 ", ""); } ViewBag.OrganId = SiteCache.Instance.ManageOrganId; ViewBag.PartitionId = organ.PartitionId; ViewBag.PlanList = DataTableToListHelper<Dianda.AP.Model.Training_Plan>.ConvertToModel(traningBll.GetList(" Delflag=0 and Display=1 and IsOpen=1").Tables[0]); ViewBag.ClassesList = fkBll.GetList(" CategoryType=5 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.SubjectList = fkBll.GetList(" CategoryType=3 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.Subject = model.Subject; ViewBag.existSubjectList = new Class_TeachSubjectBLL().GetList(" Delflag=0 and ClassId=" + param_id, ""); ViewBag.StudyLevelList = fkBll.GetList(" CategoryType=4 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.StudyLevel = model.StudyLevel; ViewBag.existStudyLevel = new Class_StudySectionBLL().GetList(" Delflag=0 and ClassId=" + param_id, ""); ViewBag.TeachGradeList = fkBll.GetList(" CategoryType=7 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.TeachGrade = model.TeachGrade; ViewBag.existTeachGrade = new Class_TeachGradeBLL().GetList(" Delflag=0 and ClassId=" + param_id, ""); ViewBag.TeachRankList = fkBll.GetList(" CategoryType=8 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.TeachRank = model.TeachRank; ViewBag.existTeachRank = new Class_TeachRankBLL().GetList(" Delflag=0 and ClassId=" + param_id, ""); var course = new Traning_DetailBLL().GetModel(model.TraningId, ""); var organBll = new Organ_DetailBLL(); var list = new List<Organ_Detail>(); //if (course.Range == 1) //区级 //{ // list = organBll.GetListModel(" OType IN ( 1, 2, 3 ) and PartitionId=" + course.PartitionId + " and ParentId=" + (course.OrganId.HasValue ? course.OrganId.Value : 0)); //} //else//市级 //{ // list = organBll.GetShiOrganDetailList(); //} list = organBll.GetListModel(" id in ( " + model.OrganRange + ")"); ViewBag.schoolList = list; ViewBag.classId = param_id; ViewBag.OrangRange = model.OrganRange.Split(','); ViewBag.doaction = param_doaction; return View(model); }
//班级操作 public ActionResult ClassAction(string strAction, int Id, int? Instructor) { try { var bll = new Class_DetailBLL(); var model = bll.GetModel(Id.ToInt()); switch (strAction) { case "clear"://清除 model.Delflag = true; break; case "complete"://结业 model.Status = 6; break; case "cancel"://撤销 model.Status = 1; break; case "setInstructor"://设置辅导员 model.Instructor = Instructor.Value; break; case "start"://开班 var traingModel=new Traning_DetailBLL().GetModel(model.TraningId,""); if (traingModel.OutSideType == -1)//内部课程要有课程信息及比例 { var list = new Course_DetailBLL().GetList(" Delflag=0 and TrainingId=" + model.TraningId, ""); if (list == null || list.Count == 0) return Json(new { Code = -1, Msg = "请设置课程信息!" }, JsonRequestBehavior.AllowGet); var courseDetail = list.First(); if (courseDetail.ReadingRate + courseDetail.DisscusRate + courseDetail.HomeWorkRate + courseDetail.QuestionRate + courseDetail.TestingRate + courseDetail.CommentRate != 100) { return Json(new { Code = -1, Msg = "请设置课程考核比例!" }, JsonRequestBehavior.AllowGet); } } model.Status = 5; break; } bll.Update(model); return Json(new { Code = 0, Msg = "提交成功" }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { Code = -1, Msg = ex.Message }, JsonRequestBehavior.AllowGet); } }
/// <summary> /// 重新打分 /// </summary> /// <param name="classId"></param> /// <param name="planId"></param> /// <param name="accountId"></param> public static void resetScore(int classId, int planId) { var member_classBll = new Member_ClassRegisterBLL(); var classDetail = new Class_DetailBLL().GetModel(classId); var traningBll = new Traning_DetailBLL(); var traning_detail = traningBll.GetModel(classDetail.TraningId, ""); if (traning_detail == null) return; var courseBll = new Course_DetailBLL(); var cousre_detail = courseBll.GetList(" TrainingId=" + traning_detail.Id, ""); if (cousre_detail == null || cousre_detail.Count == 0) return; var unitContentBll = new Course_UnitContentBLL(); var memberList = member_classBll.GetList("Delflag=0 and ClassId=" + classId + " and PlanId=" + planId, ""); foreach (var memberModel in memberList) { var accountId = memberModel.AccountId; int total = 1; IList<Course_UnitContent> contentList = new List<Course_UnitContent>(); #region //重新计算阅读分数 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "1,2"); contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "1,2")); if (contentList != null) { var scheduleBll = new Member_ClassUnitContentScheduleBLL(); int scoreCount = 0; foreach (var item in contentList) { var scheduleModel = scheduleBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().score.HasValue)//如果有值说明打过分 { scoreCount++; } } } if (scoreCount == total)//全部阅读过,给满分 { memberModel.ReadingScore = cousre_detail[0].ReadingRate; } else { memberModel.ReadingScore = cousre_detail[0].ReadingRate * scoreCount / total;//阅读数与总数折算 } } //重新计算讨论分数 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "3"); contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "3")); if (contentList != null) { var scheduleBll = new Member_ClassUnitContentScheduleBLL(); int scoreCount = 0; foreach (var item in contentList) { var scheduleModel = scheduleBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().score.HasValue)//如果有值说明打过分 { scoreCount++; } } } if (scoreCount == total)//全部讨论过,给满分 { memberModel.DiscussScore = cousre_detail[0].DisscusRate; } else { memberModel.DiscussScore = cousre_detail[0].DisscusRate * scoreCount / total;//讨论数与总数折算 } } //如有分值,重新计算作业分数 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "4"); contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "4")); if (contentList != null) { var homeworkBll = new Course_UnitHomeWorkBLL(); double homeworkscore = 0; foreach (var item in contentList) { var scheduleModel = homeworkBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().Score.HasValue)//如果有值说明打过分 { homeworkscore += (scheduleModel.First().Score.Value * (cousre_detail[0].HomeWorkRate) / (total * 100)).ToDouble();//已打分数与总数折算 } } } memberModel.HomeWorkScore = homeworkscore; } //重新计算测试分数 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "5"); contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "5")); if (contentList != null) { var scheduleBll = new Member_ClassUnitContentScheduleBLL(); double testscore = 0; foreach (var item in contentList) { var scheduleModel = scheduleBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().score.HasValue) { testscore += (scheduleModel.First().score.Value * (cousre_detail[0].QuestionRate) / (total * 100)).ToDouble(); } } } memberModel.TestingScore = testscore; } //重新计算考试分数 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "6"); contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "6")); if (contentList != null) { var scheduleBll = new Member_ClassUnitContentScheduleBLL(); double examcore = 0; foreach (var item in contentList) { var scheduleModel = scheduleBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().score.HasValue) { examcore += (scheduleModel.First().score.Value * (cousre_detail[0].TestingRate) / (total * 100)).ToDouble(); } } } memberModel.ExaminationScore = examcore; } #endregion member_classBll.Update(memberModel); } }
/// <summary> /// /// </summary> /// <param name="objectId">单元ID</param> /// <param name="objectType">单元类型</param> /// <param name="classId">班级ID</param> /// <param name="planId">计划ID</param> /// <param name="accountId">成员ID</param> /// <param name="score">分值</param> public static void ScoreSet(int? objectId, int objectType, int classId, int planId, int accountId, double score, bool add = true) { dynamic objectBll; dynamic model; Member_ClassRegister memberModel; int total = 1; var member_classBll = new Member_ClassRegisterBLL(); var member_class = member_classBll.GetList(" Delflag=0 and ClassId=" + classId + " and PlanId=" + planId + " and AccountId=" + accountId, ""); if (member_class == null || member_class.Count == 0) return; memberModel = member_class.FirstOrDefault(); var traningBll = new Traning_DetailBLL(); var traning_detail = traningBll.GetModel(memberModel.TrainingId.Value, ""); if (traning_detail == null) return; var courseBll = new Course_DetailBLL(); var cousre_detail = courseBll.GetList(" Delflag=0 and TrainingId=" + traning_detail.Id, ""); if (cousre_detail == null || cousre_detail.Count == 0) return; var unitContentBll = new Course_UnitContentBLL(); var oldScore = 0.0; switch (objectType) { case 1://read objectBll = new Member_ClassUnitContentScheduleBLL(); model = objectBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + objectId, ""); if (model.Count > 0) { if (add) model[0].score = 1; else model[0].score = 0; objectBll.Update(model[0]);// } total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "1,2");//阅读视频类的单元活动数 if (total > 1) { if (add) memberModel.ReadingScore = (memberModel.ReadingScore.HasValue ? memberModel.ReadingScore.Value : 0) + (cousre_detail[0].ReadingRate / (total)).ToDouble(); else { if (memberModel.ReadingScore.HasValue && memberModel.ReadingScore.Value.ToInt() > 0) memberModel.ReadingScore = memberModel.ReadingScore.Value - (cousre_detail[0].ReadingRate / (total)).ToDouble(); } } else { if (add) memberModel.ReadingScore = cousre_detail[0].ReadingRate; else memberModel.ReadingScore = 0.0; } if (memberModel.ReadingScore > cousre_detail[0].ReadingRate) { memberModel.ReadingScore = cousre_detail[0].ReadingRate; } if (memberModel.ReadingScore < 0) { memberModel.ReadingScore = 0; } member_classBll.Update(memberModel);//更新班级成员考试分数总值 break; case 2://discuss objectBll = new Member_ClassUnitContentScheduleBLL(); model = objectBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " and UnitContent=" + objectId, ""); if (model.Count > 0) { if (add) model[0].score = 1; else model[0].score = 0; objectBll.Update(model[0]);// } total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "3");//讨论类的单元活动数 if (total > 1) { if (add) memberModel.DiscussScore = (memberModel.DiscussScore.HasValue ? memberModel.DiscussScore.Value : 0) + (cousre_detail[0].DisscusRate / (total)).ToDouble(); else { if (memberModel.ReadingScore.HasValue && memberModel.ReadingScore.Value.ToInt() > 0) memberModel.DiscussScore = memberModel.DiscussScore.Value - (cousre_detail[0].DisscusRate / (total)).ToDouble(); } } else { if (add) memberModel.DiscussScore = cousre_detail[0].DisscusRate; else memberModel.DiscussScore = 0.0; } if (memberModel.DiscussScore > cousre_detail[0].DisscusRate) { memberModel.DiscussScore = cousre_detail[0].DisscusRate; } if (memberModel.DiscussScore < 0) { memberModel.DiscussScore = 0; } member_classBll.Update(memberModel);//更新班级成员考试分数总值 break; case 3://homework #region objectBll = new Course_UnitHomeWorkBLL(); model = objectBll.GetModel(objectId.Value, ""); model.Score = score; model.ScoreCreater = SiteCache.Instance.ManagerId; objectBll.Update(model);//更新结果表 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "4");//作业类的单元活动数 if (total > 1) { memberModel.HomeWorkScore = (memberModel.HomeWorkScore.HasValue ? memberModel.HomeWorkScore.Value : 0) + (score * (cousre_detail[0].HomeWorkRate) / (total * 100)).ToDouble(); } else { memberModel.HomeWorkScore = (score * (cousre_detail[0].HomeWorkRate) / (100)).ToDouble(); } if (memberModel.HomeWorkScore > cousre_detail[0].HomeWorkRate) { memberModel.HomeWorkScore = cousre_detail[0].HomeWorkRate; } member_classBll.Update(memberModel);//更新班级成员作业分数总值 #endregion break; case 4://question #region objectBll = new Member_ClassUnitContentScheduleBLL(); model = objectBll.GetModel(objectId.Value, ""); oldScore = model.score == null ? 0 : model.score; model.score = score; objectBll.Update(model);//更新班级成员测试分数总值 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "5");//测试类的单元活动数 if (add)//第一次打分 { if (total > 1) { memberModel.TestingScore = (memberModel.TestingScore.HasValue ? memberModel.TestingScore.Value : 0) + (score * (cousre_detail[0].QuestionRate) / (total * 100)).ToDouble(); } else { memberModel.TestingScore = (score * (cousre_detail[0].QuestionRate) / (100)).ToDouble(); } } else//多次打分,重新计算 { var contentList = DataTableToListHelper<Course_UnitContent>.ConvertToModel(unitContentBll.GetUnitByClassAndUnitType(classId, "5")); if (contentList != null) { var scheduleBll = new Member_ClassUnitContentScheduleBLL(); double testscore = 0; foreach (var item in contentList) { var scheduleModel = scheduleBll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId + " AND UnitContent=" + item.Id, ""); if (scheduleModel != null && scheduleModel.Count > 0) { if (scheduleModel.First().score.HasValue) { testscore += (scheduleModel.First().score.Value * (cousre_detail[0].QuestionRate) / (total * 100)).ToDouble(); } } } memberModel.TestingScore = testscore; } } if (memberModel.TestingScore > cousre_detail[0].QuestionRate) { memberModel.TestingScore = cousre_detail[0].QuestionRate; } member_classBll.Update(memberModel);//更新班级成员测试分数总值 #endregion break; case 5://examnation #region objectBll = new Member_ClassUnitContentScheduleBLL(); model = objectBll.GetModel(objectId.Value, ""); oldScore = model.score == null ? 0 : model.score; model.score = score; if (score >= 60)//考试大于等于60分算通过 memberModel.IsPass = true; objectBll.Update(model);//更新班级成员考试分数总值 total = unitContentBll.GetUnitCountByClassAndUnitType(classId, "6");//考试类的单元活动数 if (total > 1) { memberModel.ExaminationScore = (memberModel.ExaminationScore.HasValue ? memberModel.ExaminationScore.Value : 0) + (score * (cousre_detail[0].TestingRate) / (total * 100)).ToDouble(); } else { memberModel.ExaminationScore = (score * (cousre_detail[0].TestingRate) / (100)).ToDouble(); } if (memberModel.ExaminationScore > cousre_detail[0].TestingRate) { memberModel.ExaminationScore = cousre_detail[0].TestingRate; } member_classBll.Update(memberModel);//更新班级成员考试分数总值 #endregion break; case 6://comment #region objectBll = new Member_ClassRegisterBLL(); model = objectBll.GetList(" Delflag=0 and ClassId=" + classId + " and PlanId=" + planId + " and AccountId=" + accountId, "")[0]; model.CommentScore = (score * (cousre_detail[0].CommentRate) / (total * 100)).ToDouble(); objectBll.Update(model);//更新班级成员评价分数总值 #endregion break; default: break; } }
private int ConvertTrainingId(int input) { //20509 教育用户体验评估方法 //20508 学习分析技术 //20496 不同形式微课的设计与应用 //20495 游戏化学习在教学中的应用 //20493 虚拟现实在教学中的应用 //20492 翻转课堂的设计及其应用 //20491 移动学习的设计及其应用 //20490 新技术在教学中的应用 //20487 活动为导向的在线课程设计 //20470 微信在教学中的应用 //return input; //Traning_Detail model = new Traning_DetailBLL().GetModel("Delflag=0 and OutSideType=2 and OutSideLink='" + input + "'"); Traning_Detail model = new Traning_DetailBLL().GetModel("Delflag=0 and OutSideType=2"); if (model == null) { return 0; } else { return model.Id; } }
/// <summary> /// 课程评价,如果已合格,加上学时 /// </summary> public static void commentTraningOper(int classId,int accountId) { var classDetail = new Dianda.AP.BLL.Class_DetailBLL().GetModel(classId); var tranFieldModel = new Traning_DetailBLL().GetModel(classDetail.TraningId, ""); var model = new Dianda.AP.BLL.Member_ClassRegisterBLL().GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + accountId, "").First(); var comment = new Dianda.AP.BLL.Class_TraningCommentResultBLL().GetListModel(" ClassId=" + classId + " and AccountId=" + accountId + " and Delflag=0"); if (model.Result == 1 && comment != null && comment.Count > 0)//如果结论是合格,,并且评论过课程,则要更新用户学分 { var tranEditModel = new Member_TrainingReditBLL().GetList("Delflag=0 and TrainingField=" + tranFieldModel.TraingField + " and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId, ""); Member_TrainingRedit tranEdit = null; if (tranEditModel == null || tranEditModel.Count == 0)//创建 { tranEdit = new Member_TrainingRedit(); tranEdit.AccountId = model.AccountId; tranEdit.CreateDate = DateTime.Now; tranEdit.Credits = tranFieldModel.TotalTime.Value; tranEdit.Delflag = false; tranEdit.PlanId = model.PlanId; tranEdit.TrainingField = tranFieldModel.TraingField; new Member_TrainingReditBLL().Add(tranEdit); } else//更新 { tranEdit = tranEditModel.First(); tranEdit.Credits += tranFieldModel.TotalTime.Value; new Member_TrainingReditBLL().Update(tranEdit); } var traningCredit = DataTableToListHelper<Training_Credits>.ConvertToModel( new Training_CreditsBLL().GetList(" and PlanId=" + model.PlanId + " and OrganId=" + classDetail.OrganId, "") );//查找学时学分 if (traningCredit != null && traningCredit.Count > 0) //轮循所有大类 { bool graduateFlag = true; var member_traningBll = new Member_TrainingReditBLL(); foreach (var item in traningCredit) { var traning_credit = member_traningBll.GetList (" Delflag=0 and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId + " and TrainingField=" + item.TraningField , ""); if (traningCredit != null && traningCredit.Count > 0) { if (traningCredit.First().MinValue > tranEdit.Credits) { graduateFlag = false; break; } } } if (graduateFlag)//所有大类学分均合格,更新Member_PlanOverall表的用户合格状态。 { var Member_PlanOverallBll = new Member_PlanOverallBLL(); var Member_PlanOverall = Member_PlanOverallBll.GetListModel(" Delflag=0 and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId); if (Member_PlanOverall != null && Member_PlanOverall.Count > 0) { var item = Member_PlanOverall.First(); item.Result = 1; Member_PlanOverallBll.Update(item); } else { var item = new Member_PlanOverall(); item.Result = 1; item.PlanId = model.PlanId; item.AccountId = model.AccountId; item.CreateDate = DateTime.Now; item.Delflag = false; Member_PlanOverallBll.Add(item); } } } } }
//批量审核 public ActionResult AjaxTrainingCheckBatch(string ids, string value, string remark) { StringBuilder where = new StringBuilder(); where.Append("Delflag=0 and Status in (2,4) and PartitionId=" + Code.SiteCache.Instance.LoginInfo.PartitionId + " and Id in (" + ids + ")"); int status = value == "1" ? 3 : 4; remark = value == "1" ? "" : remark; int managerId = Code.SiteCache.Instance.ManagerId; List<Traning_ApplyApplication> applies = new List<Traning_ApplyApplication>(); foreach (string id in ids.Split(',')) { Traning_ApplyApplication apply = new Traning_ApplyApplication(); apply.TraningId = Convert.ToInt32(id); apply.Status = Convert.ToInt32(value); apply.Remark = remark; apply.Creater = managerId; apply.OrganId = Code.SiteCache.Instance.ManageOrganId; apply.Delflag = false; apply.CreateDate = DateTime.Now; applies.Add(apply); } List<Traning_Detail> trainings = new Traning_DetailBLL().GetList("Id in (" + ids + ")", ""); using (TransactionScope trans = new TransactionScope()) { try { int partitionId = Code.SiteCache.Instance.LoginInfo.PartitionId; string msg; foreach (Traning_Detail training in trainings) { if (status == 3) { msg = string.Format("课程:{0} 审核通过!", training.Title); } else { msg = string.Format("课程:{0} 审核不通过,原因:{1}", training.Title, remark); } Code.MsgHelper.sendMsg(training.Creater, managerId, partitionId, "审核信息", msg); } new PrepareTrainingCheckBLL().BatchTrainingApply(where.ToString(), status, remark, applies); trans.Complete(); return Json(new { Result = true, Msg = "操作成功!" }, JsonRequestBehavior.AllowGet); } catch { return Json(new { Result = false, Msg = "操作失败!" }, JsonRequestBehavior.AllowGet); } } }
//班级首页 public ActionResult Index() { var fkBll = new Traning_InfoFkBLL(); var traningBll = new Training_PlanBLL(); var traningDBll = new Traning_DetailBLL(); var organ = new Organ_DetailBLL().GetModel(SiteCache.Instance.ManageOrganId); if (organ.OType == 1)//培训机构职能选择自己机构开设的课程 { ViewBag.CourseList = traningDBll.GetList(" OrganId =" + organ.Id + " and Delflag=0 and Display=1 and status=5", ""); //(, "");" Range=2" } else//进修学院则可以选择自己机构开设的课程,也可以选择自己机构所属的区县下的所有课程。通过Traning_Detail.ParentOrganId。如果Range=2,则表面是市级共享课程。则可以无条件选择。 { ViewBag.CourseList = traningDBll.GetList(" ((OrganId =" + organ.Id + " or ParentOrganId=" + organ.Id + ") ) and Delflag=0 and Display=1 and status=5", ""); }//or Range=2 ViewBag.OrganId = SiteCache.Instance.ManageOrganId; ViewBag.PartitionId = organ.PartitionId; ViewBag.PlanList = DataTableToListHelper<Dianda.AP.Model.Training_Plan>.ConvertToModel(traningBll.GetList(" Delflag=0 and Display=1 ").Tables[0]); ViewBag.ClassesList = fkBll.GetList(" CategoryType=5 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.SubjectList = fkBll.GetList(" CategoryType=3 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.StudyLevelList = fkBll.GetList(" CategoryType=4 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.TeachGradeList = fkBll.GetList(" CategoryType=7 and Delflag=0 and Display=1 ", "Sort desc"); ViewBag.TeachRankList = fkBll.GetList(" CategoryType=8 and Delflag=0 and Display=1 ", "Sort desc"); return View(); }
/// <summary> /// 获取页面活动的公共方法 /// </summary> /// <returns></returns> private Course_UnitContent GetCourseUnitContentActivity() { //获取所有的阅读信息 var courseBll = new Course_UnitContentBLL(); var DetailBll = new Traning_DetailBLL(); var List_Course_UnitContent = new List<Course_UnitContent>(); var Model_Course_UnitContent = new Course_UnitContent(); var stbSqlWhere = new StringBuilder(); var strOrderBy = "Sort"; int iClassId = 0, iTrainingId = 0, iAccountId = 0, iUnitContent = 0, iUnitId = 0; int.TryParse(Convert.ToString(Request["TrainingId"]) == "" ? "0" : QueryString.Decrypt(Request["TrainingId"]), out iTrainingId); int.TryParse(Convert.ToString(Request["UnitContent"]) == "" ? "0" : QueryString.Decrypt(Request["UnitContent"]), out iUnitContent); stbSqlWhere.Append(" 1 = 1 "); if (iTrainingId > 0) stbSqlWhere.AppendFormat("AND Course_UnitDetail.TrainingId = {0}", iTrainingId); if (iTrainingId > 0) stbSqlWhere.AppendFormat("AND Course_UnitContent.Id = {0}", iUnitContent); List_Course_UnitContent = courseBll.GetListOther(stbSqlWhere.ToString(), strOrderBy); if (List_Course_UnitContent != null && List_Course_UnitContent.Count == 1) Model_Course_UnitContent = List_Course_UnitContent[0]; //获取当前登录用户的班级和ID iAccountId = Code.SiteCache.Instance.LoginInfo.UserId; //根据 TrainingId 获取 Title var Model_Traning_Detail = DetailBll.GetModel(iTrainingId, string.Empty); ViewBag.TraningDetailTitle = Model_Traning_Detail.Title; ViewBag.AccountId = iAccountId; ViewBag.TrainingId = iTrainingId; ViewBag.UnitContent = iUnitContent = Model_Course_UnitContent.Id; ViewBag.Model_Course_UnitContent = Model_Course_UnitContent; return Model_Course_UnitContent; }
//根据选择的课程返回学校范围 public JsonResult GetTrainingForm(string courseid) { try { var course = new Traning_DetailBLL().GetModel(courseid.ToInt(), ""); return Json(new { Code = course.TrainingForm }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { Code = -1, Msg = ex.Message }, JsonRequestBehavior.AllowGet); } }
public bool IsCanRegister(int ClassId, bool Issingle, int MemberId, int Type) { int ParentOrganId = 1; int oType = 1; int partitionId = Code.SiteCache.Instance.LoginInfo.PartitionId; int UserId = MemberId; Member_AccountBLL member_AccountBLL = new Member_AccountBLL(); Member_Account ma = member_AccountBLL.GetModel(UserId, ""); int OrganId = 1; if (Issingle) { ParentOrganId = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.OrganId).ParentId; oType = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.OrganId).OType; OrganId = Code.SiteCache.Instance.OrganId; } else { ParentOrganId = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.ManageOrganId).ParentId; oType = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.ManageOrganId).OType; OrganId = Code.SiteCache.Instance.ManageOrganId; } Member_BaseInfoBLL member_BaseInfoBLL = new Member_BaseInfoBLL(); Member_BaseInfo m = member_BaseInfoBLL.GetModelByAccountId(UserId); string where = " and td.PartitionId='" + partitionId + "'and cd.PlanId='" + Code.SiteCache.Instance.PlanId + "' and cd.PartitionId='" + partitionId + "' and cd.Id='" + ClassId + "'"; if (oType == 1) { where += " and td.OrganId='" + OrganId + "'"; } else if (oType == 2) { if (m != null) { switch (Type) { case 1: where += " and ((css.StudySection in(select StudySection from Member_StudySection where AccountId='" + UserId + "' and Delflag='false')and css.delflag='false' )or cd.StudyLevel=1)"; break; case 2: where += " and ((cts.TeachSubject in(select TeachSubject from Member_TeachSubject where AccountId='" + UserId + "' and Delflag='false')and cts.delflag='false' )or cd.Subject=1)"; break; case 3: where += " and ((ctg.TeachGrade in(select TeachGrade from Member_TeachGrade where AccountId='" + UserId + "' and Delflag='false')and ctg.delflag='false' )or cd.TeachGrade=1)"; break; case 4: where += " and ((ctr.TeachRank in(select WorkRank from Member_WorkRank where AccountId='" + UserId + "' and Delflag='false')and ctr.delflag='false' )or cd.TeachRank=1)"; break; case 5: where += " and (CHARINDEX('," + OrganId + ",',','+cd.OrganRange+',')>0 or cd.OrganRange='0')"; break; } where += " and (td.OrganId='" + ParentOrganId + "' or td.Range=2)"; } else { where += "and 1=2"; } } else if (oType == 5) { if (m != null) { switch (Type) { case 1: where += " and ((css.StudySection in(select StudySection from Member_StudySection where AccountId='" + UserId + "' and Delflag='false')and css.delflag='false' )or cd.StudyLevel=1)"; break; case 2: where += " and ((cts.TeachSubject in(select TeachSubject from Member_TeachSubject where AccountId='" + UserId + "' and Delflag='false')and cts.delflag='false' )or cd.Subject=1)"; break; case 3: where += " and ((ctg.TeachGrade in(select TeachGrade from Member_TeachGrade where AccountId='" + UserId + "' and Delflag='false')and ctg.delflag='false' )or cd.TeachGrade=1)"; break; case 4: where += " and ((ctr.TeachRank in(select WorkRank from Member_WorkRank where AccountId='" + UserId + "' and Delflag='false')and ctr.delflag='false' )or cd.TeachRank=1)"; break; case 5: where += " and (CHARINDEX('," + ma.OrganId + ",',','+cd.OrganRange+',')>0 or cd.OrganRange='0')"; break; } where += " and (td.OrganId='" + OrganId + "' or td.Range=2)"; } else { where += "and 1=2"; } } else { where += " and 1=2"; } Traning_DetailBLL traning_DetailBLL = new Traning_DetailBLL(); int total = 0; List<Traning_Detail> tdlist = traning_DetailBLL.GetListHasClass(10, 1, where, "CreateDate desc", out total); return total > 0; }
/// <summary> /// 学校--审核列表 /// </summary> /// <returns></returns> public ActionResult CoursemarketVerify(int? pageIndex, int? planId, int? status, int? trainingId, int? myclassId, string searchTitle) { ViewBag.Title = "教师报名管理"; int i = TypeConverter.ObjectToInt(pageIndex, 1); int groupId = Code.SiteCache.Instance.GroupId;//4,学校管理7,普通教师 //int groupId = 4; Organ_DetailBLL organ_DetailBLL = new Organ_DetailBLL(); int OrganId = 0; string where = ""; if (groupId == 4) { OrganId = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.ManageOrganId).ParentId; ViewBag.Yes = 2; ViewBag.No = 3; where += " and ma.OrganId='" + Code.SiteCache.Instance.ManageOrganId + "'"; //where += " and mcr.Status<=3"; } else if (groupId == 2) { OrganId = Code.SiteCache.Instance.ManageOrganId; ViewBag.Yes = 4; ViewBag.No = 5; where += " and cd.OrganId='" + Code.SiteCache.Instance.ManageOrganId + "'"; where += " and mcr.Status in(2,4,5)"; } else if (groupId == 3) { OrganId = Code.SiteCache.Instance.ManageOrganId; ViewBag.Yes = 4; ViewBag.No = 5; where += " and cd.OrganId='" + Code.SiteCache.Instance.ManageOrganId + "'"; where += " and mcr.Status in(2,4,5)"; } else { where += " and 1=2"; } if (planId != null && planId > 0) { where += " and mcr.PlanId='" + planId + "' "; } else { planId = -1; } if (status != null && status > 0) { where += " and mcr.Status='" + status + "' "; } else { status = -1; } if (trainingId != null && trainingId > 0) { where += " and mcr.TrainingId='" + trainingId + "' "; } else { trainingId = -1; } if (myclassId != null && myclassId > 0) { where += " and mcr.ClassId='" + myclassId + "' "; } else { myclassId = -1; } if (!string.IsNullOrEmpty(searchTitle)) { where += " and (mbi.RealName like'%" + searchTitle.Replace("'", "''") + "%' or ma.Nickname like '%" + searchTitle.Replace("'", "''") + "%' or ma.UserName like '%" + searchTitle.Replace("'", "''") + "%' or mbi.TeacherNo like '%" + searchTitle.Replace("'", "''") + "%' or mbi.CredentialsNumber like '%" + searchTitle.Replace("'", "''") + "%' or td.Title like '%" + searchTitle.Replace("'", "''") + "%' or cd.Title like '%" + searchTitle.Replace("'", "''") + "%')"; } int total = 0; Member_ClassRegisterBLL member_ClassRegisterBLL = new Member_ClassRegisterBLL(); List<ClassRegisterManage> tdlist = member_ClassRegisterBLL.GetListManage(10, i, where, "CreateDate desc", out total); ViewData["searchTitle"] = string.IsNullOrEmpty(searchTitle) ? "" : searchTitle; ViewData["planId"] = planId; ViewData["status"] = status; ViewData["trainingId"] = trainingId; ViewData["myclassId"] = myclassId; ViewData["groupId"] = groupId; ViewBag.pageIndex = i; ViewBag.totalPage = total; Training_PlanBLL training_PlanBLL = new Training_PlanBLL(); ViewBag.PlanList = training_PlanBLL.GetListModel(" Display=1 and Delflag='false'"); Traning_FieldBLL traning_FieldBLL = new Traning_FieldBLL(); ViewBag.FieldList = traning_FieldBLL.GetList(" Display=1 and Delflag='false' and IsSpec=0", " Sort"); Traning_DetailBLL traning_DetailBLL = new Traning_DetailBLL(); ViewBag.TraningList = traning_DetailBLL.GetList(" Display=1 and Delflag='false' and PartitionId='" + Code.SiteCache.Instance.LoginInfo.PartitionId + "' and Status=5 and (OrganId='" + OrganId + "' or Range=2)", " Id"); Class_DetailBLL class_DetailBLL = new Class_DetailBLL(); ViewBag.ClassList = class_DetailBLL.GetListModel(" Display=1 and Delflag='false' "); return View(tdlist); }
/// <summary> /// 教师--课程超市列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="organId"></param> /// <param name="field"></param> /// <param name="searchTitle"></param> /// <returns></returns> //[UrlDecrypt] public ActionResult CoursemarketSingleList(int? pageIndex, int? organId, int? field, string searchTitle) { ViewBag.Title = "课程超市"; int i = TypeConverter.ObjectToInt(pageIndex, 1); int groupId = Code.SiteCache.Instance.GroupId;//4,学校管理7,普通教师 Organ_DetailBLL organ_DetailBLL = new Organ_DetailBLL(); int CountyOrganId = 0; int oType = 1; if (groupId == 7) { oType = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.OrganId).OType; CountyOrganId = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.OrganId).ParentId; } else if (groupId == 2 || groupId == 3 || groupId == 4) { oType = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.ManageOrganId).OType; if (groupId == 4) CountyOrganId = (int)organ_DetailBLL.GetModel(Code.SiteCache.Instance.ManageOrganId).ParentId; else CountyOrganId = Code.SiteCache.Instance.ManageOrganId; } ViewBag.OType = oType; int partitionId = Code.SiteCache.Instance.LoginInfo.PartitionId; Member_BaseInfoBLL member_BaseInfoBLL = new Member_BaseInfoBLL(); Member_BaseInfo m = member_BaseInfoBLL.GetModelByAccountId(Code.SiteCache.Instance.LoginInfo.UserId); string where = " and td.PartitionId='" + partitionId + "'and cd.PlanId='" + Code.SiteCache.Instance.PlanId + "' and cd.PartitionId='" + partitionId + "'"; if (oType == 1) { ViewBag.OrganList = organ_DetailBLL.GetListModel(" OType=1 and Delflag='false'"); } else if (oType == 2 || oType == 5) { ViewBag.OrganList = organ_DetailBLL.GetListModel(" OType=5 and Delflag='false'"); } else { where += " and 1=2"; } if (m != null) { where += " and (td.OrganId='" + CountyOrganId + "' or td.Range=2)"; } else { where += " and 1=2"; } if (organId != null && organId > 0) { where += " and td.OrganId='" + organId + "' "; } else { organId = -1; } if (!string.IsNullOrEmpty(searchTitle)) { where += " and td.Title like'%" + searchTitle.Replace("'", "''") + "%' "; } string where2 = where; if (field != null && field > 0) { where += " and td.TraingField='" + field + "' "; } Traning_DetailBLL traning_DetailBLL = new Traning_DetailBLL(); int total = 0; List<Traning_Detail> tdlist = traning_DetailBLL.GetListHasClass(10, i, where, "CreateDate desc", out total); ViewData["searchTitle"] = string.IsNullOrEmpty(searchTitle) ? "" : searchTitle; ViewData["organId"] = organId; ViewData["field"] = field; ViewData["partitionId"] = partitionId; ViewData["groupId"] = groupId; ViewBag.pageIndex = i; ViewBag.totalPage = total; Traning_FieldBLL traning_FieldBLL = new Traning_FieldBLL(); List<Traning_Field> traning_FieldList = traning_FieldBLL.GetList(" Delflag='false' and display='1' and Id<>3", " Sort"); ViewBag.FieldList = traning_FieldList; List<Traning_Detail> tdlistall = traning_DetailBLL.GetListHasClass(-1, -1, where2, "CreateDate desc", out total); List<int> list = new List<int>(traning_FieldList.Count); int sum = 0; foreach (Traning_Field tf in traning_FieldList) { int c = tdlistall.Where(a => a.TraingField == tf.Id).Count(); list.Add(c); sum += c; } ViewBag.Sum = sum; ViewBag.FCount = list; return View(tdlist); }
public ActionResult CoursemarketSingleEnrollC(int Id) { ViewBag.Title = "课程详细"; int groupId = Code.SiteCache.Instance.GroupId;//4,学校管理7,普通教师 ViewData["groupId"] = groupId; Traning_DetailBLL traning_DetailBLL = new Traning_DetailBLL(); Traning_Detail traning_Detail = new Traning_Detail(); traning_Detail = traning_DetailBLL.GetModel(Id, ""); return View(traning_Detail); }
/// <summary> /// 获取页面活动的公共方法 /// </summary> /// <param name="bolNeedUpdateProgress">是否需要更新总进度</param> /// <returns></returns> private Course_UnitContent GetCourseUnitContentActivity(int TrainingId, int UnitContent, int ClassId, bool bolNeedUpdateProgress = true) { //获取所有的阅读信息 var courseBll = new Course_UnitContentBLL(); var DetailBll = new Traning_DetailBLL(); var List_Course_UnitContent = new List<Course_UnitContent>(); var Model_Course_UnitContent = new Course_UnitContent(); var stbSqlWhere = new StringBuilder(); var strOrderBy = "Sort"; int iAccountId = 0, iUnitId = 0; iAccountId = Code.SiteCache.Instance.LoginInfo.UserId; stbSqlWhere.Append(" 1 = 1"); if (TrainingId > 0) stbSqlWhere.AppendFormat(" AND Course_UnitDetail.TrainingId = {0}", TrainingId); if (UnitContent > 0) stbSqlWhere.AppendFormat(" AND Course_UnitContent.Id = {0}", UnitContent); List_Course_UnitContent = courseBll.GetListOther(stbSqlWhere.ToString(), strOrderBy); if (List_Course_UnitContent != null && List_Course_UnitContent.Count == 1) Model_Course_UnitContent = List_Course_UnitContent[0]; //根据 TrainingId 获取 Title var Model_Traning_Detail = DetailBll.GetModel(TrainingId, string.Empty); ViewBag.TraningDetailTitle = Model_Traning_Detail.Title; ViewBag.UnitId = iUnitId = Model_Course_UnitContent.UnitId.Value; ViewBag.AccountId = iAccountId; ViewBag.ClassId = ClassId; ViewBag.TrainingId = TrainingId; ViewBag.UnitContent = UnitContent = Model_Course_UnitContent.Id; ViewBag.Model_Course_UnitContent = Model_Course_UnitContent; if (bolNeedUpdateProgress && List_Course_UnitContent != null && List_Course_UnitContent.Count > 0) { //更新总体进度 this.UpdateOverallProgress(iUnitId, ClassId, TrainingId, iAccountId, UnitContent); } return Model_Course_UnitContent; }
public ActionResult BatchAuditGraduate(int classId, string Ids, string Remark) { try { var bll = new Member_ClassRegisterBLL(); var ids = Ids.Split(','); var classDetail = new Dianda.AP.BLL.Class_DetailBLL().GetModel(classId); var tranFieldModel = new Traning_DetailBLL().GetModel(classDetail.TraningId, ""); foreach (var id in ids) { if (!string.IsNullOrEmpty(id)) { var Val = id.Split('|')[1].ToInt(); if (Val == 0) continue;//不操作 var model = bll.GetList("Delflag=0 and ClassId=" + classId + " and AccountId=" + id.Split('|')[0].ToInt(), "").First(); model.Result = Val; var totalScore = (model.ReadingScore.HasValue ? model.ReadingScore.Value : 0) + (model.DiscussScore.HasValue ? model.DiscussScore.Value : 0) + (model.HomeWorkScore.HasValue ? model.HomeWorkScore.Value : 0) + (model.TestingScore.HasValue ? model.TestingScore.Value : 0) + (model.ExaminationScore.HasValue ? model.ExaminationScore.Value : 0) + (model.CommentScore.HasValue ? model.CommentScore.Value : 0); if (Math.Ceiling(totalScore) < 60 && Val == 1 && tranFieldModel.OutSideType == -1)//分数小于60,不操作 continue; model.ApplyRemark = Remark; model.ResultCreater = SiteCache.Instance.LoginInfo.UserId; model.TotalScore = totalScore; bll.Update(model); var comment = new Dianda.AP.BLL.Class_TraningCommentResultBLL().GetListModel(" ClassId=" + classId + " and AccountId=" + id.Split('|')[0].ToInt() + " and Delflag=0"); if (Val == 1 && comment != null && comment.Count>0)//如果结论是合格,,并且评论过课程,则要更新用户学分 { var tranEditModel = new Member_TrainingReditBLL().GetList("Delflag=0 and TrainingField=" + tranFieldModel.TraingField + " and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId, ""); Member_TrainingRedit tranEdit = null; if (tranEditModel == null || tranEditModel.Count == 0)//创建 { tranEdit = new Member_TrainingRedit(); tranEdit.AccountId = model.AccountId; tranEdit.CreateDate = DateTime.Now; tranEdit.Credits = tranFieldModel.TotalTime.Value; tranEdit.Delflag = false; tranEdit.PlanId = model.PlanId; tranEdit.TrainingField = tranFieldModel.TraingField; new Member_TrainingReditBLL().Add(tranEdit); } else//更新 { tranEdit = tranEditModel.First(); tranEdit.Credits += tranFieldModel.TotalTime.Value; new Member_TrainingReditBLL().Update(tranEdit); } var traningCredit = DataTableToListHelper<Training_Credits>.ConvertToModel( new Training_CreditsBLL().GetList(" and PlanId=" + model.PlanId + " and OrganId=" + classDetail.OrganId, "") );//查找学时学分 if (traningCredit != null && traningCredit.Count > 0) //轮循所有大类 { bool graduateFlag = true; var member_traningBll = new Member_TrainingReditBLL(); foreach (var item in traningCredit) { var traning_credit = member_traningBll.GetList (" Delflag=0 and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId + " and TrainingField=" + item.TraningField , ""); if (traningCredit != null && traningCredit.Count > 0) { if (traningCredit.First().MinValue > tranEdit.Credits) { graduateFlag = false; break; } } } if (graduateFlag)//所有大类学分均合格,更新Member_PlanOverall表的用户合格状态。 { var Member_PlanOverallBll = new Member_PlanOverallBLL(); var Member_PlanOverall = Member_PlanOverallBll.GetListModel(" Delflag=0 and PlanId=" + model.PlanId + " and AccountId=" + model.AccountId); if (Member_PlanOverall != null && Member_PlanOverall.Count > 0) { var item = Member_PlanOverall.First(); item.Result = 1; Member_PlanOverallBll.Update(item); } else { var item = new Member_PlanOverall(); item.Result = 1; item.PlanId = model.PlanId; item.AccountId = model.AccountId; item.CreateDate = DateTime.Now; item.Delflag = false; Member_PlanOverallBll.Add(item); } } } } } } return Json(new { Code = 0, Msg = "提交成功" }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { Code = -1, Msg = ex.Message + ex.StackTrace }, JsonRequestBehavior.AllowGet); } }
//根据选择的课程返回学校范围 public JsonResult GetSchoolByCourse(string courseid) { try { var course = new Traning_DetailBLL().GetModel(courseid.ToInt(), ""); var organBll = new Organ_DetailBLL(); var list = new List<Organ_Detail>(); if (course.Range == 1) //区级 { list = organBll.GetListModel(" Delflag=0 and OType IN ( 1, 2, 3 ) and PartitionId=" + SiteCache.Instance.LoginInfo.PartitionId + " and ParentId=" + SiteCache.Instance.ManageOrganId); } else//市级 { list = organBll.GetShiOrganDetailList(); } return Json(list, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { Code = -1, Msg = ex.Message }, JsonRequestBehavior.AllowGet); } }