/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_TREESPECIES_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT TSPCODE,TSPNAME,LATINNAME,ORDERBY");
sb.AppendFormat(" FROM T_SYS_TREESPECIES");
sb.AppendFormat(" WHERE 1=1");
if (sw.IsGetTopCode)
{
sb.AppendFormat(" AND len(TSPCODE)='2'");
}
if (!string.IsNullOrEmpty(sw.TSPNAME))
{
sb.AppendFormat(" AND TSPNAME like '%{0}%'", ClsSql.EncodeSql(sw.TSPNAME));
}
if (string.IsNullOrEmpty(sw.LATINNAME) == false)
{
sb.AppendFormat(" AND LATINNAME like '%{0}%'", ClsSql.EncodeSql(sw.LATINNAME));
}
if (string.IsNullOrEmpty(sw.TSPCODE) == false)
{
sb.AppendFormat(" AND Len(TSPCODE) = '{0}'", ClsSql.EncodeSql(sw.ChildCODELength.ToString()));
sb.AppendFormat(" AND Substring(TSPCODE,1,{0}) = '{1}'", ClsSql.EncodeSql(sw.TSPCODE).Length.ToString(), ClsSql.EncodeSql(sw.TSPCODE));
}
sb.AppendFormat(" ORDER BY TSPCODE,ORDERBY ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(T_SYS_TREESPECIES_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYS_TREESPECIES where 1=1");
if (string.IsNullOrEmpty(sw.TSPCODE) == false)
{
sb.AppendFormat(" and TSPCODE='{0}'", ClsSql.EncodeSql(sw.TSPCODE));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见条件模型T_SYS_TREESPECIES_SW</param>
/// <returns>参见模型T_SYS_TREESPECIES_Model</returns>
public static IEnumerable <T_SYS_TREESPECIES_Model> getListModel(T_SYS_TREESPECIES_SW sw)
{
var result = new List <T_SYS_TREESPECIES_Model>();
DataTable dt = BaseDT.T_SYS_TREESPECIES.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_TREESPECIES_Model m = new T_SYS_TREESPECIES_Model();
m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString();
m.TSPNAME = dt.Rows[i]["TSPNAME"].ToString();
m.LATINNAME = dt.Rows[i]["LATINNAME"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见条件模型T_SYS_TREESPECIES_SW</param>
/// <returns>参见模型T_SYS_TREESPECIES_Model</returns>
public static T_SYS_TREESPECIES_Model getModel(T_SYS_TREESPECIES_SW sw)
{
DataTable dt = BaseDT.T_SYS_TREESPECIES.getModel(sw);
T_SYS_TREESPECIES_Model m = new T_SYS_TREESPECIES_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString();
m.TSPNAME = dt.Rows[i]["TSPNAME"].ToString();
m.LATINNAME = dt.Rows[i]["LATINNAME"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取树种下拉框
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getSelectOption(T_SYS_TREESPECIES_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_SYS_TREESPECIES.getDT(sw);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string code = dt.Rows[i]["TSPCODE"].ToString();
string name = dt.Rows[i]["TSPNAME"].ToString();
if (code.Length == 2)
{
name = "" + name;
}
if (code.Length == 4)
{
name = "--" + name;
}
if (code.Length == 6)
{
name = "----" + name;
}
if (i == 0)
{
sb.AppendFormat("<option value=\"{0}\" selected>{1}</option>", code, name);
}
else
{
sb.AppendFormat("<option value=\"{0}\" >{1}</option>", code, name);
}
}
}
else
{
sb.AppendFormat("<option>==暂无树种==</option>");
}
dt.Clear();
dt.Dispose();
return(sb.ToString());
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getModel(T_SYS_TREESPECIES_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT TSPCODE,TSPNAME,LATINNAME,ORDERBY FROM T_SYS_TREESPECIES WHERE 1=1");
if (!string.IsNullOrEmpty(sw.TSPCODE))
{
sb.AppendFormat(" AND TSPCODE = '{0}'", ClsSql.EncodeSql(sw.TSPCODE));
}
if (!string.IsNullOrEmpty(sw.TSPNAME))
{
sb.AppendFormat(" AND TSPNAME = '{0}'", ClsSql.EncodeSql(sw.TSPNAME));
}
if (!string.IsNullOrEmpty(sw.LATINNAME))
{
sb.AppendFormat(" AND LATINNAME = '{0}'", ClsSql.EncodeSql(sw.LATINNAME));
}
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 判断是否有下级
/// </summary>
/// <param name="sw">参见模型T_SYS_TREESPECIES_Model</param>
/// <returns>true:存在 false：不存在</returns>
public static bool isExistsChild(T_SYS_TREESPECIES_SW sw)
{
return(BaseDT.T_SYS_TREESPECIES.isExistsChild(sw));
}
