/// <summary>
/// 更新静态文件内容
/// </summary>
/// <param name="html"></param>
/// <param name="adpage"></param>
/// <param name="info"></param>
/// <returns></returns>
private Tuple <string, string> ReplaceHtml(string html, string style, AdPageInfoVO adpage, ArticleInfoVO info, string stylefilename)
{
string nhtml = html;
StringBuilder sb = new StringBuilder();
sb.Append(style);
//随机插入部分样式
string rcss = Guid.NewGuid().ToString();
sb.AppendLine(string.Format(".{0}", rcss));
sb.Append("{color:red;padding:0px;}");
string nstyle = sb.ToString();
//替换CSS名称
var csslist = GetCssList();
foreach (var item in csslist)
{
nhtml.Replace(item.Key, item.Value);
nstyle.Replace(item.Key, item.Value);
}
Yahoo.Yui.Compressor.CssCompressor css = new Yahoo.Yui.Compressor.CssCompressor();
string nstylemin = css.Compress(nstyle);
nhtml = nhtml.Replace("$AdPagetId$", adpage.Id.ToString())
.Replace("$ArticleDetail$", DN.Framework.Utility.HtmlHelper.DecodeHtml(info.Content))
.Replace("$UserCode$", DN.Framework.Utility.HtmlHelper.DecodeHtml(adpage.StaticContent))
.Replace("$Title$", info.Title)
.Replace("$version$", DateTime.Now.ToString("yyyyMMddhhmmss"))
.Replace("href=\"style.css\"", string.Format("href=\"{0}\"", stylefilename));
return(new Tuple <string, string>(nhtml, nstylemin));
}
//生成中间页
private void CreateMiddPage(List <string> list, ArticleInfoVO ainfo, AdPageInfoVO adinfo)
{
string html = "";
string indexpath = HttpContext.Current.Server.MapPath(string.Format("{0}{1}", m_template, m_html_default));
using (StreamReader reader = new StreamReader(indexpath))
{
html = reader.ReadToEnd();
}
string jsscript = "var domains = ['$domains$']; var rdmain = \"\"; if (domains.length == 1){ rdmain = domains[0]; } else { rdmain = domains[Math.floor(Math.random() * domains.length)]; }document.location.href = \"http://\" + rdmain;";
jsscript = jsscript.Replace("$domains$", string.Join("','", list.ToArray()));
Yahoo.Yui.Compressor.JavaScriptCompressor js = new Yahoo.Yui.Compressor.JavaScriptCompressor();
string jstext = js.Compress(jsscript);
html = html.Replace("$script$", jstext)
.Replace("$adid$", adinfo.Id.ToString())
.Replace("$ArticleDetail$", DN.Framework.Utility.HtmlHelper.DecodeHtml(ainfo.Content));
string dir = HttpContext.Current.Server.MapPath(m_diction);
string nhtmlpath = Path.Combine(dir, "index.html");
using (StreamWriter write = new StreamWriter(nhtmlpath))
{
write.Write(html);
write.Flush();
write.Close();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
var info = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = int.Parse(hidAdId.Value)
});
string template = ddlTemplate.SelectedValue;
if (info != null)
{
int max = int.Parse(txtNum.Text);
for (int i = 0; i < max; i++)
{
AdPageInfoVO adinfo = (AdPageInfoVO)info.Clone();
adinfo.ViewPage = AdPageInfoBLL.Instance.GetPageName(template);
adinfo.CreateDate = DateTime.Now;
if (AdPageInfoBLL.Instance.CreateAdPage(adinfo.ViewPage, DN.WeiAd.Business.Config.AppConfig.TemplateName))
{
var result = AdPageInfoBLL.Instance.Add(adinfo);
sb.AppendFormat("{0}-{1},", adinfo.ViewPage, result);
sb.AppendLine();
}
}
ltTitle.Text = info.Title;
ltAdUrl.Text = AdPageInfoBLL.Instance.GetAdViewUrl(info.ViewPage);
}
lblMsg.Text = sb.ToString();
}
private string GetContent(AdPageInfoVO info)
{
string html = DN.Framework.Utility.HtmlHelper.DecodeHtml(info.Content);
if (!string.IsNullOrEmpty(info.QcodeImg))
{
var qcode = AdQcodeInfoBLL.Instance.GetRandQcode(info.Id);
string url = string.Empty;
if (qcode != null)
{
url = qcode.QcodeUrl;
}
if (!string.IsNullOrEmpty(url))
{
var list = info.QcodeImg.Split(',');
foreach (var item in list)
{
if (!string.IsNullOrEmpty(item))
{
html = html.Replace(item, url);
}
}
}
}
return(html);
}
/// <summary>
/// 生成中间页
/// </summary>
/// <param name="info"></param>
public string CreateMiddlePage(AdPageInfoVO info)
{
string pagename = Guid.NewGuid().ToString();
pagename = pagename.Substring(0, pagename.IndexOf("-"));
if (!string.IsNullOrEmpty(info.MiddlePage))
{
pagename = info.MiddlePage;
pagename = pagename.Replace("/Mp/", "").Replace(".html", "");
}
string html = GetMiddlePageTemplate();
html = ReplaceMiddlePageHtml(html, info);
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/"), "Mp", pagename + ".html");
using (StreamWriter writer = new StreamWriter(path, false))
{
writer.Write(html);
writer.Flush();
writer.Close();
}
return(string.Format("/Mp/{0}.html", pagename));
}
/// <summary>
/// 全局变量替换
/// </summary>
/// <param name="html"></param>
/// <returns></returns>
private string ReplaceAllStr(string html, AdPageInfoVO adinfo)
{
if (string.IsNullOrEmpty(html))
{
return("");
}
//设置微信分享信息
string wxtitle = string.Empty; //标题
string wxtitleimg = string.Empty; //标题图片
string wxtitlesort = string.Empty; //短标题
string wxname = string.Empty; //微信名称
string staticContent = string.Empty; //静态内容
string userCode = string.Empty; //统计代码
string id = "0";
if (adinfo != null)
{
wxtitle = adinfo.Title;
wxtitleimg = adinfo.TitleImg;
wxtitlesort = adinfo.TitleShort;
id = adinfo.Id.ToString();
wxname = adinfo.QcodeImg;
staticContent = DN.Framework.Utility.HtmlHelper.DecodeHtml(adinfo.StaticContent);
}
/*
* <meta name="sharecontent" data-msg-img="你的缩略图地址" data-msg-title="你的标题" data-msg-content="你的简介" data-msg-callBack="" data-line-img="你的缩略图地址" data-line-title="你的标题" data-line-callBack=""/>
* <meta name="sharecontent" data-msg-img="wxtitleimg" data-msg-title="wxtitle" data-msg-content="wxtitleshort" data-msg-callBack="" data-line-img="wxtitleimgshort" data-line-title="wxtitle" data-line-callBack=""/>
*/
var articleinfo = ArticleInfoBLL.Instance.GetRandModel();
string articlecontent = "";
if (articleinfo != null)
{
articlecontent = DN.Framework.Utility.HtmlHelper.DecodeHtml(articleinfo.Content);
}
string nhtml = html
.Replace("$Title$", wxtitle)
.Replace("$PageTitle$", "")
.Replace("$WxTitleImg$", wxtitleimg)
.Replace("$WxTitleShort$", wxtitlesort)
.Replace("$WxTitle$", wxtitle)
.Replace("$Title$", wxtitle)
.Replace("$AdInfoId$", id)
.Replace("version", DateTime.Now.ToString("HHmmss"))
.Replace("wxtitleimgshort", wxtitleimg)
.Replace("wxtitleshort", wxtitlesort)
.Replace("wxtitleimg", wxtitleimg)
.Replace("$QcodeUrl$", wxname)
.Replace("$StaticContent$", staticContent)
.Replace("$AdDomain$", Config.AppConfig.AdDomain)
.Replace("$ArticleDetail$", articlecontent);
return(nhtml);
}
/// <summary>
/// 删除相关广告
/// </summary>
/// <param name="adinfo"></param>
public void DeleteAd(AdPageInfoVO adinfo)
{
try
{
var ulist = AdUserPageBLL.Instance.GetModels(new AdUserPagePara()
{
AdPageId = adinfo.Id
});
string url = string.Empty;
string path = string.Empty;
foreach (var item in ulist)
{
//删除文件
url = AdPageInfoBLL.Instance.GetAdViewUrl(item.PageName);
path = HttpContext.Current.Server.MapPath(GetServerUrl(url));
if (!string.IsNullOrEmpty(path))
{
if (File.Exists(path))
{
File.Delete(path);
}
}
//删除数据，暂时不删除，等版本更新
}
//删除中间页
url = adinfo.MiddlePage;
path = HttpContext.Current.Server.MapPath(GetServerUrl(url));
if (!string.IsNullOrEmpty(path))
{
if (File.Exists(path))
{
File.Delete(path);
}
}
//删除广告页
url = AdPageInfoBLL.Instance.GetAdViewUrl(adinfo.ViewPage);
path = HttpContext.Current.Server.MapPath(GetServerUrl(url));
if (!string.IsNullOrEmpty(path))
{
if (File.Exists(path))
{
File.Delete(path);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
adinfo.IsDel = 1;
adinfo.DeleteDate = DateTime.Now;
AdPageInfoBLL.Instance.Edit(adinfo);
//删除数据，暂时不删除，等版本更新
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdPageInfoVO info = new AdPageInfoVO();
info.Title = txtTitle.Value;
info.UserId = int.Parse(ddlAdUserName.SelectedValue);
info.AdType = 0;
info.Content = hidContent.Value;
info.CreateDate = DateTime.Now;
info.LastDate = DateTime.Now;
info.Title = txtTitle.Value;
info.TitleImg = imgPerview.ImageUrl;
info.WeiXinUrl = txtWeiXinUrl.Value;
info.ViewPage = txtPage.Value;
info.Money = DbConvert.GetDecimal(txtMoney.Value, 0);
info.QcodeImg = txtQcodeImg.Text;
info.BuyMoney = 0;
info.MoneyCount = DbConvert.GetDecimal(txtMoneyCount.Value, 0);
int planip = 0;
if (!string.IsNullOrEmpty(txtPlanIp.Value))
{
planip = DbConvert.GetInt(txtPlanIp.Value);
}
info.PlanIp = planip;
info.PlanTerminal = 0;
info.StartTime = DateTime.Now;
info.UserCode = hidUserCode.Value;
info.TemplateName = ddlTemplate.SelectedValue;
info.CreateUserId = Account.UserId;
info.StaticContent = hidStaticContent.Value;
info.DeleteDate = DateTime.Now;
info.DefaultQcode = txtQcodeImg.Text;
info.QcodeImg2 = txtQcodeImg2.Text;
info.DefaultQcode2 = txtDefaultQcode2.Text;
info.DomainList = txtDomainList.Text;
info.TitleShort = txtTitleShort.Text;
int adid = AdPageInfoBLL.Instance.AddIdentity(info);
if (AdPageInfoBLL.Instance.CreateAdPage(info.ViewPage, ddlTemplate.SelectedValue, adid))
{
Response.Redirect("/Admin/Ads/AdPageList.aspx");
}
else
{
lblMsg.Text = "【广告页面】己经存在。";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdPageInfoVO info = new AdPageInfoVO();
info.AdType = int.Parse(ddlAdType.SelectedValue);
info.Title = txtTitle.Value;
//info.LinkUrl = txtLinkUrl.Value;
//info.DateEnd = DateTime.Now;
//info.DateStart = DateTime.Now;
//info.IsShow = chkIsShow.Checked ? 1 : 0;
info.UserId = Account.UserId;
//info.Desc = txtDesc.Value;
//info.ClickMoney = decimal.Parse(txtClickMoney.Value);
//info.LinkUrlBak = txtLinkUrlBak.Value;
AdPageInfoBLL.Instance.Add(info);
Response.Redirect("/Accounts/Ads/AdList.aspx");
}
/// <summary>
/// 通过广告获取平台名称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetNameByAdId(object id)
{
AdPageInfoVO info = AdPageInfoBLL.Instance.GetModelById(int.Parse(id.ToString()));
if (info == null)
{
info = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = int.Parse(id.ToString())
});
}
if (info != null)
{
return(GetNameById(info.SiteTypeId));
}
return(id.ToString());
}
/// <summary>
/// 重新生成页面
/// </summary>
/// <param name="pageName"></param>
/// <param name="templname"></param>
/// <returns></returns>
public bool ChangeAdPage(string pageName, string templname)
{
if (string.IsNullOrEmpty(pageName))
{
return(false);
}
AdPageInfoVO adinfo = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
ViewPage = pageName
});
if (adinfo == null)
{
var userpaget = AdUserPageBLL.Instance.GetSingle(new AdUserPagePara()
{
PageName = pageName
});
if (userpaget != null)
{
adinfo = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = userpaget.AdPageId
});
}
}
string html = GetTemplateFile(templname);
string turl = string.Format("/Article/{0}", pageName);
string filePath = HttpContext.Current.Server.MapPath(turl);
using (StreamWriter write = new StreamWriter(filePath))
{
html = ReplaceAllStr(html, adinfo);
write.WriteLine(html);
write.Flush();
write.Close();
}
return(true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdPageInfoVO info = new AdPageInfoVO();
info.Title = txtTitle.Text;
info.UserId = Account.UserId;
info.AdType = 0;
info.Content = hidContent.Value;
info.CreateDate = DateTime.Now;
info.LastDate = DateTime.Now;
info.WeiXinUrl = txtWeiXinUrl.Value;
info.ViewPage = txtPage.Value;
info.QcodeImg = txtQcode.Text;
info.TitleImg = imgPerview.ImageUrl;
info.TitleShort = txtTitleShort.Text;
info.UserCode = hidUserCode.Value;
info.StartTime = DateTime.Now;
info.TemplateName = ddlTemplate.SelectedValue;
info.CreateUserId = Account.UserId;
info.TemplateName = ddlTemplate.SelectedValue;
info.StaticContent = hidStaticContent.Value;
info.DefaultQcode = txtDefaultQcode.Text;
info.Desc = txtDesc.Text;
info.SiteTypeId = int.Parse(ddlSiteType.SelectedValue);
info.PlatformType = ddlPlatformType.SelectedValue;
info.UserAdTypeId = int.Parse(ddlUserAdTypeId.SelectedValue);
info.AdTimeEnd = txtAdTimeEnd.Value;
info.AdTimeStart = txtAdTimeStart.Value;
info.DeleteDate = DateTime.Now;
info.QcodeImg2 = txtWeiXinName.Text;
info.DefaultQcode2 = txtDefaultWeiXinName.Text;
info.DomainList = txtDomainList.Text;
int adid = AdPageInfoBLL.Instance.AddIdentity(info);
AdPageInfoBLL.Instance.CreateAdPage(info.ViewPage, ddlTemplate.SelectedValue, adid);
AdPageInfoBLL.Instance.Refresh();
Response.Redirect("/Accounts/Pages/AdPageList.aspx");
}
private string ReplaceMiddlePageHtml(string html, AdPageInfoVO info)
{
//有效域名
DomainInfoPara dp = new DomainInfoPara();
dp.IsAuth = 1;
dp.IsState = 0;
var list = DomainInfoBLL.Instance.GetModels(dp);
StringBuilder sbDomain = new StringBuilder();
foreach (var item in list)
{
sbDomain.AppendFormat("\"{0}\",", item.Domain);
}
if (sbDomain.Length != 0)
{
sbDomain = sbDomain.Remove(sbDomain.Length - 1, 1);
}
//有效页面
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = info.Id;
var plist = AdUserPageBLL.Instance.GetModels(aup);
StringBuilder sbPage = new StringBuilder();
foreach (var item in plist)
{
sbPage.AppendFormat("\"{0}\",", item.PageName);
}
sbPage.AppendFormat("\"{0}\"", info.ViewPage);
html = html
.Replace("$domains$", sbDomain.ToString())
.Replace("$pages$", sbPage.ToString());
return(html);
}
/// <summary>
/// 采集微信文章
/// </summary>
/// <param name="wxurl"></param>
public AdPageInfoVO GetWeiXin(string wxurl)
{
AdPageInfoVO info = new AdPageInfoVO();
info.CreateDate = DateTime.Now;
info.WeiXinUrl = wxurl;
string html = DN.Framework.Utility.WebClientHelper.GetSend(wxurl, "utf-8", "utf-8");
if (!string.IsNullOrEmpty(html))
{
html = html.Replace("section", "div");
}
HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(html);
var node = doc.DocumentNode.SelectNodes("//*[@id='activity-name']");
if (node != null && node.Count == 1)
{
Console.WriteLine(node[0].InnerText);
info.Title = node[0].InnerText;
}
string chtml = "";
var content = doc.DocumentNode.SelectNodes("//*[@id='js_content']");
if (content != null && content.Count == 1)
{
chtml = content[0].InnerHtml;
Console.WriteLine(content[0].InnerHtml);
}
info.Content = DownloadHtml(chtml);
info.LastDate = DateTime.Now;
info.QcodeImg = "";
info.TitleImg = "";
return(info);
}
private string GetContent(AdPageInfoVO info, HttpContext context)
{
string curl = context.Request.Params["_curl"] ?? "";
string html = DN.Framework.Utility.HtmlHelper.DecodeHtml(info.Content);
LogAdQcodeVO log = new LogAdQcodeVO();
log.AdId = info.Id;
log.AdUserId = info.UserId;
log.BrowseName = DN.Framework.Utility.ClientHelper.GetBrowseName();
log.BrowseType = DN.Framework.Utility.ClientHelper.GetUserAgent();
log.BrowseVersion = DN.Framework.Utility.ClientHelper.GetBrowseVersion();
log.ClientId = GetClentId(context.Request, context.Response);
log.ClientIp = DN.Framework.Utility.ClientHelper.ClientIP();
log.CreateDate = DateTime.Now;
log.IsMobile = DN.Framework.Utility.ClientHelper.GetIsMobileDevice() ? 1 : 0;
log.OsName = DN.Framework.Utility.ClientHelper.GetOsName();
log.QcodeId = 0;
log.ReferrerUrl = DN.Framework.Utility.ClientHelper.GetReferer();
log.Time = int.Parse(DateTime.Now.ToString("yyyyMMdd"));
log.Url = curl;
//获取统计代码
if (!string.IsNullOrEmpty(info.UserCode))
{
html = html + DN.Framework.Utility.HtmlHelper.DecodeHtml(info.UserCode);
}
//配置的二维码信息
if (!string.IsNullOrEmpty(info.QcodeImg))
{
var qcode = AdQcodeInfoBLL.Instance.GetRandQcode(info.Id);
if (qcode != null)
{
log.QcodeId = qcode.Id;
string url = qcode.QcodeUrl;
if (!string.IsNullOrEmpty(url))
{
var list = info.QcodeImg.Split(',');
foreach (var item in list)
{
if (!string.IsNullOrEmpty(item))
{
html = html.Replace(item, url);
}
}
html = html.Replace("$QcodeUrl$", url); //替换微信相关内容
}
}
else
{
if (!string.IsNullOrEmpty(info.DefaultQcode))
{
var list = info.QcodeImg.Split(',');
foreach (var item in list)
{
if (!string.IsNullOrEmpty(item))
{
html = html.Replace(item, info.DefaultQcode);
}
}
}
}
}
//如果没有配置相关内容，替换相关内容
html = html.Replace("$QcodeUrl$", "");
try
{
if (DN.WeiAd.Business.Config.AppConfig.IsLogBrowse == 0)
{
LogAdQcodeBLL.Instance.Add(log);
}
else
{
ErrorBLL.Add <LogAdQcodeVO>(log);
}
}
catch (Exception ex)
{
ErrorBLL.Add <LogAdQcodeVO>(ex, log);
DN.Framework.Utility.LogHelper.Write(ex.Message, "errorqcode");
}
return(html);
}
public override string GetOrderByModel(AdPageInfoVO m)
{
return("");
}
public override string GetOtherConditionByModel(AdPageInfoVO m)
{
return("");
}
/// <summary>
/// 创建
/// </summary>
/// <param name="info"></param>
/// <returns>adurl</returns>
public string CreateJSFile(AdPageInfoVO info)
{
string jshtml = GetJsTemplate();
StringBuilder sbJsCon = new StringBuilder();
sbJsCon.Append(DN.Framework.Utility.HtmlHelper.DecodeHtml(info.Content));
sbJsCon.AppendFormat("<div style='display:none'>{0}</div>", DN.Framework.Utility.HtmlHelper.DecodeHtml(info.UserCode));
string jscon = sbJsCon.ToString();
var qlist = AdQcodeInfoBLL.Instance.GetModels(new AdQcodeInfoPara()
{
AdId = info.Id
});
StringBuilder sbQlist = new StringBuilder();
foreach (var item in qlist)
{
sbQlist.AppendFormat("'{0}',", item.QcodeUrl);
}
if (sbQlist.Length >= 2)
{
sbQlist = sbQlist.Remove(sbQlist.Length - 1, 1);
}
jscon = Microsoft.JScript.GlobalObject.escape(jscon);
jshtml = jshtml
.Replace("$Content$", jscon)
.Replace("$weixinlist$", sbQlist.ToString())
.Replace("$QcodeImg$", info.QcodeImg)
.Replace("$DefaultQcodeImg$", info.DefaultQcode);
//写入JS文件
string jspath = Path.Combine(HttpContext.Current.Server.MapPath("~"), "Files", "cm_" + info.Id.ToString() + ".js");
using (StreamWriter writer = new StreamWriter(jspath))
{
writer.Write(jshtml);
writer.Flush();
writer.Close();
}
string html = GetHtmlTemplate();
string adpagename = "detail_" + info.Id.ToString() + ".html";
string path = Path.Combine(HttpContext.Current.Server.MapPath("~"), "Files", adpagename);
string adurl = string.Format("/Files/{0}", adpagename);
var articleinfo = ArticleInfoBLL.Instance.GetRandModel();
string articlecontent = "";
if (articleinfo != null)
{
articlecontent = DN.Framework.Utility.HtmlHelper.DecodeHtml(articleinfo.Content);
}
html = html.Replace("$UserCode$", DN.Framework.Utility.HtmlHelper.DecodeHtml(info.StaticContent))
.Replace("$JsFile$", "")
.Replace("$Title$", info.Title)
.Replace("$AdPagetId$", info.Id.ToString())
.Replace("$version$", DateTime.Now.ToString("hhmmss"))
.Replace("$viewpage$", "cm_" + info.Id.ToString())
.Replace("$ArticleDetail$", articlecontent);
//写入HTML
using (StreamWriter writer = new StreamWriter(path))
{
writer.Write(html);
writer.Flush();
writer.Close();
}
//读取图片，转换成base64位
//var list = GetPadSrcImg(jscon);
//foreach (var item in list)
//{
// string imgurl = item;
// if (imgurl.StartsWith("/"))
// {
// string imgpath = HttpContext.Current.Server.MapPath(imgurl);
// //string bimg = DN.WeiAd.Framework.ImageHelper.ImgToBase64String(imgpath, true);
// string bimg = DN.WeiAd.Framework.ImageHelper.encodingforfile(imgpath);
// jscon = jscon.Replace(item, bimg);
// }
//}
return(adurl);
}
public override bool Edit(AdPageInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@WeiXinUrl", Value = ParameterHelper.ConvertValue(m.WeiXinUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Title", Value = ParameterHelper.ConvertValue(m.Title)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TitleImg", Value = ParameterHelper.ConvertValue(m.TitleImg)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeImg", Value = ParameterHelper.ConvertValue(m.QcodeImg)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Content", Value = ParameterHelper.ConvertValue(m.Content)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdType", Value = ParameterHelper.ConvertValue(m.AdType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ViewPage", Value = ParameterHelper.ConvertValue(m.ViewPage)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCodeId", Value = ParameterHelper.ConvertValue(m.UserCodeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCodeIds", Value = ParameterHelper.ConvertValue(m.UserCodeIds)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SaleType", Value = ParameterHelper.ConvertValue(m.SaleType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlanIp", Value = ParameterHelper.ConvertValue(m.PlanIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@StartTime", Value = ParameterHelper.ConvertValue(m.StartTime)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlanTerminal", Value = ParameterHelper.ConvertValue(m.PlanTerminal)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MoneyCount", Value = ParameterHelper.ConvertValue(m.MoneyCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BuyMoney", Value = ParameterHelper.ConvertValue(m.BuyMoney)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OrderIndex", Value = ParameterHelper.ConvertValue(m.OrderIndex)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCode", Value = ParameterHelper.ConvertValue(m.UserCode)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TitleShort", Value = ParameterHelper.ConvertValue(m.TitleShort)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BuyIp", Value = ParameterHelper.ConvertValue(m.BuyIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TemplateName", Value = ParameterHelper.ConvertValue(m.TemplateName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDel", Value = ParameterHelper.ConvertValue(m.IsDel)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsAuth", Value = ParameterHelper.ConvertValue(m.IsAuth)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@StaticContent", Value = ParameterHelper.ConvertValue(m.StaticContent)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MiddlePage", Value = ParameterHelper.ConvertValue(m.MiddlePage)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdTimeStart", Value = ParameterHelper.ConvertValue(m.AdTimeStart)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdTimeEnd", Value = ParameterHelper.ConvertValue(m.AdTimeEnd)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserAdTypeId", Value = ParameterHelper.ConvertValue(m.UserAdTypeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SiteTypeId", Value = ParameterHelper.ConvertValue(m.SiteTypeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlatformType", Value = ParameterHelper.ConvertValue(m.PlatformType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DeleteDate", Value = ParameterHelper.ConvertValue(m.DeleteDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DefaultQcode", Value = ParameterHelper.ConvertValue(m.DefaultQcode)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeCount", Value = ParameterHelper.ConvertValue(m.QcodeCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageCount", Value = ParameterHelper.ConvertValue(m.PageCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeImg2", Value = ParameterHelper.ConvertValue(m.QcodeImg2)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DefaultQcode2", Value = ParameterHelper.ConvertValue(m.DefaultQcode2)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DomainList", Value = ParameterHelper.ConvertValue(m.DomainList)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(AdPageInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@WeiXinUrl", Value = ParameterHelper.ConvertValue(m.WeiXinUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Title", Value = ParameterHelper.ConvertValue(m.Title)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TitleImg", Value = ParameterHelper.ConvertValue(m.TitleImg)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeImg", Value = ParameterHelper.ConvertValue(m.QcodeImg)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Content", Value = ParameterHelper.ConvertValue(m.Content)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdType", Value = ParameterHelper.ConvertValue(m.AdType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ViewPage", Value = ParameterHelper.ConvertValue(m.ViewPage)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCodeId", Value = ParameterHelper.ConvertValue(m.UserCodeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCodeIds", Value = ParameterHelper.ConvertValue(m.UserCodeIds)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SaleType", Value = ParameterHelper.ConvertValue(m.SaleType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlanIp", Value = ParameterHelper.ConvertValue(m.PlanIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@StartTime", Value = ParameterHelper.ConvertValue(m.StartTime)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlanTerminal", Value = ParameterHelper.ConvertValue(m.PlanTerminal)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MoneyCount", Value = ParameterHelper.ConvertValue(m.MoneyCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BuyMoney", Value = ParameterHelper.ConvertValue(m.BuyMoney)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OrderIndex", Value = ParameterHelper.ConvertValue(m.OrderIndex)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserCode", Value = ParameterHelper.ConvertValue(m.UserCode)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TitleShort", Value = ParameterHelper.ConvertValue(m.TitleShort)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BuyIp", Value = ParameterHelper.ConvertValue(m.BuyIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TemplateName", Value = ParameterHelper.ConvertValue(m.TemplateName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDel", Value = ParameterHelper.ConvertValue(m.IsDel)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsAuth", Value = ParameterHelper.ConvertValue(m.IsAuth)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@StaticContent", Value = ParameterHelper.ConvertValue(m.StaticContent)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MiddlePage", Value = ParameterHelper.ConvertValue(m.MiddlePage)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdTimeStart", Value = ParameterHelper.ConvertValue(m.AdTimeStart)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdTimeEnd", Value = ParameterHelper.ConvertValue(m.AdTimeEnd)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserAdTypeId", Value = ParameterHelper.ConvertValue(m.UserAdTypeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SiteTypeId", Value = ParameterHelper.ConvertValue(m.SiteTypeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlatformType", Value = ParameterHelper.ConvertValue(m.PlatformType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DeleteDate", Value = ParameterHelper.ConvertValue(m.DeleteDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DefaultQcode", Value = ParameterHelper.ConvertValue(m.DefaultQcode)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeCount", Value = ParameterHelper.ConvertValue(m.QcodeCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageCount", Value = ParameterHelper.ConvertValue(m.PageCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeImg2", Value = ParameterHelper.ConvertValue(m.QcodeImg2)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DefaultQcode2", Value = ParameterHelper.ConvertValue(m.DefaultQcode2)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DomainList", Value = ParameterHelper.ConvertValue(m.DomainList)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
