public void Export()
{
IRolefunctionService rolefunctionService = UnityHelper.UnityResolve <IRolefunctionService>();
QueryEntity qe = InitQueryEntity();
qe.IsGetAll = true;
var data = rolefunctionService.GetRolefunctionByQueryList(qe);
Export2Excel("Rolefunction.xls", data);
}
public string GetAllRolefunction()
{
IRolefunctionService tmpService = UnityHelper.UnityResolve <IRolefunctionService>();
var data = tmpService.GetRolefunctionByQueryList(InitQueryEntity());
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = ConstUtils.CONST_SHOW_DATE_FORMAT;
var tmpdata = JsonConvert.SerializeObject(data.Tables[2], timeConverter);
var result = "{\"total\":" + data.Tables[1].Rows[0]["TotalRecordsCount"].ToString() + ",\"rows\":" + tmpdata + " }";
return(result);
}
public string GetRolefunction2()
{
string roleID = Session["selectedRoleID"] as string;
IRolefunctionService roleFunction = UnityHelper.UnityResolve <IRolefunctionService>();
DataSet roleFunctionDS = roleFunction.GetRolefunctionByQueryList(new QueryEntity {
IsGetAll = true, sqlWhere = new List <string> {
"roleID='" + roleID + "'"
}
});
IFunctiongroupService tmpService = UnityHelper.UnityResolve <IFunctiongroupService>();
var data = tmpService.GetFunctionGroupByRoleID(Int32.Parse(roleID));
DataRow[] drlv1 = data.Tables[0].Select("ParentID=1000");
StringBuilder sbRole = new StringBuilder();
for (int i = 0; i < drlv1.Length; i++)
{
sbRole.Append("{\"id\":" + drlv1[i]["FunctionID"].ToString() + ",\"text\":\"" + drlv1[i]["UDF01"].ToString() + "\",\"state\":\"closed\",\"children\":[");
DataRow[] drlv2 = data.Tables[0].Select(string.Format("ParentID='{0}'", drlv1[i]["FunctionID"].ToString()));
for (int j = 0; j < drlv2.Length; j++)
{
string ischecked = string.Empty;
if (!string.IsNullOrEmpty(drlv2[j]["checked_functionID"].ToString()))
{
ischecked = "true";
}
else
{
ischecked = "false";
}
sbRole.Append("{\"id\":" + drlv2[j]["FunctionID"].ToString() + ",\"text\":\"" + drlv2[j]["UDF01"].ToString() + "\",\"checked\":" + ischecked + "}");
if (j != drlv2.Length - 1)
{
sbRole.Append(",");
}
}
sbRole.Append("]}");
if (i != drlv1.Length - 1)
{
sbRole.Append(",");
}
}
var role = "[{\"id\":0,\"text\":\"角色权限\",\"state\":\"open\",\"children\":[" + sbRole.ToString() + "]}]";
return(role);
}