/// <summary> /// 删除仓库 /// </summary> /// <param name="context"></param> private void DeleteWareHouse(HttpContext context) { //需要一个实体对象参数 //1,创建要删除的对象 Model.base_WareHouse wh = new Model.base_WareHouse() { ID = int.Parse(context.Request["ID"] + ""),//仓库ID }; //2,将对象添加到EF管理容器中 db.base_WareHouse.Attach(wh); //3,修改对象的包装类对象标识为删除状态 db.base_WareHouse.Remove(wh); //4,更新到数据库 int num = db.SaveChanges(); context.Response.Write("{\"d\":" + num + "}"); }
/// <summary> /// 编辑仓库名称 /// </summary> private void EditWareHouse(HttpContext context) { Model.base_WareHouse wh = new Model.base_WareHouse() { ID = int.Parse(context.Request["ID"] + ""),//仓库ID WareHouseName = context.Request["WareHouseName"] + "",//仓库名称 CategoryIDs = context.Request["CategoryIDs"] + "", CategoryNames = context.Request["CategoryNames"] + "", Position = context.Request["Position"] + "",//位置 Status = 1,//状态 Remark = context.Request["Remark"] + "",//备注 LastUpdateBy = UserInfo.UserName,//编辑人 LastUpdateTime = DateTime.Now//编辑时间 }; //先将实体附加到实体上下文中 db.base_WareHouse.Attach(wh); //手动修改实体的状态 db.Entry(wh).State = EntityState.Modified; int num = db.SaveChanges(); context.Response.Write("{\"d\":" + num + "}"); }
/// <summary> /// 添加仓库 /// </summary> private void AddWareHouse(HttpContext context) { Model.base_WareHouse wh = new Model.base_WareHouse() { WareHouseName=context.Request["WareHouseName"]+"",//仓库名称 CategoryIDs=context.Request["CategoryIDs"]+"", CategoryNames = context.Request["CategoryNames"] + "", Position = context.Request["Position"]+"",//位置 Status =1,//状态 Remark = context.Request["Remark"] + "",//备注 AddBy = UserInfo.UserName,//添加人 AddTime = DateTime.Now//添加时间 }; db.base_WareHouse.Add(wh); int num = db.SaveChanges(); context.Response.Write("{\"d\":" + num + "}"); }