public DataSet GetOperateList(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ConfigEnum,School_ID,School_Name,D_Name,D_Value,D_Type,D_Remark,D_Order,D_CreateTime,D_CreateUser,D_UpdateTime,D_UpdateUser,D_PublicValue,SchoolIP,Mobile from ConfigSchool ");
builder.Append(" FROM ConfigSchool ");
if (strWhere.Trim() != "")
{
builder.Append(" where " + strWhere);
}
return(DbHelperSQL_Operate.Query(builder.ToString()));
}
public Model_ConfigSchool GetModelBySchoolId(string SchoolId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 * from ConfigSchool ");
builder.Append(" where School_ID=@School_ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@School_ID", SqlDbType.VarChar, 50) };
cmdParms[0].Value = SchoolId;
new Model_ConfigSchool();
DataSet set = DbHelperSQL_Operate.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count > 0)
{
return(this.DataRowToModel(set.Tables[0].Rows[0]));
}
return(null);
}
public DataSet GetListByPage_Operate(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM ( ");
builder.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
builder.Append("order by T." + orderby);
}
else
{
builder.Append("order by T.SyncFileToSchoolData_Id desc");
}
builder.Append(")AS Row, T.* from SyncFileToSchoolData T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
builder.Append(" WHERE " + strWhere);
}
builder.Append(" ) TT");
builder.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbHelperSQL_Operate.Query(builder.ToString()));
}