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());
}
