/// <summary>
///获取分页列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static DataTable getDT(WILD_ANIMALDISTRIBUTE_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM WILD_ANIMALDISTRIBUTE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.WILD_ANIMALDISTRIBUTEID) == false)
{
sb.AppendFormat(" AND WILD_ANIMALDISTRIBUTEID = '{0}'", ClsSql.EncodeSql(sw.WILD_ANIMALDISTRIBUTEID));
}
if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false)
{
sb.AppendFormat(" AND BIOLOGICALTYPECODE = '{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE));
}
if (string.IsNullOrEmpty(sw.POPULATIONTYPE) == false)
{
sb.AppendFormat(" AND POPULATIONTYPE = '{0}'", ClsSql.EncodeSql(sw.POPULATIONTYPE));
}
string sql = "SELECT WILD_ANIMALDISTRIBUTEID, BIOLOGICALTYPECODE, POPULATIONTYPE, JD, WD, JWDLIST, ANIMALCOUNT, MARK"
+ sb.ToString()
+ " order by WILD_ANIMALDISTRIBUTEID desc";
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]);
}
/// <summary>
/// 获取记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(WILD_ANIMALDISTRIBUTE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM WILD_ANIMALDISTRIBUTE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.WILD_ANIMALDISTRIBUTEID) == false)
{
sb.AppendFormat(" AND WILD_ANIMALDISTRIBUTEID = '{0}'", ClsSql.EncodeSql(sw.WILD_ANIMALDISTRIBUTEID));
}
if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false)
{
sb.AppendFormat(" AND BIOLOGICALTYPECODE = '{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE));
}
if (string.IsNullOrEmpty(sw.POPULATIONTYPE) == false)
{
sb.AppendFormat(" AND POPULATIONTYPE = '{0}'", ClsSql.EncodeSql(sw.POPULATIONTYPE));
}
string sql = "SELECT WILD_ANIMALDISTRIBUTEID, BIOLOGICALTYPECODE, POPULATIONTYPE, JD, WD, JWDLIST, ANIMALCOUNT, MARK"
+ sb.ToString()
+ " order by WILD_ANIMALDISTRIBUTEID desc";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 统计当前用户下动物的记录数量
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getNum(WILD_ANIMALDISTRIBUTE_SW sw)
{
string total = "";
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from WILD_ANIMALDISTRIBUTE a ");
sb.AppendFormat("where 1 = 1 ");
//if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的
// sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4)));
//else if (sw.BYORGNO.Substring(6, 9) == "000000000" && sw.BYORGNO.Substring(4, 11) != "00000000000") //获取所有县的
// sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6)));
//else
// sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9)));
string sqlC = "select count(1) " + sb.ToString();
total = (DataBaseClass.ReturnSqlField(sqlC)).ToString();
return(total);
}
