/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
string MZH = "";
string zycs = "1";
System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$");
if (reg1.IsMatch(this.txtzycs.Text.Trim()))
{
zycs = this.txtzycs.Text.Trim();
}
//1.自己数据库表时读取
string Sql = "select distinct t.xmdm,t.xmmc,t.xmjg,t.cssj from t_lis_result t ,t_in_patient p , t_Lis_Sample a where a.bblsh=t.bblsh and p.pid= a.mzh "
+ " and to_date(t.cssj,'YYYY-MM-DD HH24:MI:SS') between to_date('" +
dateTimePicker1.Value.ToString() + "','yyyy-MM-dd HH24:MI:SS') and to_date('" +
dateTimePicker2.Value.ToString() + "','yyyy-MM-dd HH24:MI:SS') and a.mzh='" + inPateintInfo.PId + "' order by t.cssj asc";
//string Sql = "select t.xmdm,t.xmmc,t.xmjg,t.cssj from t_lis_result t ,t_in_patient p , t_Lis_Sample a where a.bblsh=t.bblsh and p.pid= a.mzh "
// + " and t.cssj>='" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "' and t.cssj<='" + dateTimePicker2.Value.ToString("yyyy/MM/dd") + "'"
// + " and a.mzh='" + inPateintInfo.PId.Trim() + "' order by t.cssj asc";
//instr(a.mzh,'" + inPateintInfo.PId + "',1)>0
//2.采用视图读取
//string Sql = "select t.xmdm,t.xmmc,t.xmjg,to_date(t.cssj,'YYYY-MM-DD HH24:MI:SS') cssj from hnyz_zxyy.View_LIS_Result@DBHISLINK t inner join hnyz_zxyy.View_LIS_SampleInfo@DBHISLINK a on a.bblsh=t.bblsh where t.cssj is not null and a.mzh='" + inPateintInfo.PId + "' and (CASE WHEN translate(t.cssj, 'x1234567890', 'x') is null THEN TO_NUMBER (t.cssj) ELSE null END) between " + dateTimePicker1.Value.ToString("yyyyMMdd") + " and " + dateTimePicker2.Value.ToString("yyyyMMdd") + " order by t.cssj asc";
dsItes = App.GetDataSet(Sql);//数据量大，执行时间长
}
catch (System.Exception ex)
{
}
chkItemList.Items.Clear();
if (dsItes != null)
{
/*
* 刷新项目
*/
for (int i = 0; i < dsItes.Tables[0].Rows.Count; i++)
{
ChkItem item = new ChkItem();
item.Dm = dsItes.Tables[0].Rows[i]["xmdm"].ToString();
item.Mc = dsItes.Tables[0].Rows[i]["xmmc"].ToString();
item.Jcjg = dsItes.Tables[0].Rows[i]["xmjg"].ToString();
item.Dtime = Convert.ToDateTime(dsItes.Tables[0].Rows[i]["cssj"].ToString());
if (!isHaveItem(item))
{
chkItemList.Items.Add(item);
}
chkItemList.DisplayMember = "Mc";
chkItemList.ValueMember = "Dm";
}
}
}
/// <summary>
/// 判断是否已经存在项目
/// </summary>
/// <returns></returns>
private bool isHaveItem(ChkItem item)
{
for (int i = 0; i < chkItemList.Items.Count; i++)
{
ChkItem tempitem = (ChkItem)chkItemList.Items[i];
if (item.Mc == tempitem.Mc)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 趋势分析
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFenxi_Click(object sender, EventArgs e)
{
tChart1.Series.Clear();
for (int i = 0; i < chkItemList.CheckedItems.Count; i++)
{
Steema.TeeChart.Styles.Bezier templ = new Steema.TeeChart.Styles.Bezier();
templ.Marks.Visible = true;
templ.Marks.Style = 0;
tChart1.Series.Add(templ);
ChkItem tempitem = (ChkItem)chkItemList.CheckedItems[i];
templ.Title = tempitem.Mc;
DataRow[] temprows = dsItes.Tables[0].Select("xmdm='" + tempitem.Dm + "'");
for (int j = 0; j < temprows.Length; j++)
{
if (App.IsNumeric(temprows[j]["xmjg"].ToString()))
{
tChart1.Series[tChart1.Series.Count - 1].Add(Convert.ToSingle(temprows[j]["xmjg"]), temprows[j]["cssj"].ToString());
//tChart1.Series[tChart1.Series.Count - 1].Marks = temprows[j]["xmjg"].ToString();
}
}
}
}