/// <summary>
/// 添加
/// </summary>
/// <param name="minfo"></param>
private void AddAd(AdMsgInfo minfo)
{
try
{
//写入数据库
AdMsg admsg = new AdMsg();
if (Request.QueryString["action"] == "edit")//修改
{
CreatJs.CreatepicFile(minfo);
minfo.id = int.Parse(Request.QueryString["id"].ToString());
admsg.UpdateAd(minfo);
}
else
{
//添加
admsg.AddAd(minfo);
int id = admsg.AdMaxid();
//生成JS
string getpath = CreatJs.CreatepicFile(minfo);
//完成操作
admsg.AdUpdateJs(id, getpath);
}
Response.Write("完成");
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void BindDataAd()
{
AdMsg admsg = new AdMsg();
AdMsgInfo minfo = admsg.GetModelAd(int.Parse(_adid));
if (minfo != null)
{
txtAd.Text = "<script src=\"" + minfo.adjs.ToString() + "\"></script>";
}
}
protected void btnAddAd_Click(object sender, EventArgs e)
{
AdMsgInfo minfo = new AdMsgInfo();
minfo.sid = int.Parse(ddSort.SelectedValue.ToString());
minfo.adname = txtTitle.Text;
minfo.adpic = txtPic.Text;
minfo.adtype = int.Parse(radType.SelectedValue.ToString());
minfo.adurl = txtUrl.Text;
minfo.adwidth = int.Parse(txtWidth.Text.ToString());
minfo.adheight = int.Parse(txtHeight.Text.ToString());
minfo.adstop = 0;
minfo.adendtime = DateTime.Parse(DateTime.Now.ToString());
minfo.adcount = 1;
minfo.adjs = hiddJs.Value.ToString();
AddAd(minfo);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="minfo"></param>
public void UpdateAd(AdMsgInfo minfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ROYcms_Ad_Msg set ");
strSql.Append("sid=@sid,");
strSql.Append("adname=@adname,");
strSql.Append("adpic=@adpic,");
strSql.Append("adurl=@adurl,");
strSql.Append("adtype=@adtype,");
strSql.Append("adstop=@adstop,");
strSql.Append("adwidth=@adwidth,");
strSql.Append("adheight=@adheight,");
strSql.Append("adendtime=@adendtime,");
strSql.Append("adjs=@adjs");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@sid", SqlDbType.Int, 4),
new SqlParameter("@adname", SqlDbType.VarChar, 50),
new SqlParameter("@adpic", SqlDbType.VarChar, 300),
new SqlParameter("@adurl", SqlDbType.VarChar, 300),
new SqlParameter("@adtype", SqlDbType.Int, 4),
new SqlParameter("@adstop", SqlDbType.Int, 4),
new SqlParameter("@adwidth", SqlDbType.Int, 4),
new SqlParameter("@adheight", SqlDbType.Int, 4),
new SqlParameter("@adendtime", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@adjs", SqlDbType.VarChar, 200)
};
parameters[0].Value = minfo.sid;
parameters[1].Value = minfo.adname;
parameters[2].Value = minfo.adpic;
parameters[3].Value = minfo.adurl;
parameters[4].Value = minfo.adtype;
parameters[5].Value = minfo.adstop;
parameters[6].Value = minfo.adwidth;
parameters[7].Value = minfo.adheight;
parameters[8].Value = minfo.adendtime;
parameters[9].Value = minfo.id;
parameters[10].Value = minfo.adjs;
SqlHelper.ExecuteNonQuery(SqlHelper.Conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddAd(AdMsgInfo minfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ROYcms_Ad_Msg(");
strSql.Append("sid,adname,adpic,adurl,adtype,adstop,adwidth,adheight,adendtime,adcount,adjs)");
strSql.Append(" values (");
strSql.Append("@sid,@adname,@adpic,@adurl,@adtype,@adstop,@adwidth,@adheight,@adendtime,@adcount,@adjs)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@sid", SqlDbType.Int, 4),
new SqlParameter("@adname", SqlDbType.VarChar, 50),
new SqlParameter("@adpic", SqlDbType.VarChar, 300),
new SqlParameter("@adurl", SqlDbType.VarChar, 300),
new SqlParameter("@adtype", SqlDbType.Int, 4),
new SqlParameter("@adstop", SqlDbType.Int, 4),
new SqlParameter("@adwidth", SqlDbType.Int, 4),
new SqlParameter("@adheight", SqlDbType.Int, 4),
new SqlParameter("@adendtime", SqlDbType.DateTime),
new SqlParameter("@adcount", SqlDbType.Int, 4),
new SqlParameter("@adjs", SqlDbType.VarChar, 200)
};
parameters[0].Value = minfo.sid;
parameters[1].Value = minfo.adname;
parameters[2].Value = minfo.adpic;
parameters[3].Value = minfo.adurl;
parameters[4].Value = minfo.adtype;
parameters[5].Value = minfo.adstop;
parameters[6].Value = minfo.adwidth;
parameters[7].Value = minfo.adheight;
parameters[8].Value = minfo.adendtime;
parameters[9].Value = minfo.adcount;
parameters[10].Value = minfo.adjs;
return(SqlHelper.ExecuteNonQuery(SqlHelper.Conn, CommandType.Text, strSql.ToString(), parameters));
}
private void BindDataEdit()
{
AdMsg admsg = new AdMsg();
AdMsgInfo minfo = admsg.GetModelAd(int.Parse(Request.QueryString["id"].ToString()));
if (minfo != null)
{
BindDataSort(minfo.sid.ToString());
txtTitle.Text = minfo.adname;
txtPic.Text = minfo.adpic;
txtUrl.Text = minfo.adurl;
txtWidth.Text = minfo.adwidth.ToString();
txtHeight.Text = minfo.adheight.ToString();
hiddJs.Value = minfo.adjs;
//绑定所属类型
try
{
radType.Items.FindByValue(minfo.adtype.ToString()).Selected = true;
}
catch
{
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AdMsgInfo GetModelAd(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,sid,adname,adpic,adurl,adtype,adstop,adwidth,adheight,adcreattime,adendtime,adcount,adjs from ROYcms_Ad_Msg ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
AdMsgInfo ainfo = new AdMsgInfo();
using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.Conn, CommandType.Text, strSql.ToString(), parameters))
{
if (sdr.Read())
{
if (sdr["id"].ToString() != "")
{
ainfo.id = int.Parse(sdr["id"].ToString());
}
if (sdr["sid"].ToString() != "")
{
ainfo.sid = int.Parse(sdr["sid"].ToString());
}
ainfo.adname = sdr["adname"].ToString();
ainfo.adpic = sdr["adpic"].ToString();
ainfo.adurl = sdr["adurl"].ToString();
if (sdr["adtype"].ToString() != "")
{
ainfo.adtype = int.Parse(sdr["adtype"].ToString());
}
if (sdr["adstop"].ToString() != "")
{
ainfo.adstop = int.Parse(sdr["adstop"].ToString());
}
if (sdr["adwidth"].ToString() != "")
{
ainfo.adwidth = int.Parse(sdr["adwidth"].ToString());
}
if (sdr["adheight"].ToString() != "")
{
ainfo.adheight = int.Parse(sdr["adheight"].ToString());
}
if (sdr["adcreattime"].ToString() != "")
{
ainfo.adcreattime = DateTime.Parse(sdr["adcreattime"].ToString());
}
if (sdr["adendtime"].ToString() != "")
{
ainfo.adendtime = DateTime.Parse(sdr["adendtime"].ToString());
}
if (sdr["adcount"].ToString() != "")
{
ainfo.adcount = int.Parse(sdr["adcount"].ToString());
}
ainfo.adjs = sdr["adjs"].ToString();
}
else
{
ainfo = null;
}
}
return(ainfo);
}
/// <summary>
/// 生成广告js
/// </summary>
/// <param name="type">文件类型，0图片，1FLASH</param>
/// <returns></returns>
public static string CreatepicFile(AdMsgInfo minfo)
{
//判断是否有当前路径如果有添，如果没有新建目录
string pathtemp = "/" + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/";
string path = HttpContext.Current.Server.MapPath("~" + pathtemp);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string filename = DateTime.Now.ToString("yyyy-MM-dd-hh-mm-ss") + ".js";
Encoding code = Encoding.GetEncoding("utf-8");
// 读取模板文件
StringBuilder str = new StringBuilder();
if (minfo.adtype == 0)
{
str.Append("document.write('");
str.Append("<a href=\"" + minfo.adurl.ToString() + "\" target=\"_blank\">");
str.Append("<img src=\"" + minfo.adpic.ToString() + "\" border=0 width=\"" + minfo.adwidth.ToString() + "\" height=\"" + minfo.adheight.ToString() + "\" alt=\"" + minfo.adname.ToString() + "\" align=top>");
str.Append("</a>');");
}
else
{
str.Append("document.write('<EMBED src=\"" + minfo.adpic.ToString() + "\" quality=high WIDTH=\"" + minfo.adwidth.ToString() + "\" HEIGHT=\"" + minfo.adheight.ToString() + "\" TYPE=\"application/x-shockwave-flash\" PLUGINSPAGE=\"http://www.macromedia.com/go/getflashplayer\"></EMBED>');");
}
StreamWriter sw = null;
// 写文件
if (minfo.adjs.ToString().Length > 0)
{
try
{
sw = new StreamWriter(HttpContext.Current.Server.MapPath("~" + minfo.adjs.ToString()), false, code);
sw.Write(str);
sw.Flush();
return(minfo.adjs.ToString());
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
return("");
}
finally
{
sw.Close();
}
}
else
{
try
{
sw = new StreamWriter(path + filename, false, code);
sw.Write(str);
sw.Flush();
return(pathtemp + filename);
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
return("");
}
finally
{
sw.Close();
}
}
//return "";
}
