/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <PEST_TREESPECIES_PEST_Model> getListModel(PEST_TREESPECIES_PEST_SW sw)
{
var result = new List <PEST_TREESPECIES_PEST_Model>();
DataTable dt = BaseDT.PEST_TREESPECIES_PEST.getDT(sw);
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW());
for (int i = 0; i < dt.Rows.Count; i++)
{
PEST_TREESPECIES_PEST_Model m = new PEST_TREESPECIES_PEST_Model();
m.PEST_TREESPECIES_PESTID = dt.Rows[i]["PEST_TREESPECIES_PESTID"].ToString();
m.TREESPECIESCODE = dt.Rows[i]["TREESPECIESCODE"].ToString();
m.TREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TREESPECIESCODE);
m.PESTBYCODE = dt.Rows[i]["PESTBYCODE"].ToString();
m.PESTBYNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTBYCODE);
m.PESTKECODE = m.PESTBYCODE.Substring(0, 10) + "0000";
m.PESTKENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTKECODE);
m.PESTSHUCODE = m.PESTBYCODE.Substring(0, 12) + "00";
m.PESTSHUNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTSHUCODE);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
return(result);
}
/// <summary>
/// 获取本地树种下拉框
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getSelectOption(PEST_TREESPECIES_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.PEST_TREESPECIES_PEST.getDT(sw);
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW());
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string code = dt.Rows[i]["PESTBYCODE"].ToString();
string name = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, code);
sb.AppendFormat("<option value=\"{0}\" >{1}</option>", code, name);
}
}
else
{
sb.AppendFormat("<option value=\"\">==暂无病虫==</option>");
}
dt.Clear();
dt.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
return(sb.ToString());
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(PEST_TREESPECIES_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from PEST_TREESPECIES_PEST where 1=1");
if (string.IsNullOrEmpty(sw.TREESPECIESCODE) == false)
{
sb.AppendFormat(" and TREESPECIESCODE='{0}'", ClsSql.EncodeSql(sw.TREESPECIESCODE));
}
if (string.IsNullOrEmpty(sw.PESTBYCODE) == false)
{
sb.AppendFormat(" and PESTBYCODE='{0}'", ClsSql.EncodeSql(sw.PESTBYCODE));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static PEST_TREESPECIES_PEST_Model getModel(PEST_TREESPECIES_PEST_SW sw)
{
DataTable dt = BaseDT.PEST_TREESPECIES_PEST.getDT(sw);
PEST_TREESPECIES_PEST_Model m = new PEST_TREESPECIES_PEST_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.PEST_TREESPECIES_PESTID = dt.Rows[i]["PEST_TREESPECIES_PESTID"].ToString();
m.TREESPECIESCODE = dt.Rows[i]["TREESPECIESCODE"].ToString();
m.PESTBYCODE = dt.Rows[i]["PESTBYCODE"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDT(PEST_TREESPECIES_PEST_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_TREESPECIES_PEST WHERE 1=1");
if (!string.IsNullOrEmpty(sw.TREESPECIESCODE))
{
sb.AppendFormat(" AND TREESPECIESCODE = '{0}'", ClsSql.EncodeSql(sw.TREESPECIESCODE));
}
if (!string.IsNullOrEmpty(sw.PESTBYCODE))
{
sb.AppendFormat(" AND PESTBYCODE = '{0}'", ClsSql.EncodeSql(sw.PESTBYCODE));
}
string sql = " SELECT PEST_TREESPECIES_PESTID, TREESPECIESCODE, PESTBYCODE " + sb.ToString() + " ORDER BY TREESPECIESCODE,PESTBYCODE ";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取分页数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">总记录数</param>
/// <returns>参见模型</returns>
public static DataTable getDT(PEST_TREESPECIES_PEST_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_TREESPECIES_PEST WHERE 1=1");
if (!string.IsNullOrEmpty(sw.TREESPECIESCODE))
{
sb.AppendFormat(" AND TREESPECIESCODE = '{0}'", ClsSql.EncodeSql(sw.TREESPECIESCODE));
}
if (!string.IsNullOrEmpty(sw.PESTBYCODE))
{
sb.AppendFormat(" AND PESTBYCODE = '{0}'", ClsSql.EncodeSql(sw.PESTBYCODE));
}
string sql = " SELECT PEST_TREESPECIES_PESTID, TREESPECIESCODE, PESTBYCODE " + sb.ToString() + " ORDER BY TREESPECIESCODE,PESTBYCODE ";
string sqlC = "SELECT Count(1) " + sb.ToString();
total = int.Parse(DataBaseClass.ReturnSqlField(sqlC));
sw.CurPage = PagerCls.getCurPage(new PagerSW {
curPage = sw.CurPage, pageSize = sw.PageSize, rowCount = total
});
DataSet ds = DataBaseClass.FullDataSet(sql, (sw.CurPage - 1) * sw.PageSize, sw.PageSize, "a");
return(ds.Tables[0]);
}
