/// <summary>
/// 获取分页数据
/// </summary>
public DataTable GetPaginationData(DBDic_StaffInfoQuery TAB_Dic_StaffInfoQuery)
{
StringBuilder strSqlOption = new StringBuilder();
StringBuilder strSql = new StringBuilder();
SqlParameter[] sqlParams;
TAB_Dic_StaffInfoQuery.OutPut(out strSqlOption, out sqlParams);
strSql.Append(@"select top " + TAB_Dic_StaffInfoQuery.rows.ToString() + " * from VIEW_WebPlatForm_StaffInfo where 1=1 " + strSqlOption.ToString() + " and nID not in ( select top " + (TAB_Dic_StaffInfoQuery.page - 1) * TAB_Dic_StaffInfoQuery.rows + " nID from VIEW_WebPlatForm_StaffInfo where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}
/// <summary>
/// 获取数据总数
/// </summary>
/// <param name="jcid"></param>
/// <returns></returns>
public int GetDataCount(DBDic_StaffInfoQuery TAB_Dic_StaffInfoQuery)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
TAB_Dic_StaffInfoQuery.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) ");
strSql.Append(" FROM VIEW_WebPlatForm_StaffInfo where 1=1" + strSqlOption.ToString());
return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams)));
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public DataTable GetData(DBDic_StaffInfoQuery TAB_Dic_StaffInfoQuery)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
TAB_Dic_StaffInfoQuery.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM VIEW_WebPlatForm_StaffInfo where 1=1" + strSqlOption.ToString());
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dic_StaffInfo GetModel(DBDic_StaffInfoQuery Query)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
Query.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select *");
strSql.Append(" from WebPlatForm_Dic_StaffInfo where 1=1 " + strSqlOption);
Dic_StaffInfo model = new Dic_StaffInfo();
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["nID"].ToString() != "")
{
model.nID = int.Parse(ds.Tables[0].Rows[0]["nID"].ToString());
}
model.strID = ds.Tables[0].Rows[0]["strID"].ToString();
model.strNumber = ds.Tables[0].Rows[0]["strNumber"].ToString();
model.strName = ds.Tables[0].Rows[0]["strName"].ToString();
model.strDuty = ds.Tables[0].Rows[0]["strDuty"].ToString();
model.strPassword = ds.Tables[0].Rows[0]["strPassword"].ToString();
model.strPictureFileName = ds.Tables[0].Rows[0]["strPictureFileName"].ToString();
model.dtTokenTime = ObjectConvertClass.static_ext_Date(ds.Tables[0].Rows[0]["dtTokenTime"]);
model.dtLoginTime = ObjectConvertClass.static_ext_Date(ds.Tables[0].Rows[0]["dtLoginTime"]);
model.strTokenID = ObjectConvertClass.static_ext_string(ds.Tables[0].Rows[0]["strTokenID"]);
model.nRoleID = ObjectConvertClass.static_ext_int(ds.Tables[0].Rows[0]["nRoleID"]);
return(model);
}
else
{
return(null);
}
}
