/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(T_SYS_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYS_PEST where 1=1");
if (string.IsNullOrEmpty(sw.PESTCODE) == false)
{
sb.AppendFormat(" and PESTCODE='{0}'", ClsSql.EncodeSql(sw.PESTCODE));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 判断记录是否存在下级
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExistsChild(T_SYS_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYS_PEST where 1=1");
if (string.IsNullOrEmpty(sw.PESTCODE) == false)
{
sb.AppendFormat(" AND len(PESTCODE)>'{0}'", ClsSql.EncodeSql(sw.PESTCODE).Length);
sb.AppendFormat(" AND substring(PESTCODE,1,{0})= '{1}'", ClsSql.EncodeSql(sw.PESTCODE).Length, ClsSql.EncodeSql(sw.PESTCODE));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型T_SYS_PEST_SW</param>
/// <returns>参见模型T_SYS_PEST_Model</returns>
public static IEnumerable <T_SYS_PEST_Model> getListModel(T_SYS_PEST_SW sw)
{
var result = new List <T_SYS_PEST_Model>();
DataTable dt = BaseDT.T_SYS_PEST.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_PEST_Model m = new T_SYS_PEST_Model();
m.PESTCODE = dt.Rows[i]["PESTCODE"].ToString();
m.PESTNAME = dt.Rows[i]["PESTNAME"].ToString();
m.LATINNAME = dt.Rows[i]["LATINNAME"].ToString();
m.ISLOCAL = dt.Rows[0]["ISLOCAL"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见条件模型T_SYS_PEST_SW</param>
/// <returns>参见模型T_SYS_PEST_Model</returns>
public static T_SYS_PEST_Model getModel(T_SYS_PEST_SW sw)
{
DataTable dt = BaseDT.T_SYS_PEST.getModel(sw);
T_SYS_PEST_Model m = new T_SYS_PEST_Model();
if (dt.Rows.Count > 0)
{
//数据库表字段
m.PESTCODE = dt.Rows[0]["PESTCODE"].ToString();
m.PESTNAME = dt.Rows[0]["PESTNAME"].ToString();
m.LATINNAME = dt.Rows[0]["LATINNAME"].ToString();
m.ISLOCAL = dt.Rows[0]["ISLOCAL"].ToString();
m.ORDERBY = dt.Rows[0]["ORDERBY"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getModel(T_SYS_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT PESTCODE,PESTNAME,LATINNAME,ISLOCAL,ORDERBY FROM T_SYS_PEST WHERE 1=1");
if (!string.IsNullOrEmpty(sw.PESTCODE))
{
sb.AppendFormat(" AND PESTCODE = '{0}'", ClsSql.EncodeSql(sw.PESTCODE));
}
if (!string.IsNullOrEmpty(sw.PESTNAME))
{
sb.AppendFormat(" AND PESTNAME = '{0}'", ClsSql.EncodeSql(sw.PESTNAME));
}
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">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT PESTCODE,PESTNAME,LATINNAME,ISLOCAL,ORDERBY");
sb.AppendFormat(" FROM T_SYS_PEST");
sb.AppendFormat(" WHERE 1=1");
if (sw.IsGetTopCode)
{
sb.AppendFormat(" AND Len(PESTCODE)='2'");
}
if (!string.IsNullOrEmpty(sw.PESTNAME))
{
sb.AppendFormat(" AND PESTNAME like '%{0}%'", ClsSql.EncodeSql(sw.PESTNAME));
}
if (string.IsNullOrEmpty(sw.LATINNAME) == false)
{
sb.AppendFormat(" AND LATINNAME like '%{0}%'", ClsSql.EncodeSql(sw.LATINNAME));
}
if (string.IsNullOrEmpty(sw.PESTCODE) == false)
{
if (sw.GetAllChileCode)
{
string lenth = sw.PESTCODE.Length.ToString();
sb.AppendFormat(" AND Len(PESTCODE) >'{0}' AND Substring(PESTCODE,1," + lenth + ")='{1}'", ClsSql.EncodeSql(sw.PESTCODE.Length.ToString()), ClsSql.EncodeSql(sw.PESTCODE));
}
else
{
sb.AppendFormat(" AND Len(PESTCODE) = '{0}'", ClsSql.EncodeSql(sw.ChildCODELength.ToString()));
sb.AppendFormat(" AND Substring(PESTCODE,1,{0}) = '{1}'", ClsSql.EncodeSql(sw.PESTCODE).Length.ToString(), ClsSql.EncodeSql(sw.PESTCODE));
}
}
sb.AppendFormat(" ORDER BY PESTCODE,ORDERBY ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 获取有害生物下拉框
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getSelectOption(T_SYS_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_SYS_PEST.getDT(sw);
if (sw.IsShowALL)
{
sb.AppendFormat("<option value=\"{0}\">==所有==</option>", "All");
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string code = dt.Rows[i]["PESTCODE"].ToString();
string name = dt.Rows[i]["PESTNAME"].ToString();
if (!string.IsNullOrEmpty(sw.PESTCODE))
{
int x = (code.Length - sw.PESTCODE.Length) / 2;
if (x == 0 || x == 1)
{
name = "" + name;
}
if (x == 2)
{
name = "--" + name;
}
if (x == 3)
{
name = "----" + name;
}
if (x == 4)
{
name = "--------" + name;
}
if (x == 5)
{
name = "----------" + name;
}
if (x == 6)
{
name = "------------" + name;
}
if (x == 7)
{
name = "--------------" + name;
}
if (x == 8)
{
name = "----------------" + name;
}
if (x == 9)
{
name = "------------------" + name;
}
}
else
{
int x = code.Length / 2;
if (x == 1)
{
name = "" + name;
}
if (x == 2)
{
name = "--" + name;
}
if (x == 3)
{
name = "----" + name;
}
if (x == 4)
{
name = "------" + name;
}
if (x == 5)
{
name = "--------" + name;
}
if (x == 6)
{
name = "----------" + name;
}
if (x == 7)
{
name = "------------" + name;
}
if (x == 8)
{
name = "--------------" + name;
}
if (x == 9)
{
name = "----------------" + name;
}
if (x == 10)
{
name = "-----------------" + name;
}
}
sb.AppendFormat("<option value=\"{0}\" >{1}</option>", code, name);
}
}
else
{
sb.AppendFormat("<option value=\"{0}\">==暂无害虫==</option>", "");
}
dt.Clear();
dt.Dispose();
return(sb.ToString());
}
/// <summary>
/// 判断是否有下级
/// </summary>
/// <param name="sw">参见模型T_SYS_PEST_Model</param>
/// <returns>true:存在 false：不存在</returns>
public static bool isExistsChild(T_SYS_PEST_SW sw)
{
return(BaseDT.T_SYS_PEST.isExistsChild(sw));
}
