public ActionResult DeptOperManage()
{
var gridModel = new DeptOperManageGridModel();
SetupDeptOperManageGridModel(gridModel);
return(PartialView(gridModel));
}
public ActionResult DeptOperManage_Func_EditData(string ParentRowId, bool IsInRole, DXInfo.Models.tbFunc func)
{
var gridModel = new DeptOperManageGridModel();
SetupDeptOperManageGridModel(gridModel);
DXInfo.Models.tbOperFunc operFunc = Uow.tbOperFunc.GetAll().Where(w => w.vcOperID == ParentRowId &&
w.vcFuncName == func.cnvcFuncName //&&w.vcFuncAddress == func.cnvcFuncAddress
).FirstOrDefault();
if (IsInRole)
{
if (operFunc == null)
{
DXInfo.Models.tbFunc oldFunc = Uow.tbFunc.GetById(g => g.cnvcFuncName == func.cnvcFuncName &&
g.cnvcFuncType == "CS");
operFunc = new tbOperFunc();
operFunc.vcFuncAddress = oldFunc.cnvcFuncAddress;
operFunc.vcFuncName = func.cnvcFuncName;//func.cnvcFuncName;
operFunc.vcOperID = ParentRowId;
Uow.tbOperFunc.Add(operFunc);
Uow.Commit();
}
}
else
{
if (operFunc != null)
{
Uow.tbOperFunc.Delete(operFunc);
Uow.Commit();
}
}
return(new EmptyResult());
}
public ActionResult DeptOperManage_EditData(DXInfo.Models.tbOper tbOper)
{
var gridModel = new DeptOperManageGridModel();
SetupDeptOperManageGridModel(gridModel);
return(ajaxCallBack <DXInfo.Models.tbOper>(gridModel.DeptOperManageGrid, tbOper, addDeptOperManage, editDeptOperManage, delDeptOperManage));
}
public ActionResult DeptOperManage_RequestData()
{
var gridModel = new DeptOperManageGridModel();
SetupDeptOperManageGridModel(gridModel);
var q = from d in Uow.tbOper.GetAll()
select d;
return(QueryAndExcel(gridModel.DeptOperManageGrid, q, "客户端操作员.xls"));
}
private void SetupDeptOperManageGridModel(DeptOperManageGridModel gridModel)
{
var operGrid = gridModel.DeptOperManageGrid;
var funcGrid = gridModel.FuncGrid;
operGrid.DataUrl = Url.Action("DeptOperManage_RequestData");
operGrid.EditUrl = Url.Action("DeptOperManage_EditData");
SetUpGrid(operGrid);
SetRequiredColumn(operGrid, "vcOperId");
SetRequiredColumn(operGrid, "vcDeptId");
SetRequiredColumn(operGrid, "vcOperName");
SetRequiredColumn(operGrid, "vcLimit");
SetRequiredColumn(operGrid, "vcActiveFlag");
SetRequiredColumn(operGrid, "vcPwdBeginFlag");
SetDropDownColumn(operGrid, "vcLimit", centerCommon.GetLM());
SetDropDownColumn(operGrid, "vcDeptId", centerCommon.GetMD());
SetDropDownColumn(operGrid, "vcActiveFlag", new List <SelectListItem>()
{
new SelectListItem {
Selected = true, Text = "正常", Value = "1"
},
new SelectListItem {
Text = "冻结", Value = "0"
}
});
SetDropDownColumn(operGrid, "vcPwdBeginFlag", new List <SelectListItem>()
{
new SelectListItem {
Selected = true, Text = "正常", Value = "0"
},
new SelectListItem {
Text = "待初始化", Value = "1"
}
});
SetBoolColumn(operGrid, "IsDiscount");
funcGrid.DataUrl = Url.Action("DeptOperManage_Func_RequestData");
funcGrid.EditUrl = Url.Action("DeptOperManage_Func_EditData");
funcGrid.SortSettings.InitialSortColumn = "cnvcFuncParentName";
SetBoolColumn(funcGrid, "IsInRole");
}
public ActionResult DeptOperManage_Func_RequestData(string ParentRowId)
{
var gridModel = new DeptOperManageGridModel();
SetupDeptOperManageGridModel(gridModel);
var q = from d in Uow.tbFunc.GetAll().Where(w => w.cnvcFuncType == "CS")
join d1 in Uow.tbOperFunc.GetAll().Where(w => w.vcOperID == ParentRowId)
on new { key1 = d.cnvcFuncAddress, key2 = d.cnvcFuncName } equals new { key1 = d1.vcFuncAddress, key2 = d1.vcFuncName } into dd1
from dd1s in dd1.DefaultIfEmpty()
//where dd1s.vcOperID==ParentRowId && d.cnvcFuncType=="CS"
select new
{
IsInRole = dd1s != null,
d.cnvcFuncName,
d.cnvcFuncParentName,
//d.cnvcFuncAddress,
};
return(QueryAndExcel(gridModel.FuncGrid, q, "操作员权限.xls"));
//return gridModel.UsersGrid.DataBind(users);
}
