protected void Page_Load(object sender, EventArgs e) { // 在此处放置用户代码以初始化页面 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_date desc"; string ST_top_sql = "select top 10 * from ST_news order by ST_n_hit desc"; string personindex = "select top 10* from ST_news order by ST_n_id desc"; string TitleClass = "select ST_c_id, ST_c_name from ST_class order by ST_date desc"; DataSet ST_classds = myobj.GetDataSet(TitleClass, "ST_class"); DataSet ST_cmdds = myobj.GetDataSet(ST_cmd_sql, "ST_news"); DataSet ST_topds = myobj.GetDataSet(ST_top_sql, "ST_news"); DataSet mypersonds = myobj.GetDataSet(personindex, "ST_class"); //绑定博客文章类型列表 ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); //绑定推荐文章列表 CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //绑定热点文章列表 TopList.DataSource = new DataView(ST_topds.Tables[0]); TopList.DataBind(); //绑定最新个人最新发表的博客文章 ClassList0.DataSource = new DataView(mypersonds.Tables[0]); ClassList0.DataBind(); if (Request.QueryString["c_id"] == null) { person_BindData(); } else { NewsBlogList_Bind(); } if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFFFFF"; ST_tcolor = "#cccccc"; } Page.DataBind(); string rd = DateTime.Now.Ticks.ToString(); str = "imgFile/1.jpg?rd=" + rd + "|imgFile/2.jpg?rd=" + rd + "|imgFile/3.jpg?rd=" + rd + "|imgFile/4.jpg?rd=" + rd + ""; string path = Server.MapPath("./") + "imgFile/LoopId.txt"; loopId = File.ReadAllText(path); loopId = loopId.Replace(',', '|'); }
protected void GetShift(object sender, EventArgs e) { if (IsPostBack) { string shift = ShiftList.SelectedItem.ToString(); Session["Shift"] = shift; string currentyear = DateTime.Now.Year.ToString(); ClassErr.Visible = false; CourseErr.Visible = false; TeacherErr.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); string query = "Select * from ClassTable where DId='" + Session["AccountId"].ToString() + "' and Year='" + currentyear + "' and Shift='" + Session["Shift"] + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); ClassList.DataSource = dt; ClassList.DataBind(); ClassList.DataTextField = "ClassName"; ClassList.DataValueField = "ClassId"; ClassList.DataBind(); ClassList.Items.Insert(0, new ListItem("Select", "NA")); Section.Text = dt.Rows[0][2].ToString(); con.Close(); } } }
private void LoadData() { if (ClassList.Items.Count > 0) { ClassList.Items.Clear(); } SortedList list = new SortedList(); foreach (MetaClass mc in DataContext.Current.MetaModel.MetaClasses) { if (!mc.IsBridge && !mc.IsCard && !String.IsNullOrEmpty(mc.TitleFieldName)) { string name = mc.Name; string friendlyName = CHelper.GetResFileString(mc.FriendlyName); string text = name; if (name != friendlyName) { text = String.Format(CultureInfo.InvariantCulture, "{0} ({1})", friendlyName, name); } list.Add(text, name); } } ClassList.DataSource = list; ClassList.DataTextField = "key"; ClassList.DataValueField = "value"; ClassList.DataBind(); }
public void TitleClass(string sqlstr) { SqlConnection myconn = new SqlConnection(ConfigurationSettings.AppSettings["ConStr"].ToString()); myconn.Open(); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, myconn); DataSet myds = new DataSet(); myda.Fill(myds); ClassList.DataSource = new DataView(myds.Tables[0]); ClassList.DataBind(); }
//加载文章类型的信息 public void ST_Type_List_Bind() { string sqlstr = "select * from ST_class order by ST_date desc "; //调用公共类中的ExceDS()方法,用来返回一个DataSet类型 My_sqldata.ExceDS(sqlstr); //获取数据表中的主键字段 ClassList.DataKeyNames = new string[] { "ST_c_id" }; ClassList.DataSource = My_sqldata.ExceDS(sqlstr); ClassList.DataBind(); }
protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (IsSafe(Request.QueryString["id"], 2) == false) { Response.Write("非法参数,<a href=BlogIndex.aspx>点此返回</a>"); Response.End(); } string ST_dns = ConfigurationSettings.AppSettings["conStr"]; string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + ""; //最新推荐文章 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_id desc"; ST_myConn = new SqlConnection(ST_dns); SqlDataAdapter ST_myCmd = new SqlDataAdapter(ST_sql, ST_myConn); SqlDataAdapter ST_classCmd = new SqlDataAdapter("select ST_c_id,ST_c_name from ST_class", ST_myConn); SqlDataAdapter ST_cmdCmd = new SqlDataAdapter(ST_cmd_sql, ST_myConn); DataSet ST_ds = new DataSet(); ST_myCmd.Fill(ST_ds, "新闻查看"); DataSet ST_classds = new DataSet(); ST_classCmd.Fill(ST_classds, "类别列表"); DataSet ST_cmdds = new DataSet(); ST_cmdCmd.Fill(ST_cmdds, "推荐文章"); NewsShow.DataSource = ST_ds.Tables[0]; NewsShow.DataBind(); ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //调用ST_UpdateHit()方法 ST_UpdateHit(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new char[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFDE94"; ST_tcolor = "#efe3ce"; } Page.DataBind(); }
public void BindClassDropdown() { string command = "Select ClassId, ClassName from class order by ClassName"; DataTable ClassTable = new DataTable(); ClassTable = DataService.GetDataWithoutParameter(command); ClassList.DataValueField = "ClassId"; ClassList.DataTextField = "ClassName"; ClassList.DataSource = ClassTable; ClassList.DataBind(); ClassList.Items.Insert(0, new ListItem("--- Select Class ---", "0")); }
public void CategoriesDatabind() { DataSet CategoriesList = AccountsTool.GetAllCategories(); ClassList.DataSource = CategoriesList; ClassList.DataTextField = "Description"; ClassList.DataValueField = "CategoryID"; ClassList.DataBind(); droplistCategories.DataSource = CategoriesList; droplistCategories.DataTextField = "Description"; droplistCategories.DataValueField = "CategoryID"; droplistCategories.DataBind(); droplistCategories.Items.Insert(0, new ListItem("移动到...", "")); }
protected void Page_Load(object sender, EventArgs e) { string login = Session["Log"].ToString(); if (!Page.IsPostBack) { using (var db = new hackerEntities()) { //分类 ClassList.DataSource = db.VideoClass.ToList(); ClassList.DataValueField = "id"; ClassList.DataTextField = "name"; ClassList.DataBind(); //ClassList.Items.Insert(0, new ListItem("请选择一个分类", "0")); } } }
protected void Page_Load(object sender, EventArgs e) { // 在此处放置用户代码以初始化页面 if (IsSafe(Request.QueryString["id"], 2) == false) { Response.Write("错误页面,<a href=BlogIndex.aspx>点此返回</a>"); Response.End(); } string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + ""; //最新推荐文章 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_id desc"; string sqlstr = "select ST_c_id,ST_c_name from ST_class"; DataSet ST_ds = myobj.GetDataSet(ST_sql, "ST_news"); DataSet ST_classds = myobj.GetDataSet(sqlstr, "ST_class"); DataSet ST_cmdds = myobj.GetDataSet(ST_cmd_sql, "ST_news"); NewsShow.DataSource = ST_ds.Tables[0]; NewsShow.DataBind(); ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //调用ST_UpdateHit()方法 ST_UpdateHit(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFFFFF"; ST_tcolor = "#cccccc"; } Page.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //初始化页面 string ST_dns = ConfigurationSettings.AppSettings["conStr"]; //最新推荐文章 string ST_cmd_sql = "select top 10 * from news where ST_n_iscmd=1 order by n_date desc"; SqlConnection ST_myConn = new SqlConnection(ST_dns); //定义并初始化命令对象 SqlDataAdapter ST_classCmd = new SqlDataAdapter("select n_classid, classname from class", ST_myConn); SqlDataAdapter ST_cmd_Cmd = new SqlDataAdapter(ST_cmd_sql, ST_myConn); //创建一个dataset数据集 DataSet ST_classds = new DataSet(); ST_classCmd.Fill(ST_classds, "类别列表"); DataSet ST_cmdds = new DataSet(); ST_cmd_Cmd.Fill(ST_cmdds, "推荐文章"); ClassList.DataSource = new DataView(ST_classds.Tables[0]); //绑定文章类型列表 ClassList.DataBind(); cmdList.DataSource = new DataView(ST_cmdds.Tables[0]); cmdList.DataBind(); //绑定最新博客列表 NewsList_Bind(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; string[] ST_colorList = ST_test.Split(new char[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFDE94"; ST_tcolor = "#EFE3CE"; } Page.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // 在此处放置用户代码以初始化页面 string ST_dns = ConfigurationSettings.AppSettings["conStr"]; //最新推荐文章 string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_date desc"; ST_myConn = new SqlConnection(ST_dns); SqlDataAdapter ST_classCmd = new SqlDataAdapter("select ST_c_id, ST_c_name from ST_class ", ST_myConn); SqlDataAdapter ST_cmdCmd = new SqlDataAdapter(ST_cmd_sql, ST_myConn); DataSet ST_classds = new DataSet(); ST_classCmd.Fill(ST_classds, "类别列表"); DataSet ST_cmdds = new DataSet(); ST_cmdCmd.Fill(ST_cmdds, "推荐文章"); ClassList.DataSource = new DataView(ST_classds.Tables[0]); ClassList.DataBind(); CmdList.DataSource = new DataView(ST_cmdds.Tables[0]); CmdList.DataBind(); //调用自定义NewsBlogList_Bind方法 NewsBlogList_Bind(); if (Request.Cookies["colors"] != null) { string ST_test = Request.Cookies["colors"].Value; String[] ST_colorList = ST_test.Split(new char[] { ',' }); ST_bgcolor = ST_colorList[0]; ST_tcolor = ST_colorList[1]; } else { ST_bgcolor = "#FFDE94"; ST_tcolor = "#efe3ce"; } Page.DataBind(); }
private void EditClick(object sender, EventArgs e) { PnlMain.Visible = true; // ShowTTForm.Visible = false; string temp = ((LinkButton)sender).ID.ToString(); Session["TTId"] = temp; if (Page.IsPostBack) { string[] classInfo = new string[2]; string[] courseInfo = new string[2]; string q = "Select * from TimeTable where Id='" + temp + "'"; con.Open(); SqlCommand com = new SqlCommand(q, con); SqlDataReader dr = com.ExecuteReader(); dr.Read(); if (dr.HasRows) { classInfo = GetClassInfo(dr["ClassId"].ToString()); //ShiftList.SelectedValue = classInfo[1]; ShiftList.SelectedIndex = ShiftList.Items.IndexOf(ShiftList.Items.FindByText(classInfo[1])); Section.Text = classInfo[2]; courseInfo = GetCourseInfo(dr["CourseId"].ToString()); CourseList.SelectedIndex = CourseList.Items.IndexOf(CourseList.Items.FindByText(courseInfo[1])); Session["courseId"] = CourseList.SelectedValue; //CourseList.SelectedItem.Text = courseInfo[1]; //TeacherList.SelectedItem.Text = GetTeacherInfo(dr["TId"].ToString()); string Tname = GetTeacherInfo(dr["TId"].ToString()); TeacherList.SelectedIndex = TeacherList.Items.IndexOf(TeacherList.Items.FindByText(Tname)); Session["TeacId"] = TeacherList.SelectedValue; STime.Text = dr["STime"].ToString(); ETime.Text = dr["ETime"].ToString(); RoomNo.Text = dr["ClassRoomNo"].ToString(); SemesterList.SelectedValue = dr["SemesterNo"].ToString(); DaysList.SelectedValue = dr["Day"].ToString(); Tname = GetTeacherInfo(dr["AId"].ToString()); if (!dr["AId"].Equals("0")) { AssDiv.Visible = true; AssErr.Visible = false; string query2 = "Select * from Teacher where Department='" + Session["AccountId"].ToString() + "'"; con.Close(); con.Open(); SqlDataAdapter sda2 = new SqlDataAdapter(query2, con); DataTable dt2 = new DataTable(); sda2.Fill(dt2); AssisTeacherList.DataSource = dt2; AssisTeacherList.DataBind(); AssisTeacherList.DataTextField = "TName"; AssisTeacherList.DataValueField = "TId"; AssisTeacherList.DataBind(); AssisTeacherList.Items.Insert(0, new ListItem("Select", "NA")); AssisTeacherList.SelectedIndex = AssisTeacherList.Items.IndexOf(AssisTeacherList.Items.FindByText(Tname)); Session["AssisId"] = AssisTeacherList.SelectedValue; con.Close(); } else { AssDiv.Visible = false; AssErr.Visible = false; } using (SqlConnection con = new SqlConnection(conString)) { con.Close(); string currentyear = DateTime.Now.Year.ToString(); con.Open(); string query = "Select * from ClassTable where DId='" + Session["AccountId"].ToString() + "' and Year='" + currentyear + "' and Shift='" + classInfo[1] + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); ClassList.DataSource = dt; ClassList.DataBind(); ClassList.DataTextField = "ClassName"; ClassList.DataValueField = "ClassId"; ClassList.DataBind(); ClassList.Items.Insert(0, new ListItem("Select", "NA")); Section.Text = dt.Rows[0][2].ToString(); ClassList.SelectedIndex = ClassList.Items.IndexOf(ClassList.Items.FindByText(classInfo[0])); Session["classId"] = ClassList.SelectedValue; con.Close(); } } con.Close(); AddTT.Visible = false; UpdateTT.Visible = true; } //Response.Redirect("proforma.aspx"); }
protected void GetDeparmentID() { if (!IsPostBack) { string currentyear = DateTime.Now.Year.ToString(); ClassErr.Visible = false; CourseErr.Visible = false; TeacherErr.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); string query = "Select * from ClassTable where DId='" + Session["AccountId"].ToString() + "' and Year='" + currentyear + "' and Shift='" + ShiftList.SelectedItem + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); ClassList.DataSource = dt; ClassList.DataBind(); ClassList.DataTextField = "ClassName"; ClassList.DataValueField = "ClassId"; ClassList.DataBind(); ClassList.Items.Insert(0, new ListItem("Select", "NA")); Section.Text = dt.Rows[0][2].ToString(); con.Close(); con.Open(); string query1 = "Select * from Course"; SqlDataAdapter sda1 = new SqlDataAdapter(query1, con); DataTable dt1 = new DataTable(); sda1.Fill(dt1); if (!dt1.HasErrors) { } CourseList.DataSource = dt1; CourseList.DataBind(); CourseList.DataTextField = "CourseName"; CourseList.DataValueField = "CourseId"; CourseList.DataBind(); CourseList.Items.Insert(0, new ListItem("Select", "NA")); con.Close(); con.Open(); string query2 = "Select * from Teacher where Department='" + Session["AccountId"].ToString() + "'"; SqlDataAdapter sda2 = new SqlDataAdapter(query2, con); DataTable dt2 = new DataTable(); sda2.Fill(dt2); TeacherList.DataSource = dt2; TeacherList.DataBind(); TeacherList.DataTextField = "TName"; TeacherList.DataValueField = "TId"; TeacherList.DataBind(); TeacherList.Items.Insert(0, new ListItem("Select", "NA")); //AssisTeacherList.DataSource = dt2; //AssisTeacherList.DataBind(); //AssisTeacherList.DataTextField = "TName"; //AssisTeacherList.DataValueField = "TId"; //AssisTeacherList.DataBind(); //AssisTeacherList.Items.Insert(0, new ListItem("Select", "NA")); con.Close(); } // } } }