protected void Page_Load(object sender, EventArgs e) { this.Button1.Attributes.Add("onclick", "return conf();"); CheckLogin.checkAll(); if (!IsPostBack) { string sql = "select * from t_3th where id="; string tit = ""; switch (UID) { case "interface": tit = "地图API管理"; sql += "1"; break; case "use": tit = "应用管理"; sql += "2"; break; case "source": tit = "资源管理"; sql += "3"; break; } this.Label1.Text = tit; DataTable dt = AccessDb.Execute(sql).Tables[0]; this.txt_url.Text = dt.Rows[0]["purl"].ToString(); } }
private void editIni() { string sql = "select * from t_sample where id=" + UID; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt.Rows.Count == 0) { JS.Alert("读数据失败"); Response.End(); } else { _dr = dt.Rows[0]; } this.txt_title.Text = DR["ptitle"].ToString(); this.txt_Url.Text = DR["purl"].ToString(); this.content2.Value = DR["pcontent"].ToString(); this.HyperLink1.NavigateUrl = DR["ppic"].ToString(); this.HyperLink1.Target = "_blank"; this.txt_DateTime.Value = DR["pdate"].ToString(); if (DR["ppic"].ToString().Trim() != "") { this.HyperLink1.Text = "点击查看"; } else { this.HyperLink1.Text = "---"; } }
private void ini() { if (UID != null && !UID.Equals(String.Empty)) { string sql = "select * from t_lunpic where id=" + UID; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt != null) { this.link1.NavigateUrl = dt.Rows[0]["ppic"].ToString(); this.link1.Target = "_blank"; this.txt_title.Text = dt.Rows[0]["ptitle"].ToString(); this.txt_url.Text = dt.Rows[0]["purl"].ToString(); this.txt_sort.Text = dt.Rows[0]["psort"].ToString(); string isShow = dt.Rows[0]["PIsShow"].ToString(); if (isShow.ToLower() == "false") { this.drp_isUse.SelectedIndex = 1; } else { this.drp_isUse.SelectedIndex = 0; } } } }
private void showgrid(object sender, System.EventArgs e) { DataTable mydt = null; mydt = AccessDb.Execute("select * from t_news where ptype='" + typ + "' order by id desc").Tables[0]; DGList.DataSource = mydt; DataTable dt = new DataTable(); try { DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } catch { if ((DGList.CurrentPageIndex - 1) >= 0) { DGList.CurrentPageIndex = DGList.CurrentPageIndex - 1; } DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } }
private void ini() { string sql = "select * from t_about where pname='padv'"; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt.Rows.Count == 0) { JS.Alert("发生错误"); Response.End(); } this.content2.Value = dt.Rows[0]["pcontent"].ToString(); }
private void ini() { string sql = "select * from t_const where pname='zhitong'"; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt.Rows.Count == 0) { Response.Write("请先填写"); } else { this.content2.Value = dt.Rows[0]["pcontent"].ToString(); } }
private void editIni() { string sql = "select * from t_interface where id=" + UID; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt.Rows.Count == 0) { JS.Alert("读数据失败"); Response.End(); } else { _dr = dt.Rows[0]; } this.txt_title.Text = DR["ptitle"].ToString(); this.content2.Value = DR["pcontent"].ToString(); }
private void show() { string sql = "select * from t_news where id=" + UID; DataTable dt = AccessDb.Execute(sql).Tables[0]; dr = dt.Rows[0]; if (dr["purl"] != null && dr["purl"].ToString().Length > 0) { string FilePath = dr["purl"].ToString(); FilePath = FilePath.Substring(FilePath.LastIndexOf('\\') + 1); this.SpFile.InnerHtml = "附件: <a href=\"" + dr["purl"].ToString() + "\" title=\"" + FilePath + "\">" + FilePath + " </a>"; } else { this.SpFile.InnerHtml = ""; } }
private void but_save_Click(object sender, System.EventArgs e) { //add if (ViewState["pk"] != null) {//edit txt_user.Enabled = true; try { string pass = this.txt_pass.Text; AccessDb.ExecuteNonQuery("update t_user set pass='******' where id=" + ViewState["pk"].ToString()); JS.Alert("修改成功"); ViewState["pk"] = null; } catch (Exception ex) { JS.Alert("修改失败:" + ex); } } else { if (AccessDb.Execute("select * from t_user where Uname='" + this.txt_user.Text.Trim().Replace("'", "''") + "'").Tables[0].Rows.Count != 0) { JS.Alert("存在同名用户"); return; } try { string pass = this.txt_pass.Text; string uname = this.txt_user.Text; string sql = "insert into t_user (uname,pass) values('{0}','{1}')"; sql = string.Format(sql, uname, pass); AccessDb.ExecuteNonQuery(sql); JS.Alert("添加成功"); ViewState["pk"] = null; } catch (Exception ex) { JS.Alert("添加失败:" + ex); } } showgrid(null, null); this.txt_user.Text = ""; this.txt_pass.Text = ""; }
private void showgrid(object sender, System.EventArgs e) { DataTable mydt = null; mydt = AccessDb.Execute("select * from t_user").Tables[0]; DGList.DataSource = mydt; try { DGList.DataBind(); } catch { if ((DGList.CurrentPageIndex - 1) >= 0) { DGList.CurrentPageIndex = DGList.CurrentPageIndex - 1; } DGList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { #region//新闻2 string strCount = ConfigurationManager.AppSettings.Get("NewsDetailCount"); if (strCount != null || strCount.Length > 0) { try { this.Count = Convert.ToInt32(strCount); } catch (System.Exception ex) { } } DataTable mydt = null; mydt = AccessDb.Execute("select top " + Count.ToString() + " * from t_news order by id desc").Tables[0]; this.rpleft2.DataSource = mydt; this.rpleft2.DataBind(); #endregion }
private void showgrid(object sender, System.EventArgs e) { DataTable mydt = null; mydt = AccessDb.Execute("select * from t_question order by pAnswered ,pdate desc").Tables[0]; DGList.DataSource = mydt; try { DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } catch { if ((DGList.CurrentPageIndex - 1) >= 0) { DGList.CurrentPageIndex = DGList.CurrentPageIndex - 1; } DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } }
protected void but_login_Click(object sender, EventArgs e) { if (this.txt_pass.Text == "" || this.txt_user.Text == "") { JS.Alert("请输入用户,密码"); return; } string user = this.txt_user.Text.Replace("'", ""); string pass = this.txt_pass.Text.Replace("'", ""); string sql = "select * from t_user where uname='{0}' and pass='******'"; sql = string.Format(sql, user, pass); if (AccessDb.Execute(sql).Tables[0].Rows.Count == 0) { JS.Alert("用户,密码错误."); return; } else { Session["user"] = user; Response.Redirect("main.htm"); } }
protected void DGList_EditCommand(object source, DataGridCommandEventArgs e) { ViewState["pk"] = e.Item.Cells[0].Text; string sql = "select * from t_programs where id=" + ViewState["pk"].ToString(); DataTable dt = AccessDb.Execute(sql).Tables[0]; this.txt_title.Text = dt.Rows[0]["ptitle"].ToString(); this.txt_url.Text = dt.Rows[0]["purl"].ToString(); string isShow = dt.Rows[0]["pstate"].ToString(); string sort = dt.Rows[0]["psort"].ToString(); this.txt_sort.Text = sort; if (isShow.ToLower() == "false") { this.drp_isUse.SelectedIndex = 1; } else { this.drp_isUse.SelectedIndex = 0; } //this.txt_title.Enabled = false; }
private void showleft2() { string strCount = ConfigurationManager.AppSettings.Get("NewsCount"); if (strCount != null || strCount.Length > 0) { try { this.count = Convert.ToInt32(strCount); } catch (System.Exception ex) { } } string _TemSelfName = Request.Url.AbsolutePath; _SelfPageName = Server.UrlEncode(_TemSelfName); DataTable mydt = null; mydt = AccessDb.Execute("select * from t_news order by id desc").Tables[0]; // 数据源 PagedDataSource Pgds = new PagedDataSource(); Pgds.DataSource = mydt.DefaultView; // 设置允许分页 Pgds.AllowPaging = true; // 每页显示为6行 Pgds.PageSize = count; // 显示总共页数 // lblTotalPage.Text = Pgds.PageCount.ToString(); // 当前页 int CurrentPage; // 请求页码为不为null设置当前页,否则为第一页 if (Request.QueryString["Page"] != null) { CurrentPage = Convert.ToInt32(Request.QueryString["Page"]); } else { CurrentPage = 1; } // 当前页所引为页码-1 Pgds.CurrentPageIndex = CurrentPage - 1; // 显示当前页码 lblCurrentPage.Text = CurrentPage.ToString(); // 如果不是第一页,通过参数Page设置上一页为当前页-1,否则不显示连接 lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Pgds.PageCount; if (!Pgds.IsFirstPage) { // Request.CurrentExecutionFilePath为当前请求虚拟路径 lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage - 1); } // End If // 如果不是最后一页,通过参数Page设置下一页为当前页+1,否则不显示连接 if (!Pgds.IsLastPage) { // Request.CurrentExecutionFilePath为当前请求虚拟路径 lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage + 1); } // 模板绑定数据源 rpleft2.DataSource = Pgds; rpleft2.DataBind(); }
/// <summary> /// 记录初始化 /// </summary> private void editIni() { string sql = "select * from t_service where id=" + UID; DataTable dt = AccessDb.Execute(sql).Tables[0]; if (dt.Rows.Count == 0) { JS.Alert("读数据失败"); Response.End(); } else { _dr = dt.Rows[0]; } if (DR["ptitle"] != null) { this.txt_title.Text = DR["ptitle"].ToString(); } else { this.txt_title.Text = ""; } if (DR["surl"] != null) { this.txt_url.Text = DR["surl"].ToString();; } else { this.txt_url.Text = ""; } if (DR["unit"] != null) { this.txt_unit.Text = DR["unit"].ToString(); } else { this.txt_title.Text = ""; } if (DR["servicetype"] != null) { this.txt_servicetype.Text = DR["servicetype"].ToString(); } else { this.txt_servicetype.Text = ""; } if (DR["remark"] != null) { this.txt_remark.Text = DR["remark"].ToString(); } else { this.txt_remark.Text = ""; } if (DR["redu"] != null) { this.txt_redu.Text = DR["redu"].ToString(); } else { this.txt_redu.Text = ""; } if (DR["setdate"] != null) { this.txt_DateTime.Value = DR["setdate"].ToString(); } else { this.txt_DateTime.Value = DateTime.Now.ToUniversalTime().ToString(); } }