public Tuple <dynamic, DataTable, List <TreeEntity>, TreeModel[], DataTable, DataTable, DataTable> GetRoleInit()
{
var org = DataService.GetTreeOrg();
//更改权限列表为树 by：DZK
string sql1 = @" (select NVL(U.MENUID,0) MENUID,U.MODULECODE,U.MODULENAME,nvl(substr(MODULECODE,0,LENGTH(MODULECODE)-2),0) parentid FROM USERMODULE U,MENU M
WHERE U.MENUID=M.ID AND U.ENABLE_FLAG=1
UNION ALL
select NVL(MENUID,0),MODULECODE,MODULENAME,nvl(substr(MODULECODE,0,LENGTH(MODULECODE)-2),0) parentid FROM USERMODULE
WHERE ENABLE_FLAG=1 and (MENUID is null or MENUID =0))
ORDER BY MODULECODE " ;
List <USERMODULEEntity> um = DbHelper.ExecuteTable(sql1).ToList <USERMODULEEntity>();
List <TreeEntity> treeList = new List <TreeEntity>();
foreach (var item in um)
{
TreeEntity node = new TreeEntity();
node.value = item.MENUID;
node.code = item.MODULECODE;
node.title = item.MODULENAME;
node.expand = false;
node.parentId = item.PARENTID;
treeList.Add(node);
}
var module = treeList.ToTree();
//费用
string sqlitem2 = $@"select A.TRIMID,A.NAME from FEESUBJECT A order by A.TRIMID";
DataTable fee = DbHelper.ExecuteTable(sqlitem2);
//区域
string sqlitemRegion = $@"select A.REGIONID,A.NAME from REGION A order by A.REGIONID";
DataTable region = DbHelper.ExecuteTable(sqlitemRegion);
//业态树
List <CATEGORYEntity> p = DbHelper.SelectList(new CATEGORYEntity()).OrderBy(a => a.CATEGORYCODE).ToList();
var ytTreeData = TreeModel.Create(p,
a => a.CATEGORYCODE,
a => new TreeModel()
{
value = a.CATEGORYID,
code = a.CATEGORYCODE,
title = a.CATEGORYCODE + " " + a.CATEGORYNAME,
expand = false
})?.ToArray();
//门店
string sqlbranch = $@"select B.ID BRANCHID,B.NAME from BRANCH B order by B.ID";
DataTable branch = DbHelper.ExecuteTable(sqlbranch);
//预警
string sqlalert = $@"select B.ID ALERTID,B.MC NAME from DEF_ALERT B order by B.ID";
DataTable alert = DbHelper.ExecuteTable(sqlalert);
return(new Tuple <dynamic, DataTable, List <TreeEntity>, TreeModel[], DataTable, DataTable, DataTable>(org.Item1, fee, module, ytTreeData, region, branch, alert));
}
public virtual UIResult TreeGoodsKindList()
{
List <GOODS_KINDEntity> p = DbHelper.SelectList(new GOODS_KINDEntity()).OrderBy(a => a.CODE).ToList();
return(new UIResult(TreeModel.Create(p,
a => a.CODE,
a => new TreeModel()
{
code = a.CODE,
title = a.CODE + " " + a.NAME,
expand = true
})?.ToArray()));
}
public virtual UIResult TreeOrgList()
{
List <ORGEntity> p = DbHelper.SelectList(new ORGEntity()).OrderBy(a => a.ORGCODE).ToList();
return(new UIResult(TreeModel.Create(p,
a => a.ORGCODE,
a => new TreeModel()
{
code = a.ORGCODE,
title = a.ORGCODE + " " + a.ORGNAME,
expand = true
})?.ToArray()));
}
public virtual UIResult TreeCategoryList()
{
List <CATEGORYEntity> p = DbHelper.SelectList(new CATEGORYEntity()).OrderBy(a => a.CATEGORYCODE).ToList();
return(new UIResult(TreeModel.Create(p,
a => a.CATEGORYCODE,
a => new TreeModel()
{
code = a.CATEGORYCODE,
title = a.CATEGORYCODE + " " + a.CATEGORYNAME,
expand = true
})?.ToArray()));
}
/// <summary>
/// 树形业态
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public Tuple <dynamic> GetTreeCategory()
{
List <CATEGORYEntity> p = DbHelper.SelectList(new CATEGORYEntity()).OrderBy(a => a.CATEGORYCODE).ToList();
var treeOrg = new UIResult(TreeModel.Create(p,
a => a.CATEGORYCODE,
a => new TreeModel()
{
code = a.CATEGORYCODE,
title = a.CATEGORYNAME,
value = a.CATEGORYID,
label = a.CATEGORYNAME,
expand = true
})?.ToArray());
return(new Tuple <dynamic>(treeOrg));
}
public Tuple <dynamic> GetKindInit()
{
List <GOODS_KINDEntity> p = DbHelper.SelectList(new GOODS_KINDEntity()).OrderBy(a => a.CODE).ToList();
var treeOrg = new UIResult(TreeModel.Create(p,
a => a.CODE,
a => new TreeModel()
{
code = a.CODE,
title = a.NAME,
value = a.ID,
label = a.NAME,
expand = true
})?.ToArray());
return(new Tuple <dynamic>(treeOrg));
}
/// <summary>
/// 从列表页编辑跳转到编辑页数据的展示查询
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public Tuple <dynamic, DataTable, dynamic> GetMerchantElement(MERCHANTEntity Data)
{
if (Data.MERCHANTID.IsEmpty())
{
throw new LogicException("请确认商户编号!");
}
string sql = $@"SELECT * FROM MERCHANT WHERE 1=1 ";
if (!Data.MERCHANTID.IsEmpty())
{
sql += (" AND MERCHANTID= " + Data.MERCHANTID);
}
DataTable merchant = DbHelper.ExecuteTable(sql);
merchant.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC");
string sqlitem = $@"SELECT M.BRANDID,C.NAME,D.CATEGORYCODE,D.CATEGORYNAME " +
" FROM MERCHANT_BRAND M,MERCHANT E,BRAND C,CATEGORY D " +
" where M.MERCHANTID = E.MERCHANTID AND M.BRANDID=C.ID AND C.CATEGORYID = D.CATEGORYID ";
if (!Data.MERCHANTID.IsEmpty())
{
sqlitem += (" and E.MERCHANTID= " + Data.MERCHANTID);
}
DataTable merchantBrand = DbHelper.ExecuteTable(sqlitem);
List <ORGEntity> p = DbHelper.SelectList(new ORGEntity()).OrderBy(a => a.ORGCODE).ToList();
var treeOrg = new UIResult(TreeModel.Create(p,
a => a.ORGCODE,
a => new TreeModel()
{
code = a.ORGCODE,
title = a.ORGNAME,
value = a.ORGID,
label = a.ORGNAME,
expand = true
})?.ToArray());
return(new Tuple <dynamic, DataTable, dynamic>(merchant.ToOneLine(), merchantBrand, treeOrg));
}
public Tuple <dynamic, DataTable, List <TreeEntity>, DataTable, DataTable, TreeModel[], DataTable> GetRoleElement(ROLEEntity Data)
{
string sql = $@"SELECT A.*,B.ORGIDCASCADER FROM ROLE A,ORG B WHERE A.ORGID=B.ORGID ";
if (!Data.ROLEID.IsEmpty())
{
sql += (" AND ROLEID= " + Data.ROLEID);
}
DataTable role = DbHelper.ExecuteTable(sql);
//更改权限列表为树 by：DZK
string sql1 = @" SELECT NVL(U.MENUID,0) MENUID,U.MODULECODE,U.MODULENAME,nvl(substr(U.MODULECODE,0,LENGTH(U.MODULECODE)-2),0) parentid,R.ROLEID IsChecked FROM USERMODULE U
LEFT JOIN ROLE_MENU R ON U.MODULECODE=R.MODULECODE AND U.MENUID=R.MENUID AND R.ROLEID = " + Data.ROLEID + @"
WHERE U.ENABLE_FLAG=1
ORDER BY U.MODULECODE" ;
List <USERMODULEEntity> um = DbHelper.ExecuteTable(sql1).ToList <USERMODULEEntity>();;
List <TreeEntity> treeList = new List <TreeEntity>();
foreach (var item in um)
{
TreeEntity node = new TreeEntity();
node.value = item.MENUID;
node.code = item.MODULECODE;
node.@checked = !item.IsChecked.IsNullValue();
node.title = item.MODULENAME;
node.expand = false;
node.parentId = item.PARENTID;
treeList.Add(node);
}
var module = treeList.ToTree();
//费用
string sqlFee = $@" SELECT TRIMID FROM ROLE_FEE WHERE 1=1";
if (!Data.ROLEID.IsEmpty())
{
sqlFee += (" AND ROLEID= " + Data.ROLEID);
}
DataTable fee = DbHelper.ExecuteTable(sqlFee);
//业态
string sqlYt = $@" SELECT YTID ID FROM ROLE_YT WHERE 1=1";
if (!Data.ROLEID.IsEmpty())
{
sqlYt += (" AND ROLEID= " + Data.ROLEID);
}
DataTable yt = DbHelper.ExecuteTable(sqlYt);
//区域
string sqlRegion = $@" SELECT REGIONID FROM ROLE_REGION WHERE 1=1";
if (!Data.ROLEID.IsEmpty())
{
sqlRegion += (" AND ROLEID= " + Data.ROLEID);
}
DataTable region = DbHelper.ExecuteTable(sqlRegion);
//业态
string sqlYt2 = "select G.CATEGORYID,G.CATEGORYCODE,G.CATEGORYNAME,Y.YTID LEVEL_LAST from CATEGORY G,ROLE_YT Y where G.CATEGORYID =Y.YTID(+) ";
sqlYt2 += (" AND Y.ROLEID(+)= " + Data.ROLEID);
sqlYt2 += " order by G.CATEGORYCODE";
List <CATEGORYEntity> p = DbHelper.ExecuteTable(sqlYt2).ToList <CATEGORYEntity>();
var ytTreeData = TreeModel.Create(p,
a => a.CATEGORYCODE,
a => new TreeModel()
{
value = a.CATEGORYID,
@checked = !a.LEVEL_LAST.IsNullValue(),
code = a.CATEGORYCODE,
title = a.CATEGORYCODE + " " + a.CATEGORYNAME,
expand = false
})?.ToArray();
//门店
string sqlbranch = $@"select B.ID BRANCHID,B.NAME from BRANCH B,ROLE_BRANCH R WHERE B.ID=R.BRANCHID ";
if (!Data.ROLEID.IsEmpty())
{
sqlbranch += (" AND ROLEID= " + Data.ROLEID);
}
DataTable branch = DbHelper.ExecuteTable(sqlbranch);
//预警
string sqlalert = $@"select B.ID ALERTID,B.MC NAME from DEF_ALERT B,ROLE_ALERT R WHERE B.ID=R.ALERTID";
if (!Data.ROLEID.IsEmpty())
{
sqlalert += (" AND ROLEID= " + Data.ROLEID);
}
DataTable alert = DbHelper.ExecuteTable(sqlalert);
return(new Tuple <dynamic, DataTable, List <TreeEntity>, DataTable, DataTable, TreeModel[], DataTable>(role.ToOneLine(), fee, module, alert, region, ytTreeData, branch));
}
