private void setSCNRText()
{
string title = "";
foreach (var var in CheckBoxList)
{
stuTag t = (stuTag)var.Tag;
if (var.Checked == true)
{
if (string.IsNullOrEmpty(label8.Text))
{
title = t.scxm;
label8.Text = "★" + t.scxm + ":\n Δ " + var.Text;
}
else
{
if (title == t.scxm)
{
label8.Text = label8.Text + "\n Δ " + var.Text;
}
else
{
label8.Text = label8.Text + "\n\n★" + t.scxm + ":\n Δ " + var.Text;
title = t.scxm;
}
}
}
}
}
private void UpdateDataNewHistory(DataRow dr)
{
label8.Text = "";
clearSCXM();
edtage.Text = dr["年龄"].ToString();
// edtbgr.Text = dr["报告人"].ToString().IsEmpty() ? edtbgr.Text : dr["报告人"].ToString();
;
// edtbgrq.Text = dr["报告日期"].ToString().IsEmpty() ? DateTime.Now.ToShortDateString() : dr["报告日期"].ToString();
edtcsrq.Text = dr["出生日期"].ToString(); //.DateTime.ToString("yyyy年MM月dd日");
edtcbzd.Text = dr["初步诊断"].ToString();
;
edtsfzh.Text = dr["身份证号"].ToString();
edtsfzh_Leave(this, null);
// edtbgjg.Text = dr["报告机构"].ToString();
edtName.Text = dr["姓名"].ToString();
edtmzh.Text = dr["门诊号"].ToString();
edtlxdh.Text = dr["联系电话"].ToString();
// edtpgsj.Text = dr["评估时间"].ToString().IsEmpty() ? DateTime.Now.ToShortDateString() : dr["评估时间"].ToString();
// dv.Id = Convert.ToInt32(dr["ID"]);
string[] v = dr["筛查ID"].ToString().Split(';');
bool first = true;
foreach (string vv in v)
{
foreach (CheckBox cb in CheckBoxList)
{
stuTag t = (stuTag)cb.Tag;
if (t.ID.ToString() == vv)
{
cb.Checked = true;
cb.Visible = true;
if (first)
{
first = false;
RadioButton fff = cb.Parent.Tag as RadioButton;
if (fff == null)
{
continue;
}
fff.Checked = true;
cb.Parent.BringToFront();
}
break;
}
}
}
}
private void UpdateData(DataRow dr)
{
label8.Text = "";
clearSCXM();
edtage.Text = dr["年龄"].ToString();
edtbgr.Text = dr["报告人"].ToString().IsEmpty() ? edtbgr.Text : dr["报告人"].ToString();
;
edtbgrq.Text = dr["报告日期"].ToString().IsEmpty() ? DateTime.Now.ToShortDateString() : dr["报告日期"].ToString();
edtcsrq.Text = dr["出生日期"].ToString(); //.DateTime.ToString("yyyy年MM月dd日");
edtcbzd.Text = dr["初步诊断"].ToString();
;
edtsfzh.Text = dr["身份证号"].ToString();
edtsfzh_Leave(this, null);
try
{
edtyz.Text = dr["孕周"].ToString().Split('.')[0];
edtyzt.Text = dr["孕周"].ToString().Split('.')[1];
}
catch (Exception e)
{
}
// edtbgjg.Text = dr["报告机构"].ToString();
edtName.Text = dr["姓名"].ToString();
edtmzh.Text = dr["门诊号"].ToString();
edtlxdh.Text = dr["联系电话"].ToString();
edtpgsj.Text = dr["评估时间"].ToString().IsEmpty() ? DateTime.Now.ToShortDateString() : dr["评估时间"].ToString();
dv.Id = Convert.ToInt32(dr["ID"]);
string[] v = dr["筛查ID"].ToString().Split(';');
foreach (string vv in v)
{
foreach (CheckBox cb in CheckBoxList)
{
stuTag t = (stuTag)cb.Tag;
if (t.ID.ToString() == vv)
{
cb.Checked = true;
cb.Visible = true;
break;
}
}
}
}
private void SaveDataToDB(DataValue dv)
{
var getSQLID = "select ry_scxx.nextval as ID from dual";
oraComm.CommandText = getSQLID;
DataTable tmp = new DataTable();
oraDA.Fill(tmp);
int ID = Convert.ToInt32(tmp.Rows[0]["ID"]);
var sql = "insert into 筛查信息(ID,姓名,年龄,出生日期,身份证号,孕周,联系电话,初步诊断,评估时间," +
"报告人,报告日期,评估分级,门诊号,筛查ID,筛查结果) values ( {0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')";
string strv = "";
foreach (var v in selectLst)
{
stuTag t = (stuTag)v.Tag;
strv = t.ID.ToString() + ";" + strv;
}
if (historyData)
{
oraComm.CommandText = "delete 筛查信息 where ID= " + dv.Id;
oraComm.ExecuteNonQuery();
}
oraComm.CommandText = string.Format(sql, ID, dv.Name, dv.Age, dv.Birthday, dv.Sfzh, dv.Yz + "." + dv.Yzt, dv.Lxdh,
dv.Cbzd, dv.Pgsj,
dv.Bgr, dv.Bgrq, dv.Pgfj, dv.Mzh, strv, dv.Scjg);
oraComm.ExecuteNonQuery();
dv.Id = ID;
historyData = true;
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (sender != null)
{
zs = false;
string title = "";
string context;
var cb = sender as CheckBox;
label8.Text = "";
int v, j = 0;
if (cb.Checked)
{
selectLst.Add(cb);
}
else
{
selectLst.Remove(cb);
}
setSCNRText();
foreach (var x in selectLst)
{
stuTag t = (stuTag)x.Tag;
/*
* if (string.IsNullOrEmpty(label8.Text))
* {
* title = t.scxm;
* label8.Text = "★" +t.scxm + ":\n " + x.Text;
* }
* else
* {
* if (title == t.scxm)
* label8.Text = label8.Text + "\n " + x.Text;
* else
* {
* label8.Text = label8.Text + "\n\n★" + t.scxm + ":\n " + x.Text;
* title = t.scxm;
*
* }
*
* }
*/
stuTag vv = (stuTag)x.Tag;
v = vv.jb;
if (v < 4)
{
if (v > j)
{
j = v;
}
}
else
{
zs = true;
}
}
/* foreach (var var in CheckBoxList)
* {
* stuTag v1 = (stuTag)var.Tag;
* if (j == 0) var.Visible = true;
* if (Convert.ToInt32(v1.jb) <= j && selectLst.IndexOf(var) < 0)
* var.Visible = false;
* }*/
switch (j)
{
case 1:
label8.ForeColor = Color.Yellow;
break;
case 2:
label8.ForeColor = Color.Coral;
break;
case 3:
label8.ForeColor = Color.Red;
break;
case 4:
label8.ForeColor = Color.Magenta;
break;
}
currentLevel = j;
if (selectLst.Count == 0)
{
currentLevel = 0;
}
}
else
{
}
switch (currentLevel)
{
case 0:
lblYS.Text = "";
break;
case 1:
lblYS.Text = "黄色";
break;
case 2:
lblYS.Text = "橙色";
break;
case 3:
lblYS.Text = "红色";
break;
case 4:
lblYS.Text = "紫色";
break;
}
if (zs)
{
lblYS.Text = lblYS.Text + ",紫色";
}
}
