/// <summary>
/// 查找所对应的广告信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Tz888.Model.advertise.ADMessageInfo SelMessage(int id)
{
ADMessageInfo message = new ADMessageInfo();
string sql = "select BID,TypeName,SerialID,size,price,giving,note,checkid from ADMessageInfo where positionID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", SqlDbType.Int, 8)
};
para[0].Value = id;
DataSet ds = DbHelperSQL.Query(sql, para);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
message.BID = Convert.ToInt32(ds.Tables[0].Rows[0]["BID"].ToString());
message.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString();
message.SerialID = ds.Tables[0].Rows[0]["SerialID"].ToString();
message.size = ds.Tables[0].Rows[0]["size"].ToString();
message.price = float.Parse(ds.Tables[0].Rows[0]["price"].ToString());
message.giving = Convert.ToDateTime(ds.Tables[0].Rows[0]["giving"].ToString());
message.note = ds.Tables[0].Rows[0]["note"].ToString();
message.checkid = Convert.ToInt32(ds.Tables[0].Rows[0]["checkid"].ToString());
}
return(message);
}
/// <summary>
/// 根据ID获取所对于的信息
/// </summary>
/// <param name="id"></param>
private void seladvister(int id)
{
MessageInfo = messageBll.SelMessage(id); //查询方法
this.txtTypeName.Text = MessageInfo.TypeName.ToString(); //广告名称
this.ddlBName.SelectedValue = MessageInfo.BID.ToString(); //频道
this.txtSerial.Text = MessageInfo.SerialID.ToString(); //序号
this.txtsize.Text = MessageInfo.size.ToString(); //尺寸大小
this.txtprice.Text = MessageInfo.price.ToString(); //价格
this.txtgiving.Value = MessageInfo.giving.ToString(); //赠送日期
this.txtnote.Text = MessageInfo.note.ToString(); //备注
this.rblcheck.SelectedValue = MessageInfo.checkid.ToString(); //激活状态
}
