コード例 #1
0
ファイル: FrameReviewBLL.cs プロジェクト: 839928622/WageDemo
        /// <summary>
        /// 获取自评分数
        /// </summary>
        /// <param name="intentionID">评审单号</param>
        public FrameReviewBLL(string FrameReviewID)
        {
            if (string.IsNullOrEmpty(FrameReviewID))
            {
                FrameReviewID = "-1";//这样取出的就是一个空的视图
            }
            FrameReviewEntity1 = new V_FrameReviewEntity();
            FrameReviewEntity1.ResetForSearch();
            FrameReviewEntity1.FrameReviewID = FrameReviewID;
            FrameReviewEntity1.GetTable(true);

            FrameReviewerShowEntity = new FrameReviewerEntity();
            FrameReviewerShowEntity.ResetForSearch();
            FrameReviewerShowEntity.FrameReviewID = FrameReviewID;
            FrameReviewerShowEntity.Reviewer      = FrameReviewEntity1.CreateMan;
            FrameReviewerShowEntity.GetTable(true);



            FrameReviewScoreEntity          = new V_FrameReviewScoreShowEntity();
            FrameReviewScoreEntity.PageSize = 0;//设置返回数据,即集合变量的大小,为0则放回全部数据
            FrameReviewScoreEntity.ResetForSearch();

            FrameReviewScoreEntity.FrameReviewID = FrameReviewID;
            //FrameReviewScoreEntity.GetTable(true);
            FrameReviewScoreEntity.OrderFields = "StandardType,SequenceID";
            FrameReviewScoreList = FrameReviewScoreEntity.ToList <V_FrameReviewScoreShowEntity>();
        }
コード例 #2
0
ファイル: FrameReviewBLL.cs プロジェクト: 839928622/WageDemo
        /// <summary>
        /// 用于获取评审人评分数据
        /// </summary>
        /// <param name="FrameReviewID">框架评审单号</param>
        /// <param name="Reviewer">评审人工号</param>
        public FrameReviewBLL(string FrameReviewID, string Reviewer)
        {
            string flagReviewer = null;

            flagReviewer = Reviewer;

            FrameReviewEntity1 = new V_FrameReviewEntity();
            FrameReviewEntity1.ResetForSearch();
            FrameReviewEntity1.FrameReviewID = FrameReviewID;
            FrameReviewEntity1.GetTable(true);

            FrameReviewerShowEntity = new FrameReviewerEntity();
            FrameReviewerShowEntity.ResetForSearch();
            FrameReviewerShowEntity.FrameReviewID = FrameReviewID;
            FrameReviewerShowEntity.Reviewer      = Reviewer;
            FrameReviewerShowEntity.GetTable(true);


            FrameReviewScoreEntity          = new V_FrameReviewScoreShowEntity();
            FrameReviewScoreEntity.PageSize = 0;//设置返回数据,即集合变量的大小,为0则放回全部数据
            FrameReviewScoreEntity.ResetForSearch();

            FrameReviewScoreEntity.FrameReviewID = FrameReviewID;
            FrameReviewScoreEntity.OrderFields   = "StandardType,SequenceID";

            FrameReviewScoreList = FrameReviewScoreEntity.ToList <V_FrameReviewScoreShowEntity>();
            foreach (var s in FrameReviewScoreList)
            {
                if (string.IsNullOrEmpty(s.Reviewer))
                {
                    Isexist = 0;//插入
                    break;
                }
                else if (s.Reviewer == flagReviewer)
                {
                    Reviewer = flagReviewer;
                    Isexist  = 1;//更新
                    break;
                }
                else
                {
                    Reviewer = s.Reviewer;
                    Isexist  = 2;//插入,评委第一次评分
                }
            }

            //其实这里可以用一个foreach来遍历标准表,依次插数据到实体类中然后插入
            if (Isexist != 0)
            {
                FrameReviewScoreEntity          = new V_FrameReviewScoreShowEntity();
                FrameReviewScoreEntity.PageSize = 0;
                FrameReviewScoreEntity.ResetForSearch();
                if (string.IsNullOrEmpty(FrameReviewID) || string.IsNullOrEmpty(Reviewer))
                {
                    FrameReviewID = "-1";
                    Reviewer      = "-1";
                }
                FrameReviewScoreEntity.FrameReviewID = FrameReviewID;
                FrameReviewScoreEntity.Reviewer      = Reviewer;

                FrameReviewScoreList = FrameReviewScoreEntity.ToList <V_FrameReviewScoreShowEntity>();
                if (Isexist == 2 && Reviewer != flagReviewer)
                {
                    if (FrameReviewEntity1.FrameReviewers.Contains(flagReviewer))
                    {
                        foreach (var i in FrameReviewScoreList)//第一次评分时消除历史数据
                        {
                            i.reviewerReview = null;
                        }
                    }
                    else
                    { //其他人员查看
                        V_FrameReviewEntity FrameReviewEntity = new V_FrameReviewEntity();
                        FrameReviewEntity.ResetForSearch();
                        FrameReviewEntity.FrameReviewID = FrameReviewID;
                        FrameReviewEntity.GetTable(true);
                        decimal?devDay   = FrameReviewEntity.DevelopDays;
                        decimal?passRate = FrameReviewEntity.PassingRate;

                        SqlDataBase db = new SqlDataBase();
                        //妙,这里取最小值作为分数,避免了相加的麻烦,good for you
                        DataTable dt = db.GetTable(" SELECT A.Reviewerreview FROM(SELECT StandardType,SequenceID,MIN(reviewerReview) reviewerReview FROM dbo.V_FrameReviewScore " +
                                                   " WHERE ISNULL(Reviewer, '') <> '' AND FrameReviewID = '" + FrameReviewID + "' GROUP BY StandardType, SequenceID) A ORDER BY A.StandardType,A.SequenceID");
                        int flag = 0;
                        foreach (var i in FrameReviewScoreList)//替换数据为综合数据
                        {
                            i.reviewerReview = (int)dt.Rows[flag]["reviewerReview"];
                            flag++;
                        }
                    }
                }
            }
        }