Exemplo n.º 1
0
        List <Knowledge> ICedts_HomeRepository.KPMaster()
        {
            List <Knowledge> knowList = new List <Knowledge>();

            var Kp = db.CEDTS_SampleKnowledgeInfomation;

            foreach (var m in Kp)
            {
                Knowledge know = new Knowledge();

                var   kpname = (from s in db.CEDTS_KnowledgePoints where s.KnowledgePointID == m.KnowledgePointID select s.Title).FirstOrDefault();
                Regex regex  = new Regex(@"[.\d]");//去除数字
                kpname = regex.Replace(kpname, "");
                double KP_MasterRate1 = m.KP_MasterRate.Value * 100;
                string KP_MasterRate  = KP_MasterRate1 + "";

                if (KP_MasterRate.Length > 4)
                {
                    KP_MasterRate = KP_MasterRate.Substring(0, KP_MasterRate.IndexOf('.') + 2);
                }

                m.KP_MasterRate = Convert.ToDouble(KP_MasterRate);
                if (knowList.Count == 0)
                {
                    know.KPName = kpname;

                    know.UMi = m.KP_MasterRate.Value;
                    knowList.Add(know);
                }
                else
                {
                    int Right = 0;
                    for (int i = 0; i < knowList.Count; i++)
                    {
                        if (knowList[i].KPName == kpname)
                        {
                            knowList[i].UMi = (knowList[i].UMi + m.KP_MasterRate.Value) / 2;
                            Right           = 1;
                        }
                    }
                    if (Right != 1)
                    {
                        know.KPName = kpname;
                        know.UMi    = m.KP_MasterRate.Value;
                        knowList.Add(know);
                    }
                }
            }
            return(knowList);
        }
Exemplo n.º 2
0
        List <Knowledge> ICedts_HomeRepository.UserKpMaster(string UserName)
        {
            List <Knowledge> KnowList = new List <Knowledge>();
            var UserID = (from m in db.CEDTS_User where m.UserAccount == UserName select m.UserID).FirstOrDefault();
            var KpName = (from m in db.CEDTS_KnowledgePoints orderby m.Title select m);

            foreach (var kp in KpName)
            {
                string    Name  = string.Empty;
                Knowledge kown  = new Knowledge();
                Regex     regex = new Regex(@"[.\d]");
                Name = regex.Replace(kp.Title, "");
                var SMiInfo = (from m in db.CEDTS_SampleKnowledgeInfomation where m.KnowledgePointID == kp.KnowledgePointID select m.KP_MasterRate).FirstOrDefault();
                var UMiInfo = (from m in db.CEDTS_UserKnowledgeInfomation where m.UserID == UserID && m.KnowledgePointID == kp.KnowledgePointID select m.KP_MasterRate).FirstOrDefault();

                if (UMiInfo != null)
                {
                    double SMi1 = SMiInfo.Value * 100;
                    double UMi1 = UMiInfo.Value * 100;
                    string SMi  = SMi1 + "";
                    string UMi  = UMi1 + "";
                    if (SMi.Length > 4)
                    {
                        SMi = SMi.Substring(0, SMi.IndexOf('.') + 2);
                    }
                    if (UMi.Length > 4)
                    {
                        UMi = UMi.Substring(0, UMi.IndexOf('.') + 2);
                    }
                    kown.KPName = Name;
                    kown.SMi    = double.Parse(SMi);
                    kown.UMi    = double.Parse(UMi);
                    KnowList.Add(kown);
                }
            }
            return(KnowList);
        }