private Guid AddProductLend()
        {
            ProductLend v = new ProductLend();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                try{
                    v.PPName    = "OdIfUy";
                    v.PPCompany = "QyTP";
                    v.PPMan     = "5yiMffBKn";
                    v.PPTel     = "ktWi";
                    v.PPAddress = "MV58sLTIa";
                    v.PPFax     = "6hWhT";
                    v.Email     = "obLTExJb";
                    v.PPUrl     = "E02";
                    v.PPBank    = "oPtpfzd3k";
                    v.PPGoods   = "z95D";
                    v.PPDesc    = "SPX0v";
                    context.Set <ProductLend>().Add(v);
                    context.SaveChanges();
                }
                catch {}
            }
            return(v.ID);
        }
Exemple #2
0
        /// <summary>
        /// 修改供货商信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int Edit(ProductLend pd)
        {
            PSSEntities db = new PSSEntities();

            db.Entry <ProductLend>(pd).State = System.Data.Entity.EntityState.Modified;
            return(db.SaveChanges());
        }
        private Guid AddProductLend()
        {
            ProductLend v = new ProductLend();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                try{
                    v.PPName    = "XeyRpyJ";
                    v.PPCompany = "NagQSeGX7";
                    v.PPMan     = "42dA";
                    v.PPTel     = "tCNP";
                    v.PPAddress = "HhRt";
                    v.PPFax     = "m4T7j";
                    v.Email     = "dTntSyfqx";
                    v.PPUrl     = "cQJoJtNzP";
                    v.PPBank    = "juM";
                    v.PPGoods   = "EwJqfYu";
                    v.PPDesc    = "WT8c";
                    context.Set <ProductLend>().Add(v);
                    context.SaveChanges();
                }
                catch {}
            }
            return(v.ID);
        }
Exemple #4
0
        /// <summary>
        /// 添加供货商
        /// </summary>
        /// <param name="pd"></param>
        /// <returns></returns>
        public static int Add(ProductLend pd)
        {
            PSSEntities db = new PSSEntities();

            db.ProductLend.Add(pd);
            return(db.SaveChanges());
        }
Exemple #5
0
        public ActionResult EditProductLend(ProductLend pd)
        {
            if (ProductLendBLL.Edit(pd) > 0)
            {
                TempData["fg"] = "edit_yes";
            }
            else
            {
                TempData["fg"] = "edit_no";
            }

            return(RedirectToAction("ProductLend"));
        }
Exemple #6
0
        public ActionResult AddProductLend(ProductLend pd)
        {
            if (ProductLendBLL.Add(pd) > 0)
            {
                TempData["fg"] = "add_yes";
            }
            else
            {
                TempData["fg"] = "add_no";
            }

            return(RedirectToAction("ProductLend"));
        }
        public void BatchDeleteTest()
        {
            ProductLend v1 = new ProductLend();
            ProductLend v2 = new ProductLend();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v1.PPName    = "v2oN";
                v1.PPCompany = "Sza6IW";
                v1.PPMan     = "IJ5X";
                v1.PPTel     = "kpXu4";
                v1.PPAddress = "nJ4OQ4";
                v1.PPFax     = "m42oqLkCB";
                v1.Email     = "6ajhl";
                v1.PPUrl     = "yrt2p";
                v1.PPBank    = "POf9cnR";
                v1.PPGoods   = "VzWw6F";
                v1.PPDesc    = "brh6";
                v2.PPName    = "IUBI5yl";
                v2.PPCompany = "wAt";
                v2.PPMan     = "ws9LAcKGM";
                v2.PPTel     = "hAi8";
                v2.PPAddress = "HElI1hP";
                v2.PPFax     = "uzO";
                v2.Email     = "I1kyoqEnL";
                v2.PPUrl     = "OvZWiPl";
                v2.PPBank    = "xdTSPahAz";
                v2.PPGoods   = "dCaFM";
                v2.PPDesc    = "Ec5RFf";
                context.Set <ProductLend>().Add(v1);
                context.Set <ProductLend>().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 <ProductLend>().Find(v1.ID);
                var data2 = context.Set <ProductLend>().Find(v2.ID);
                Assert.AreEqual(data1, null);
                Assert.AreEqual(data2, null);
            }

            rv = _controller.BatchDelete(new string[] {});
            Assert.IsInstanceOfType(rv, typeof(OkResult));
        }
        public void CreateTest()
        {
            ProductLendVM vm = _controller.Wtm.CreateVM <ProductLendVM>();
            ProductLend   v  = new ProductLend();

            v.PPName    = "v2oN";
            v.PPCompany = "Sza6IW";
            v.PPMan     = "IJ5X";
            v.PPTel     = "kpXu4";
            v.PPAddress = "nJ4OQ4";
            v.PPFax     = "m42oqLkCB";
            v.Email     = "6ajhl";
            v.PPUrl     = "yrt2p";
            v.PPBank    = "POf9cnR";
            v.PPGoods   = "VzWw6F";
            v.PPDesc    = "brh6";
            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 <ProductLend>().Find(v.ID);

                Assert.AreEqual(data.PPName, "v2oN");
                Assert.AreEqual(data.PPCompany, "Sza6IW");
                Assert.AreEqual(data.PPMan, "IJ5X");
                Assert.AreEqual(data.PPTel, "kpXu4");
                Assert.AreEqual(data.PPAddress, "nJ4OQ4");
                Assert.AreEqual(data.PPFax, "m42oqLkCB");
                Assert.AreEqual(data.Email, "6ajhl");
                Assert.AreEqual(data.PPUrl, "yrt2p");
                Assert.AreEqual(data.PPBank, "POf9cnR");
                Assert.AreEqual(data.PPGoods, "VzWw6F");
                Assert.AreEqual(data.PPDesc, "brh6");
                Assert.AreEqual(data.CreateBy, "user");
                Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
            }
        }
        public void GetTest()
        {
            ProductLend v = new ProductLend();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.PPName    = "v2oN";
                v.PPCompany = "Sza6IW";
                v.PPMan     = "IJ5X";
                v.PPTel     = "kpXu4";
                v.PPAddress = "nJ4OQ4";
                v.PPFax     = "m42oqLkCB";
                v.Email     = "6ajhl";
                v.PPUrl     = "yrt2p";
                v.PPBank    = "POf9cnR";
                v.PPGoods   = "VzWw6F";
                v.PPDesc    = "brh6";
                context.Set <ProductLend>().Add(v);
                context.SaveChanges();
            }
            var rv = _controller.Get(v.ID.ToString());

            Assert.IsNotNull(rv);
        }
Exemple #10
0
 public async Task <int> INSERTuniversalProductLend(ProductLend s)
 {
     return(await universalModuelProductLend.Insert(s));
 }
Exemple #11
0
 public async Task <int> UPuniversalModuelProductLend(ProductLend s)
 {
     return(await universalModuelProductLend.Update_Key(s.PPID, s));
 }
        public void EditTest()
        {
            ProductLend v = new ProductLend();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.PPName    = "v2oN";
                v.PPCompany = "Sza6IW";
                v.PPMan     = "IJ5X";
                v.PPTel     = "kpXu4";
                v.PPAddress = "nJ4OQ4";
                v.PPFax     = "m42oqLkCB";
                v.Email     = "6ajhl";
                v.PPUrl     = "yrt2p";
                v.PPBank    = "POf9cnR";
                v.PPGoods   = "VzWw6F";
                v.PPDesc    = "brh6";
                context.Set <ProductLend>().Add(v);
                context.SaveChanges();
            }

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

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

            v.PPName    = "IUBI5yl";
            v.PPCompany = "wAt";
            v.PPMan     = "ws9LAcKGM";
            v.PPTel     = "hAi8";
            v.PPAddress = "HElI1hP";
            v.PPFax     = "uzO";
            v.Email     = "I1kyoqEnL";
            v.PPUrl     = "OvZWiPl";
            v.PPBank    = "xdTSPahAz";
            v.PPGoods   = "dCaFM";
            v.PPDesc    = "Ec5RFf";
            vm.Entity   = v;
            vm.FC       = new Dictionary <string, object>();

            vm.FC.Add("Entity.PPName", "");
            vm.FC.Add("Entity.PPCompany", "");
            vm.FC.Add("Entity.PPMan", "");
            vm.FC.Add("Entity.PPTel", "");
            vm.FC.Add("Entity.PPAddress", "");
            vm.FC.Add("Entity.PPFax", "");
            vm.FC.Add("Entity.Email", "");
            vm.FC.Add("Entity.PPUrl", "");
            vm.FC.Add("Entity.PPBank", "");
            vm.FC.Add("Entity.PPGoods", "");
            vm.FC.Add("Entity.PPDesc", "");
            var rv = _controller.Edit(vm);

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

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

                Assert.AreEqual(data.PPName, "IUBI5yl");
                Assert.AreEqual(data.PPCompany, "wAt");
                Assert.AreEqual(data.PPMan, "ws9LAcKGM");
                Assert.AreEqual(data.PPTel, "hAi8");
                Assert.AreEqual(data.PPAddress, "HElI1hP");
                Assert.AreEqual(data.PPFax, "uzO");
                Assert.AreEqual(data.Email, "I1kyoqEnL");
                Assert.AreEqual(data.PPUrl, "OvZWiPl");
                Assert.AreEqual(data.PPBank, "xdTSPahAz");
                Assert.AreEqual(data.PPGoods, "dCaFM");
                Assert.AreEqual(data.PPDesc, "Ec5RFf");
                Assert.AreEqual(data.UpdateBy, "user");
                Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
            }
        }
Exemple #13
0
 /// <summary>
 /// 修改供货商信息
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public static int Edit(ProductLend pd)
 {
     return(ProductLendDAL.Edit(pd));
 }
Exemple #14
0
 /// <summary>
 /// 添加供货商信息
 /// </summary>
 /// <param name="pd"></param>
 /// <returns></returns>
 public static int Add(ProductLend pd)
 {
     return(ProductLendDAL.Add(pd));
 }