/// <summary>
/// 获取类别子菜单
/// </summary>
/// <param name="sw">sw</param>
/// <param name="dt">dt</param>
/// <param name="SubRightID">SubRightID</param>
/// <returns></returns>
private static JArray getTreeChild(T_SYSSEC_RIGHT_SW sw, DataTable dt, string SubRightID)
{
JArray childobjArray = new JArray();
DataRow[] dr = dt.Select("len(RIGHTID)=" + (SubRightID.Length + 3) + " and SUBSTRING(RIGHTID,1," + SubRightID.Length + ")='" + SubRightID + "'", "ORDERBY");
string flag = ConfigCls.getSystemFlag();
for (int i = 0; i < dr.Length; i++)
{
string text = dr[i]["RIGHTNAME"].ToString();
if (dr[i]["SYSFLAG"].ToString() != flag)
{
text = "<font color=red>" + text + "</font>";
}
JObject root = new JObject {
{ "id", dr[i]["RIGHTID"].ToString() }, { "text", text }, { "state", "open" },
};
if (dr[i]["RIGHTID"].ToString().Length <= 3)
{
root.Add("children", getTreeChild(sw, dt, dr[i]["RIGHTID"].ToString()));
}
childobjArray.Add(root);
}
return(childobjArray);
}
/// <summary>
/// 获取数据,获取所有角色
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYSSEC_RIGHT_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT RIGHTID, RIGHTNAME, SYSFLAG,ORDERBY");
sb.AppendFormat(" FROM T_SYSSEC_RIGHT");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.SYSFLAG) == false)
{
sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG));
}
if (string.IsNullOrEmpty(sw.RIGHTID) == false)
{
sb.AppendFormat(" AND RIGHTID = '{0}'", ClsSql.EncodeSql(sw.RIGHTID));
}
if (string.IsNullOrEmpty(sw.SubRightID) == false)
{
if (sw.SubRightID == "0")
{
sb.AppendFormat(" AND Len(RIGHTID)=3");
}
else
{
sb.AppendFormat(" AND len(RIGHTID)=" + (sw.SubRightID.Length + 3).ToString() + " AND SUBSTRING(RIGHTID,1," + sw.SubRightID.Length.ToString() + ")=" + sw.SubRightID);
}
}
sb.AppendFormat(" ORDER BY ORDERBY,RIGHTID ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 类别树形菜单
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>string</returns>
public static string getTypeTree(T_SYSSEC_RIGHT_SW sw)
{
JArray childobjArray = new JArray();
DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw);
JArray JA = getTreeChild(sw, dt, "");//, dctypetopid);
dt.Clear();
dt.Dispose();
return(JsonConvert.SerializeObject(JA));
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(T_SYSSEC_RIGHT_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYSSEC_RIGHT where 1=1");
if (string.IsNullOrEmpty(sw.RIGHTID) == false)
{
sb.AppendFormat(" and RIGHTID='{0}'", ClsSql.EncodeSql(sw.RIGHTID));
}
if (string.IsNullOrEmpty(sw.SYSFLAG) == false)
{
sb.AppendFormat(" and SYSFLAG='{0}'", ClsSql.EncodeSql(sw.SYSFLAG));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYSSEC_RIGHT_Model getModel(T_SYSSEC_RIGHT_SW sw)
{
DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw);
T_SYSSEC_RIGHT_Model m = new T_SYSSEC_RIGHT_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.RIGHTID = dt.Rows[i]["RIGHTID"].ToString();
m.RIGHTNAME = dt.Rows[i]["RIGHTNAME"].ToString();
m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
//扩充字段
}
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYSSEC_RIGHT_Model> getListModel(T_SYSSEC_RIGHT_SW sw)
{
var result = new List <T_SYSSEC_RIGHT_Model>();
DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYSSEC_RIGHT_Model m = new T_SYSSEC_RIGHT_Model();
m.RIGHTID = dt.Rows[i]["RIGHTID"].ToString();
m.RIGHTNAME = dt.Rows[i]["RIGHTNAME"].ToString();
m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据编号查询权限名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getNameByID(T_SYSSEC_RIGHT_SW sw)
{
return(BaseDT.T_SYSSEC_RIGHT.getNameByID(sw));
}
/// <summary>
/// 根据编号查询权限名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getNameByID(T_SYSSEC_RIGHT_SW sw)
{
string sql = "SELECT RIGHTNAME FROM T_SYSSEC_RIGHT WHERE RIGHTID='" + sw.RIGHTID + "' and SYSFLAG='" + sw.SYSFLAG + "'";
return(DataBaseClass.ReturnSqlField(sql));
}
