protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "SELECT name,name from t_dict where flm=1 ;"; DBFun.FillDwList(ddlist_dept, str_sql); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_Status, str_sql); ddlist_Status.Items.Insert(0, "全部"); str_sql = "SELECT name,name from t_dict where flm=13 ;"; DBFun.FillDwList(ddlist_sqbm, str_sql); ddlist_sqbm.Items.Insert(0, "全部"); //str_sql = "select distinct left(appNo,4)&'年',left(appNo,4) from t_teacher_list order by left(appNo,4) desc"; //DBFun.FillDwList(ddlist_year, str_sql); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { Calc_fs(); str_sql = "SELECT name,name from t_dict where flm=3 ;"; DBFun.FillDwList(ddlist_cGroup, str_sql); ddlist_cGroup.Items.Insert(0, "全部"); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_xmzt0, str_sql); ddlist_xmzt0.Items.Insert(0, "全部"); str_sql = "select content from t_dict where flm = 14 and bm =3"; str_sql = DBFun.ExecuteScalar(str_sql).ToString(); DBFun.FillDwList(ddlist_year, str_sql); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // CommFun.IsAdmin(); string Action = Request.QueryString["Action"]; string ID = Request.QueryString["ID"]; if (Action == null) { ltl_Title.Text = "新添影片类型"; btn_Ok.Text = "添加"; } else if (Action == "Edit") { ltl_Title.Text = "编辑影片类型"; btn_Ok.Text = "确认修改"; ReadFromDb(ID); } else if (Action == "Delete") { DeleteFromDb(ID); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); ////读取PageSize信息 //AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); //try //{ // ddl_PageSize.SelectedValue = ConfigurationManager.AppSettings.Get("PageSize"); //} //catch //{ // ddl_PageSize.SelectedIndex = 0; //} AspNetPager1.PageSize = 10; //GridView1.SelectedRowStyle.BackColor = System.Drawing.Color.RosyBrown; bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_xmzt, str_sql); ddlist_xmzt.Items.Insert(0, "全部"); AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); try { ddl_PageSize.SelectedValue = ConfigurationManager.AppSettings.Get("PageSize"); } catch { ddl_PageSize.SelectedIndex = 0; } bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { CommFun.IsAdmin(); string strqry; if (!IsPostBack) { //服务器路径 strqry = "select * From T_Path"; DwPath.DataSource = DBFun.GetDataView(strqry).Table; DwPath.DataTextField = "Caption"; DwPath.DataValueField = "id"; DwPath.DataBind(); //类型 strqry = "select * From T_Class"; DwClass.DataSource = DBFun.GetDataView(strqry); DwClass.DataTextField = "caption"; DwClass.DataValueField = "ID"; DwClass.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CommFun.IsAdmin(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CommFun.IsAdmin(); string strqry = "select id,Caption From T_class"; DBFun.FillDwList(dw_class, strqry); strqry = "Select * From T_Class"; GridView1.DataSource = DBFun.GetDataView(strqry); GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } lbl_type.Text = Request.QueryString["type"]; if (!IsPostBack) { bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { bindData(); //this.GridView1.Columns[7].Visible = true; //this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { CommFun.IsAdmin(); string strqry = "select * From T_HotSearch order by scount desc"; GridView1.DataSource = DBFun.GetDataView(strqry); GridView1.DataBind(); } catch (Exception ex) { Response.Write("执行时出错!" + ex.Message); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { DataView dv = DBFun.GetDataView("select * from master;"); GridView1.DataSource = dv; GridView1.DataBind(); Session["dv_detail"] = dv; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { CommFun.IsAdmin(); DBFun.FillDwList(dw_class, "select ID,caption From T_Class"); string strqry = "select * From T_IndexPage"; GridView1.DataSource = DBFun.GetDataView(strqry); GridView1.DataBind(); } catch (Exception ex) { Response.Write("执行时出错!" + ex.Message); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); bindData(); this.GridView1.SelectedIndex = -1; this.btn_CreateRws.Attributes.Add("onclick", "return confirm (\"生成任务书会删除原有任务书,确定要继续吗?\");"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(dw_group, str_sql); DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); this.GridView1.SelectedIndex = -1; btn_create.Attributes.Add("onclick", "return confirm (\"原有的对应关系将会删除,是否继续?\");"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(dw_group, str_sql); DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); this.GridView1.SelectedIndex = -1; } //Label lbl; //for (int i = 0; i < GridView1.Rows.Count; i++) //{ // CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("cbx_HandOn"); // lbl = (Label)this.GridView1.Rows[i].FindControl("lbl_Flag"); // if (ckb.Checked) // { // lbl.Text = "已提交"; // lbl.ForeColor = System.Drawing.Color.Green; // } // else // { // lbl.Text = "未提交"; // lbl.ForeColor = System.Drawing.Color.Red; // } //} }
private void pageload() { //网页加载过程 CommFun.IsAdmin(); if (!IsPostBack) { string strqry; string Action = Request.QueryString["Action"]; string id = Request.QueryString["ID"]; if (Action == "Edit") { //修改 strqry = "select * From T_Path where id=" + id; DataView dv = DBFun.GetDataView(strqry); Tb_PlayPath.Text = dv.Table.Rows[0]["PlayPath"].ToString(); tb_PlayPath2.Text = dv.Table.Rows[0]["PlayPath2"].ToString(); Tb_DownPath.Text = dv.Table.Rows[0]["downpath"].ToString(); Tb_Caption.Text = dv.Table.Rows[0]["caption"].ToString(); BtnAdd.Text = "保存"; } if (Action == "Delete") { //删除 strqry = "Delete From T_Path where ID=" + id; if (DBFun.ExecuteUpdate(strqry)) { Response.Redirect(Request.UrlReferrer.ToString()); } } strqry = "select * From T_Path order by id desc"; Repeater1.DataSource = DBFun.GetDataView(strqry); Repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "select flag from master where admin_name = '" + Session["admin_name"].ToString() + "'"; if ((int)DBFun.ExecuteScalar(str_sql) != 2) { Response.Write("<script>alert('您没有权限访问此页面!');location.href = './main.aspx';</script>"); return; } //lbl_type.Text = Request.QueryString["type"]; //if (lbl_type.Text=="") //{ // Response.Write("<script>alert('请您通过正规渠道访问此页面!');history.go(-1);</script>"); // return; //} //str_sql = "select bm,name from t_dict where flm = "+lbl_type.Text; //DBFun.FillDwList(dw_group, str_sql); bindData(); //this.GridView1.Columns[8].Visible = false; this.GridView1.Columns[7].Visible = true; //this.GridView1.Columns[this.GridView1.Columns.Count - 4].Visible = false; //this.GridView1.Columns[this.GridView1.Columns.Count - 2].Visible = false; //this.GridView1.AllowSorting = false; //this.GridView1.AllowPaging = false; this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { //网页加载 CommFun.IsAdmin(); string strqry; if (!IsPostBack) { //服务器路径 strqry = "select * From T_Path"; DwPath.DataSource = DBFun.GetDataView(strqry).Table; DwPath.DataTextField = "Caption"; DwPath.DataValueField = "id"; DwPath.DataBind(); //类型 strqry = "select * From T_Class"; DwClass.DataSource = DBFun.GetDataView(strqry); DwClass.DataTextField = "caption"; DwClass.DataValueField = "ID"; DwClass.DataBind(); string Action = Request.QueryString["Action"]; string id = Request.QueryString["ID"]; string pid = Request.QueryString["PID"]; if (Action == "Edit" && id != null) { //是示信息以供修改 strqry = string.Format("select * From T_films where ID={0}", id); DataRow dr = DBFun.GetDataView(strqry).Table.Rows[0]; DwPath.Text = dr["pathid"].ToString(); TbFilmname.Text = dr["film_name"].ToString(); TbOthername.Text = dr["other_name"].ToString(); TbDirector.Text = dr["film_director"].ToString(); TbPlayer.Text = dr["film_player"].ToString(); DwClass.Text = dr["film_classid"].ToString(); DwFrom.Text = dr["film_from"].ToString(); DwLevel.Text = dr["film_level"].ToString(); DwClear.Text = dr["film_clear"].ToString(); CkbBest.Items[0].Selected = (dr["filmisgood1"].ToString() == "1"); CkbBest.Items[1].Selected = (dr["filmisgood2"].ToString() == "1"); TbMoney.Text = dr["film_money"].ToString(); Rbfilmtype.Text = dr["playtype"].ToString(); RbIsReq.Text = dr["filmisseq"].ToString(); TbPicUrl.Text = dr["film_pic"].ToString(); TbGut.Text = dr["film_gut"].ToString().Replace("<br>", "\n");; TbFilmPhyPath.Text = dr["filePhypath"].ToString(); uppath.Value = dr["filefolder"].ToString(); Rb_AllowDown.Text = dr["AllowDown"].ToString(); Rb_Showtype.Text = dr["showType"].ToString(); Tb_SearchKey.Text = dr["SearchKey"].ToString(); img_pic.Src = "..\\film_poster\\" + dr["film_pic"].ToString(); //显示详细集数 strqry = string.Format("select * From T_Film_detail where filmid={0} order by id asc", id); string strDetail = ""; DataView dv = DBFun.GetDataView(strqry); for (int i = 0; i < dv.Table.Rows.Count; i++) { strDetail += "第" + (i + 1) + "集:<input type=text name=urla" + (i + 1) + " size=60 value=" + dv.Table.Rows[i]["filename"].ToString() + ">"; strDetail += " <a href=film_edit.aspx?Action=Delete&ID=" + dv.Table.Rows[i]["id"].ToString() + "&PID=" + id + ">删除</a><br/>"; } Label2.Text = strDetail; //InnerHtml = strDetail; } if (Action == "Delete" && id != null) { strqry = string.Format("Delete From [T_film_detail] where id={0}", id); DBFun.ExecuteSql(strqry); strqry = string.Format("Update [T_films] set film_num=film_num-1,filmupdatetime=#{1}# where id={0}", pid, DateTime.Now.ToString()); DBFun.ExecuteSql(strqry); Response.Redirect("film_edit.aspx?Action=Edit&ID=" + pid); } } }
protected void Page_Load(object sender, EventArgs e) { //加载 CommFun.IsAdmin(); strqry = ""; if (!IsPostBack) { strqry = "select * From T_Class"; dwclass.DataSource = DBFun.GetDataView(strqry); dwclass.DataTextField = "caption"; dwclass.DataValueField = "id"; dwclass.DataBind(); dw_NewClass.DataSource = dwclass.DataSource; dw_NewClass.DataTextField = "caption"; dw_NewClass.DataValueField = "id"; dw_NewClass.DataBind(); ListItem lt = new ListItem(); lt.Text = "--请选择--"; lt.Value = "0"; dwclass.Items.Add(lt); dwclass.Text = "0"; strqry = "Select id,caption From T_Path order by id desc"; DBFun.FillDwList(dw_ServerList, strqry); dw_ServerList.Items.Add(new ListItem("--请选择--", "0")); dw_ServerList.Text = "0"; strqry = "select * From T_films order by id desc"; if (Request.QueryString["FilmisSeq"] == "1") { //连载中 strqry = "select * From T_films where filmisseq=1 order by id desc"; } Session["strqry"] = strqry; //绑定数据 dvlist = DBFun.GetDataView(strqry); AspNetPager1.RecordCount = dvlist.Table.Rows.Count; Cache.Insert("dvlist", (DataView)dvlist, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(0, 5, 0)); bindData(); } else { //回发 string ctrlname = Page.Request.Params.Get("__EVENTTARGET"); if (ctrlname.IndexOf("dw") != -1) { //是由dropdwonlist 引发的 strqry = "select * From T_films where 1=1"; string filter = ""; if (dwclass.Text != "0") { filter += (" and film_classid=" + dwclass.Text); } if (dwfrom.Text != "0") { filter += (" and film_from = " + dwfrom.Text); } if (dwseecount.Text != "0") { filter += (" and see_count<=" + dwseecount.Text); } if (dw_ServerList.Text != "0") { filter += (" and pathid=" + dw_ServerList.Text); } if (dw_jointime.Text != "0") { filter += string.Format(" and join_time>=DateAdd('m',-{0},date())", dw_jointime.Text); } filter += " order by id desc"; strqry += filter; Session["strqry"] = strqry; dvlist = DBFun.GetDataView(strqry); AspNetPager1.RecordCount = dvlist.Table.Rows.Count; Cache["dvlist"] = dvlist; bindData(); } } }