예제 #1
0
        /// <summary>
        /// 下拉框 (经销存类型)
        /// </summary>
        /// <returns></returns>
        public ActionResult ChaXunSeleLeiXing()
        {
            string   dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd");
            DateTime d           = Convert.ToDateTime(dateTimeNow);

            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tbWaerHouse in myModels.B_WareHouseList
                                                  join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID//合同
                                                  join tbAdjLeiXing in myModels.S_AdjustAccountsFashionList on tbHeTong.AdjustAccountsFashionID equals tbAdjLeiXing.AdjustAccountsFashionID
                                                  where tbWaerHouse.ExamineNot == true && tbWaerHouse.Status == true && tbWaerHouse.CrushRedNot == false && tbWaerHouse.ExamineTime == d
                                                  select new SelectXiaLa
            {
                id = tbAdjLeiXing.AdjustAccountsFashionID,
                text = tbAdjLeiXing.AdjustAccountsFashion
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #2
0
        /// <summary>
        /// 绑定商标
        /// </summary>
        /// <returns></returns>
        public ActionResult BangGoodBiao()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.B_GoodsChopList
                                                  select new SelectXiaLa
            {
                id = tb.GoodsChopID,
                text = tb.GoodsChopName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #3
0
        /// <summary>
        /// 下拉框(配送部门)一
        /// </summary>
        /// <returns></returns>
        public ActionResult PeiSong()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.S_SpouseBRanchList
                                                  where tb.SpouseBRanchID == 1 || tb.SpouseBRanchID == 2
                                                  select new SelectXiaLa
            {
                id = tb.SpouseBRanchID,
                text = tb.SpouseBRanchName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #4
0
        /// <summary>
        /// 下拉框(盘点部门)二
        /// </summary>
        /// <returns></returns>
        public ActionResult BuMen(int DrugTypeID)
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.B_PanlList
                                                  where tb.F_DrugTypeID == DrugTypeID
                                                  select new SelectXiaLa
            {
                id = tb.DrugTypeID,
                text = tb.DrugType
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #5
0
        /// <summary>
        /// 进仓单类型
        /// </summary>
        /// <returns></returns>
        public ActionResult QuarctJin()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.S_QuFenLeiXingList
                                                  select new SelectXiaLa
            {
                id = tb.QuFenLeiXingID,
                text = tb.QuFenLeiXingMC
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #6
0
        /// <summary>
        /// 下拉(库存地点)
        /// </summary>
        /// <returns></returns>
        public ActionResult KuCunDiDian()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_StockPlaceList
                                                  select new SelectXiaLa
            {
                id = tb.StockPlaceID,
                text = tb.StockPlaceName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #7
0
        /// <summary>
        /// 下拉(退货原因)
        /// </summary>
        /// <returns></returns>
        public ActionResult TuiHuoYuanYin()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_ReturnofList
                                                  select new SelectXiaLa
            {
                id = tb.ReturnofID,
                text = tb.Returnof
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #8
0
        /// <summary>
        /// 下拉框 (买卖场)
        /// </summary>
        /// <returns></returns>
        public ActionResult ChaXunSeleSuppout()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);

            List <SelectXiaLa> listNoticeTypeS = (from tbWaerHouse in myModels.S_MaiChangList
                                                  select new SelectXiaLa
            {
                id = tbWaerHouse.MaiChangID,
                text = tbWaerHouse.MaiChangMC
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);

            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #9
0
        /// <summary>
        /// 下拉(退货原因)
        /// </summary>
        /// <returns></returns>
        public ActionResult TuiHuoBuMen()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_SpouseBRanchList
                                                  where tb.SpouseBRanchID == 3 || tb.SpouseBRanchID == 4
                                                  select new SelectXiaLa
            {
                id = tb.SpouseBRanchID,
                text = tb.SpouseBRanchName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #10
0
        /// 下拉框 (库存地点)
        /// </summary>
        /// <returns></returns>
        public ActionResult SelectKuCunDian()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);

            List <SelectXiaLa> listNoticeTypeS = (from tbAdjLeiXing in myModels.S_StockPlaceList

                                                  select new SelectXiaLa
            {
                id = tbAdjLeiXing.StockPlaceID,
                text = tbAdjLeiXing.StockPlaceName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);

            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }
예제 #11
0
        /// <summary>
        /// 商品分类(下拉)
        /// </summary>
        /// <returns></returns>
        public ActionResult SelectGoodFeiLei()
        {
            List <SelectXiaLa> listCaiGou  = new List <SelectXiaLa>();
            SelectXiaLa        selectXiaLa = new SelectXiaLa()
            {
                id   = 0,
                text = "---请选择---"
            };

            listCaiGou.Add(selectXiaLa);
            //然后又使用  List<SelectXiaLa>来进行查询
            List <SelectXiaLa> listNoticeTypeS = (from tbGooFeiLeiLiet in MyModels.B_GoodsClassifyList
                                                  where tbGooFeiLeiLiet.F_GoodsClassifyID == 0
                                                  select new SelectXiaLa
            {
                id = tbGooFeiLeiLiet.GoodsClassifyID,
                text = tbGooFeiLeiLiet.GoodsClassifyName
            }).ToList();

            listCaiGou.AddRange(listNoticeTypeS);
            //最后拼接起来返回 listNoticeTypeS
            return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
        }