/// <summary>
/// 获取字典类别单条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_DICTTYPE_Model getTypeModel(T_SYS_DICTTYPE_SW sw)
{
DataTable dt = BaseDT.T_SYS_DICT.getDICTFLAGDT(sw);
T_SYS_DICTTYPE_Model m = new T_SYS_DICTTYPE_Model();
for (int i = 0; i < dt.Rows.Count; i++)
{
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTTYPERID = dt.Rows[i]["DICTTYPERID"].ToString();
m.DICTTYPENAME = dt.Rows[i]["DICTTYPENAME"].ToString();
m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString();
m.ISMAN = dt.Rows[i]["ISMAN"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.DICTTYPEListModel = getTypeListModel(new T_SYS_DICTTYPE_SW {
DICTTYPERID = m.DICTTYPEID
}).ToList();
if (m.DICTTYPEListModel.Count() > 0)
{
foreach (var type in m.DICTTYPEListModel)
{
type.DICTListModel = getListModel(new T_SYS_DICTSW {
DICTTYPEID = type.DICTTYPEID
}).ToList();
}
}
m.DICTListModel = getListModel(new T_SYS_DICTSW {
DICTTYPEID = m.DICTTYPEID
}).ToList();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取表T_SYS_DICTTYPE数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDICTFLAGDT(T_SYS_DICTTYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT DICTTYPEID,DICTTYPERID, DICTTYPENAME, SYSFLAG, ISMAN, MARK, ORDERBY");
sb.AppendFormat(" FROM T_SYS_DICTTYPE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.DICTTYPEID) == false)
{
sb.AppendFormat(" AND DICTTYPEID={0}", sw.DICTTYPEID);
}
if (string.IsNullOrEmpty(sw.DICTTYPERID) == false)
{
sb.AppendFormat(" AND DICTTYPERID={0}", sw.DICTTYPERID);
}
if (string.IsNullOrEmpty(sw.SYSFLAG) == false)
{
sb.AppendFormat(" AND (SYSFLAG='{0}' or SYSFLAG='0')", sw.SYSFLAG);
}
if (string.IsNullOrEmpty(sw.ISMAN) == false)
{
sb.AppendFormat(" AND ISMAN='{0}'", sw.ISMAN);
}
sb.AppendFormat(" ORDER BY ORDERBY", "");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 类别树形菜单
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>string</returns>
public static string getTypeTree(T_SYS_DICTTYPE_SW sw)
{
JArray childobjArray = new JArray();
DataTable dt = BaseDT.T_SYS_DICT.getDICTFLAGDT(sw);
if (string.IsNullOrEmpty(sw.DICTTYPERID))
{
sw.DICTTYPERID = "0";
}
JArray JA = getTreeChild(sw, dt, sw.DICTTYPERID);//, dctypetopid);
dt.Clear();
dt.Dispose();
return(JsonConvert.SerializeObject(JA));
}
/// <summary>
/// 获取字典类别名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns></returns>
public static string getDicTypeName(T_SYS_DICTTYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT DICTTYPENAME FROM T_SYS_DICTTYPE WHERE 1=1");
if (!string.IsNullOrEmpty(sw.DICTTYPEID))
{
sb.AppendFormat(" AND DICTTYPEID='{0}'", sw.DICTTYPEID);
}
if (!string.IsNullOrEmpty(sw.DICTTYPERID))
{
sb.AppendFormat(" AND DICTTYPERID='{0}'", sw.DICTTYPERID);
}
return(DataBaseClass.ReturnSqlField(sb.ToString()));
}
/// <summary>
/// 获取字典类别数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYS_DICTTYPE_Model> getTypeListModel(T_SYS_DICTTYPE_SW sw)
{
var result = new List <T_SYS_DICTTYPE_Model>();
DataTable dt = BaseDT.T_SYS_DICT.getDICTFLAGDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_DICTTYPE_Model m = new T_SYS_DICTTYPE_Model();
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTTYPENAME = dt.Rows[i]["DICTTYPENAME"].ToString();
m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString();
m.ISMAN = dt.Rows[i]["ISMAN"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取类别子菜单
/// </summary>
/// <param name="sw">sw</param>
/// <param name="dt">dt</param>
/// <param name="DICTTYPERID">DICTTYPERID</param>
/// <returns></returns>
private static JArray getTreeChild(T_SYS_DICTTYPE_SW sw, DataTable dt, string DICTTYPERID)
{
JArray childobjArray = new JArray();
DataRow[] dr = dt.Select("DICTTYPERID = " + DICTTYPERID + "", "ORDERBY");
for (int i = 0; i < dr.Length; i++)
{
string DICTTYPEID = dr[i]["DICTTYPEID"].ToString();
DataRow[] dr1 = dt.Select("DICTTYPERID=" + dr[i]["DICTTYPEID"].ToString());
if (dr1.Count() > 0)
{
DICTTYPEID = "";
}
JObject root = new JObject {
{ "id", DICTTYPEID }, { "text", dr[i]["DICTTYPENAME"].ToString() }, { "state", "open" },
};
root.Add("children", getTreeChild(sw, dt, dr[i]["DICTTYPEID"].ToString()));
childobjArray.Add(root);
}
return(childobjArray);
}
/// <summary>
/// 字典类别下拉框
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getSelectOption(T_SYS_DICTTYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_SYS_DICT.getDICTFLAGDT(sw);
if (sw.isShowAll == "1")
{
sb.AppendFormat("<option value=\"\">{0}</option>", "--所有--");
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (sw.DICTTYPEID == dt.Rows[i]["DICTTYPEID"].ToString())
{
sb.AppendFormat("<option value=\"{0}\" selected>{1}</option>", dt.Rows[i]["DICTTYPEID"].ToString(), dt.Rows[i]["DICTTYPENAME"].ToString());
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", dt.Rows[i]["DICTTYPEID"].ToString(), dt.Rows[i]["DICTTYPENAME"].ToString());
}
}
return(sb.ToString());
}
/// <summary>
/// 获取字典类别名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns></returns>
public static string getDicTypeName(T_SYS_DICTTYPE_SW sw)
{
return(BaseDT.T_SYS_DICT.getDicTypeName(sw));
}
