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 + ",紫色"; } }