Example #1
0
        //获取组合表中的产品名称
        public ActionResult GetChanPinName()
        {
            var             temp    = YXB_WinCanPinService.LoadEntities(x => x.Del == null).DefaultIfEmpty();
            var             TempKey = temp.GroupBy(x => x.TCanpinID).Where(g => g.Count() > 1);
            List <RetcTEMP> lr      = new List <RetcTEMP>();

            foreach (var a in TempKey)
            {
                YXB_WinCanPin iqt = temp.Where(x => x.TCanpinID == a.Key).FirstOrDefault();
                RetcTEMP      trp = new RetcTEMP();
                trp.ID     = iqt.T_ChanPinName.ID;
                trp.MyText = iqt.T_ChanPinName.MyTexts;
                lr.Add(trp);
            }
            return(Json(lr, JsonRequestBehavior.AllowGet));
        }
Example #2
0
        //显示客户信息
        public ActionResult GetKhDataId()
        {
            var khid      = Convert.ToInt64(Request["khid"]);
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 10;

            int totalCount = 0;
            var Adata      = T_BaoJiaToPService.LoadPageEntities(pageIndex, pageSize, out totalCount, x => x.Kh_List_id == khid && x.DelFlag == delFlag, x => x.AddTime, false);

            var temp = from a in Adata
                       select new
            {
                ID             = a.id,
                HeTongQianDing = a.HeTongQianDing,
                JishuYaoqiu    = a.JiShuYaoQiu,
                Addess         = a.Addess,
                AddTime        = a.AddTime,
                KHComname      = a.KHComname,
                HanSui         = a.T_BoolItem.str,
                MyText         = a.T_YSItems.MyText
            };
            List <RetcTEMP> ts = new List <RetcTEMP>();

            foreach (var TP in temp)
            {
                RetcTEMP t = new RetcTEMP();
                t.ID          = TP.ID;
                t.JishuYaoqiu = TP.JishuYaoqiu;
                t.AddTime     = TP.AddTime;
                t.Seaddess    = ArrF(TP.Addess);
                t.KHComname   = TP.KHComname;
                t.HanSui      = TP.HanSui;
                t.MyText      = TP.MyText;
                ts.Add(t);
            }

            return(Json(new { rows = ts, ret = "ok", total = totalCount }, JsonRequestBehavior.AllowGet));
        }