public void CreateTest() { SaleDepotVM vm = _controller.Wtm.CreateVM <SaleDepotVM>(); SaleDepot v = new SaleDepot(); v.SDID = "llzttATB"; v.CustomersID = AddCustomers(); v.DepotsID = AddDepots(); v.SDState = SCMSupplyChain.Model.SDState.未定义3; v.SDDesc = "dKnEjDp7L"; 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 <SaleDepot>().Find(v.ID); Assert.AreEqual(data.SDID, "llzttATB"); Assert.AreEqual(data.SDState, SCMSupplyChain.Model.SDState.未定义3); Assert.AreEqual(data.SDDesc, "dKnEjDp7L"); Assert.AreEqual(data.CreateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10); } }
/// <summary> /// 添加销售出库单 /// </summary> /// <param name="qp"></param> /// <param name="list"></param> /// <returns></returns> internal static int AddStocks(SaleDepot qp, List <SaleDepotDetail> list) { PSSEntities db = new PSSEntities(); int fg = 1; using (var tx = db.Database.BeginTransaction()) { try { db.SaleDepot.Add(qp); if (list != null) { db.SaleDepotDetail.AddRange(list); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { fg = 0; tx.Rollback(); throw new Exception(ex.Message); } } return(fg); }
/// <summary> /// 审核销售出库单 /// </summary> /// <param name="id"></param> /// <param name="userid"></param> /// <returns></returns> internal static int CKInDepot(string id, int userid) { PSSEntities db = new PSSEntities(); int fg = 1; using (var tx = db.Database.BeginTransaction()) { try { SaleDepot co = db.SaleDepot.FirstOrDefault(p => p.SDID.Equals(id)); co.SDState = 1; ObjectParameter para = new ObjectParameter("DD", ""); db.pro_order("InOutDepot", "IODNum", "RK", para); string IODNum = para.Value.ToString(); //添加入库记录 db.InOutDepot.Add(new InOutDepot() { DepotID = co.DepotID, IODType = 2, IODNum = IODNum, IODDate = DateTime.Now, IODUser = userid, IODDesc = co.SDDesc }); db.SaveChanges(); int inod = db.InOutDepot.Max(i => i.IODID); List <SaleDepotDetail> list = db.SaleDepotDetail.Where(p => p.SDID.Equals(id)).ToList(); //销售出库详单 List <CustomerOrderDetail> cuslist = db.CustomerOrderDetail.Where(p => p.COID.Equals(co.COID)).ToList(); //客户订单详单 foreach (SaleDepotDetail item in list) { //修改客户订单已销数量 foreach (CustomerOrderDetail cus in cuslist) { if (cus.ProID == item.ProID) { cus.CODSale = item.SDDAmount; } } if (db.DepotStock.FirstOrDefault(p => p.DepotID.Equals(co.DepotID) && p.ProID == item.ProID) == null) {//如果指定的仓库中不存在该商品 throw new Exception("不存在该商品,操作失败!"); } else {//如果指定仓库存在这个商品,修改这个商品的库存 DepotStock ds = db.DepotStock.FirstOrDefault(d => d.ProID == item.ProID && d.DepotID == co.DepotID); ds.DSAmount = ds.DSAmount - item.SDDAmount; } //添加入库记录详情 db.InOutDepotDetail.Add(new InOutDepotDetail() { IODID = inod, ProID = item.ProID, IODDAmount = item.SDDAmount, IODDPrice = item.SDDPrice }); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { fg = 0; tx.Rollback(); throw new Exception(ex.Message); } } return(fg); }
/// <summary> /// 修改销售出库单 /// </summary> /// <param name="qp"></param> /// <param name="list"></param> /// <returns></returns> internal static int EditStocks(SaleDepot qp, List <SaleDepotDetail> list) { PSSEntities db = new PSSEntities(); int fg = 1; using (var tx = db.Database.BeginTransaction()) { try { SaleDepot c = db.SaleDepot.FirstOrDefault(p => p.SDID.Equals(qp.SDID)); c.CusID = qp.CusID; c.DepotID = qp.DepotID; c.SDState = qp.SDState; c.SDDesc = qp.SDDesc; db.SaleDepotDetail.RemoveRange(db.SaleDepotDetail.Where(s => s.SDID.Equals(qp.SDID))); if (list != null) { db.SaleDepotDetail.AddRange(list); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { fg = 0; tx.Rollback(); throw new Exception(ex.Message); } } return(fg); }
/// <summary> /// 修改客户订单 /// </summary> /// <param name="qp"></param> /// <param name="list"></param> /// <returns></returns> public ActionResult EditCustomerOrder(SaleDepot qp, List <SaleDepotDetail> list) { if (SaleDepotBLL.EditStocks(qp, list) > 0) { return(Content("edit_yes")); } else { return(Content("edit_no")); } }
/// <summary> /// 添加客户订单 /// </summary> /// <param name="qp"></param> /// <param name="list"></param> /// <returns></returns> public ActionResult AddSaleDepot(SaleDepot qp, List <SaleDepotDetail> list) { qp.UserID = Convert.ToInt32(Session["uid"]); if (SaleDepotBLL.AddStocks(qp, list) > 0) { return(Content("add_yes")); } else { return(Content("add_no")); } }
public void EditTest() { SaleDepot v = new SaleDepot(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.SDID = "llzttATB"; v.CustomersID = AddCustomers(); v.DepotsID = AddDepots(); v.SDState = SCMSupplyChain.Model.SDState.未定义3; v.SDDesc = "dKnEjDp7L"; context.Set <SaleDepot>().Add(v); context.SaveChanges(); } SaleDepotVM vm = _controller.Wtm.CreateVM <SaleDepotVM>(); var oldID = v.ID; v = new SaleDepot(); v.ID = oldID; v.SDID = "7n7mcX"; v.SDState = SCMSupplyChain.Model.SDState.未定义3; v.SDDesc = "U4MY"; vm.Entity = v; vm.FC = new Dictionary <string, object>(); vm.FC.Add("Entity.SDID", ""); vm.FC.Add("Entity.CustomersID", ""); vm.FC.Add("Entity.DepotsID", ""); vm.FC.Add("Entity.SDState", ""); vm.FC.Add("Entity.SDDesc", ""); var rv = _controller.Edit(vm); Assert.IsInstanceOfType(rv, typeof(OkObjectResult)); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <SaleDepot>().Find(v.ID); Assert.AreEqual(data.SDID, "7n7mcX"); Assert.AreEqual(data.SDState, SCMSupplyChain.Model.SDState.未定义3); Assert.AreEqual(data.SDDesc, "U4MY"); Assert.AreEqual(data.UpdateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10); } }
public void GetTest() { SaleDepot v = new SaleDepot(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.SDID = "llzttATB"; v.CustomersID = AddCustomers(); v.DepotsID = AddDepots(); v.SDState = SCMSupplyChain.Model.SDState.未定义3; v.SDDesc = "dKnEjDp7L"; context.Set <SaleDepot>().Add(v); context.SaveChanges(); } var rv = _controller.Get(v.ID.ToString()); Assert.IsNotNull(rv); }
public void BatchDeleteTest() { SaleDepot v1 = new SaleDepot(); SaleDepot v2 = new SaleDepot(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v1.SDID = "llzttATB"; v1.CustomersID = AddCustomers(); v1.DepotsID = AddDepots(); v1.SDState = SCMSupplyChain.Model.SDState.未定义3; v1.SDDesc = "dKnEjDp7L"; v2.SDID = "7n7mcX"; v2.CustomersID = v1.CustomersID; v2.DepotsID = v1.DepotsID; v2.SDState = SCMSupplyChain.Model.SDState.未定义3; v2.SDDesc = "U4MY"; context.Set <SaleDepot>().Add(v1); context.Set <SaleDepot>().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 <SaleDepot>().Find(v1.ID); var data2 = context.Set <SaleDepot>().Find(v2.ID); Assert.AreEqual(data1.IsValid, false); Assert.AreEqual(data2.IsValid, false); } rv = _controller.BatchDelete(new string[] {}); Assert.IsInstanceOfType(rv, typeof(OkResult)); }
/// <summary> /// 根据ID查询客户订单信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult GetSaleDepotByID(string id) { SaleDepot item = SaleDepotBLL.GetSaleDepotByID(id); return(Json(new { SDID = item.SDID, CusID = item.CusID, CusName = item.Customers.CusName, UserID = item.UserID, UsersName = item.Users.UsersName, SDDate = item.SDDate, SDState = item.SDState, SDDesc = item.SDDesc, CLAgio = item.Customers.CustomerLevel.CLAgio })); }
/// <summary> /// 修改销售出库单 /// </summary> /// <param name="qp"></param> /// <param name="list"></param> /// <returns></returns> internal static int EditStocks(SaleDepot qp, List <SaleDepotDetail> list) { return(SaleDepotDAL.EditStocks(qp, list)); }