/// <summary>
/// 获取类别子菜单
/// </summary>
/// <param name="sw">sw</param>
/// <param name="dt">dt</param>
/// <param name="RATID">RATID</param>
/// <returns></returns>
private static JArray getTreeChild(T_SYS_ADDREDDTYPE_SW sw, DataTable dt, string RATID)
{
JArray childobjArray = new JArray();
DataRow[] dr = dt.Select("RATID = " + RATID + "", "ORDERBY");
getTreeUser(childobjArray, sw, RATID);
for (int i = 0; i < dr.Length; i++)
{
string atid = "typeid" + dr[i]["ATID"].ToString();
if (sw.treeIsShowTypeID == "0")
{
atid = "";
}
JObject root = new JObject
{
{ "id", atid }
, { "text", dr[i]["RTNAME"].ToString() }
, { "rid", dr[i]["RATID"].ToString() }
, { "flag", "type" }
, { "state", sw.isTreeOpen },
};
root.Add("children", getTreeChild(sw, dt, dr[i]["ATID"].ToString()));
childobjArray.Add(root);
}
return(childobjArray);
}
/// <summary>
/// 下拉框
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getSelectOption(T_SYS_ADDREDDTYPE_SW sw)
{
DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);
string str = getSelectOptionChiled(dt, sw.CurATID, "0", 0);
dt.Clear();
dt.Dispose();
return(str);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <T_SYS_ADDREDDTYPE_Model> getModelList(T_SYS_ADDREDDTYPE_SW sw)
{
var result = new List <T_SYS_ADDREDDTYPE_Model>();
DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_ADDREDDTYPE_Model m = new T_SYS_ADDREDDTYPE_Model();
m.ATID = dt.Rows[i]["ATID"].ToString();
m.RATID = dt.Rows[i]["RATID"].ToString();
m.RTNAME = dt.Rows[i]["RTNAME"].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 T_SYS_ADDREDDTYPE_Model getModel(T_SYS_ADDREDDTYPE_SW sw)
{
var result = new List <T_SYS_ADDREDDTYPE_Model>();
DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);//列表
T_SYS_ADDREDDTYPE_Model m = new T_SYS_ADDREDDTYPE_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.ATID = dt.Rows[i]["ATID"].ToString();
m.RATID = dt.Rows[i]["RATID"].ToString();
m.RTNAME = dt.Rows[i]["RTNAME"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(T_SYS_ADDREDDTYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from T_SYS_ADDREDDTYPE a ");
sb.AppendFormat("where 1=1");
if (string.IsNullOrEmpty(sw.ATID) == false)
{
sb.AppendFormat("and ATID = '{0}'", ClsSql.EncodeSql(sw.ATID));
}
if (string.IsNullOrEmpty(sw.RATID) == false)
{
sb.AppendFormat("and RATID = '{0}'", ClsSql.EncodeSql(sw.RATID));
}
string sql = ("select ATID, RATID, RTNAME, ORDERBY") + sb.ToString() + (" order by ATID ");
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 类别树形菜单
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>string</returns>
public static string getTypeTreeYU(T_SYS_ADDREDDTYPE_SW sw)
{
JArray childobjArray = new JArray();
DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);
if (string.IsNullOrEmpty(sw.RATID))
{
sw.RATID = "0";
}
if (sw.isTreeOpen == "0")
{
sw.isTreeOpen = "closed";
}
else
{
sw.isTreeOpen = "open";
}
JArray JA = getTreeChild(sw, dt, sw.RATID);//, dctypetopid);
DataRow[] dr = dt.Select("", "ORDERBY");
getTreeUser(childobjArray, sw, sw.RATID);
for (int i = 0; i < dr.Length; i++)
{
string atid = "typeid" + dr[i]["ATID"].ToString();
if (sw.treeIsShowTypeID == "0")
{
atid = "";
}
JObject root = new JObject
{
{ "id", atid }
, { "text", dr[i]["RTNAME"].ToString() }
, { "rid", dr[i]["RATID"].ToString() }
, { "flag", "type" }
, { "state", sw.isTreeOpen },
};
//root.Add("children", getTreeChild(sw, dt, dr[i]["ATID"].ToString()));
childobjArray.Add(root);
}
dt.Clear();
dt.Dispose();
return(JsonConvert.SerializeObject(childobjArray));
}
private static JArray getTreeUser(JArray childobjArray, T_SYS_ADDREDDTYPE_SW sw, string atid)
{
DataTable dtU = BaseDT.T_SYS_ADDREDDBOOK.getDT(new T_SYS_ADDREDDBOOK_SW {
ATID = atid
});
for (int k = 0; k < dtU.Rows.Count; k++)
{//{ADID}{PHONE}{ADNAME}{USERJOB}{ORDERBY}
if (string.IsNullOrEmpty(sw.treeIDShowUserType))
{
sw.treeIDShowUserType = "{ADID}";
}
if (string.IsNullOrEmpty(sw.treeNameShowUserType))
{
sw.treeNameShowUserType = "{ADNAME}[{USERJOB}]";
}
string id = sw.treeIDShowUserType
.Replace("{ADID}", dtU.Rows[k]["ADID"].ToString())
.Replace("{PHONE}", dtU.Rows[k]["PHONE"].ToString())
.Replace("{ADNAME}", dtU.Rows[k]["ADNAME"].ToString())
.Replace("{USERJOB}", dtU.Rows[k]["USERJOB"].ToString())
.Replace("{ORDERBY}", dtU.Rows[k]["ORDERBY"].ToString());
string name = sw.treeNameShowUserType
.Replace("{ADID}", dtU.Rows[k]["ADID"].ToString())
.Replace("{PHONE}", dtU.Rows[k]["PHONE"].ToString())
.Replace("{ADNAME}", dtU.Rows[k]["ADNAME"].ToString())
.Replace("{USERJOB}", dtU.Rows[k]["USERJOB"].ToString())
.Replace("{ORDERBY}", dtU.Rows[k]["ORDERBY"].ToString());
id = id.Replace("<>", "").Replace("[]", "");
name = name.Replace("<>", "").Replace("[]", "");
JObject root1 = new JObject
{
{ "id", id }
, { "text", name }
, { "rid", "" }
, { "flag", "user" }
};
childobjArray.Add(root1);
}
dtU.Clear();
dtU.Dispose();
return(childobjArray);
}
/// <summary>
/// 类别树形菜单
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>string</returns>
public static string getTypeTree(T_SYS_ADDREDDTYPE_SW sw)
{
JArray childobjArray = new JArray();
DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);
if (string.IsNullOrEmpty(sw.RATID))
{
sw.RATID = "0";
}
if (sw.isTreeOpen == "0")
{
sw.isTreeOpen = "closed";
}
else
{
sw.isTreeOpen = "open";
}
JArray JA = getTreeChild(sw, dt, sw.RATID);//, dctypetopid);
dt.Clear();
dt.Dispose();
return(JsonConvert.SerializeObject(JA));
}
