/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">总记录数</param>
/// <returns></returns>
public static List <PEST_REPORT_DIEPINESURVEY_Model> getListModel(PEST_REPORT_DIEPINESURVEY_SW sw, out int total)
{
var result = new List <PEST_REPORT_DIEPINESURVEY_Model>();
DataTable dt = BaseDT.PEST_REPORT_DIEPINESURVEY.getDT(sw, out total);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
for (int i = 0; i < dt.Rows.Count; i++)
{
PEST_REPORT_DIEPINESURVEY_Model m = new PEST_REPORT_DIEPINESURVEY_Model();
m.PEST_REPORT_DIEPINESURVEYID = dt.Rows[i]["PEST_REPORT_DIEPINESURVEYID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.FINDER = dt.Rows[i]["FINDER"].ToString();
m.FINDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FINDDATE"].ToString());
m.LINKTELL = dt.Rows[i]["LINKTELL"].ToString();
m.DIEPINECOUNT = dt.Rows[i]["DIEPINECOUNT"].ToString();
m.REPORTDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["REPORTDATE"].ToString());
m.SAMPLINGCOUNT = dt.Rows[i]["SAMPLINGCOUNT"].ToString();
m.AUTHENTICATERESULT = dt.Rows[i]["AUTHENTICATERESULT"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(result);
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns></returns>
public static PEST_REPORT_DIEPINESURVEY_Model getModel(PEST_REPORT_DIEPINESURVEY_SW sw)
{
DataTable dt = BaseDT.PEST_REPORT_DIEPINESURVEY.getDT(sw);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
PEST_REPORT_DIEPINESURVEY_Model m = new PEST_REPORT_DIEPINESURVEY_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.PEST_REPORT_DIEPINESURVEYID = dt.Rows[i]["PEST_REPORT_DIEPINESURVEYID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.FINDER = dt.Rows[i]["FINDER"].ToString();
m.FINDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FINDDATE"].ToString());
m.LINKTELL = dt.Rows[i]["LINKTELL"].ToString();
m.DIEPINECOUNT = dt.Rows[i]["DIEPINECOUNT"].ToString();
m.REPORTDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["REPORTDATE"].ToString());
m.SAMPLINGCOUNT = dt.Rows[i]["SAMPLINGCOUNT"].ToString();
m.AUTHENTICATERESULT = dt.Rows[i]["AUTHENTICATERESULT"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(PEST_REPORT_DIEPINESURVEY_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELETE 1 FROM PEST_REPORT_DIEPINESURVEY WHERE 1=1");
if (string.IsNullOrEmpty(sw.PEST_REPORT_DIEPINESURVEYID) == false)
{
sb.AppendFormat(" AND PEST_REPORT_DIEPINESURVEYID='{0}'", ClsSql.EncodeSql(sw.PEST_REPORT_DIEPINESURVEYID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取数据列表-分页
/// </summary>
/// <param name="sw">查询模型</param>
/// <param name="total">总记录数</param>
/// <returns></returns>
public static DataTable getDT(PEST_REPORT_DIEPINESURVEY_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_REPORT_DIEPINESURVEY WHERE 1=1");
#region 查询条件
if (!string.IsNullOrEmpty(sw.BYORGNO))
{
if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}')", 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}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6)));
}
else if (sw.BYORGNO.Substring(9, 6) == "000000" && sw.BYORGNO.Substring(6, 9) != "000000000") //获取所有乡镇的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9)));
}
else if (sw.BYORGNO.Substring(9, 6) != "000000") //获取所有村的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,12) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 12)));
}
else
{
sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO));
}
}
if (!string.IsNullOrEmpty(sw.FINDER))
{
sb.AppendFormat(" AND FINDER LIKE '%{0}%'", ClsSql.EncodeSql(sw.FINDER));
}
if (!string.IsNullOrEmpty(sw.STARTDATE))
{
sb.AppendFormat(" AND FINDDATE >= '{0}'", DateTime.Parse(sw.STARTDATE).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(sw.ENDDATE))
{
sb.AppendFormat(" AND FINDDATE <= '{0}'", DateTime.Parse(sw.ENDDATE).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss"));
}
#endregion
string sql = "SELECT * " + sb.ToString() + " ORDER BY FINDDATE DESC,BYORGNO ";
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, "PEST_REPORT_DIEPINESURVEY");
return(ds.Tables[0]);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(PEST_REPORT_DIEPINESURVEY_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT * FROM PEST_REPORT_DIEPINESURVEY WHERE 1=1");
if (!string.IsNullOrEmpty(sw.BYORGNO))
{
if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}')", 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}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6)));
}
else if (sw.BYORGNO.Substring(9, 6) == "000000" && sw.BYORGNO.Substring(6, 9) != "000000000") //获取所有乡镇的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9)));
}
else if (sw.BYORGNO.Substring(9, 6) != "000000") //获取所有村的
{
sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,12) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 12)));
}
else
{
sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO));
}
}
if (!string.IsNullOrEmpty(sw.PEST_REPORT_DIEPINESURVEYID))
{
sb.AppendFormat(" AND PEST_REPORT_DIEPINESURVEYID = '{0}'", ClsSql.EncodeSql(sw.PEST_REPORT_DIEPINESURVEYID));
}
if (!string.IsNullOrEmpty(sw.FINDER))
{
sb.AppendFormat(" AND FINDER LIKE '%{0}%'", ClsSql.EncodeSql(sw.FINDER));
}
if (!string.IsNullOrEmpty(sw.FINDDATE))
{
sb.AppendFormat(" AND FINDDATE >= '{0}'", ClsSql.EncodeSql(sw.FINDDATE));
}
sb.AppendFormat(" ORDER BY FINDDATE DESC,BYORGNO");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
