private void MyDataBind() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from [ArticleTags] where ID not in (" + Label3.Text + ") order by ID asc "; conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); cmd.CommandText = "select * from [Articles_ArticleTags] where ArticleID = @ArticleID"; cmd.Parameters.AddWithValue("@ArticleID", IDLabel.Text); SqlDataReader rd1 = cmd.ExecuteReader(); ListBox1.DataSource = rd1; ListBox1.DataTextField = "ArticleTagName"; ListBox1.DataValueField = "ArticleTagID"; ListBox1.DataBind(); rd1.Close(); } }
protected void Page_Load(object sender, EventArgs e) { RandomID.Text = Request["RandomID"]; if (!IsPostBack) { if (Session["UserID"] == null) { Util.ShowMessage("会话超期,请重新登录", "Login.aspx"); } else { using (SqlConnection conn = new DB().GetConnection()) { string userid = Convert.ToString(Session["UserID"]); string sql = "select * from UserTags order by ID desc"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } init(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string UserID = Convert.ToString(Session["UserID"]); if (Session["RoleID"] != null && !String.IsNullOrEmpty(Session["RoleID"].ToString()) && (Session["RoleID"].ToString() == "1" || Session["RoleID"].ToString() == "2")) { //ClassifyPanel.Visible = true; } else { //ClassifyPanel.Visible = false; } using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from [UserTags] where [UserID] = @UserID order by ID asc "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", UserID); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } }
private void MyDataBind() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = "select * from [CommonWord] order by ID desc "; SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "CommonWord"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } }
private void UpdateTags() { string userid = Convert.ToString(Session["UserID"]); using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from UserTags where UserID = @UserID order by ID desc"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", userid); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string UserID = Convert.ToString(Session["UserID"]); using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from [ArticleTags] where [UserID] = @UserID order by ID asc "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", UserID); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } }
// --------文章标签操作------// private void MyDataBind() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = "select * from [Medicine] order by ID desc "; SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "MedicineName"; TagsList.DataValueField = "GUID"; TagsList.DataBind(); rd.Close(); if (Request.QueryString["GUID"] != null && !String.IsNullOrEmpty(Request.QueryString["GUID"].ToString())) { string sql1 = "select count(*) as Maxrow from [Patient_Medicine] where PatientGUID=@PatientGUID"; string sql2 = "select MedicineName from [Patient_Medicine] where PatientGUID=@PatientGUID"; SqlCommand cmd1 = conn.CreateCommand(); SqlCommand cmd2 = conn.CreateCommand(); cmd1.Parameters.AddWithValue("@PatientGUID", GUIDLabel.Text); cmd2.Parameters.AddWithValue("@PatientGUID", GUIDLabel.Text); cmd1.CommandText = sql1; cmd2.CommandText = sql2; int count = int.Parse(Convert.ToString(cmd1.ExecuteScalar())); string[] TagName = new string[count]; SqlDataReader rd2 = cmd2.ExecuteReader(); for (int j = 0; j < count; j++) { if (rd2.Read()) { TagName[j] = rd2["MedicineName"].ToString(); for (int p = 0; p < TagsList.Items.Count; p++) { if (TagName[j] == TagsList.Items[p].Text) { TagsList.Items[p].Selected = true; // TextBox2.Text = TagsList.Items[p].Text; } } } } rd2.Close(); } // --------字段名称设置------// cmd.CommandText = "select * from PatientText where GUID=@GUID"; cmd.Parameters.AddWithValue("@GUID", Session["HospitalGUID"].ToString() + "p"); rd = cmd.ExecuteReader(); if (rd.Read()) { Label1.Text = rd["PatientName"].ToString(); Label2.Text = rd["Initials"].ToString(); Label3.Text = rd["Sex"].ToString(); Label5.Text = rd["Birthday"].ToString(); Label6.Text = rd["Department"].ToString(); Label7.Text = rd["Num1"].ToString(); Label8.Text = rd["Num2"].ToString(); Label9.Text = rd["Phone1"].ToString(); Label10.Text = rd["Phone2"].ToString(); Label11.Text = rd["EducationYears"].ToString(); Label12.Text = rd["EducationLevel"].ToString(); Label13.Text = rd["Handedness"].ToString(); Label14.Text = rd["Marriage"].ToString(); Label15.Text = rd["FMH"].ToString(); Label16.Text = rd["Working"].ToString(); Label17.Text = rd["Ethnicity"].ToString(); Label18.Text = rd["Career"].ToString(); Label19.Text = rd["AI"].ToString(); Label20.Text = rd["AHI"].ToString(); Label21.Text = rd["GrowingPlace"].ToString(); Label22.Text = rd["Residence"].ToString(); } rd.Close(); conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (Session["RoleID"] == null || Session["UserID"] == null) { Util.ShowMessage("用户登录超时,请重新登录!", "Login2.aspx"); } else if (RoleID > 1) { Util.ShowMessage("您没有访问该页面的权限!", "Login2.aspx"); } else { if (Request.QueryString["ID"] != null) { IDSLabel.Text = Request.QueryString["ID"]; string[] array = IDSLabel.Text.Split(','); int t = array.Length; Label6.Text = t.ToString(); using (SqlConnection conn = new DB().GetConnection()) { string userid = Convert.ToString(Session["UserID"]); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select distinct RoleName as RoleName from Roles"; conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); RoleTypeDDL.DataSource = rd; RoleTypeDDL.DataValueField = "RoleName"; RoleTypeDDL.DataTextField = "RoleName"; RoleTypeDDL.DataBind(); rd.Close(); RoleTypeDDL.Items.Insert(0, new ListItem("角色类型", "")); cmd.CommandText = "select * from UserTags where ID in (" + IDSLabel.Text + ") order by ID desc"; rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); cmd.CommandText = "select count(*) as maxrow from [Users_UserTags] where UserTagID=@TagID1"; cmd.Parameters.AddWithValue("@TagID1", IDSLabel.Text); SqlDataReader rd1 = cmd.ExecuteReader(); if (rd1.Read()) { count.Text = rd1["maxrow"].ToString(); } rd1.Close(); string s = ""; int i = Convert.ToInt32(count.Text); string[] UserID = new string[i]; cmd.CommandText = "select * from [Users_UserTags] where UserTagID in (" + IDSLabel.Text + ")"; SqlDataReader rd2 = cmd.ExecuteReader(); if (i != 0) { for (int j = 0; j < i; j++) { if (rd2.Read()) { UserID[j] = rd2["UserID"].ToString(); for (int k = 0; k < i; k++) { s = string.Join(",", UserID); UserIDs.Text = s; } } } } else { int s1 = 0; UserIDs.Text = s1.ToString(); } rd2.Close(); MyDataBind2(); } } for (int i = 0; i <= TagsList.Items.Count - 1; i++) { TagsList.Items[i].Selected = true; } } } }