private M_Advertisement GetInfoFromReader(SqlDataReader rdr)
{
M_Advertisement info = new M_Advertisement();
info.AdId = DataConverter.CLng(rdr["ADID"]);
info.UserId = DataConverter.CLng(rdr["UserID"]);
info.AdType = DataConverter.CLng(rdr["ADType"]);
info.AdName = rdr["ADName"].ToString();
info.ImgUrl = rdr["ImgUrl"].ToString();
info.ImgWidth = DataConverter.CLng(rdr["ImgWidth"]);
info.ImgHeight = DataConverter.CLng(rdr["ImgHeight"]);
info.FlashWmode = DataConverter.CLng(rdr["FlashWmode"]);
info.ADIntro = rdr["ADIntro"].ToString();
info.LinkUrl = rdr["LinkUrl"].ToString();
info.LinkTarget = DataConverter.CLng(rdr["LinkTarget"]);
info.LinkAlt = rdr["LinkAlt"].ToString();
info.Priority = DataConverter.CLng(rdr["Priority"]);
info.Setting = rdr["Setting"].ToString();
info.CountView = DataConverter.CBool(rdr["CountView"].ToString());
info.Views = DataConverter.CLng(rdr["Views"]);
info.CountClick = DataConverter.CBool(rdr["CountClick"].ToString());
info.Clicks = DataConverter.CLng(rdr["Clicks"]);
info.Passed = DataConverter.CBool(rdr["Passed"].ToString());
info.OverdueDate = DataConverter.CDate(rdr["OverdueDate"]);
return(info);
}
/// <summary>
/// 创建广告版位JS
/// </summary>
/// <param name="adZoneInfo"></param>
/// <param name="advertisementInfoList"></param>
public void CreateJS(M_Adzone adZoneInfo, IList <M_Advertisement> advertisementInfoList)
{
//将当前版位对象设置为要操作的版位对象
this.zoneInfo = adZoneInfo;
//读取模板基本代码
StringBuilder builder = new StringBuilder(this.GetZoneJSTemplate());
if (this.zoneInfo.Active == false)
{
builder.Insert(0, "var jsshow=0;if (jsshow==1 ){");
}
//定义版位对象
builder.Append("var ZoneAD_" + adZoneInfo.ZoneID + "=new ");
builder.Append(string.Concat(new object[] { this.zoneConfig[adZoneInfo.ZoneType], "ZoneAD(\"ZoneAD_", adZoneInfo.ZoneID, "\");" }));
//将广告对象定义加入到JS代码中
for (int i = 0; i < advertisementInfoList.Count; i++)
{
this.advertisementInfo = advertisementInfoList[i];
this.advertisementInfo.ZoneID = adZoneInfo.ZoneID;
if (this.advertisementInfo.Passed && (this.advertisementInfo.Days >= 0))
{
builder.Append(this.CreatAdvertisementJS());
}
}
//加入版位属性定义
builder.Append(this.CreateADZoneJS());
FileSystemObject.WriteFile(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Server.MapPath("~/" + SiteConfig.SiteOption.AdvertisementDir)) + adZoneInfo.ZoneJSName, builder.ToString());
}
/// <summary>
/// 复制一个广告
/// </summary>
public bool Copy(int adid)
{
M_Advertisement model = new M_Advertisement();
model = SelReturnModel(adid);
model.ADName = "复制" + model.ADName;
return(Insert(model) > 0);
}
/// <summary>
/// 复制某个广告
/// </summary>
/// <param name="adid"></param>
/// <returns></returns>
public static bool Advertisement_Copy(int adid)
{
M_Advertisement model = new M_Advertisement();
B_Advertisement bll = new B_Advertisement();
model = bll.SelReturnModel(adid);
model.ADName = "复制" + model.ADName;
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)) > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
ZoomLa.Common.function.AccessRulo();
string action = "添加广告内容";
if (!IsPostBack)
{
B_Admin badmin = new B_Admin();
if (!B_ARoleAuth.Check(ZoomLa.Model.ZLEnum.Auth.other, "ADManage"))
{
function.WriteErrMsg("没有权限进行此项操作");
}
listbind();
txtOverdueDate.Text = DateTime.Now.AddYears(1).ToString("yyyy-MM-dd");
//this.InitJSScript();
string id = base.Request.QueryString["ADId"];
if (string.IsNullOrEmpty(id))
{
id = "0";
this.HdnID.Value = id;
action = "添加广告内容";
this.Label1.Text = "添加广告内容";
string ZoneIDs = base.Request.QueryString["ZoneId"];
if (!string.IsNullOrEmpty(ZoneIDs))
{
this.SetLstZoneNameSelected(ZoneIDs);
}
}
else
{
this.HdnID.Value = id;
this.Label1.Text = "修改广告";
M_Advertisement adv = B_Advertisement.Advertisement_GetAdvertisementByid(DataConverter.CLng(id));
this.TxtADName.Text = adv.ADName;
this.TxtPriority.Text = adv.Priority.ToString();
this.txtOverdueDate.Text = adv.OverdueDate.ToString("yyyy-MM-dd");
this.InitRadlAdType(adv.ADType);
this.InitShowPanel(adv);
this.SetLstZoneNameSelected(B_Advertisement.GetZoneIDByAd(adv.ADID));
this.ChkCountClick.Checked = adv.CountClick;
this.ChkCountView.Checked = adv.CountView;
this.TxtClicks.Text = adv.Clicks.ToString();
this.TxtViews.Text = adv.Views.ToString();
ChkPasses.Checked = adv.Passed;
if (adv.ADType > 0)
{
this.ChkCountClick.Enabled = false;
this.TxtClicks.Enabled = false;
}
this.Price.Text = Math.Round(adv.Price, 2).ToString();
ADBuy.Checked = adv.ADBuy == 1 ? true : false;
action = "<a href='Advertisement.aspx?ADId=" + id + "'>修改广告</a>[" + adv.ADName + "]";
}
}
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='ADManage.aspx'>广告管理</a></li><li class='active'>" + action + "</li>" + Call.GetHelp(29));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
B_Admin badmin = new B_Admin();
badmin.CheckMulitLogin();
if (!badmin.ChkPermissions("ADManage"))
{
function.WriteErrMsg("没有权限进行此项操作");
}
listbind();
this.InitJSScript();
string id = base.Request.QueryString["ADId"];
if (string.IsNullOrEmpty(id))
{
id = "0";
this.HdnID.Value = id;
this.Label1.Text = "添加广告";
string ZoneIDs = base.Request.QueryString["ZoneId"];
if (!string.IsNullOrEmpty(ZoneIDs))
{
this.SetLstZoneNameSelected(ZoneIDs);
}
this.txtOverdueDate.Text = DateTime.Now.AddDays(30).ToString("yyyy-MM-dd");
}
else
{
this.HdnID.Value = id;
this.Label1.Text = "修改广告";
M_Advertisement adv = B_Advertisement.Advertisement_GetAdvertisementByid(DataConverter.CLng(id));
this.TxtADName.Text = adv.AdName;
this.TxtPriority.Text = adv.Priority.ToString();
this.txtOverdueDate.Text = adv.OverdueDate.ToString("yyyy-MM-dd");
this.InitRadlAdType(adv.AdType);
this.InitShowPanel(adv);
this.SetLstZoneNameSelected(B_Advertisement.GetZoneIDByAd(adv.AdId));
this.ChkCountClick.Checked = adv.CountClick;
this.ChkCountView.Checked = adv.CountView;
this.TxtClicks.Text = adv.Clicks.ToString();
this.TxtViews.Text = adv.Views.ToString();
if (adv.AdType > 0)
{
this.ChkCountClick.Enabled = false;
this.TxtClicks.Enabled = false;
}
}
}
}
private SqlParameter[] GetParameter(M_Advertisement adv)
{
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@ADID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@ADType", SqlDbType.Int),
new SqlParameter("@ADName", SqlDbType.NVarChar, 100),
new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 255),
new SqlParameter("@ImgWidth", SqlDbType.Int),
new SqlParameter("@ImgHeight", SqlDbType.Int),
new SqlParameter("@FlashWmode", SqlDbType.Int),
new SqlParameter("@ADIntro", SqlDbType.NText),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 255),
new SqlParameter("@LinkTarget", SqlDbType.Int),
new SqlParameter("@LinkAlt", SqlDbType.NVarChar, 255),
new SqlParameter("@Priority", SqlDbType.Int),
new SqlParameter("@Setting", SqlDbType.NText),
new SqlParameter("@CountView", SqlDbType.Bit),
new SqlParameter("@Views", SqlDbType.Int),
new SqlParameter("@CountClick", SqlDbType.Bit),
new SqlParameter("@Clicks", SqlDbType.Int),
new SqlParameter("@Passed", SqlDbType.Int),
new SqlParameter("@OverdueDate", SqlDbType.DateTime)
};
sp[0].Value = adv.AdId;
sp[1].Value = adv.UserId;
sp[2].Value = adv.AdType;
sp[3].Value = adv.AdName;
sp[4].Value = adv.ImgUrl;
sp[5].Value = adv.ImgWidth;
sp[6].Value = adv.ImgHeight;
sp[7].Value = adv.FlashWmode;
sp[8].Value = adv.ADIntro;
sp[9].Value = adv.LinkUrl;
sp[10].Value = adv.LinkTarget;
sp[11].Value = adv.LinkAlt;
sp[12].Value = adv.Priority;
sp[13].Value = adv.Setting;
sp[14].Value = adv.CountView;
sp[15].Value = adv.Views;
sp[16].Value = adv.CountClick;
sp[17].Value = adv.Clicks;
sp[18].Value = adv.Passed;
sp[19].Value = adv.OverdueDate;
return(sp);
}
protected void Page_Load(object sender, EventArgs e)
{
M_Advertisement advertisementById = B_Advertisement.Advertisement_GetAdvertisementByid(DataConverter.CLng(base.Request.QueryString["AdId"]));
if (!advertisementById.IsNull)
{
this.LabAdShow.Text = B_Advertisement.GetAdContent(advertisementById);
if (advertisementById.CountClick)
{
advertisementById.Clicks++;
}
if (advertisementById.CountView)
{
advertisementById.Views++;
}
B_Advertisement.Advertisement_Update(advertisementById);
}
}
private void InitShowPanel(M_Advertisement adv)
{
switch (adv.AdType)
{
case 1:
this.ADContent1.Attributes.Add("style", "display: ");
this.txtpic.Text = adv.ImgUrl;
this.TxtImgWidth.Text = adv.ImgWidth.ToString();
this.TxtImgHeight.Text = adv.ImgHeight.ToString();
this.TxtLinkUrl.Text = adv.LinkUrl;
this.TxtLinkAlt.Text = adv.LinkAlt;
this.RadlLinkTarget.SelectedValue = adv.LinkTarget.ToString();
this.TxtADIntro.Text = adv.ADIntro;
return;
case 2:
this.ADContent2.Attributes.Add("style", "display: ");
this.txtFlashPath.Text = adv.ImgUrl;
this.TxtFlashWidth.Text = adv.ImgWidth.ToString();
this.TxtFlashHeight.Text = adv.ImgHeight.ToString();
this.RadlFlashMode.SelectedValue = adv.FlashWmode.ToString();
return;
case 3:
this.ADContent3.Attributes.Add("style", "display: ");
this.TxtADText.Text = adv.ADIntro;
return;
case 4:
this.ADContent4.Attributes.Add("style", "display: ");
this.TxtADCode.Text = adv.ADIntro;
return;
case 5:
this.ADContent5.Attributes.Add("style", "display: ");
this.TxtWebFileUrl.Text = adv.ADIntro;
return;
}
this.ADContent1.Attributes.Add("style", "display: ");
}
protected void Page_Load(object sender, EventArgs e)
{
string strB = base.Request.QueryString["Action"];
M_Advertisement advertisementById = B_Advertisement.Advertisement_GetAdvertisementByid(DataConverter.CLng(base.Request.QueryString["AdId"]));
if (!advertisementById.IsNull)
{
if (advertisementById.CountView)
{
advertisementById.Views++;
}
if (advertisementById.CountClick)
{
advertisementById.Clicks++;
}
B_Advertisement.Advertisement_Update(advertisementById);
if ((string.Compare("Click", strB, true) == 0) && !string.IsNullOrEmpty(advertisementById.LinkUrl))
{
Response.Write("<script language='javascript' type='text/javascript'>window.location='" + advertisementById.LinkUrl + "';</script>");
}
}
}
/// <summary>
/// 添加广告
/// </summary>
/// <param name="Advertisement"></param>
/// <returns></returns>
public static bool Advertisement_Add(M_Advertisement Advertisement)
{
return(advertisement.Advertisement_Add(Advertisement));
}
public static string GetAdContent(M_Advertisement advertisementInfo)
{
StringBuilder builder2;
StringBuilder builder = new StringBuilder();
switch (advertisementInfo.AdType)
{
case 1:
{
builder2 = new StringBuilder();
builder2.Append("<img src=\"");
string imgUrl = advertisementInfo.ImgUrl;
if (((!imgUrl.StartsWith("/") && !imgUrl.StartsWith("~/")) && !imgUrl.StartsWith("http", StringComparison.CurrentCultureIgnoreCase)) && !imgUrl.StartsWith("https", StringComparison.CurrentCultureIgnoreCase))
{
builder2.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath));
//builder2.Append(VirtualPathUtility.AppendTrailingSlash(SiteConfig.SiteOption.UploadDir));
builder2.Append(imgUrl);
break;
}
builder2.Append(imgUrl);
break;
}
case 2:
builder.Append("<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"");
if (advertisementInfo.ImgWidth > 0)
{
builder.Append(" width=\"");
builder.Append(advertisementInfo.ImgWidth);
builder.Append("\"");
}
if (advertisementInfo.ImgHeight > 0)
{
builder.Append(" height=\"");
builder.Append(advertisementInfo.ImgHeight);
builder.Append("\"");
}
builder.Append("><param name=\"movie\" value=\"");
builder.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath));
builder.Append(advertisementInfo.ImgUrl);
builder.Append("\">");
if (advertisementInfo.FlashWmode == 1)
{
builder.Append("<param name=\"wmode\" value=\"transparent\">");
}
builder.Append("<param name=\"quality\" value=\"autohigh\">");
builder.Append("<embed src=\"");
builder.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath));
//builder.Append(VirtualPathUtility.AppendTrailingSlash(SiteConfig.SiteOption.UploadDir));
builder.Append(advertisementInfo.ImgUrl);
builder.Append("\" quality=\"autohigh\" pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" type=\"application/x-shockwave-flash\"");
if (advertisementInfo.FlashWmode == 1)
{
builder.Append(" wmode=\"transparent\" ");
}
if (advertisementInfo.ImgWidth > 0)
{
builder.Append(" width=\"");
builder.Append(advertisementInfo.ImgWidth);
builder.Append("\"");
}
if (advertisementInfo.ImgHeight > 0)
{
builder.Append(" height=\"");
builder.Append(advertisementInfo.ImgHeight);
builder.Append("\"");
}
builder.Append("></embed></object>");
goto Label_04B5;
case 3:
builder.Append(advertisementInfo.ADIntro);
goto Label_04B5;
case 4:
builder.Append(advertisementInfo.ADIntro);
goto Label_04B5;
case 5:
builder.Append("<iframe id=\"AD_");
builder.Append(advertisementInfo.AdId);
builder.Append("\" marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=no width=100% height=100% src=\"");
builder.Append(advertisementInfo.ADIntro);
builder.Append("\">AD</iframe>");
goto Label_04B5;
default:
goto Label_04B5;
}
builder2.Append("\"");
if (advertisementInfo.ImgWidth > 0)
{
builder2.Append(" width=\"");
builder2.Append(advertisementInfo.ImgWidth);
builder2.Append("\"");
}
if (advertisementInfo.ImgHeight > 0)
{
builder2.Append(" height=\"");
builder2.Append(advertisementInfo.ImgHeight);
builder2.Append("\"");
}
builder2.Append(" border=\"0\"></img>");
if (!string.IsNullOrEmpty(advertisementInfo.LinkUrl))
{
builder.Append("<a href=\"");
builder.Append(advertisementInfo.LinkUrl);
builder.Append("\"");
if (advertisementInfo.LinkTarget == 0)
{
builder.Append(" target=\"_self\"");
}
else
{
builder.Append(" target=\"_blank\"");
}
builder.Append(" title=\"");
builder.Append(advertisementInfo.LinkAlt);
builder.Append("\"");
builder.Append(">");
builder.Append(builder2.ToString());
builder.Append("</a>");
}
else
{
builder = builder2;
}
Label_04B5:
return(builder.ToString());
}
public int Insert(M_Advertisement model)
{
return(DBCenter.Insert(model));
}
/// <summary>
/// 修改广告
/// </summary>
/// <param name="Advertisement"></param>
/// <param name="StrZoneID"></param>
/// <returns></returns>
public bool Advertisement_Update(M_Advertisement Advertisement)
{
SqlParameter[] parameter = this.GetParameter(Advertisement);
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "dt_Advertisement_Update", parameter) > 0);
}
/// <summary>
/// 修改广告
/// </summary>
/// <param name="Advertisement"></param>
/// <returns></returns>
public static bool Advertisement_Update(M_Advertisement Advertisement)
{
return(Sql.UpdateByIDs(strTableName, PK, Advertisement.ADID.ToString(), BLLCommon.GetFieldAndPara(Advertisement), Advertisement.GetParameters()));
}
public bool UpdateByID(M_Advertisement model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ADID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
string adZoneIdList = LstZoneName.SelectedValue;
if (this.Page.IsValid)
{
int adid = DataConverter.CLng(this.HdnID.Value.Trim());
M_Advertisement adv = new M_Advertisement();
adv.UserID = 0;
adv.ADName = Server.HtmlEncode(this.TxtADName.Text.Trim());
adv.ADType = DataConverter.CLng(this.RadlADType.SelectedValue);
adv.Priority = DataConverter.CLng(this.TxtPriority.Text.Trim());
adv.Passed = ChkPasses.Checked;
adv.CountView = this.ChkCountView.Checked;
adv.Views = DataConverter.CLng(this.TxtViews.Text.Trim());
adv.CountClick = this.ChkCountClick.Checked;
adv.Clicks = DataConverter.CLng(this.TxtClicks.Text.Trim());
//adv.ZoneID = adZoneIdList;
adv.ADID = adid;
adv.OverdueDate = DataConverter.CDate(this.txtOverdueDate.Text);
adv.Setting = "";
adv.Price = DataConverter.CDecimal(this.Price.Text);
adv.ADBuy = this.ADBuy.Checked ? 1 : 0;
switch (adv.ADType)
{
case 1:
{
adv.ImgUrl = this.txtpic.Text.Trim();
if (string.IsNullOrEmpty(adv.ImgUrl))
{
function.WriteErrMsg("图片广告的图片地址不能为空！");
}
adv.ImgHeight = DataConverter.CLng(this.TxtImgHeight.Text.Trim());
adv.ImgWidth = DataConverter.CLng(this.TxtImgWidth.Text.Trim());
string str2 = (this.TxtLinkUrl.Text.Trim() == "http://") ? "" : this.TxtLinkUrl.Text.Trim();
adv.LinkUrl = str2;
adv.LinkTarget = DataConverter.CLng(this.RadlLinkTarget.SelectedValue);
adv.LinkAlt = this.TxtLinkAlt.Text.Trim();
adv.ADIntro = this.TxtADIntro.Text.Trim();
adv.ImgUrl1 = this.txtpic1.Text.Trim();
adv.ImgHeight1 = DataConverter.CLng(this.TxtImgHeight1.Text.Trim());
adv.ImgWidth1 = DataConverter.CLng(this.TxtImgWidth1.Text.Trim());
string str3 = (this.TxtLinkUrl1.Text.Trim() == "http://") ? "" : this.TxtLinkUrl1.Text.Trim();
adv.LinkUrl1 = str3;
adv.LinkTarget1 = DataConverter.CLng(this.RadlLinkTarget1.SelectedValue);
adv.LinkAlt1 = this.TxtLinkAlt1.Text.Trim();
adv.ADIntro1 = this.TxtADIntro1.Text.Trim();
break;
}
case 2:
adv.ImgUrl = this.txtFlashPath.Text.Trim();
if (string.IsNullOrEmpty(adv.ImgUrl))
{
function.WriteErrMsg("动画广告的Flash地址不能为空");
}
adv.ImgHeight = DataConverter.CLng(this.TxtFlashHeight.Text.Trim());
adv.ImgWidth = DataConverter.CLng(this.TxtFlashWidth.Text.Trim());
adv.FlashWmode = DataConverter.CLng(this.RadlFlashMode.SelectedValue);
adv.ImgUrl1 = this.txtFlashPath1.Text.Trim();
adv.ImgHeight1 = DataConverter.CLng(this.TxtFlashHeight1.Text.Trim());
adv.ImgWidth1 = DataConverter.CLng(this.TxtFlashWidth1.Text.Trim());
adv.FlashWmode1 = DataConverter.CLng(this.RadlFlashMode1.SelectedValue);
break;
case 3:
adv.ADIntro = this.TxtADText.Text.Trim();
adv.ADIntro1 = this.TxtADText1.Text.Trim();
break;
case 4:
adv.ADIntro = this.TxtADCode.Text.Trim();
adv.ADIntro1 = this.TxtADCode1.Text.Trim();
break;
case 5:
adv.ADIntro = this.TxtWebFileUrl.Text.Trim();
adv.ADIntro1 = this.TxtWebFileUrl1.Text.Trim();
break;
}
bool flag = false;
if (adv.ADID > 0)
{
flag = B_Advertisement.Advertisement_Update(adv);
}
else
{
adv.ADID = B_Advertisement.MaxID();
flag = B_Advertisement.Advertisement_Add(adv);
adv.ADID = B_Advertisement.MaxID() - 1;
}
if (flag)
{
int zid = 0;
B_ADZone.Delete_ADZone_Ad(adv.ADID.ToString());
if (!string.IsNullOrEmpty(adZoneIdList))
{
if (adZoneIdList.IndexOf(',') > -1)
{
string[] arr = adZoneIdList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int s = 0; s < arr.Length; s++)
{
zid = DataConverter.CLng(arr[s]);
if (!B_Advertisement.IsExistZoneAdv(zid, adv.ADID))
{
B_Advertisement.Add_Zone_Advertisement(zid, adv.ADID);
}
}
B_ADZone.CreateJS(adZoneIdList);
}
else
{
zid = DataConverter.CLng(adZoneIdList);
bool isadd = false;
if (!B_Advertisement.IsExistZoneAdv(zid, adv.ADID))
{
isadd = B_Advertisement.Add_Zone_Advertisement(zid, adv.ADID);
}
B_ADZone.CreateJS(adZoneIdList);
}
}
function.WriteSuccessMsg("广告信息保存成功!", "ADManage.aspx");
}
else
{
function.WriteErrMsg("保存失败!");
}
}
}
public int insert(M_Advertisement model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_Advertisement model)
{
return(DBCenter.UpdateByID(model, model.ADID));
}
/// <summary>
/// 修改广告
/// </summary>
/// <param name="Advertisement"></param>
/// <returns></returns>
public static bool Advertisement_Update(M_Advertisement Advertisement)
{
return(advertisement.Advertisement_Update(Advertisement));
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
string adZoneIdList = this.GetAdZoneIdList();
if (this.Page.IsValid)
{
M_Advertisement adv = new M_Advertisement();
adv.UserId = 0;
adv.AdName = DataSecurity.HtmlEncode(this.TxtADName.Text.Trim());
adv.AdType = DataConverter.CLng(this.RadlADType.SelectedValue);
adv.Priority = DataConverter.CLng(this.TxtPriority.Text.Trim());
adv.Passed = this.ChkPassed.Checked;
adv.CountView = this.ChkCountView.Checked;
adv.Views = DataConverter.CLng(this.TxtViews.Text.Trim());
adv.CountClick = this.ChkCountClick.Checked;
adv.Clicks = DataConverter.CLng(this.TxtClicks.Text.Trim());
//adv.ZoneID = adZoneIdList;
adv.AdId = DataConverter.CLng(this.HdnID.Value.Trim());
adv.OverdueDate = DataConverter.CDate(this.txtOverdueDate.Text);
adv.Setting = "";
switch (adv.AdType)
{
case 1:
{
adv.ImgUrl = this.txtpic.Text.Trim();
if (string.IsNullOrEmpty(adv.ImgUrl))
{
function.WriteErrMsg("图片广告的图片地址不能为空！");
}
adv.ImgHeight = DataConverter.CLng(this.TxtImgHeight.Text.Trim());
adv.ImgWidth = DataConverter.CLng(this.TxtImgWidth.Text.Trim());
string str2 = this.TxtLinkUrl.Text.Trim();
adv.LinkUrl = str2;
adv.LinkTarget = DataConverter.CLng(this.RadlLinkTarget.SelectedValue);
adv.LinkAlt = this.TxtLinkAlt.Text.Trim();
adv.ADIntro = this.TxtADIntro.Text.Trim();
break;
}
case 2:
adv.ImgUrl = this.txtFlashPath.Text.Trim();
if (string.IsNullOrEmpty(adv.ImgUrl))
{
function.WriteErrMsg("动画广告的Flash地址不能为空");
}
adv.ImgHeight = DataConverter.CLng(this.TxtFlashHeight.Text.Trim());
adv.ImgWidth = DataConverter.CLng(this.TxtFlashWidth.Text.Trim());
adv.FlashWmode = DataConverter.CLng(this.RadlFlashMode.SelectedValue);
break;
case 3:
adv.ADIntro = this.TxtADText.Text.Trim();
break;
case 4:
adv.ADIntro = this.TxtADCode.Text.Trim();
break;
case 5:
adv.ADIntro = this.TxtWebFileUrl.Text.Trim();
break;
}
bool flag = false;
if (adv.AdId > 0)
{
flag = B_Advertisement.Advertisement_Update(adv);
}
else
{
adv.AdId = B_Advertisement.MaxID();
flag = B_Advertisement.Advertisement_Add(adv);
}
if (flag)
{
int zid = 0;
if (!string.IsNullOrEmpty(adZoneIdList))
{
string[] arr = adZoneIdList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int s = 0; s < arr.Length; s++)
{
zid = DataConverter.CLng(arr[s]);
if (!B_Advertisement.IsExistZoneAdv(zid, adv.AdId))
{
B_Advertisement.Add_Zone_Advertisement(zid, adv.AdId);
}
}
B_ADZone.CreateJS(adZoneIdList);
}
Response.Write("<script>alert('广告信息保存成功！');window.document.location.href='ADManage.aspx'</script>");
}
else
{
Response.Write("<script>alert('广告信息保存失败！');</script>");
}
}
}
public static bool Advertisement_Add(M_Advertisement Advertisement)
{
return(Sql.insert(strTableName, Advertisement.GetParameters(), BLLCommon.GetParas(Advertisement), BLLCommon.GetFields(Advertisement)) > 0);
}
private void ShowAd()
{
M_Advertisement advertisementById = B_Advertisement.Advertisement_GetAdvertisementByid(DataConverter.CLng(base.Request.QueryString["AdId"]));
this.ShowJS.InnerHtml = B_Advertisement.GetAdContent(advertisementById);
}
///// <summary>
/////根据广告类型，查找广告
///// </summary>
///// <param name="type"></param>
///// <returns></returns>
//public static DataTable GetAdvByType(int type)
//{
// DataTable dt = new DataTable();
// string cmd = @"select * from ZL_Advertisement where ADType=@type order by Priority DESC, ADID desc";
// SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@type", SqlDbType.Int) };
// parameter[0].Value = type;
// dt = SqlHelper.ExecuteTable(CommandType.Text, cmd, parameter);
// return dt;
//}
/// <summary>
/// 是据广告的类型,输出内容
/// </summary>
public string GetAdContent(M_Advertisement advMod)
{
return("");
}
