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;
}
}
}
}