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); }
/// <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); }
/// <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()); }
public ActionResult EditProductLend(ProductLend pd) { if (ProductLendBLL.Edit(pd) > 0) { TempData["fg"] = "edit_yes"; } else { TempData["fg"] = "edit_no"; } return(RedirectToAction("ProductLend")); }
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); }
public async Task <int> INSERTuniversalProductLend(ProductLend s) { return(await universalModuelProductLend.Insert(s)); }
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); } }
/// <summary> /// 修改供货商信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int Edit(ProductLend pd) { return(ProductLendDAL.Edit(pd)); }
/// <summary> /// 添加供货商信息 /// </summary> /// <param name="pd"></param> /// <returns></returns> public static int Add(ProductLend pd) { return(ProductLendDAL.Add(pd)); }