public object GetGridDataByUnitSeq(string unitSeq) { var busiQuery = new TBusinessDAL(this.db, this.areaNo).GetQuery(); var dicType = new FDictionaryDAL(this.db, this.areaNo).GetModelQueryByName(FDictionaryString.AppointmentType); return(busiQuery.LeftJoin(dicType, (m, t) => m.busiType.ToString() == t.Value) .Where((m, t) => m.unitSeq == unitSeq) .Select((m, t) => new { m.unitSeq, m.busiSeq, m.busiCode, m.busiName, busiType = t.Name, acceptBusi = m.acceptBusi ? "是" : "否", getBusi = m.getBusi ? "是" : "否", askBusi = m.askBusi ? "是" : "否" }) .OrderBy(k => k.unitSeq) .ToList()); }