protected void Button2_Click(object sender, EventArgs e)
{
Random ran = new Random();
int RandKey = ran.Next(100, 999);
string bookid = Session["bookid"].ToString();
string plid = bookid + RandKey;
string pl = text_new.Text.Trim();
string readerid = Session["userID"].ToString();
string date = DateTime.Now.ToString();
if (pl != "")
{
string sql = string.Format("insert into[评论信息表] values('{0}','{1}','{2}','{3}','{4}')", plid, readerid, bookid, date, pl);
try
{
superConn mycon = new superConn();
mycon.open();
mycon.NoQuery(sql);
mycon.close();
text_new.Text = "";
}
catch
{
text_new.Text = "";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//子菜单的插入
submenuHolder.Controls.Add(subMenu.getSubmenu(1));
//获取新闻
string _nid = (Request["nid"] == null) ? "1" : Request["nid"];
newsReader_1.newsID = int.Parse(_nid);
//插入最后节点
superConn scnn = new superConn("DATA.MDB");
scnn.open();
string sql = "SELECT List_newsClass.* FROM T_NEWS INNER JOIN List_newsClass " +
" ON T_NEWS.news_ncid = List_newsClass.nc_id" +
" WHERE news_id=" + _nid;
OleDbDataReader dr = scnn.GetDataReader(sql);
if (dr.Read())
{
HyperLink lastNode = new HyperLink();
lastNode.NavigateUrl = "~/news/newsList.aspx?ncid=" + dr["nc_id"].ToString();
lastNode.Text = dr["nc_ttl"].ToString();
Master.FindControl("SiteMapPath1").Controls.Add(lastNode);
}
scnn.close();
}
protected void adminLogin()
{
int count = 0;//"????
string adminID = username.Text.Trim();
string adminPSW = password.Text.Trim();
string sql = string.Format("select * from [管理员信息表] where [管理员账号]='{0}' and [管理员密码]= '{1}'", adminID, adminPSW);
superConn mycon = new superConn();
mycon.open();
count = mycon.count(sql);
mycon.close();
if (count == 1)
{
Session["aisLogin"] = true;
Session["adminID"] = adminID;
Response.Redirect("../管理/读者.aspx");
}
else
{
error.Text = "错误的用户";
}
}
/// <summary>
/// 读者登录
/// </summary>
protected void userLogin()
{
int count = 0;
string userID = username.Text.Trim();
string userPSW = password.Text.Trim();
string sql = string.Format("select * from [读者信息表] where [读者账号]='{0}' and [读者密码]= '{1}'", userID, userPSW);
superConn mycon = new superConn();
mycon.open();
count = mycon.count(sql);
mycon.close();
if (count == 1)
{
Session["isLogin"] = true;
Session["userID"] = userID;
SetCookies();
Response.Redirect("../读者/订阅.aspx");
}
else
{
error.Text = "错误的用户";
}
}
protected void show_jiey()
{
string readerid = Session["userID"].ToString();
string bookid = Request.QueryString["bookid"];
string sql_reader = string.Format("select [读者账号],[读者姓名],[联系方式] from[读者信息表] where [读者账号]= '{0}'", readerid);
string sql_book = string.Format("select [书名],[作者],[图书单价] from[图书信息表] where [图书编号]= '{0}'", bookid);
SqlDataReader dr;
superConn mycon = new superConn();
mycon.open();
dr = mycon.GetDataReader(sql_reader);
while (dr.Read())
{
text_sure.Text += "读者账号：" + dr[0].ToString() + "\n";
text_sure.Text += "读者姓名：" + dr[1].ToString() + "\n";
text_sure.Text += "联系方式：" + dr[2].ToString() + "\n";
}
mycon.close();
mycon.open();
dr = mycon.GetDataReader(sql_book);
while (dr.Read())
{
text_sure.Text += "书名：" + dr[0].ToString() + "\n";
text_sure.Text += "作者：" + dr[1].ToString() + "\n";
text_sure.Text += "单价：" + dr[2].ToString() + "\n";
}
mycon.close();
}
protected void Page_Load(object sender, EventArgs e)
{
//遍历数据表格submenuclass
superConn scnn = new superConn("data.mdb");
scnn.open();
string _sql = "SELECT *FROM list_submenuclass";
OleDbDataReader dr = scnn.GetDataReader(_sql);
while (dr.Read())
{
TableCell td = new TableCell();
Label lab_title = new Label();
lab_title.Text = dr["smenu_ttl"].ToString();
lab_title.CssClass = "submenuTitle";
td.Controls.Add(lab_title);
td.Controls.Add(subMenu.getSubmenu((int)dr["smenu_id"]));
row_links.Controls.Add(td);
}
scnn.close();
}
protected void Page_Load(object sender, EventArgs e)
{
//1.相册控件图片源
superConn scnn = new superConn("data.mdb");
scnn.open();
string _sql = "SELECT * FROM T_albumHome WHERE abHome_enable=true";
OleDbDataReader dr = scnn.GetDataReader(_sql);
List <HyperLink> _links = new List <HyperLink>();
HyperLink _l;
while (dr.Read())
{
_l = new HyperLink();
_l.ImageUrl = dr["abhome_imgurl"].ToString();
_l.NavigateUrl = dr["abhome_nav"].ToString();
_links.Add(_l);
}
scnn.close();
album_home.ImgLinks = _links;
//2.隐藏母版页内容
Master.FindControl("divmst_sitemapPath").Visible = false;
Master.FindControl("lbl_subpageTitle").Visible = false;
}
protected void showdetails()
{
string id;
id = Session["bookid"].ToString();
string sql = string.Format("select * from [图书信息表] where [图书编号]='{0}'", id);
SqlDataAdapter sa;
superConn mycon = new superConn();
DataTable dt = new DataTable();
mycon.open();
sa = mycon.GetDataAdapter(sql);
sa.Fill(dt);
mycon.close();
for (int i = 0; i < dt.Columns.Count; i++)
{
Label label = new Label();
TextBox textbox = new TextBox();
label.Text = dt.Columns[i].ColumnName;
label.Width = 300; label.Height = 40;
textbox.Text = dt.Rows[0][i].ToString();
textbox.Width = 300; textbox.Height = 40; textbox.BackColor = Color.AntiqueWhite; textbox.ForeColor = Color.Black; textbox.ReadOnly = true;
pn.Controls.Add(label);
pn.Controls.Add(textbox);
}
}
protected void Page_Load(object sender, EventArgs e)
{
superConn scnn = new superConn("DATA.MDB");
scnn.open();
string sql = "SELECT * FROM T_IMGS WHERE img_id=" + _imgID;
OleDbDataReader dr = scnn.GetDataReader(sql);
if (dr.Read())
{
Image1.ImageUrl = dr["img_url"].ToString();
}
scnn.close();
}
public artItem(int artID)
{
superConn scnn = new superConn("DATA.MDB");
scnn.open();
string sql = "SELECT * FROM T_artMng WHERE art_id=" + artID;
OleDbDataReader dr = scnn.GetDataReader(sql);
if (dr.Read())
{
artTitle = dr["art_title"].ToString();
artContent = dr["art_content"].ToString();
}
scnn.close();
}
//public MyProduct()
//{
// //
// // TODO: Add constructor logic here
// //
//}
/// <summary>
/// 根据数据表的ID，实例化一个产品
/// </summary>
/// <param name="ProductID"></param>
public MyProduct(int ProductID)
{
superConn scnn = new superConn("data.mdb");
scnn.open();
string _sql = "SELECT T_Product.*, List_pdColor.cl_name, T_IMGS.img_url, List_pdSeries.se_name, List_pdSize.si_size, " +
" (SELECT list_pdport.pt_name from list_pdport where pt_id = t_product.pd_pt1 ) as Port1, " +
" (SELECT list_pdport.pt_name from list_pdport where pt_id = t_product.pd_pt2 ) as Port2, " +
" (SELECT list_pdport.pt_name from list_pdport where pt_id = t_product.pd_pt3 ) as Port3, " +
" (SELECT list_pdport.pt_name from list_pdport where pt_id = t_product.pd_pt4 ) as Port4 " +
" FROM T_IMGS INNER JOIN (List_pdSeries INNER JOIN(List_pdSize INNER JOIN(List_pdColor INNER JOIN T_Product ON List_pdColor.cl_id = T_Product.pd_clid) ON List_pdSize.si_id = T_Product.pd_szid) ON List_pdSeries.se_id = T_Product.pd_seid) ON T_IMGS.img_id = T_Product.pd_img " + " WHERE pd_id= " + ProductID;
OleDbDataReader dr = scnn.GetDataReader(_sql);
if (dr.Read())
{
_id = (int)dr["pd_id"];
_seid = (int)dr["pd_seid"]; _seName = dr["se_name"].ToString();
_clid = (int)dr["pd_clid"]; _ColorName = dr["cl_name"].ToString();
_szid = (int)dr["pd_szid"]; _SizeName = dr["si_size"].ToString();
_name = dr["pd_name"].ToString();
_bandwidth = (int)dr["pd_bandwidth"];
_rtime = (int)dr["pd_rtime"];
_lms = (int)dr["pd_lms"];
_screen = dr["pd_screen"].ToString();
_feature = dr["pd_feature"].ToString();
_other = dr["pd_other"].ToString();
_pt1 = (int)dr["pd_pt1"];
_pt2 = (int)dr["pd_pt2"];
_pt3 = (int)dr["pd_pt3"];
_pt4 = (int)dr["pd_pt4"];
_pt1Name = dr["Port1"].ToString();
_pt2Name = dr["Port2"].ToString();
_pt3Name = dr["Port3"].ToString();
_pt4Name = dr["Port4"].ToString();
_img = (int)dr["pd_img"];
_mainImgUrl = dr["img_url"].ToString();
_album = dr["pd_album"].ToString();
_albumLinks = getAlbumLinks(_album);
_push = (Boolean)dr["pd_push"];
}
scnn.close();
}
protected void showyuqi()
{
SqlDataReader dr;
superConn mycon = new superConn();
string sql = string.Format("select * from [借阅信息表] where datediff(day,借阅日期,getdate())>=day(借阅时长)");
mycon.open();
dr = mycon.GetDataReader(sql);
if (dr != null)
{
// string id = dr["读者信_读者账号"].ToString();
gv_yuqi.DataSource = dr;
gv_yuqi.DataBind();
}
mycon.close();
}
protected void btn_sure_Click(object sender, EventArgs e)
{
string bookid = ddl_book.SelectedValue;
string readerid = Session["userID"].ToString();
string sql_1 = string.Format("delete from [借阅信息表] where [图书信_图书编号] ='{0}' and [读者信_读者账号] ='{1}'", bookid, readerid);
string sql_2 = string.Format("update [图书信息表] set [剩余数量] = [剩余数量] + 1 where [图书编号] = '{0}'", bookid);
superConn mycon = new superConn();
mycon.open();
mycon.NoQuery(sql_1);
mycon.NoQuery(sql_2);
mycon.close();
string url = Request.Url.LocalPath;
Response.Redirect(url);
}
protected void Page_Load(object sender, EventArgs e)
{
superConn scnn = new superConn("DATA.mdb");
scnn.open();
string _sql = "SELECT * FROM T_NEWS WHERE news_id=" + _newsID;
OleDbDataReader dr = scnn.GetDataReader(_sql);
if (dr.Read())
{
newsTitle.InnerText = dr["news_ttl"].ToString();
newsDateTime.InnerText = ((DateTime)dr["news_date"]).ToShortTimeString();
newsContent.InnerHtml = dr["news_content"].ToString();
}
scnn.close();
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
//1.写入数据库
string _name, _phone, _content;
string _date;
_name = txt_name.Text;
_phone = txt_phone.Text;
_content = txt_msg.Text;
_date = DateTime.Now.ToString();
superConn scnn = new superConn("data.mdb");
scnn.open();
string sql = "INSERT INTO T_MESSAGE (msg_name,msg_phone,msg_date,msg_message) values " + "('" + _name + "','" + _phone + "','" + _date + "','" + _content + "')";
OleDbCommand cmd = new OleDbCommand(sql, scnn.cnn);
cmd.ExecuteNonQuery();
scnn.close();
//2.邮件发送
string _from, _to, _subject, _body;
_from = "*****@*****.**";
_to = "*****@*****.**";
_subject = _name + "提交的留言[" + _date + "]";
_body = _content;
MailMessage _msg = new MailMessage(_from, _to, _subject, _body);
SmtpClient _client = new SmtpClient("smtp.163.com", 25);
_client.DeliveryMethod = SmtpDeliveryMethod.Network;
_client.Credentials = new NetworkCredential("*****@*****.**", "zxcvbnm123");
_client.Send(_msg);
//3.mv切换
mv_form.SetActiveView(v_success);
}
protected void showyuqi()
{
string id = Session["userID"].ToString();
SqlDataReader dr;
superConn mycon = new superConn();
string sql = string.Format("select * from [借阅信息表] where [读者信_读者账号]='{0}' and datediff(day,借阅日期,getdate())>=day(借阅时长)", id);//查询结果一行有误
mycon.open();
dr = mycon.GetDataReader(sql);
if (dr.HasRows)
{
text_show.Text = "你已有逾期未还书目";
gv_yuqi.DataSource = dr;
gv_yuqi.DataBind();
}
mycon.close();
}
protected void Page_Load(object sender, EventArgs e)
{
//子菜单的插入
submenuHolder.Controls.Add(subMenu.getSubmenu(1));
//子页面标题
superConn scnn = new superConn("DATA.MDB");
scnn.open();
string _ncid = (Request["ncid"] == null) ? "1" : Request["ncid"];
string sql = "SELECT * FROM List_newsClass where nc_id=" + _ncid;
OleDbDataReader dr = scnn.GetDataReader(sql);
if (dr.Read())
{
lab_subtitle.Text = dr["nc_ttl"].ToString();
}
scnn.close();
}
protected void Page_Load(object sender, EventArgs e)
{
//子菜单的插入
submenuHolder.Controls.Add(subMenu.getSubmenu(5));
//SELECT T_Product.pd_id, T_Product.pd_name, T_IMGS.img_url FROM (T_IMGS INNER JOIN T_Product ON T_IMGS.img_id = T_Product.pd_img)
//访问地址时，url有3中可能：
//1.prodList.aspx
//2.prodList.aspx?seid=1
//3.prodList.aspx?type=serch 这表示通过搜索来访问
string _type = Request["type"];
string _seid = Request["seid"] == null ? "1" : Request["seid"];
string _sqlDefault = "SELECT T_Product.pd_id, T_Product.pd_name, T_IMGS.img_url FROM (T_IMGS INNER JOIN T_Product ON T_IMGS.img_id = T_Product.pd_img) where pd_seid=" + _seid;
Label lab_LastNode = new Label();
if (_type == "serch")
{
_sqlDefault = Session["sql_serch"] == null ? _sqlDefault : Session["sql_serch"].ToString();
lab_LastNode.Text = "搜索结果";
}
else
{
superConn scnn = new superConn("data.mdb");
scnn.open();
string _sql = "SELECT * FROM LIST_PDSERIES WHERE se_id=" + _seid;
OleDbDataReader dr = scnn.GetDataReader(_sql);
if (dr.Read())
{
lab_LastNode.Text = dr["se_name"].ToString() + "产品列表";
}
scnn.close();
}
//SQL
SqlDataSource1.SelectCommand = _sqlDefault;
//NODE
Master.FindControl("SiteMapPath1").Controls.Add(lab_LastNode);
}
private void maketree()
{
TreeNode tn;
SqlDataReader dr;
string sql_type = "select * from [图书类型表]";
superConn mycon = new superConn();
mycon.open();
dr = mycon.GetDataReader(sql_type);
while (dr.Read())
{
tn = new TreeNode();
tn.Text = dr["类型名称"].ToString();
tn.Value = dr["类型编号"].ToString();
tv.Nodes.Add(tn);
}
mycon.close();
/* string sql_books = "select * from books_information";
* cmd = new SqlCommand(sql_books, conn);
* dr = cmd.ExecuteReader();
* while (dr.Read())
* {
* string value = dr["Bi_typeid"].ToString();
* par = new TreeNode();
* foreach (TreeNode t in tv.Nodes)
* {
* if (t.Value == value)
* par = t;
* }
* tn = new TreeNode();
* tn.Text = dr["Bi_name"].ToString();
* tn.Value = dr["Bi_id"].ToString();
* par.ChildNodes.Add(tn);
* }
* dr.Close();*///用于构建树的二级子节点
}
private List <HyperLink> getAlbumLinks(string __album)
{
List <HyperLink> __links = new List <HyperLink>();
superConn scnn2 = new superConn("data.mdb");
scnn2.open();
string _sql2 = "SELECT * FROM T_IMGS WHERE img_id in (" + __album + ")";
OleDbDataReader dr2 = scnn2.GetDataReader(_sql2);
HyperLink __link;
while (dr2.Read())
{
__link = new HyperLink();
__link.ImageUrl = dr2["img_url"].ToString();
__link.NavigateUrl = dr2["img_nav"].ToString();
__links.Add(__link);
}
scnn2.close();
return(__links);
}
protected void Button1_Click(object sender, EventArgs e)
{
string userID, old_str, new_str;
old_str = old_psw.Text.Trim();
new_str = old_psw.Text.Trim();
userID = Session["userID"].ToString();
string sql = string.Format("update [读者信息表] set [读者密码]='{0}' where [读者账号]='{1}' and [读者密码] = '{2}'", new_str, userID, old_str);
try
{
superConn mycon = new superConn();
mycon.open();
mycon.NoQuery(sql);
mycon.close();
result.Text = "修改成功";
}
catch
{
result.Text = "修改失败，请重试";
}
}
protected void btn_addNew_Click(object sender, EventArgs e)
{
string _filename = txt_temp.Text;
string _ext = Path.GetExtension(_filename);
string _imgurl = "~/_uploadImgs/" + DateTime.Now.ToFileTime().ToString() + _ext;
string _nav = txt_nav.Text;
string _enable = chk_enable.Checked ? "true" : "false";
File.Move(MapPath(_filename), MapPath(_imgurl));
superConn scnn = new superConn("data.mdb");
scnn.open();
string _sql = "INSERT INTO T_albumHome (abhome_imgurl,abhome_nav,abhome_enable) values ('" + _imgurl + "','" + _nav + "'," + _enable + ")";
OleDbCommand cmd = new OleDbCommand(_sql, scnn.cnn);
cmd.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "location.reload();", true);
scnn.close();
}
protected void Button1_Click(object sender, EventArgs e)
{
Random ran = new Random();
int RandKey = ran.Next(100, 999);
string jyid = Request.QueryString["bookid"] + RandKey;
string readerid = Session["userID"].ToString();
string bookid = Request.QueryString["bookid"];
string date = DateTime.Now.ToString();
string time = DropDownList1.SelectedValue;
string sql_1 = string.Format("update [图书信息表] set [剩余数量] = [剩余数量] - 1 where [图书编号] = '{0}'", bookid);
string sql_2 = string.Format("insert into[借阅信息表] values('{0}', '{1}', '{2}', '{3}', '{4}')", jyid, readerid, bookid, date, time);
superConn mycon = new superConn();
mycon.open();
mycon.NoQuery(sql_1);
mycon.NoQuery(sql_2);
mycon.close();
string url = Request.Url.LocalPath;
Response.Redirect(url);
}
protected void showpl()
{
string book;
book = Request.QueryString["bookid"].ToString();
string sql = string.Format("select * from [评论信息表] where [图书信_图书编号]='{0}'", book);
SqlDataReader dr;
superConn mycon = new superConn();
mycon.open();
dr = mycon.GetDataReader(sql);
while (dr.Read())
{
Label lab_bq = new Label(); Label lab_content = new Label();
lab_bq.CssClass = "css_bq"; lab_content.CssClass = "css_content";
lab_bq.Text = dr["评论日期"].ToString() + dr["读者信_读者账号"].ToString();
lab_content.Text = "<br/><br/>   " + dr["评论内容"].ToString() + "<hr/>";
P_pl.Controls.Add(lab_bq);
P_pl.Controls.Add(lab_content);
}
mycon.close();
}
protected void updata()
{
string text = "";
superConn mycon = new superConn();
try
{
string sql1 = string.Format("select * from [图书信息表] where [图书编号] ='{0}' or [书名] ='{1}'", id, name);
mycon.open();
if (mycon.count(sql1) > 0)
{
text = "书名或编号重复";
}
else
{
if (upload.HasFile)
{
path = MapPath("~/数据/") + id + ".txt";//为文本设置统一的文件名和路径
upload.SaveAs(path);
}
string sql = string.Format("insert into [图书信息表] values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", id, name, writer, press, date, pressdate, brief, type, price, number, leftnumber, path);
mycon.NoQuery(sql);
text = "添加成功";
}
}
catch (Exception e)
{
text = "添加失败，请重试" + e.ToString();
}
finally
{
mycon.close();
error.Text = text;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string new_id = text_id.Text;
string new_pw = text_pw.Text;
string new_mail = text_mail.Text;
string sql_add = string.Format("insert into [读者信息表](读者账号,读者密码,联系方式)values('{0}','{1}','{2}')", new_id, new_pw, new_mail);
superConn mycon = new superConn();
mycon.open();
try
{
mycon.NoQuery(sql_add);
Session["userID"] = new_id;
Session["userPSW"] = new_pw;
Session["isLogin"] = true;
Response.Redirect("../读者/个人页.aspx");
}
catch
{
result.Text = "存在相同的账号，注册失败";
}
mycon.close();
}
