/// <summary>
/// 获得数据List
/// </summary>
public DDML_ConfirmList GetDataList(DDML_Confirm_RecordQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM TAB_DDML_Confirm_Record where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_DDML_Confirm_Record where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_DDML_Confirm_Record where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DDML_ConfirmList list = new DDML_ConfirmList();
foreach (DataRow dr in dt.Rows)
{
DDML_Confirm _DDML_Confirm = new DDML_Confirm();
DataRowToModel(_DDML_Confirm, dr);
list.Add(_DDML_Confirm);
}
return(list);
}
/// <summary>
/// 获得记录总数
/// </summary>
public int GetDataCount(DDML_Confirm_RecordQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) ");
strSql.Append(" FROM TAB_DDML_Confirm_Record where 1=1" + strSqlOption.ToString());
return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams)));
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public DDML_Confirm GetModel(DDML_Confirm_RecordQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append(" FROM TAB_DDML_Confirm_Record where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DDML_Confirm _DDML_Confirm = null;
if (dt.Rows.Count > 0)
{
_DDML_Confirm = new DDML_Confirm();
DataRowToModel(_DDML_Confirm, dt.Rows[0]);
}
return(_DDML_Confirm);
}
/// <summary>
/// 获得数据DataTable
/// </summary>
public DataTable GetDataTable(DDML_Confirm_RecordQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM TAB_DDML_Confirm_Record where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_DDML_Confirm_Record where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_DDML_Confirm_Record where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}