Пример #1
0
        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());
        }