protected void btnSave_Click(object sender, EventArgs e) { Maticsoft.Model.Settings.AdvertisePosition model = new Maticsoft.Model.Settings.AdvertisePosition(); if (this.txtAdvPositionName.Text.Trim().Length == 0) { MessageBox.ShowFailTip(this, "广告位名称不能为空!"); } else { string selectedValue = this.ddlShowType.SelectedValue; switch (selectedValue) { case "1": if (!PageValidate.IsNumber(this.txtRepeatColumns.Text)) { MessageBox.ShowFailTip(this, "请数如正确的横向平铺时行显示个数!"); return; } model.RepeatColumns = new int?(Globals.SafeInt(this.txtRepeatColumns.Text, 0)); break; case "4": if (string.IsNullOrWhiteSpace(this.txtAdvHtml.Text)) { MessageBox.ShowFailTip(this, "请数广告位内容!"); return; } model.AdvHtml = this.txtAdvHtml.Text.Trim(); break; } model.Width = new int?(Globals.SafeInt(this.txtWidth.Text, 0)); model.Height = new int?(Globals.SafeInt(this.txtHeight.Text, 0)); if (this.chkIsOne.Checked) { if (!PageValidate.IsNumber(this.txtTimeInterval.Text)) { MessageBox.ShowFailTip(this, "请输入正确的循环广告时间间隔!"); return; } model.IsOne = true; model.TimeInterval = new int?(Globals.SafeInt(this.txtTimeInterval.Text, 0)); } else { model.IsOne = false; } model.ShowType = new int?(Globals.SafeInt(selectedValue, -1)); model.AdvPositionName = this.txtAdvPositionName.Text.Trim(); model.CreatedDate = new DateTime?(DateTime.Now); model.CreatedUserID = new int?(base.CurrentUser.UserID); Maticsoft.BLL.Settings.AdvertisePosition position2 = new Maticsoft.BLL.Settings.AdvertisePosition(); int num = 0; if (selectedValue == "4") { num = position2.Add(model); Maticsoft.BLL.Settings.Advertisement advertisement = new Maticsoft.BLL.Settings.Advertisement(); Maticsoft.Model.Settings.Advertisement advertisement2 = new Maticsoft.Model.Settings.Advertisement { AdvertisementName = "自定义广告代码", ContentType = 3, AdvPositionId = new int?(num), CreatedDate = new DateTime?(DateTime.Now) }; advertisement.Add(advertisement2); } else { num = position2.Add(model); } if (num > 0) { MessageBox.ResponseScript(this, "parent.location.href='List.aspx'"); } else { MessageBox.ShowFailTip(this, "网络异常,请稍后再试"); } } }
public List<Maticsoft.Model.Settings.Advertisement> DataTableToList(DataTable dt) { List<Maticsoft.Model.Settings.Advertisement> list = new List<Maticsoft.Model.Settings.Advertisement>(); if (DataTableTools.DataTableIsNull(dt)) { return null; } int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Settings.Advertisement item = new Maticsoft.Model.Settings.Advertisement { Row = i + 1 }; if ((dt.Rows[i]["AdvertisementId"] != null) && (dt.Rows[i]["AdvertisementId"].ToString() != "")) { item.AdvertisementId = int.Parse(dt.Rows[i]["AdvertisementId"].ToString()); } if ((dt.Rows[i]["AdvertisementName"] != null) && (dt.Rows[i]["AdvertisementName"].ToString() != "")) { item.AdvertisementName = dt.Rows[i]["AdvertisementName"].ToString(); } if ((dt.Rows[i]["AdvPositionId"] != null) && (dt.Rows[i]["AdvPositionId"].ToString() != "")) { item.AdvPositionId = new int?(int.Parse(dt.Rows[i]["AdvPositionId"].ToString())); } if ((dt.Rows[i]["ContentType"] != null) && (dt.Rows[i]["ContentType"].ToString() != "")) { item.ContentType = new int?(int.Parse(dt.Rows[i]["ContentType"].ToString())); } if ((dt.Rows[i]["FileUrl"] != null) && (dt.Rows[i]["FileUrl"].ToString() != "")) { item.FileUrl = dt.Rows[i]["FileUrl"].ToString(); } if ((dt.Rows[i]["AlternateText"] != null) && (dt.Rows[i]["AlternateText"].ToString() != "")) { item.AlternateText = dt.Rows[i]["AlternateText"].ToString(); } if ((dt.Rows[i]["NavigateUrl"] != null) && (dt.Rows[i]["NavigateUrl"].ToString() != "")) { item.NavigateUrl = dt.Rows[i]["NavigateUrl"].ToString(); } if ((dt.Rows[i]["AdvHtml"] != null) && (dt.Rows[i]["AdvHtml"].ToString() != "")) { item.AdvHtml = dt.Rows[i]["AdvHtml"].ToString(); } if ((dt.Rows[i]["Impressions"] != null) && (dt.Rows[i]["Impressions"].ToString() != "")) { item.Impressions = new int?(int.Parse(dt.Rows[i]["Impressions"].ToString())); } if ((dt.Rows[i]["CreatedDate"] != null) && (dt.Rows[i]["CreatedDate"].ToString() != "")) { item.CreatedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CreatedDate"].ToString())); } if ((dt.Rows[i]["CreatedUserID"] != null) && (dt.Rows[i]["CreatedUserID"].ToString() != "")) { item.CreatedUserID = new int?(int.Parse(dt.Rows[i]["CreatedUserID"].ToString())); } if ((dt.Rows[i]["State"] != null) && (dt.Rows[i]["State"].ToString() != "")) { item.State = new int?(int.Parse(dt.Rows[i]["State"].ToString())); } if ((dt.Rows[i]["StartDate"] != null) && (dt.Rows[i]["StartDate"].ToString() != "")) { item.StartDate = new DateTime?(DateTime.Parse(dt.Rows[i]["StartDate"].ToString())); } if ((dt.Rows[i]["EndDate"] != null) && (dt.Rows[i]["EndDate"].ToString() != "")) { item.EndDate = new DateTime?(DateTime.Parse(dt.Rows[i]["EndDate"].ToString())); } if ((dt.Rows[i]["DayMaxPV"] != null) && (dt.Rows[i]["DayMaxPV"].ToString() != "")) { item.DayMaxPV = new int?(int.Parse(dt.Rows[i]["DayMaxPV"].ToString())); } if ((dt.Rows[i]["DayMaxIP"] != null) && (dt.Rows[i]["DayMaxIP"].ToString() != "")) { item.DayMaxIP = new int?(int.Parse(dt.Rows[i]["DayMaxIP"].ToString())); } if ((dt.Rows[i]["CPMPrice"] != null) && (dt.Rows[i]["CPMPrice"].ToString() != "")) { item.CPMPrice = new decimal?(decimal.Parse(dt.Rows[i]["CPMPrice"].ToString())); } if ((dt.Rows[i]["AutoStop"] != null) && (dt.Rows[i]["AutoStop"].ToString() != "")) { item.AutoStop = new int?(int.Parse(dt.Rows[i]["AutoStop"].ToString())); } if ((dt.Rows[i]["Sequence"] != null) && (dt.Rows[i]["Sequence"].ToString() != "")) { item.Sequence = new int?(int.Parse(dt.Rows[i]["Sequence"].ToString())); } if ((dt.Rows[i]["EnterpriseID"] != null) && (dt.Rows[i]["EnterpriseID"].ToString() != "")) { item.EnterpriseID = new int?(int.Parse(dt.Rows[i]["EnterpriseID"].ToString())); } list.Add(item); } } return list; }
protected void btnSave_Click(object sender, EventArgs e) { Maticsoft.Model.Settings.Advertisement model = new Maticsoft.Model.Settings.Advertisement { AdvPositionId = new int?(this.AdPositionID) }; if (string.IsNullOrWhiteSpace(this.txtAdvertisementName.Text)) { MessageBox.ShowFailTip(this, "广告名称不能为空!"); } else { model.AdvertisementName = this.txtAdvertisementName.Text; string s = string.Empty; if (this.rbTextContent.Checked) { s = "0"; } else if (this.rbImgContent.Checked) { s = "1"; } else if (this.rbFlashContent.Checked) { s = "2"; } else { s = "3"; } string oldValue = string.Format("/Upload/Temp/{0}", DateTime.Now.ToString("yyyyMMdd")); string newValue = string.Format("/Upload/AD/{0}", this.AdPositionID); ArrayList fileNameList = new ArrayList(); if (s.Equals("1")) { if (string.IsNullOrWhiteSpace(this.hfFileUrl.Value)) { MessageBox.ShowFailTip(this, "请选择要上传的图片!"); return; } string str4 = string.Format(this.hfFileUrl.Value, ""); fileNameList.Add(str4.Replace(oldValue, "")); model.FileUrl = str4.Replace(oldValue, newValue); } if (s.Equals("2")) { model.FileUrl = this.hfSwfUrl.Value; } if (s.Equals("3")) { if (string.IsNullOrWhiteSpace(this.txtAdvHtml.Text)) { MessageBox.ShowFailTip(this, "广告HTML代码不能为空!"); return; } model.AdvHtml = this.txtAdvHtml.Text; } model.ContentType = new int?(int.Parse(s)); model.AlternateText = this.txtAlternateText.Text; model.NavigateUrl = this.txtNavigateUrl.Text; if (!PageValidate.IsNumber(this.txtImpressions.Text)) { MessageBox.ShowFailTip(this, "显示频率格式不正确!"); } else { model.Impressions = new int?(int.Parse(this.txtImpressions.Text)); model.CreatedDate = new DateTime?(DateTime.Now); model.CreatedUserID = new int?(base.CurrentUser.UserID); if (this.chkIsValid.Checked) { model.State = 1; } else { model.State = 0; } if (!string.IsNullOrWhiteSpace(this.txtStartDate.Text)) { if (!PageValidate.IsDateTime(this.txtStartDate.Text)) { MessageBox.ShowFailTip(this, "请输入正确的开始时间!"); return; } model.StartDate = new DateTime?(DateTime.Parse(this.txtStartDate.Text)); } if (!string.IsNullOrWhiteSpace(this.txtEndDate.Text)) { if (!PageValidate.IsDateTime(this.txtEndDate.Text)) { MessageBox.ShowFailTip(this, "请输入正确的结束时间!"); return; } model.EndDate = new DateTime?(DateTime.Parse(this.txtEndDate.Text)); } if (!PageValidate.IsNumber(this.txtDayMaxPV.Text)) { MessageBox.ShowFailTip(this, "最大PV格式不正确!"); } else { model.DayMaxPV = new int?(int.Parse(this.txtDayMaxPV.Text)); if (!PageValidate.IsNumber(this.txtDayMaxIP.Text)) { MessageBox.ShowFailTip(this, "最大IP格式不正确!"); } else { model.DayMaxIP = new int?(int.Parse(this.txtDayMaxIP.Text)); if (string.IsNullOrWhiteSpace(this.txtCPMPrice.Text)) { MessageBox.ShowFailTip(this, "请输入正确的价格!"); } else { decimal result = 0M; if (!decimal.TryParse(this.txtCPMPrice.Text, out result)) { MessageBox.ShowFailTip(this, "价格格式不正确!"); } else { model.CPMPrice = new decimal?(result); if (this.rbAutoStop.Checked) { model.AutoStop = 1; } else if (this.rbNoStup.Checked) { model.AutoStop = 0; } else { model.AutoStop = -1; } model.Sequence = new int?(this.bll.GetMaxSequence()); string text = this.txtEnterpriseID.Text; Enterprise enterprise = new Enterprise(); if (!string.IsNullOrWhiteSpace(text)) { List<Enterprise> modelByEnterpriseName = enterprise.GetModelByEnterpriseName(text); if (modelByEnterpriseName.Count <= 0) { MessageBox.ShowFailTip(this, "没有找到相应商户,请重新输入!"); return; } model.EnterpriseID = new int?(modelByEnterpriseName[0].EnterpriseID); } else { model.EnterpriseID = -1; } if (this.bll.Add(model)) { string url = string.Format("SingleList.aspx?id={0}", this.AdPositionID); this.btnCancle.Enabled = false; this.btnSave.Enabled = false; if (!string.IsNullOrWhiteSpace(this.hfFileUrl.Value)) { FileManage.MoveFile(base.Server.MapPath(oldValue), base.Server.MapPath(newValue), fileNameList); } MessageBox.ShowSuccessTip(this, "保存成功", url); } else { MessageBox.ShowFailTip(this, "网络异常,请稍后再试!"); } } } } } } } }
public Maticsoft.Model.Settings.Advertisement GetModelByAdvPositionId(int AdvPositionId) { StringBuilder builder = new StringBuilder(); builder.Append("SELECT TOP 1 * FROM AD_Advertisement "); builder.Append(" WHERE AdvPositionId=@AdvPositionId AND State=1"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@AdvPositionId", SqlDbType.Int, 4) }; cmdParms[0].Value = AdvPositionId; Maticsoft.Model.Settings.Advertisement advertisement = new Maticsoft.Model.Settings.Advertisement(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["AdvertisementId"] != null) && (set.Tables[0].Rows[0]["AdvertisementId"].ToString() != "")) { advertisement.AdvertisementId = int.Parse(set.Tables[0].Rows[0]["AdvertisementId"].ToString()); } if ((set.Tables[0].Rows[0]["AdvertisementName"] != null) && (set.Tables[0].Rows[0]["AdvertisementName"].ToString() != "")) { advertisement.AdvertisementName = set.Tables[0].Rows[0]["AdvertisementName"].ToString(); } if ((set.Tables[0].Rows[0]["AdvPositionId"] != null) && (set.Tables[0].Rows[0]["AdvPositionId"].ToString() != "")) { advertisement.AdvPositionId = new int?(int.Parse(set.Tables[0].Rows[0]["AdvPositionId"].ToString())); } if ((set.Tables[0].Rows[0]["ContentType"] != null) && (set.Tables[0].Rows[0]["ContentType"].ToString() != "")) { advertisement.ContentType = new int?(int.Parse(set.Tables[0].Rows[0]["ContentType"].ToString())); } if ((set.Tables[0].Rows[0]["FileUrl"] != null) && (set.Tables[0].Rows[0]["FileUrl"].ToString() != "")) { advertisement.FileUrl = set.Tables[0].Rows[0]["FileUrl"].ToString(); } if ((set.Tables[0].Rows[0]["AlternateText"] != null) && (set.Tables[0].Rows[0]["AlternateText"].ToString() != "")) { advertisement.AlternateText = set.Tables[0].Rows[0]["AlternateText"].ToString(); } if ((set.Tables[0].Rows[0]["NavigateUrl"] != null) && (set.Tables[0].Rows[0]["NavigateUrl"].ToString() != "")) { advertisement.NavigateUrl = set.Tables[0].Rows[0]["NavigateUrl"].ToString(); } if ((set.Tables[0].Rows[0]["AdvHtml"] != null) && (set.Tables[0].Rows[0]["AdvHtml"].ToString() != "")) { advertisement.AdvHtml = set.Tables[0].Rows[0]["AdvHtml"].ToString(); } if ((set.Tables[0].Rows[0]["Impressions"] != null) && (set.Tables[0].Rows[0]["Impressions"].ToString() != "")) { advertisement.Impressions = new int?(int.Parse(set.Tables[0].Rows[0]["Impressions"].ToString())); } if ((set.Tables[0].Rows[0]["CreatedDate"] != null) && (set.Tables[0].Rows[0]["CreatedDate"].ToString() != "")) { advertisement.CreatedDate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["CreatedDate"].ToString())); } if ((set.Tables[0].Rows[0]["CreatedUserID"] != null) && (set.Tables[0].Rows[0]["CreatedUserID"].ToString() != "")) { advertisement.CreatedUserID = new int?(int.Parse(set.Tables[0].Rows[0]["CreatedUserID"].ToString())); } if ((set.Tables[0].Rows[0]["State"] != null) && (set.Tables[0].Rows[0]["State"].ToString() != "")) { advertisement.State = new int?(int.Parse(set.Tables[0].Rows[0]["State"].ToString())); } if ((set.Tables[0].Rows[0]["StartDate"] != null) && (set.Tables[0].Rows[0]["StartDate"].ToString() != "")) { advertisement.StartDate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["StartDate"].ToString())); } if ((set.Tables[0].Rows[0]["EndDate"] != null) && (set.Tables[0].Rows[0]["EndDate"].ToString() != "")) { advertisement.EndDate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["EndDate"].ToString())); } if ((set.Tables[0].Rows[0]["DayMaxPV"] != null) && (set.Tables[0].Rows[0]["DayMaxPV"].ToString() != "")) { advertisement.DayMaxPV = new int?(int.Parse(set.Tables[0].Rows[0]["DayMaxPV"].ToString())); } if ((set.Tables[0].Rows[0]["DayMaxIP"] != null) && (set.Tables[0].Rows[0]["DayMaxIP"].ToString() != "")) { advertisement.DayMaxIP = new int?(int.Parse(set.Tables[0].Rows[0]["DayMaxIP"].ToString())); } if ((set.Tables[0].Rows[0]["CPMPrice"] != null) && (set.Tables[0].Rows[0]["CPMPrice"].ToString() != "")) { advertisement.CPMPrice = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["CPMPrice"].ToString())); } if ((set.Tables[0].Rows[0]["AutoStop"] != null) && (set.Tables[0].Rows[0]["AutoStop"].ToString() != "")) { advertisement.AutoStop = new int?(int.Parse(set.Tables[0].Rows[0]["AutoStop"].ToString())); } if ((set.Tables[0].Rows[0]["Sequence"] != null) && (set.Tables[0].Rows[0]["Sequence"].ToString() != "")) { advertisement.Sequence = new int?(int.Parse(set.Tables[0].Rows[0]["Sequence"].ToString())); } if ((set.Tables[0].Rows[0]["EnterpriseID"] != null) && (set.Tables[0].Rows[0]["EnterpriseID"].ToString() != "")) { advertisement.EnterpriseID = new int?(int.Parse(set.Tables[0].Rows[0]["EnterpriseID"].ToString())); } return advertisement; }