Пример #1
0
        public void BatchDeleteTest()
        {
            MajorInfo v1 = new MajorInfo();
            MajorInfo v2 = new MajorInfo();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v1.ID   = 97;
                v1.Code = "OvF";
                v1.Name = "YTWPQ2Nb";
                v2.ID   = 39;
                v2.Code = "Am0";
                v2.Name = "Ids";
                context.Set <MajorInfo>().Add(v1);
                context.Set <MajorInfo>().Add(v2);
                context.SaveChanges();
            }

            var rv = _controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() });

            Assert.IsInstanceOfType(rv, typeof(OkObjectResult));

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                var data1 = context.Set <MajorInfo>().Find(v1.ID);
                var data2 = context.Set <MajorInfo>().Find(v2.ID);
                Assert.AreEqual(data1.IsValid, false);
                Assert.AreEqual(data2.IsValid, false);
            }

            rv = _controller.BatchDelete(new string[] {});
            Assert.IsInstanceOfType(rv, typeof(OkResult));
        }
Пример #2
0
        private Int32 AddMajorInfo()
        {
            MajorInfo v = new MajorInfo();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.ID   = 13;
                v.Code = "Bif";
                v.Name = "wCku2uz";
                context.Set <MajorInfo>().Add(v);
                context.SaveChanges();
            }
            return(v.ID);
        }
Пример #3
0
        private Int32 AddMajorInfo()
        {
            MajorInfo v = new MajorInfo();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.ID   = 95;
                v.Code = "CSiT";
                v.Name = "b2SGAGBlh";
                context.Set <MajorInfo>().Add(v);
                context.SaveChanges();
            }
            return(v.ID);
        }
Пример #4
0
        public void GetTest()
        {
            MajorInfo v = new MajorInfo();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.ID   = 97;
                v.Code = "OvF";
                v.Name = "YTWPQ2Nb";
                context.Set <MajorInfo>().Add(v);
                context.SaveChanges();
            }
            var rv = _controller.Get(v.ID.ToString());

            Assert.IsNotNull(rv);
        }
Пример #5
0
        public List <MajorInfo> GetAllMajorInfo(int collegeID) //以学院编号获取专业信息的方法
        {
            MajorInfo        major;
            List <MajorInfo> list = new List <MajorInfo>();
            string           sql  = "select * from MajorInfo where CollegeID=@CollegeID";

            SqlParameter[] parameter = { new SqlParameter("@CollegeID", collegeID) };
            //parameter[0].Value = collegeID;
            using (SqlDataReader sdr = DBHelpers.GetAllInfo(sql, parameter))
            {
                while (sdr.Read())
                {
                    major             = new MajorInfo();
                    major.MajorInfoID = int.Parse(sdr["MajorInfoID"].ToString());
                    major.MajorSimple = sdr["MajorSimple"].ToString();
                    list.Add(major);
                }
            }
            return(list);
        }
Пример #6
0
        public void EditTest()
        {
            MajorInfo v = new MajorInfo();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.ID   = 97;
                v.Code = "OvF";
                v.Name = "YTWPQ2Nb";
                context.Set <MajorInfo>().Add(v);
                context.SaveChanges();
            }

            MajorInfoVM vm    = _controller.Wtm.CreateVM <MajorInfoVM>();
            var         oldID = v.ID;

            v    = new MajorInfo();
            v.ID = oldID;

            v.Code    = "Am0";
            v.Name    = "Ids";
            vm.Entity = v;
            vm.FC     = new Dictionary <string, object>();

            vm.FC.Add("Entity.ID", "");
            vm.FC.Add("Entity.Code", "");
            vm.FC.Add("Entity.Name", "");
            var rv = _controller.Edit(vm);

            Assert.IsInstanceOfType(rv, typeof(OkObjectResult));

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                var data = context.Set <MajorInfo>().Find(v.ID);

                Assert.AreEqual(data.Code, "Am0");
                Assert.AreEqual(data.Name, "Ids");
                Assert.AreEqual(data.UpdateBy, "user");
                Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
            }
        }
Пример #7
0
        public void CreateTest()
        {
            MajorInfoVM vm = _controller.Wtm.CreateVM <MajorInfoVM>();
            MajorInfo   v  = new MajorInfo();

            v.ID      = 97;
            v.Code    = "OvF";
            v.Name    = "YTWPQ2Nb";
            vm.Entity = v;
            var rv = _controller.Add(vm);

            Assert.IsInstanceOfType(rv, typeof(OkObjectResult));

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                var data = context.Set <MajorInfo>().Find(v.ID);

                Assert.AreEqual(data.ID, 97);
                Assert.AreEqual(data.Code, "OvF");
                Assert.AreEqual(data.Name, "YTWPQ2Nb");
                Assert.AreEqual(data.CreateBy, "user");
                Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
            }
        }