public object GetGridData() { var dicType = new FDictionaryDAL(this.db, this.areaNo).GetModelQueryByName(FDictionaryString.AppointmentType); var unitQuery = new TUnitDAL(this.db, this.areaNo).GetQuery(); return(this.GetQuery() .LeftJoin(dicType, (m, t) => m.busiType.ToString() == t.Value) .LeftJoin(unitQuery, (m, t, u) => m.unitSeq == u.unitSeq) .Select((m, t, u) => new { m.ID, u.unitName, m.unitSeq, m.busiSeq, m.busiCode, m.busiName, busiType = t.Name, acceptBusi = m.acceptBusi ? "是" : "否", getBusi = m.getBusi ? "是" : "否", askBusi = m.askBusi ? "是" : "否", Model = m }) .OrderBy(k => k.ID) .ToList()); }
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()); }
public object GetGridData() { var dic = new FDictionaryDAL(this.db, this.areaNo).GetModelQueryByName(FDictionaryString.WorkState); var winAreaQuery = new TWindowAreaDAL(this.db, this.areaNo).GetQuery(); return(this.GetQuery() .LeftJoin(dic, (w, d) => w.State == d.Value) .LeftJoin(winAreaQuery, (w, d, a) => w.AreaName == a.ID) .Select((w, d, a) => new { w.ID, w.Name, w.Number, w.Type, State = d.Name, CallNumber = w.CallNumber, AreaName = a.areaName, Model = w }) .OrderBy(k => k.ID) .ToList()); }
public object GetGridData() { var dicState = new FDictionaryDAL(this.db, this.areaNo).GetModelQueryByName(FDictionaryString.WorkState); var dicSex = new FDictionaryDAL(this.db, this.areaNo).GetModelQueryByName(FDictionaryString.UserSex); var unitQuery = new TUnitDAL(this.db, this.areaNo).GetQuery(); return(this.GetQuery() .LeftJoin(dicState, (u, d) => u.State == d.Value) .LeftJoin(dicSex, (u, d, s) => u.Sex == s.Value) .LeftJoin(unitQuery, (u, d, s, u2) => u.unitSeq == u2.unitSeq) .Select((u, d, s, u2) => new { u.ID, u.Code, u.Name, u2.unitName, Sex = s.Name, State = d.Name, u.Remark }) .OrderBy(k => k.ID).ToList()); }