WarehouseController

目录

1、 WarehouseController

1.1、 //仓库信息设置

1.2、 /// 查询

1.3、 /// 删除

1. WarehouseController 

using QXQPS.Models;

using QXQPS.Vo;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace QXQPS.Areas.BasicdataManagment.Controllers

{

    public class WarehouseController : Controller

    {

        // GET: BasicdataManagment/Warehouse

        Models.QXQPEntities myModels = new Models.QXQPEntities();

1. 1.        //仓库信息设置

 public ActionResult Warehouse()//仓库信息设置

        {

            return View();

        }

        /// <summary>

1. 1.         /// 查询

        /// </summary>

        /// <param name="bsgridpage"></param>

        /// <returns></returns>

        ///

        public ActionResult SelectWarehouse(BsgridPage bsgridPage)

        {

            List<SYS_Warehouse> listWarehouse = myModels.SYS_Warehouse.OrderByDescending(m => m.WarehouseID)

                .Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();

            int totalRow = myModels.SYS_Warehouse.Count();

            Bsgrid<SYS_Warehouse> bsgrid = new Bsgrid<SYS_Warehouse>()

            {

                success = true,

                totalRows = totalRow,

                curPage = bsgridPage.curPage,

                data = listWarehouse

            };

            return Json(bsgrid, JsonRequestBehavior.AllowGet);

        }

        /// <summary>

1. 1.         /// 删除

        /// </summary>

        /// <param name="WarehouseID"></param>

        /// <returns></returns>

        public ActionResult DeleteWarehouse(int WarehouseID)

        {

            try

            {

                var listWarehouse = myModels.SYS_Warehouse

                    .Where(m => m.WarehouseID == WarehouseID).Single();

                myModels.SYS_Warehouse.Remove(listWarehouse);

                if (myModels.SaveChanges() > 0)

                {

                    return Json(true, JsonRequestBehavior.AllowGet);

                }

                else

                {

                    return Json(false, JsonRequestBehavior.AllowGet);

                }

            }

            catch (Exception E)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

        }

    }

}