public M_Adzone SelReturnModel(int ID)
{
using (DbDataReader reader = Sql.SelReturnReader(TbName, PK, ID))
{
if (reader.Read())
{
return(initMod.GetModelFromReader(reader));
}
else
{
return(null);
}
}
}
/// <summary>
/// 获取某个广告所属第一个版位
/// </summary>
public static M_Adzone getAdzones(int adverseId)
{
M_Adzone model = new M_Adzone();
string sql = "select * from ZL_AdZone where ZoneID=(select top 1 ZoneID from ZL_Zone_Advertisement where ADID=" + adverseId + " order by ZoneID desc)";
using (DbDataReader drd = SqlHelper.ExecuteReader(CommandType.Text, sql))
{
if (drd.Read())
{
return(model.GetModelFromReader(drd));
}
else
{
return(new M_Adzone(true));
}
}
}
/// <summary>
/// 获取指定版位的详细信息
/// </summary>
/// <param name="adzoneid"></param>
/// <returns></returns>
public static M_Adzone getAdzoneByZoneId(int adzoneid)
{
M_Adzone model = new M_Adzone();
string sql = "select * from ZL_AdZone where ZoneId=@zoneid";
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@zoneid", SqlDbType.Int);
parameter[0].Value = adzoneid;
using (SqlDataReader drd = SqlHelper.ExecuteReader(CommandType.Text, sql, parameter))
{
if (drd.Read())
{
return(model.GetModelFromReader(drd));
}
else
{
return(new M_Adzone(true));
}
}
}
/// <summary>
/// 获取某个广告所属第一个版位
/// </summary>
/// <param name="adverseId"></param>
/// <returns></returns>
public static M_Adzone getAdzones(int adverseId)
{
M_Adzone model = new M_Adzone();
string sql = "select * from ZL_AdZone where ZoneID=(select top 1 ZoneID from ZL_Zone_Advertisement where ADID=@ADID order by ZoneID desc)";
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@ADId", SqlDbType.Int);
parameter[0].Value = adverseId;
using (SqlDataReader drd = SqlHelper.ExecuteReader(CommandType.Text, sql, parameter))
{
if (drd.Read())
{
return(model.GetModelFromReader(drd));
}
else
{
return(new M_Adzone(true));
}
}
}