/// <summary> /// 得到一个对象实体 /// </summary> public ROYcms.Sys.Model.ROYcms_Role GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,zhaiyao,Time from " + PubConstant.date_prefix + "Role "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; ROYcms.Sys.Model.ROYcms_Role model = new ROYcms.Sys.Model.ROYcms_Role(); DataSet ds = DbHelpers.GetDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.zhaiyao = ds.Tables[0].Rows[0]["zhaiyao"].ToString(); if (ds.Tables[0].Rows[0]["Time"].ToString() != "") { model.Time = DateTime.Parse(ds.Tables[0].Rows[0]["Time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,zhaiyao,Time "); strSql.Append(" from " + PubConstant.date_prefix + "Role "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbHelpers.GetDataSet(strSql.ToString())); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" id,name,zhaiyao,Time "); strSql.Append(" from " + PubConstant.date_prefix + "Role "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(DbHelpers.GetDataSet(strSql.ToString())); }