/// <summary>
        /// 执行查询
        /// </summary>
        /// <returns></returns>
        public ActionResult DataLoad()
        {
            int           remainTime      = int.Parse(Request.Form["remainTime"]);
            string        MaterialType    = Request.Form["MaterialType"].ToString();
            List <string> mTypeList       = getMaterialTypeList(MaterialType);
            string        MaterialID      = Request.Form["MaterialID"].ToString();
            List <int>    listStorageCode = new List <int>();
            string        StorageCode     = Request.Form["StorageCode"].ToString();

            if (StorageCode.Length > 0)
            {
                listStorageCode.Add(int.Parse(StorageCode));
            }
            else
            {
                listStorageCode = UserOperateContext.Current.Session_StorageRelated.listUserStorage;
            }

            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total     = 0;
            var list      = new I_SurplusBLL().GetSurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, mTypeList, -1, remainTime, false);

            return(Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetLastDaySurplusList()
        {
            List <int> listStorageCode = new List <int>();

            string        SurplusCode  = Request.Form["SurplusCode"].ToString();
            string        MaterialType = Request.Form["MaterialType"].ToString();
            List <string> mTypeList    = UserOperateContext.Current.getMaterialTypeList(MaterialType);
            string        MaterialID   = Request.Form["MaterialID"].ToString();

            if (SurplusCode.Length > 0)
            {
                listStorageCode.Add(int.Parse(SurplusCode));
            }
            else
            {
                string listCode = AppConfig.GetConfigString("ApplyStorageCode");
                listStorageCode = listCode.Split(',').Select <string, int>(e => Convert.ToInt32(e)).ToList();
            }

            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total     = 0;
            var list      = new I_SurplusBLL().GetLastDaySurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, mTypeList);

            return(Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetMaterialSurplusList()
        {
            List<int> listStorageCode = new List<int>();

            int SurplusCode = int.Parse(Request.Form["SurplusCode"]);
            string MaterialID = Request.Form["MaterialID"].ToString();
            listStorageCode.Add(SurplusCode);

            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total = 0;
            var list = new I_SurplusBLL().GetSurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, null, -1, 0, false);
            return Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet);
        }
        public ActionResult GetMaterialSurplusList()
        {
            List <int> listStorageCode = new List <int>();

            int    SurplusCode = int.Parse(Request.Form["SurplusCode"]);
            string MaterialID  = Request.Form["MaterialID"].ToString();

            listStorageCode.Add(SurplusCode);


            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total     = 0;
            var list      = new I_SurplusBLL().GetSurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, null, -1, 0, false);

            return(Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetSurplusList()
        {
            List<int> listStorageCode = new List<int>();

            string SurplusCode = Request.Form["SurplusCode"].ToString();
            string MaterialType = Request.Form["MaterialType"].ToString();
            List<string> mTypeList = UserOperateContext.Current.getMaterialTypeList(MaterialType);
            string MaterialID = Request.Form["MaterialID"].ToString();
            if (SurplusCode.Length > 0)
                listStorageCode.Add(int.Parse(SurplusCode));
            else
                listStorageCode = UserOperateContext.Current.Session_StorageRelated.listUserStorage;

            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total = 0;
            var list = new I_SurplusBLL().GetSurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, mTypeList);
            return Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet);
        }
        public ActionResult GetLastDaySurplusList()
        {
            List<int> listStorageCode = new List<int>();

            string SurplusCode = Request.Form["SurplusCode"].ToString();
            string MaterialType = Request.Form["MaterialType"].ToString();
            List<string> mTypeList = UserOperateContext.Current.getMaterialTypeList(MaterialType);
            string MaterialID = Request.Form["MaterialID"].ToString();
            if (SurplusCode.Length > 0)
                listStorageCode.Add(int.Parse(SurplusCode));
            else
            {
                string listCode = AppConfig.GetConfigString("ApplyStorageCode");
                listStorageCode = listCode.Split(',').Select<string, int>(e => Convert.ToInt32(e)).ToList();
            }

            //获取页容量
            int pageSize = int.Parse(Request.Form["rows"]);
            //获取请求的页码
            int pageIndex = int.Parse(Request.Form["page"]);
            int total = 0;
            var list = new I_SurplusBLL().GetLastDaySurplusList(pageIndex, pageSize, ref total, MaterialID, listStorageCode, mTypeList);
            return Json(new { total = total, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet);
        }