public void ParseIndicatorScoreParameterNull_Test() { // Arrange IndicatorScoreDTO indicatorScoreDTO = null; // Act IndicatorScore indicatorScore = factory.Parse(indicatorScoreDTO); }
public IndicatorScoreDTO Create(IndicatorScore indicatorScore) { return(new IndicatorScoreDTO() { Id = indicatorScore.Id, Name = indicatorScore.Name, Weight = indicatorScore.Weight }); }
private IndicatorScore ParseForAdd(IndicatorScoreDTO indicatorScoreDTO) { if (indicatorScoreDTO != null) { var indicatorScore = new IndicatorScore() { Id = indicatorScoreDTO.Id, Name = indicatorScoreDTO.Name, Weight = indicatorScoreDTO.Weight }; return(indicatorScore); } else { throw new NotSupportedException(String.Format("BAD GATEWAY!!! {0} ADD operation temporary NOT SUPPORTED for IndicatorScore table...", Environment.NewLine)); } }
public void ParseIndicatorScoreIdNotZero_Test() { // Arrange IndicatorScoreDTO indicatorScoreDTO = new IndicatorScoreDTO() { Id = 2, Name = "TestName", Weight = 10 }; // Act IndicatorScore indicatorScore = factory.Parse(indicatorScoreDTO); // Assert Assert.True(indicatorScore != null && indicatorScore.Id == indicatorScoreDTO.Id && indicatorScore.Name == indicatorScoreDTO.Name && indicatorScore.Weight == indicatorScoreDTO.Weight); }
private void CancelLaunch() //撤销启动 { if (esEnt.ExamineType == "部门级考核") //撤销启动的时候 如果是部门级考核 需要将考核对象的自定义指标状态设置为2 也就是可以还填写自我评价 { sql = @"select A.* from BJKY_Examine..DeptExamineRelation as A left join BJKY_Examine..ExamineStageDetail as B on A.Id=B.ExamineRelationId where B.ExamineStageId='" + esEnt.Id + "'"; //找到部门考核关系里面的所有被考核人 查找他们的自定义指标 IList <EasyDictionary> dicsRelation = DataHelper.QueryDictList(sql); string beUserIds = ""; string beUserNames = ""; foreach (EasyDictionary dic in dicsRelation) { beUserIds += dic.Get <string>("BeUserIds") + ","; beUserNames += dic.Get <string>("BeUserNames") + ","; } string[] userIdArray = null; if (!string.IsNullOrEmpty(beUserIds)) { userIdArray = beUserIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); } for (int j = 0; j < userIdArray.Length; j++) { IList <CustomIndicator> ciEnts = CustomIndicator.FindAllByProperties("CreateId", userIdArray[j], "Year", esEnt.Year, "StageType", esEnt.StageType); if (ciEnts.Count > 0) { ciEnts[0].State = "2"; ciEnts[0].DoUpdate(); } } } IList <ExamineTask> etEnts = ExamineTask.FindAllByProperty(ExamineTask.Prop_ExamineStageId, esEnt.Id); foreach (ExamineTask etEnt in etEnts) { IList <IndicatorScore> isEnts = IndicatorScore.FindAllByProperty(IndicatorScore.Prop_ExamineTaskId, etEnt.Id); foreach (IndicatorScore isEnt in isEnts) { isEnt.DoDelete(); } etEnt.DoDelete(); } esEnt.TaskQuan = 0; esEnt.State = 0; esEnt.DoUpdate(); }
private void SaveSubScore() { string ExamineTaskId = RequestData.Get <string>("ExamineTaskId"); ExamineTask etEnt = ExamineTask.Find(ExamineTaskId); string IndicatorSecondId = RequestData.Get <string>("IndicatorSecondId"); decimal SubScore = RequestData.Get <decimal>("SubScore"); //decimal Score = RequestData.Get<decimal>("Score"); IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, ExamineTaskId, IndicatorScore.Prop_IndicatorSecondId, IndicatorSecondId); if (insEnts.Count > 0)//更新 { insEnts[0].SubScore = SubScore; insEnts[0].DoUpdate(); } else//创建 { IndicatorScore insEnt = new IndicatorScore(); IndicatorSecond isEnt = IndicatorSecond.Find(IndicatorSecondId); IndicatorFirst ifEnt = IndicatorFirst.Find(isEnt.IndicatorFirstId); string tooltip = "!" + ifEnt.CustomColumn + "#" + isEnt.ToolTip;//加入#号前面的字符是为了标识该指标下有自定义指标,有明细分 insEnt.ExamineTaskId = ExamineTaskId; insEnt.IndicatorFirstId = isEnt.IndicatorFirstId; insEnt.IndicatorFirstName = isEnt.IndicatorFirstName; insEnt.FirstMaxScore = ifEnt.MaxScore; insEnt.FirstSortIndex = ifEnt.SortIndex; insEnt.IndicatorSecondId = isEnt.Id; insEnt.IndicatorSecondName = isEnt.IndicatorSecondName; insEnt.SecondMaxScore = isEnt.MaxScore; insEnt.SecondSortIndex = isEnt.SortIndex; insEnt.SubScore = SubScore; insEnt.ToolTip = tooltip; insEnt.DoCreate(); } sql = "select isnull(SUM(SubScore),0) FROM BJKY_Examine..IndicatorScore WHERE ExamineTaskId = '" + ExamineTaskId + "'"; etEnt.Score = DataHelper.QueryValue <decimal>(sql); etEnt.DoUpdate(); PageState.Add("Score", etEnt.Score); }
private void SaveSubScore() { string ExamineTaskId = RequestData.Get <string>("ExamineTaskId"); ExamineTask etEnt = ExamineTask.Find(ExamineTaskId); string IndicatorSecondId = RequestData.Get <string>("IndicatorSecondId"); decimal SubScore = RequestData.Get <decimal>("SubScore"); decimal Score = RequestData.Get <decimal>("Score"); IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, ExamineTaskId, IndicatorScore.Prop_IndicatorSecondId, IndicatorSecondId); if (insEnts.Count > 0)//更新 { insEnts[0].SubScore = SubScore; insEnts[0].DoUpdate(); } else//创建 { IndicatorScore insEnt = new IndicatorScore(); IndicatorSecond isEnt = IndicatorSecond.Find(IndicatorSecondId); IndicatorFirst ifEnt = IndicatorFirst.Find(isEnt.IndicatorFirstId); string tooltip = "!" + ifEnt.InsteadColumn + "#" + isEnt.ToolTip;//加入#号前面的字符是为了验证经营开发正职 部分要素分是由人力资源部打的 insEnt.ExamineTaskId = ExamineTaskId; insEnt.IndicatorFirstId = isEnt.IndicatorFirstId; insEnt.IndicatorFirstName = isEnt.IndicatorFirstName; insEnt.FirstMaxScore = ifEnt.MaxScore; insEnt.FirstSortIndex = ifEnt.SortIndex; insEnt.IndicatorSecondId = isEnt.Id; insEnt.IndicatorSecondName = isEnt.IndicatorSecondName; insEnt.SecondMaxScore = isEnt.MaxScore; insEnt.SecondSortIndex = isEnt.SortIndex; insEnt.SubScore = SubScore; insEnt.ToolTip = tooltip; insEnt.DoCreate(); etEnt.Score = Score; etEnt.DoUpdate(); } etEnt.Score = Score; etEnt.DoUpdate(); }
private void DoSelect() { string sequence = ""; DeptExamineRelation derEnt = DeptExamineRelation.TryFind(ExamineRelationId);//根据阶段取得部门 if (derEnt != null) { sequence = derEnt.BeUserNames; } if (Index == "0") { sql = @"select *,CharIndex(BeUserName,'{0}') as SortIndex from BJKY_Examine..ExamineTask where State='1' and ExamineStageId='{1}' and ToUserId='{2}' and ExamineRelationId='{3}' order by SortIndex "; sql = string.Format(sql, sequence, ExamineStageId, UserInfo.UserID, ExamineRelationId); } if (Index == "1") { sql = @"select *,CharIndex(BeUserName,'{0}') as SortIndex from BJKY_Examine..ExamineTask where State='2' and ExamineStageId='{1}' and ToUserId='{2}' and ExamineRelationId='{3}'"; sql = string.Format(sql, sequence, ExamineStageId, UserInfo.UserID, ExamineRelationId); } if (Index == "2") { sql = @"select *,CharIndex(BeUserName,'{0}') as SortIndex from BJKY_Examine..ExamineTask where State='3' and ExamineStageId='{1}' and ToUserId='{2}' and ExamineRelationId='{3}' order by SortIndex "; sql = string.Format(sql, sequence, ExamineStageId, UserInfo.UserID, ExamineRelationId); } if (!string.IsNullOrEmpty(id))//单任务查看明细 { sql = @"select * from BJKY_Examine..ExamineTask where Id='" + id + "'"; } IList <EasyDictionary> dics = DataHelper.QueryDictList(sql);//找到所有符合条件的任务 if (dics.Count > 0) { if (Index != "2") { DataTable dt = new DataTable(); DataColumn dc = new DataColumn("Id"); dt.Columns.Add(dc); dc = new DataColumn("BeUserName"); dt.Columns.Add(dc); dc = new DataColumn("BeDeptName"); dt.Columns.Add(dc); dc = new DataColumn("Score"); dt.Columns.Add(dc); dc = new DataColumn("Tag"); dt.Columns.Add(dc); DataTable dt1 = new DataTable();//这个表专门用来存储一级指标名称和各2级指标数量 DataColumn dc1 = new DataColumn("IndicatorFirstName"); dt1.Columns.Add(dc1); dc1 = new DataColumn("SecondCount"); dt1.Columns.Add(dc1); ExamineIndicator eiEnt = ExamineIndicator.Find(dics[0].Get <string>("ExamineIndicatorId")); IList <IndicatorFirst> ifEnts = IndicatorFirst.FindAllByProperty("SortIndex", IndicatorFirst.Prop_ExamineIndicatorId, eiEnt.Id); foreach (IndicatorFirst ifEnt in ifEnts) { IList <IndicatorSecond> isEnts = IndicatorSecond.FindAllByProperty("SortIndex", IndicatorSecond.Prop_IndicatorFirstId, ifEnt.Id); DataRow dr1 = dt1.NewRow(); dr1["IndicatorFirstName"] = ifEnt.IndicatorFirstName + "(" + ifEnt.MaxScore + ")"; dr1["SecondCount"] = isEnts.Count; if (isEnts.Count > 0) { dt1.Rows.Add(dr1);//防止只有一级指标无2级指标。 } foreach (IndicatorSecond isEnt in isEnts) { string standard = "!" + ifEnt.CustomColumn + "#" + isEnt.ToolTip; //加入#号前面的字符是为了验证自定义指标列 dc = new DataColumn(isEnt.Id + isEnt.IndicatorSecondName + "(" + isEnt.MaxScore + ")" + standard); //列名有多种信息组合而成。便于前台取对应的值 dt.Columns.Add(dc); //循环2级指标构建剩余列 } } IList <EasyDictionary> secDics = null; if (dics.Count > 0)//通过任务的指标Id找到其下所有 的二级指标 { sql = @"select A.Id, a.IndicatorSecondName,B.CustomColumn,A.ToolTip,A.MaxScore from BJKY_Examine..IndicatorSecond A left join BJKY_Examine..IndicatorFirst B on A.IndicatorFirstId=B.Id where B.ExamineIndicatorid='{0}' " ; sql = string.Format(sql, dics[0].Get <string>("ExamineIndicatorId")); secDics = DataHelper.QueryDictList(sql); } foreach (EasyDictionary dic in dics)//通过任务构建行记录 { DataRow dr = dt.NewRow(); dr["Id"] = dic.Get <string>("Id"); dr["BeUserName"] = dic.Get <string>("BeUserName"); dr["BeDeptName"] = dic.Get <string>("BeDeptName"); dr["Score"] = dic.Get <string>("Score"); dr["Tag"] = dic.Get <string>("Tag"); foreach (EasyDictionary secDic in secDics) { string standard = "!" + secDic.Get <string>("CustomColumn") + "#" + secDic.Get <string>("ToolTip"); IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, dic.Get <string>("Id"), IndicatorScore.Prop_IndicatorSecondId, secDic.Get <string>("Id")); if (insEnts.Count > 0) { dr[secDic.Get <string>("Id") + secDic.Get <string>("IndicatorSecondName") + "(" + secDic.Get <string>("MaxScore") + ")" + standard] = insEnts[0].SubScore; } } dt.Rows.Add(dr); } PageState.Add("DataList", dt); PageState.Add("ColumnData", dt.Columns); PageState.Add("DataList1", dt1); } else { InitialHistoryScore(dics); } esEnt = ExamineStage.Find(ExamineStageId); string stageType = ""; if (esEnt.StageType != "4") { stageType = "第" + esEnt.StageType + "季度"; } else { stageType = "年度"; } PageState.Add("Title", esEnt.Year + stageType + "考核评分表"); } }