Ejemplo n.º 1
0
        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()));
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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()));
        }