public ActionResult Desk_EditData(DXInfo.Models.Desks desk)
{
var gridModel = new DeskGridModel();
SetupDeskGridModel(gridModel);
return(ajaxCallBack <DXInfo.Models.Desks>(gridModel.DeskGrid, desk, addDesk, editDesk, delDesk));
}
public ActionResult Desk()
{
var gridModel = new DeskGridModel();
SetupDeskGridModel(gridModel);
return(View(gridModel));
}
public ActionResult Desk_RequestData()
{
var gridModel = new DeskGridModel();
SetupDeskGridModel(gridModel);
var q = from d in Uow.Desks.GetAll()
join d1 in Uow.Rooms.GetAll() on d.RoomId equals d1.Id into dd1
from dd1s in dd1.DefaultIfEmpty()
join d2 in Uow.NameCode.GetAll().Where(w => w.Type == "DeskStatus") on SqlFunctions.StringConvert((double?)d.Status).Trim() equals d2.Code into dd2
from dd2s in dd2.DefaultIfEmpty()
select new
{
d.Id,
d.RoomId,
RoomName = dd1s.Name,
d.Code,
d.Name,
d.Size,
d.Comment,
d.Status,
StatusName = dd2s.Name,
};
return(QueryAndExcel(gridModel.DeskGrid, q, "桌台.xls"));
}
private void SetupDeskGridModel(DeskGridModel gridModel)
{
var grid = gridModel.DeskGrid;
grid.DataUrl = Url.Action("Desk_RequestData");
grid.EditUrl = Url.Action("Desk_EditData");
SetUpGrid(grid);
SetDropDownColumn(grid, "RoomId", centerCommon.GetRoom());
SetDropDownColumn(grid, "Status", centerCommon.GetDeskStatus());
}
