//获取组合表中的产品名称 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)); }
//显示客户信息 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)); }