protected void Page_Load(object sender, EventArgs e)
{
if (!sys.IsRunning)
{
Response.Write("站点维护中，请稍后访问");
Response.End();
return;
}
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
sys.beiAnHao = modelcycms.dbo_BeiAnHao;
string pathName = sys.RequestPathName();
DataTable sdr = bllspeciality.GetList("dbo_htmlDir='" + pathName + "'").Tables[0];
if (sdr.Rows.Count > 0)
{
articleTitle = Page.Title = sdr.Rows[0]["dbo_name"].ToString();
PageContent = sdr.Rows[0]["dbo_contenthtml"].ToString();
nowposition = sdr.Rows[0]["dbo_name"].ToString();
linknowposition = sys.AppPath + sdr.Rows[0]["dbo_htmlDir"].ToString() + "/";
fillImg(Convert.ToInt32(sdr.Rows[0]["id"]));
filltype(Convert.ToInt32(sdr.Rows[0]["id"]));
}
}
protected void Page_Load(object sender, EventArgs e)
{
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
sys.beiAnHao = modelcycms.dbo_BeiAnHao;
string htmlName = sys.RequestFileName();
DataTable sdr = bllhtmlpage.GetList("dbo_htmlName='" + htmlName + "'").Tables[0];
if (sdr.Rows.Count > 0)
{
articleTitle = Page.Title = sdr.Rows[0]["dbo_pagetitle"].ToString();
PageContent = sdr.Rows[0]["dbo_PageContent"].ToString();
nowposition = sdr.Rows[0]["dbo_pagetitle"].ToString();
linknowposition = sys.AppPath + sdr.Rows[0]["dbo_pagepath"].ToString().Substring(1) + sdr.Rows[0]["dbo_htmlName"].ToString() + ".aspx";
fillImg(Convert.ToInt32(sdr.Rows[0]["dbo_SpcId"]));
filltype(Convert.ToInt32(sdr.Rows[0]["dbo_SpcId"]));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (currentAdmin.strPower != "super")
{
Response.Write("您无权访问该页，错误原因：1.登陆超时；2.非法进入；3.权限不足。请登陆后访问<a href='login.aspx' target='_parent'>登陆</a>");
Response.End();
}
if (!Page.IsPostBack)
{
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
sys.beiAnHao = modelcycms.dbo_BeiAnHao;
this.chkSysIsRun.Checked = sys.IsRunning;
this.rbtnIsStatic.SelectedIndex = sys.IsStatic ? 0 : 1;
this.txtWebAddress.Text = sys.webAddress;
this.txtWebName.Text = sys.webName;
this.txtLianXiRen.Text = sys.lianXiren;
this.txtCellPhone.Text = sys.cellPhone;
this.txtFlax.Text = sys.flax;
this.txtWorkPlace.Text = sys.workPlace;
this.txtWorkPhone.Text = sys.workPhone;
this.txtBeiAnHao.Text = sys.beiAnHao;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.Cycms model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_Cycms(");
strSql.Append("dbo_IsRunning,dbo_IsStatic,dbo_WebAddress,dbo_WebName,dbo_StaticListPages,dbo_VisitedTimes,dbo_SmtpServer,dbo_MailAddress,dbo_MailName,dbo_MailPwd,dbo_WorkPlace,dbo_LianXiRen,dbo_CellPhone,dbo_Flax,dbo_WorkPohne,dbo_BeiAnHao)");
strSql.Append(" values (");
strSql.Append("@dbo_IsRunning,@dbo_IsStatic,@dbo_WebAddress,@dbo_WebName,@dbo_StaticListPages,@dbo_VisitedTimes,@dbo_SmtpServer,@dbo_MailAddress,@dbo_MailName,@dbo_MailPwd,@dbo_WorkPlace,@dbo_LianXiRen,@dbo_CellPhone,@dbo_Flax,@dbo_WorkPohne,@dbo_BeiAnHao)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_IsRunning", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_IsStatic", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_WebAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WebName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_StaticListPages", OleDbType.Integer, 4),
new OleDbParameter("@dbo_VisitedTimes", OleDbType.Integer, 4),
new OleDbParameter("@dbo_SmtpServer", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailPwd", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WorkPlace", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_LianXiRen", OleDbType.VarChar, 10),
new OleDbParameter("@dbo_CellPhone", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_Flax", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_WorkPohne", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_BeiAnHao", OleDbType.VarChar, 100)
};
parameters[0].Value = model.dbo_IsRunning;
parameters[1].Value = model.dbo_IsStatic;
parameters[2].Value = model.dbo_WebAddress;
parameters[3].Value = model.dbo_WebName;
parameters[4].Value = model.dbo_StaticListPages;
parameters[5].Value = model.dbo_VisitedTimes;
parameters[6].Value = model.dbo_SmtpServer;
parameters[7].Value = model.dbo_MailAddress;
parameters[8].Value = model.dbo_MailName;
parameters[9].Value = model.dbo_MailPwd;
parameters[10].Value = model.dbo_WorkPlace;
parameters[11].Value = model.dbo_LianXiRen;
parameters[12].Value = model.dbo_CellPhone;
parameters[13].Value = model.dbo_Flax;
parameters[14].Value = model.dbo_WorkPohne;
parameters[15].Value = model.dbo_BeiAnHao;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void fillguestBooktype(string Gtypeid)
{
if (Gtypeid != null)
{
}
else
{
nowposition = "我要咨询";
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
this.txtmailAddress.Text = sys.mailAddress;
this.txtsmtpServer.Text = sys.smtpServer;
this.txtmailName.Text = sys.mailName;
this.txtmailPwd.Text = sys.mailPwd;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
modelguestbook = bllguestbook.GetModel(Convert.ToInt32(id));
modelguestbook.dbo_IsReply = true;
modelguestbook.dbo_ReplyContent = this.txtReplyContent.Text;
modelguestbook.dbo_ReplyTime = DateTime.Now;
modelguestbook.dbo_IsShow = this.rbtnIsShow.Items[0].Selected;
bllguestbook.Update(modelguestbook);
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "alert('回复成功！');window.location.href='guestbooklist.aspx'", true);
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
string name = this.litName.Text;
string ptime = this.litPtime.Text;
string title = this.litTitle.Text;
string content = this.litContent.Text;
string mailto = this.litEmail.Text;
string subject = sys.webName + "的回复";
string body = this.txtReplyContent.Text + "<br /><br /><br />该邮箱为" + sys.webName + "回复留言的邮件，请勿直接回复<br /><br / >" + name + ",您在" + ptime + "的来信:<br>" + title + "<br>" + content;
if (sys.SendEmail(subject, body, mailto))
{
sys.alert("回复成功，已经发送到邮箱。请选择其他操作");
}
else
{
sys.alert("回复成功！但是由于邮箱地址错误或者服务器拒绝无法到达对方邮箱，请直接发送邮件至对方邮箱");
}
sys.regisgerScirpt("window.location.href='guestbooklist.aspx'", "redirect");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public cycms.Model.Cycms GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,dbo_IsRunning,dbo_IsStatic,dbo_WebAddress,dbo_WebName,dbo_StaticListPages,dbo_VisitedTimes,dbo_SmtpServer,dbo_MailAddress,dbo_MailName,dbo_MailPwd,dbo_WorkPlace,dbo_LianXiRen,dbo_CellPhone,dbo_Flax,dbo_WorkPohne,dbo_BeiAnHao from dbo_Cycms ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
cycms.Model.Cycms model = new cycms.Model.Cycms();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public cycms.Model.Cycms DataRowToModel(DataRow row)
{
cycms.Model.Cycms model = new cycms.Model.Cycms();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["dbo_IsRunning"] != null && row["dbo_IsRunning"].ToString() != "")
{
if ((row["dbo_IsRunning"].ToString() == "1") || (row["dbo_IsRunning"].ToString().ToLower() == "true"))
{
model.dbo_IsRunning = true;
}
else
{
model.dbo_IsRunning = false;
}
}
if (row["dbo_IsStatic"] != null && row["dbo_IsStatic"].ToString() != "")
{
if ((row["dbo_IsStatic"].ToString() == "1") || (row["dbo_IsStatic"].ToString().ToLower() == "true"))
{
model.dbo_IsStatic = true;
}
else
{
model.dbo_IsStatic = false;
}
}
if (row["dbo_WebAddress"] != null)
{
model.dbo_WebAddress = row["dbo_WebAddress"].ToString();
}
if (row["dbo_WebName"] != null)
{
model.dbo_WebName = row["dbo_WebName"].ToString();
}
if (row["dbo_StaticListPages"] != null && row["dbo_StaticListPages"].ToString() != "")
{
model.dbo_StaticListPages = int.Parse(row["dbo_StaticListPages"].ToString());
}
if (row["dbo_VisitedTimes"] != null && row["dbo_VisitedTimes"].ToString() != "")
{
model.dbo_VisitedTimes = int.Parse(row["dbo_VisitedTimes"].ToString());
}
if (row["dbo_SmtpServer"] != null)
{
model.dbo_SmtpServer = row["dbo_SmtpServer"].ToString();
}
if (row["dbo_MailAddress"] != null)
{
model.dbo_MailAddress = row["dbo_MailAddress"].ToString();
}
if (row["dbo_MailName"] != null)
{
model.dbo_MailName = row["dbo_MailName"].ToString();
}
if (row["dbo_MailPwd"] != null)
{
model.dbo_MailPwd = row["dbo_MailPwd"].ToString();
}
if (row["dbo_WorkPlace"] != null)
{
model.dbo_WorkPlace = row["dbo_WorkPlace"].ToString();
}
if (row["dbo_LianXiRen"] != null)
{
model.dbo_LianXiRen = row["dbo_LianXiRen"].ToString();
}
if (row["dbo_CellPhone"] != null)
{
model.dbo_CellPhone = row["dbo_CellPhone"].ToString();
}
if (row["dbo_Flax"] != null)
{
model.dbo_Flax = row["dbo_Flax"].ToString();
}
if (row["dbo_WorkPohne"] != null)
{
model.dbo_WorkPohne = row["dbo_WorkPohne"].ToString();
}
if (row["dbo_BeiAnHao"] != null)
{
model.dbo_BeiAnHao = row["dbo_BeiAnHao"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(cycms.Model.Cycms model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo_Cycms set ");
strSql.Append("dbo_IsRunning=@dbo_IsRunning,");
strSql.Append("dbo_IsStatic=@dbo_IsStatic,");
strSql.Append("dbo_WebAddress=@dbo_WebAddress,");
strSql.Append("dbo_WebName=@dbo_WebName,");
strSql.Append("dbo_StaticListPages=@dbo_StaticListPages,");
strSql.Append("dbo_VisitedTimes=@dbo_VisitedTimes,");
strSql.Append("dbo_SmtpServer=@dbo_SmtpServer,");
strSql.Append("dbo_MailAddress=@dbo_MailAddress,");
strSql.Append("dbo_MailName=@dbo_MailName,");
strSql.Append("dbo_MailPwd=@dbo_MailPwd,");
strSql.Append("dbo_WorkPlace=@dbo_WorkPlace,");
strSql.Append("dbo_LianXiRen=@dbo_LianXiRen,");
strSql.Append("dbo_CellPhone=@dbo_CellPhone,");
strSql.Append("dbo_Flax=@dbo_Flax,");
strSql.Append("dbo_WorkPohne=@dbo_WorkPohne,");
strSql.Append("dbo_BeiAnHao=@dbo_BeiAnHao");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_IsRunning", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_IsStatic", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_WebAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WebName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_StaticListPages", OleDbType.Integer, 4),
new OleDbParameter("@dbo_VisitedTimes", OleDbType.Integer, 4),
new OleDbParameter("@dbo_SmtpServer", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailPwd", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WorkPlace", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_LianXiRen", OleDbType.VarChar, 10),
new OleDbParameter("@dbo_CellPhone", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_Flax", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_WorkPohne", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_BeiAnHao", OleDbType.VarChar, 100),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.dbo_IsRunning;
parameters[1].Value = model.dbo_IsStatic;
parameters[2].Value = model.dbo_WebAddress;
parameters[3].Value = model.dbo_WebName;
parameters[4].Value = model.dbo_StaticListPages;
parameters[5].Value = model.dbo_VisitedTimes;
parameters[6].Value = model.dbo_SmtpServer;
parameters[7].Value = model.dbo_MailAddress;
parameters[8].Value = model.dbo_MailName;
parameters[9].Value = model.dbo_MailPwd;
parameters[10].Value = model.dbo_WorkPlace;
parameters[11].Value = model.dbo_LianXiRen;
parameters[12].Value = model.dbo_CellPhone;
parameters[13].Value = model.dbo_Flax;
parameters[14].Value = model.dbo_WorkPohne;
parameters[15].Value = model.dbo_BeiAnHao;
parameters[16].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!sys.IsRunning)
{
Response.Write("站点维护中，请稍后访问");
Response.End();
return;
}
cycms.Model.Cycms modelcycms = bllcycms.GetModel(bllcycms.GetMaxId() - 1);
sys.workPlace = modelcycms.dbo_WorkPlace;
sys.lianXiren = modelcycms.dbo_LianXiRen;
sys.cellPhone = modelcycms.dbo_CellPhone;
sys.workPhone = modelcycms.dbo_WorkPohne;
sys.flax = modelcycms.dbo_Flax;
sys.mailAddress = modelcycms.dbo_MailAddress;
sys.smtpServer = modelcycms.dbo_SmtpServer;
sys.mailName = modelcycms.dbo_MailName;
sys.mailPwd = modelcycms.dbo_MailPwd;
sys.beiAnHao = modelcycms.dbo_BeiAnHao;
switch (sys.RequestFileName().ToLower())
{
case "showlist":
{
showlist();
} break;
case "showarticle":
{
ShowArticle();
} break;
case "dsource":
{
if (Request.QueryString["id"] == null || Request.QueryString["id"] == "")
{
Response.End();
return;
}
if (!Page.IsPostBack)
{
dSource();
}
else
{
dSourcePostBack(Request.Form["txtDownPass"]);
}
} break;
case "logincenter":
{
loginCenter();
} break;
case "default":
{
Default();
} break;
case "guestbook":
{
fillguestBooktype(Request.QueryString["Gtypeid"]);
fillImg(0);
if (!Page.IsPostBack)
{
guestbook();
}
else
{
guestbookpostback(Request.Form["txtTitle"], Request.Form["ddlGuestType"], Request.Form["txtName"], Request.Form["txtEmail"], Request.Form["rbtnSex"], Request.Form["txtContent"], Request.Form["txtWorkPlace"], Request.Form["txtChuanZhen"], Request.Form["txtCellphone"], Request.Form["txtAddress"]);
}
} break;
case "search":
{
search();
} break;
}
}