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())); }