protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Session["UserID"] == null)
//{
// Util.ShowMessage("用户登录超时，请重新登录！", "Login.aspx");
//}
//else
//{
//}
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T19 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位。同时四舍五入
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
}
}
}
protected void DelButton_Click(object sender, EventArgs e)
{
string IC = "";
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
IC = Util.AESDecrypt(rd["IDCard"].ToString());
}
rd.Close();
conn.Close();
if (IDCard.Text.Trim() == IC)
{
Del();
}
else
{
ResultLabel.Text = "身份证号输入错误！";
ResultLabel.ForeColor = System.Drawing.Color.Red;
}
}
}
private void MyInit()
{
HospitalGUID.Text = Session["HospitalGUID"].ToString();
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
conn.Open();
SqlDataReader rd;
cmd.CommandText = "select * from [Hospital] where [GUID] = @HospitalGUID";
cmd.Parameters.AddWithValue("@HospitalGUID", HospitalGUID.Text);
rd = cmd.ExecuteReader();
if (rd.Read())
{
Image1.ImageUrl = rd["Avatar"].ToString();
HospitalName.Text = rd["HospitalName"].ToString();
Introduction.Text = rd["Introduction"].ToString();
}
rd.Close();
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T13 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);
RS1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
RS2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 0);
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
}
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
if (IsAdmin == "True")
{
e.Row.Cells[6].Visible = true;
}
else
{
e.Row.Cells[6].Visible = false;
}
conn.Close();
}
}
async protected Task <AuthUser> GetUserByToken(string token)
{
var data = Util.AESDecrypt(token, Encoding.UTF8.GetBytes(Configuration["login_aes:key"]), Encoding.UTF8.GetBytes(Configuration["login_aes:iv"])); //解密
var at = JsonConvert.DeserializeObject <(int UserId, Guid RandomId, long LoginTime)>(data);
var user = await AuthUser.FindAsync(at.UserId);
if (user.Status == AuthUserStatus.禁用)
{
return(null);
}
//if (user?.LoginTime.GetTime() != at.LoginTime) user = null;
//验证 token 内的登陆时间，与实际的登陆时间，不相等的话等于 token 失效
return(user);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["DoctorGUID"] == null)
{
Util.ShowMessage("用户登录超时，请重新登录！", "../Login.aspx");
Response.End();
}
else
{
string IsAdmin = "";
DoctorGUID.Text = Session["DoctorGUID"].ToString();
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", DoctorGUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
DoctorName.Text = rd["DoctorName"].ToString();
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
conn.Close();
}
if (IsAdmin == "True")
{
AdminUser.Visible = true;
}
else
{
AdminUser.Visible = false;
}
string Hash = Util.GetSuperPassword();
if ((string)Session["Super"] == Hash)
{
Super.Visible = true;
}
else
{
Super.Visible = false;
}
}
}
}
private void decodeNotifyData(byte[] encryptData)
{
uint encryptAlgo = Util.ReadProtoInt(encryptData, 1);
uint compressAlgo = Util.ReadProtoInt(encryptData, 4);
byte[] cipherText = Util.ReadProtoRawData(encryptData, 8);
if (encryptAlgo == 5)
{
int Salt = (int)Util.ReadProtoInt(encryptData, 3);
byte[] sencryptSalt = TLVUtil.int2byte(Salt, 4, false);
byte[] sessionKey = SessionPackMgr.getAccount().SessionKey;
byte[] decodeKey = new byte[20];
Buffer.BlockCopy(sessionKey, 0, decodeKey, 0, 16);
Buffer.BlockCopy(sencryptSalt, 0, decodeKey, 16, sencryptSalt.Length);
byte[] decodeAesKey = MD5Core.GetHash(decodeKey);
// Log.w("Network", string.Concat(new object[] { "encode notify salt ", Util.byteToHexStr(sencryptSalt), "SessionKey ", Util.byteToHexStr(sessionKey), "decode Key ", Util.byteToHexStr(decodeAesKey) }));
byte[] decryptedData = Util.AESDecrypt(cipherText, decodeAesKey);
if (compressAlgo == 1)
{
Zlib.Decompress(decryptedData, decryptedData.Length, ref decryptedData);
}
Log.w("Network", string.Concat(new object[] { "decode notify result ", Util.byteToHexStr(decryptedData) }));
cipherText = Util.ReadProtoRawData(decryptedData, 1);
cipherText = Util.ReadProtoRawData(cipherText, 1);
string ChatRoomId = Encoding.UTF8.GetString(cipherText);
// uint newMsgid = Util.ReadProtoInt(decryptedData, 2);
uint newMsgSeq = Util.ReadProtoInt(decryptedData, 3);
cipherText = Util.ReadProtoRawData(decryptedData, 6);
cipherText = Util.ReadProtoRawData(cipherText, 1);
string Contact = Encoding.UTF8.GetString(cipherText);
uint msgType = Util.ReadProtoInt(decryptedData, 8);
Log.w("Network", string.Concat(new object[] { "decode notify data ", " ChatRoomId ", ChatRoomId, " newMsgSeq ", newMsgSeq, "MsgType ", msgType, " Contact ", Contact }));
new NetSceneGetChatRoomMsg().doScene(ChatRoomId, newMsgSeq);
}
}
protected void InitBtn_Click(object sender, EventArgs e)
{
int i = 0;
if (Licenses.Text != "")
{
string str = "GZKZYL_201";
Licenses.Text = str + Licenses.Text;
}
using (SqlConnection conn = new DB().GetConnection())
{
string sql = "Update [Hospital] set Licenses=@Licenses";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Licenses", Util.AESEncrypt(Licenses.Text));
conn.Open();
i = cmd.ExecuteNonQuery();
conn.Close();
}
if (i == 1)
{
ErrorLabel.Text = "授权登录数更新成功！";
Licenses.Text = "";
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Hospital where GUID=@HGUID";
cmd.Parameters.AddWithValue("@HGUID", Session["HospitalGUID"]);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
Licensesnum.Text = Util.AESDecrypt(rd["Licenses"].ToString());
Licensesnum.Text = Licensesnum.Text.Substring(10, Licensesnum.Text.Length - 10);
}
rd.Close();
conn.Close();
}
}
else
{
ErrorLabel.Text = "授权登录数更新失败，请重试！";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec = 0;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T10 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 2) * 100;
RawScore.Text = dec.ToString() + "%";
}
rd.Close();
conn.Close();
}
if (Convert.ToInt16(dec) <= 60)
{
Explain.Text = "低等水平";
}
else if (Convert.ToInt16(dec) > 60 && Convert.ToInt16(dec) < 80)
{
Explain.Text = "中等水平";
}
else
{
Explain.Text = "高等水平";
}
Explain.Text += "；得分指标越高，自我效能水平越高。";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Super"] == null)
{
Util.ShowMessage("用户登录超时，请重新登录！", "Login.aspx");
Response.End();
}
else
{
string Hash = Util.GetSuperPassword();
if (Session["Super"].ToString() != Hash)
{
Util.ShowMessage("密码错误，请重新登录！", "Login.aspx");
Response.End();
}
}
}
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Hospital where GUID=@HGUID";
cmd.Parameters.AddWithValue("@HGUID", Session["HospitalGUID"]);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
Licensesnum.Text = Util.AESDecrypt(rd["Licenses"].ToString());
Licensesnum.Text = Licensesnum.Text.Substring(10, Licensesnum.Text.Length - 10);
}
rd.Close();
conn.Close();
}
}
private void MyInit()
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Doctor order by ID desc;";
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
DoctorDDL.DataSource = rd;
DoctorDDL.DataValueField = "GUID";
DoctorDDL.DataTextField = "DoctorName";
DoctorDDL.DataBind();
rd.Close();
DoctorDDL.Items.Insert(0, new ListItem("按医生分类", "-1"));
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
if (IsAdmin == "True")
{
DelBtn.Visible = true;
}
else
{
DelBtn.Visible = false;
}
conn.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int j = 0, flag = 0, print = 0;
Hashtable hs = new Hashtable();
System.Guid guid = System.Guid.NewGuid();
string strGUID = System.Guid.NewGuid().ToString();
string CDT = DateTime.Now.ToString();
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = " ";
for (int i = 1; i <= 28; i++)
{
if (Request.Form["" + i + ""] != null && i != 15)
{
cmd.CommandText += "select RawScore from T" + i + " where GUID=@GUID" + i + ";";
cmd.Parameters.AddWithValue("@GUID" + i + "", Request["" + i + ""].ToString());
}
}
if (cmd.CommandText == " ")
{
Response.Write(" <script> alert(\"该病人未做过测试，无法打印报告单！\");;window.location='Test_Select.aspx?GUID=" + Request.QueryString["GUID"].ToString() + "'; </script> ");
}
else
{
print = 1;
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
do
{
if (rd.Read())
{
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));//获取查询的结果
}
else
{
hs[j] = "0";//如果没有，则赋值为0
}
j++;
} while (rd.NextResult());
rd.Close();
conn.Close();
}
}
if (print == 1)
{
//***插入数据库***
//动态生成数组
ArrayList fields = new ArrayList();//字段数组
fields.Add("GUID"); fields.Add("PatientGUID"); fields.Add("PatientName"); fields.Add("CDT"); fields.Add("DoctorGUID"); fields.Add("DoctorName");
ArrayList values = new ArrayList();//插入值数组（务必与字段数组的添加顺序一样）
values.Add(strGUID); values.Add(GUID.Text); values.Add(Patient.Text); values.Add(CDT); values.Add(DoctorGUID.Text); values.Add(DoctorName.Text);
j = 0;
for (int i = 1; i <= 28; i++)
{
if (Request.Form["" + i + ""] != null && i != 15)
{
fields.Add("T" + i + "Score");
values.Add(hs[j]);
j++;
}
}
if (Request.Form["2"] != null)
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T2 where GUID=@T2GUID";
cmd.Parameters.AddWithValue("@T2GUID", Request["2"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
fields.Add("T2ScoreRS1");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
fields.Add("T2ScoreRS2");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
fields.Add("T2ScoreRS3");
values.Add(hs[j]);
j++;
}
rd.Close();
conn.Close();
}
}
if (Request.Form["7"] != null)
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T7 where GUID=@T7GUID";
cmd.Parameters.AddWithValue("@T7GUID", Request["7"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
fields.Add("T7ScoreRS1");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
fields.Add("T7ScoreRS2");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
fields.Add("T7ScoreRS3");
values.Add(hs[j]);
j++;
}
rd.Close();
conn.Close();
}
}
if (Request.Form["8"] != null)
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T8 where GUID=@T8GUID";
cmd.Parameters.AddWithValue("@T8GUID", Request["8"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
fields.Add("T8ScoreRS1");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
fields.Add("T8ScoreRS2");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
fields.Add("T8ScoreRS5");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
fields.Add("T8ScoreRS6");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS5"].ToString()));
fields.Add("T8ScoreRS34");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS6"].ToString()));
fields.Add("T8ScoreRS7");
values.Add(hs[j]);
j++;
}
rd.Close();
conn.Close();
}
}
if (Request.Form["15"] != null)
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T15 where GUID=@T15GUID";
cmd.Parameters.AddWithValue("@T15GUID", Request["15"].ToString());
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
fields.Add("T15ScoreRS1");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
fields.Add("T15ScoreRS2");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
fields.Add("T15ScoreRS3");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
fields.Add("T15ScoreRS4");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RS5"].ToString()));
fields.Add("T15ScoreRS5");
values.Add(hs[j]);
j++;
hs[j] = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore2"].ToString()));
fields.Add("T15Score");
values.Add(hs[j]);
j++;
}
rd.Close();
conn.Close();
}
}
//调用Util中写好的函数将值插入数据库
flag = Util.InsertDatabase("Report", fields, values, fields.Count);
if (flag == 1)
{
Response.Write(" <script> alert(\"成功提交！\");;window.location='Report.aspx?TGUID=" + strGUID + "'; </script> ");
}
else
{
Response.Write(" <script> alert(\"提交失败！请重试或关闭页面。\"); </script> ");
}
}
}
private void MyDataBind()
{
AspNetPager1.PageSize = Convert.ToInt16(PageSizeDDL.SelectedValue);
string param = SearchTB.Text;
StringBuilder whereStr = new StringBuilder(" where 1= 1 ");
if (!String.IsNullOrEmpty(param))
{
whereStr.Append(" and [Department] like '%").Append(Server.HtmlEncode(param.Trim().Replace("'", ""))).Append("%' ");
}
string sql = "select count(ID) as total from Department " + whereStr.ToString();
using (SqlConnection conn = (SqlConnection) new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
AspNetPager1.RecordCount = Convert.ToInt16(rd[0]);
}
else
{
AspNetPager1.RecordCount = 0;
}
rd.Close();
Label1.Text = AspNetPager1.RecordCount + ""; //总记录数
Label2.Text = (AspNetPager1.RecordCount / AspNetPager1.PageSize) + 1 + ""; //总页数
if (AspNetPager1.CurrentPageIndex == 1)
{
sql = "Select top " + AspNetPager1.PageSize + " * from Department " + whereStr.ToString() + " " + OrderDDL.SelectedValue;
}
else
{
// Select Top 页容量 * from 表 where 条件 and id not in (Select Top 页容量*（当前页数-1） id from 表 where 条件 order by 排序条件) order by 排序条件
sql = "Select top " + AspNetPager1.PageSize + " * from Department " + whereStr.ToString() + " and id not in ( select top " + AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1) + " id from Department " + whereStr.ToString() + " " + OrderDDL.SelectedValue + " ) " + OrderDDL.SelectedValue;
//sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER ( " + orderStr + ") AS MyRank,* FROM Article " + whereStr +" ) AS Rank " + whereStr + " and MyRank BETWEEN " +AspNetPager1.StartRecordIndex+" AND "+ (AspNetPager1.StartRecordIndex+AspNetPager1.PageSize-1) +orderStr;
}
//TestLabel.Text = sql;
cmd.CommandText = sql;
rd = cmd.ExecuteReader();
GridView1.DataSource = rd;
GridView1.DataBind();
rd.Close();
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
if (IsAdmin == "True")
{
DelAr.Visible = true;
}
else
{
DelAr.Visible = false;
}
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["DoctorGUID"] == null)
{
Util.ShowMessage("用户登录超时，请重新登录！", "Login.aspx");
Response.End();
}
else
{
DoctorGUID.Text = Convert.ToString(Session["DoctorGUID"]);
if (Request.QueryString["GUID"] != null)
{
DoctorGUID.Text = Request.QueryString["GUID"].ToString();
}
using (SqlConnection conn = new DB().GetConnection())
{
string sql = "Select * from Department order by ID asc";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
DepartmentDDL.DataSource = rd;
DepartmentDDL.DataTextField = "Department";
DepartmentDDL.DataValueField = "GUID";
DepartmentDDL.DataBind();
rd.Close();
cmd.CommandText = "select * from Doctor where GUID=@DoctorGUID";
cmd.Parameters.AddWithValue("@DoctorGUID", DoctorGUID.Text);
rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
DoctorName.Text = rd["DoctorName"].ToString();
IDCard.Text = Util.AESDecrypt(rd["IDCard"].ToString());
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
if (IDCard.Text.Length > 3)
{
IDC.Text = IDCard.Text.Substring(0, 3) + "**********";
}
else
{
IDC.Text = "**********";
}
if (IsAdmin == "True")
{
UpdateBtn.Visible = true;
RolePanel.Visible = true;
Role2.Checked = true;
}
else
{
UpdateBtn.Visible = false;
RolePanel.Visible = false;
Role1.Checked = true;
}
Phone.Text = rd["Phone"].ToString();
EmployeeNum.Text = rd["EmployeeNum"].ToString();
string DepartmentGUID = rd["DepartmentGUID"].ToString();
if (DepartmentDDL.Items.FindByValue(DepartmentGUID) != null)
{
DepartmentDDL.ClearSelection();
DepartmentDDL.Items.FindByValue(DepartmentGUID).Selected = true;
}
}
rd.Close();
conn.Close();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Session["UserID"] == null)
//{
// Util.ShowMessage("用户登录超时，请重新登录！", "Login.aspx");
//}
//else
//{
//}
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T16 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
RS2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS3.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
dec = Math.Round(dec, 0);
RS4.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS5"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS5.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS6"].ToString()));
dec = Math.Round(dec, 0);
RS6.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS7"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS7.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C1"].ToString()));
dec = Math.Round(dec, 0);
C1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T1"].ToString()));
dec = Math.Round(dec, 0);
T1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C2"].ToString()));
dec = Math.Round(dec, 0);
C2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T2"].ToString()));
dec = Math.Round(dec, 0);
T2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C3"].ToString()));
dec = Math.Round(dec, 0);
C3.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T3"].ToString()));
dec = Math.Round(dec, 0);
T3.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C4"].ToString()));
dec = Math.Round(dec, 0);
C4.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T4"].ToString()));
dec = Math.Round(dec, 0);
T4.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C5"].ToString()));
dec = Math.Round(dec, 0);
C5.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T5"].ToString()));
dec = Math.Round(dec, 0);
T5.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C6"].ToString()));
dec = Math.Round(dec, 0);
C6.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T6"].ToString()));
dec = Math.Round(dec, 0);
T6.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C7"].ToString()));
dec = Math.Round(dec, 0);
C7.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T7"].ToString()));
dec = Math.Round(dec, 0);
T7.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C8"].ToString()));
dec = Math.Round(dec, 0);
C8.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T8"].ToString()));
dec = Math.Round(dec, 0);
T8.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["C9"].ToString()));
dec = Math.Round(dec, 0);
C9.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["T9"].ToString()));
dec = Math.Round(dec, 0);
T9.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 2);
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
}
}
}
private void MyInit()
{
HospitalGUID.Text = Session["HospitalGUID"].ToString();
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Doctor order by ID desc;";
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
DoctorDDL.DataSource = rd;
DoctorDDL.DataValueField = "GUID";
DoctorDDL.DataTextField = "DoctorName";
DoctorDDL.DataBind();
rd.Close();
DoctorDDL.Items.Insert(0, new ListItem("按医生分类", "-1"));
/*
* cmd.CommandText = "select count(*) as maxrow from [Patient] ";
* rd = cmd.ExecuteReader();
* if (rd.Read())
* {
* PatientNum.Text = rd["maxrow"].ToString();
* }
* rd.Close();
*
*
* cmd.CommandText = "select count(*) as maxrow from [TSView] where IsDel=0";
* rd = cmd.ExecuteReader();
* if (rd.Read())
* {
* TestNum.Text = rd["maxrow"].ToString();
* }
* rd.Close();
*
* cmd.CommandText = "select count(*) as maxrow from [Report] where IsDel=0";
* rd = cmd.ExecuteReader();
* if (rd.Read())
* {
* ReportNum.Text = rd["maxrow"].ToString();
* }
* rd.Close();
*
* cmd.CommandText = "select * from [Hospital] where [GUID] = @HospitalGUID";
* cmd.Parameters.AddWithValue("@HospitalGUID", HospitalGUID.Text);
* rd = cmd.ExecuteReader();
* if (rd.Read())
* {
* Image1.ImageUrl = rd["Avatar"].ToString();
* HospitalName.Text = rd["HospitalName"].ToString();
* Introduction.Text = rd["Introduction"].ToString();
* }
* rd.Close();
*/
cmd.CommandText = "select * from Doctor where GUID=@GUID";
cmd.Parameters.AddWithValue("@GUID", Session["DoctorGUID"].ToString());
rd = cmd.ExecuteReader();
string IsAdmin = "";
if (rd.Read())
{
IsAdmin = Util.AESDecrypt(rd["IsAdmin"].ToString());
}
rd.Close();
if (IsAdmin == "True")
{
DelBtn.Visible = true;
}
else
{
DelBtn.Visible = false;
}
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec, D58;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T3 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS1.Text = dec.ToString();
R1 = (Math.Round(dec / 6, 0)).ToString();;
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
RS2.Text = dec.ToString();
R2 = (Math.Round(dec / 5, 0)).ToString();;
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS3.Text = dec.ToString();
R33 = (Math.Round(dec / 4, 0)).ToString();;
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
dec = Math.Round(dec, 0);
RS4.Text = dec.ToString();
R4 = (Math.Round(dec / 5, 0)).ToString();;
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS5"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位
RS5.Text = dec.ToString();
D58 = Convert.ToDecimal(Util.AESDecrypt(rd["D58"].ToString()));
if (D58 == 0)
{
R5 = (Math.Round(dec / 4, 0)).ToString();
}
else
{
R5 = (Math.Round(dec / 8, 0)).ToString();
}
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS6"].ToString()));
dec = Math.Round(dec, 0);
RS6.Text = dec.ToString();
R6 = (Math.Round(dec / 8, 0)).ToString();;
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 0);
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
switch (R1)
{
case "1":
RS1Add.Text = "无";
break;
case "2":
RS1Add.Text = "轻度";
break;
case "3":
RS1Add.Text = "中度";
break;
case "4":
RS1Add.Text = "重度";
break;
case "5":
RS1Add.Text = "极重度/不能做";
break;
}
switch (R2)
{
case "1":
RS2Add.Text = "无";
break;
case "2":
RS2Add.Text = "轻度";
break;
case "3":
RS2Add.Text = "中度";
break;
case "4":
RS2Add.Text = "重度";
break;
case "5":
RS2Add.Text = "极重度/不能做";
break;
}
switch (R33)
{
case "1":
RS3Add.Text = "无";
break;
case "2":
RS3Add.Text = "轻度";
break;
case "3":
RS3Add.Text = "中度";
break;
case "4":
RS3Add.Text = "重度";
break;
case "5":
RS3Add.Text = "极重度/不能做";
break;
}
switch (R4)
{
case "1":
RS4Add.Text = "无";
break;
case "2":
RS4Add.Text = "轻度";
break;
case "3":
RS4Add.Text = "中度";
break;
case "4":
RS4Add.Text = "重度";
break;
case "5":
RS4Add.Text = "极重度/不能做";
break;
}
switch (R5)
{
case "1":
RS5Add.Text = "无";
break;
case "2":
RS5Add.Text = "轻度";
break;
case "3":
RS5Add.Text = "中度";
break;
case "4":
RS5Add.Text = "重度";
break;
case "5":
RS5Add.Text = "极重度/不能做";
break;
}
switch (R6)
{
case "1":
RS6Add.Text = "无";
break;
case "2":
RS6Add.Text = "轻度";
break;
case "3":
RS6Add.Text = "中度";
break;
case "4":
RS6Add.Text = "重度";
break;
case "5":
RS6Add.Text = "极重度/不能做";
break;
}
int RawScore1 = Convert.ToInt16(RawScore.Text);
if (RawScore1 >= 116)
{
RawScoreAdd.Text = "精神残疾一级";
}
if (106 <= RawScore1 && RawScore1 <= 115)
{
RawScoreAdd.Text = "精神残疾二级";
}
if (96 <= RawScore1 && RawScore1 <= 105)
{
RawScoreAdd.Text = "精神残疾三级";
}
if (52 <= RawScore1 && RawScore1 <= 95)
{
RawScoreAdd.Text = "精神残疾四级";
}
if (RawScore1 <= 51)
{
RawScoreAdd.Text = "正常";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Session["UserID"] == null)
//{
// Util.ShowMessage("用户登录超时，请重新登录！", "Login.aspx");
//}
//else
//{
//}
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T18 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位。同时四舍五入
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
switch (RawScore.Text)
{
case "0":
case "1":
case "2":
case "3":
case "4":
case "5":
RS_S.Text = "得分低于或等于5分，为低自杀风险";
break;
case "6":
case "7":
case "8":
RS_S.Text = "得分在6~8分范围内，为中自杀风险";
break;
case "9":
case "10":
case "11":
RS_S.Text = "得分在9~11分范围内，为高自杀风险";
break;
case "12":
case "13":
case "14":
case "15":
case "16":
case "17":
case "18":
case "19":
case "20":
case "21":
case "22":
case "23":
case "24":
case "25":
RS_S.Text = "得分大于或等于12分，为极高自杀风险";
break;
default:
RS_S.Text = "得分出错";
break;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
int HW_Score, Waist_Score, QTC_Score, BP_Score, BS_Score, BF_Score = 0;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T8 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位。同时四舍五入
RS1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
RS2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
dec = Math.Round(dec, 0);
RS3.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
dec = Math.Round(dec, 0);
RS4.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS5"].ToString()));
dec = Math.Round(dec, 0);
RS5.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS6"].ToString()));
dec = Math.Round(dec, 0);
RS6.Text = dec.ToString();
//dec = Convert.ToDecimal(rd["RS3"].ToString()) + Convert.ToDecimal(rd["RS4"].ToString());
//dec = Math.Round(dec, 0);
//RS34.Text = dec.ToString();
//RS3Add.Text = rd["ECG1"].ToString() + rd["ECG2"].ToString();
//RS4Add.Text=rd["BP4"].ToString();
//if (RS4Add.Text.Trim() == "低血压")
//{
// RS4Add.Text = rd["BP4"].ToString() +"; "+ rd["BP3"].ToString();
//}
//dec = Convert.ToDecimal(rd["RS5"].ToString());
//dec = Math.Round(dec, 0);
//RS5.Text = dec.ToString();
//RS5Add.Text = rd["BS3"].ToString();
//if (RS5Add.Text.Trim() == "低血糖")
//{
// RS5Add.Text = rd["BS3"].ToString() + "; " + rd["BS2"].ToString();
//}
HW_ScoreExplain.Text = rd["HW_ScoreExplain"].ToString();
Waist_ScoreExplain.Text = rd["Waist_ScoreExplain"].ToString();
BS_ScoreExplain.Text = rd["BS_ScoreExplain"].ToString();
BF_ScoreExplain.Text = rd["BF_ScoreExplain"].ToString();
QTC.Text = rd["QTC"].ToString() + rd["QTC_Add"].ToString();
BP_ScoreExplain.Text = rd["BP_ScoreExplain"].ToString();
RS7Add1.Text = rd["SmokingFQ"].ToString() + "; 吸烟的日子里" + rd["SmokingDosage"].ToString();
RS7Add2.Text = rd["DrinkFQ"].ToString() + "; 每次" + rd["DrinkDosage"].ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["HW_Score"].ToString()));
dec = Math.Round(dec, 0);
HW_Score = Convert.ToInt16(dec.ToString());
dec = Convert.ToDecimal(Util.AESDecrypt(rd["Waist_Score"].ToString()));
dec = Math.Round(dec, 0);
Waist_Score = Convert.ToInt16(dec.ToString());
dec = Convert.ToDecimal(Util.AESDecrypt(rd["QTC_Score"].ToString()));
dec = Math.Round(dec, 0);
QTC_Score = Convert.ToInt16(dec.ToString());
dec = Convert.ToDecimal(Util.AESDecrypt(rd["BP_Score"].ToString()));
dec = Math.Round(dec, 0);
BP_Score = Convert.ToInt16(dec.ToString());
dec = Convert.ToDecimal(Util.AESDecrypt(rd["BS_Score"].ToString()));
dec = Math.Round(dec, 0);
BS_Score = Convert.ToInt16(dec.ToString());
dec = Convert.ToDecimal(Util.AESDecrypt(rd["BF_Score"].ToString()));
dec = Math.Round(dec, 0);
BF_Score = Convert.ToInt16(dec.ToString());
}
else
{
HW_Score = 0;
Waist_Score = 0;
QTC_Score = 0;
BP_Score = 0;
BS_Score = 0;
BF_Score = 0;
}
rd.Close();
conn.Close();
}
switch (HW_Score)
{
case 1:
break;
case 2:
case 3:
HW_ScoreExplain.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
switch (Waist_Score)
{
case 1:
break;
case 2:
case 3:
Waist_ScoreExplain.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
switch (QTC_Score)
{
case 1:
case 2:
break;
case 3:
QTC.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
switch (BP_Score)
{
case 1:
case 2:
break;
case 3:
case 4:
BP_ScoreExplain.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
switch (BS_Score)
{
case 1:
case 2:
break;
case 3:
BS_ScoreExplain.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
switch (BF_Score)
{
case 1:
case 2:
break;
case 3:
BF_ScoreExplain.ForeColor = System.Drawing.Color.Red;
break;
default:
break;
}
//switch (RS2.Text)
//{
// case "1":
// RS2Add.Text = "正常";
// break;
// case "2":
// RS2Add.Text = "增粗";
// break;
// case "3":
// RS2Add.Text = "过粗";
// break;
// default:
// RS2Add.Text = "得分出错";
// break;
//}
//switch (RS6.Text)
//{
// case "1":
// RS6Add.Text = "正常水平";
// break;
// case "2":
// RS6Add.Text = "边缘异常";
// break;
// case "3":
// RS6Add.Text = "异常";
// break;
// default:
// RS6Add.Text = "得分出错";
// break;
//}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T14 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位。同时四舍五入
CGIS.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
CGII.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 2);
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
switch (CGIS.Text)
{
case "1":
CGIS2.Text = "正常，无病";
break;
case "2":
CGIS2.Text = "病情极轻";
break;
case "3":
CGIS2.Text = "轻度有病";
break;
case "4":
CGIS2.Text = "中度有病";
break;
case "5":
CGIS2.Text = "明显有病";
break;
case "6":
CGIS2.Text = "严重有病";
break;
case "7":
CGIS2.Text = "病情极重";
break;
default:
CGIS2.Text = "得分出错";
break;
}
switch (CGII.Text)
{
case "1":
CGII2.Text = "进步非常明显";
break;
case "2":
CGII2.Text = "进步明显";
break;
case "3":
CGII2.Text = "稍有进步";
break;
case "4":
CGII2.Text = "无变化";
break;
case "5":
CGII2.Text = "稍有恶化";
break;
case "6":
CGII2.Text = "明显恶化";
break;
case "7":
CGII2.Text = "恶化非常明显";
break;
default:
CGII2.Text = "得分出错";
break;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["TGUID"] != null && Request.QueryString["TNum"] != null)
{
GUID.Text = Request.QueryString["TGUID"].ToString();
decimal dec;
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from T2 where GUID=@TGUID";
cmd.Parameters.AddWithValue("@TGUID", GUID.Text);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS1"].ToString()));
dec = Math.Round(dec, 0);//Math.Round(X,N)，X是数据，N是保留小数点后N位。同时四舍五入
RS1.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS2"].ToString()));
dec = Math.Round(dec, 0);
RS2.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS3"].ToString()));
dec = Math.Round(dec, 0);
RS3.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RS4"].ToString()));
dec = Math.Round(dec, 0);
RS4.Text = dec.ToString();
dec = Convert.ToDecimal(Util.AESDecrypt(rd["RawScore"].ToString()));
dec = Math.Round(dec, 0);
RawScore.Text = dec.ToString();
}
rd.Close();
conn.Close();
}
switch (RS1.Text)
{
case "0":
RS1Add.Text = "无";
break;
case "1":
RS1Add.Text = "轻度";
break;
case "2":
RS1Add.Text = "中度";
break;
case "3":
RS1Add.Text = "偏重";
break;
case "4":
RS1Add.Text = "重度";
break;
case "5":
RS1Add.Text = "极重";
break;
default:
RS1Add.Text = "得分出错";
break;
}
switch (RS2.Text)
{
case "0":
RS2Add.Text = "无";
break;
case "1":
RS2Add.Text = "轻度";
break;
case "2":
RS2Add.Text = "中度";
break;
case "3":
RS2Add.Text = "偏重";
break;
case "4":
RS2Add.Text = "重度";
break;
case "5":
RS2Add.Text = "极重";
break;
default:
RS2Add.Text = "得分出错";
break;
}
switch (RS3.Text)
{
case "0":
RS3Add.Text = "无";
break;
case "1":
RS3Add.Text = "轻度";
break;
case "2":
RS3Add.Text = "中度";
break;
case "3":
RS3Add.Text = "偏重";
break;
case "4":
RS3Add.Text = "重度";
break;
case "5":
RS3Add.Text = "极重";
break;
default:
RS3Add.Text = "得分出错";
break;
}
switch (RS4.Text)
{
case "0":
RS4Add.Text = "无";
break;
case "1":
RS4Add.Text = "轻度";
break;
case "2":
RS4Add.Text = "中度";
break;
case "3":
RS4Add.Text = "偏重";
break;
case "4":
RS4Add.Text = "重度";
break;
case "5":
RS4Add.Text = "极重";
break;
default:
RS4Add.Text = "得分出错";
break;
}
int Score = Convert.ToInt16(RawScore.Text);
if (Score <= 100 && Score >= 71)
{
RawScoreAdd.Text = "仅有轻度困难";
}
else if (Score <= 70 && Score >= 31)
{
RawScoreAdd.Text = "存在不同程度的残疾";
}
else
{
RawScoreAdd.Text = "功能极差，病人需要加强支持或密切监护";
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int flag = 0;
if (Session["CheckCode"] == null)
{
ErrorLabel.Text = "页面停留过久，请刷新验证码！";
}
else
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from [Doctor] where [DoctorName] = @UserName and [Password] = @Password";
cmd.Parameters.AddWithValue("@UserName", UserNameDDL.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Password", Util.GetHash(Password.Text.Trim()));
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
DoctorGUID.Text = rd["GUID"].ToString();
HospitalGUID.Text = rd["HospitalGUID"].ToString();
flag = 1;
}
cmd.Dispose();
rd.Close();
cmd.CommandText = "select * from [Hospital] where GUID = @HospitalGUID";
cmd.Parameters.AddWithValue("@HospitalGUID", HospitalGUID.Text);
rd = cmd.ExecuteReader();
if (rd.Read())
{
StrToInt.Text = Util.AESDecrypt(rd["Licenses"].ToString());
StrToInt.Text = StrToInt.Text.Substring(10, StrToInt.Text.Length - 10);
}
cmd.Dispose();
rd.Close();
conn.Close();
}
//判断用户输入验证码是否相等
if (Session["CheckCode"].ToString().ToLower() == ValidateCode.Text.ToLower().Trim())
{
if (flag == 1)
{
int OnLineUserCount = (int)Application["OnLineUserCount"];
if (OnLineUserCount <= Convert.ToInt32(StrToInt.Text))
{
System.Web.HttpContext.Current.Session["DoctorGUID"] = DoctorGUID.Text;
System.Web.HttpContext.Current.Session["HospitalGUID"] = HospitalGUID.Text;
HttpCookie cookie = new HttpCookie("DoctorName");
cookie.Value = HttpUtility.UrlEncode(UserNameDDL.SelectedItem.Text, Encoding.GetEncoding("UTF-8"));
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
ErrorLabel.Text = "登录成功！";
ErrorLabel.ForeColor = System.Drawing.Color.Green;
Response.Redirect(Server.HtmlEncode("Index.aspx"));
}
else
{
ErrorLabel.Text = "登录失败，客户端占用过多！";
}
}
else if (UserNameDDL.SelectedItem.Text == "--请选择医生--")
{
ErrorLabel.Text = "请先选择医生";
}
else
{
ErrorLabel.Text = "用户名或密码错误！";
}
}
else
{
ErrorLabel.Text = "验证码输入错误！";
}
}
}
