/// <summary> /// 获取门诊事件数据(数据库:192.168.201.2) /// </summary> /// <param name="eventtype"></param> /// <param name="P_eventtype"></param> /// <param name="rq1"></param> /// <param name="rq2"></param> /// <param name="eventname"></param> /// <param name="bizid"></param> /// <param name="bk"></param> /// <param name="finish"></param> /// <param name="dv"></param> public void GetMzEventlog(string P_eventtype, string rq1, string rq2, string eventname, string bizid, bool bk, int finish, Trasen.Controls.DataGridView dv) { string ssql = "select CAST(0 as smallint) 选择,ID,EVENT,CATEGORY,BIZID,MESSAGE,TS,RETURNDESC,FINISH_DATE from event_mz_hjb where 1=1 "; //and url <> '' if (finish == 0) { ssql = ssql + " and finish=" + finish + ""; } else if (finish > 0) { ssql = ssql + " and finish>=" + finish + ""; } if (!string.IsNullOrEmpty(P_eventtype)) { ssql = ssql + " and EVENT='" + P_eventtype + "'"; } ssql = ssql + " and ts>='" + rq1 + "' and ts<='" + rq2 + "'"; if (bizid.Trim() != "") { ssql = ssql + " and bizid='" + bizid + "'"; } if (eventname.Trim() != "") { ssql = ssql + " and EVENT like '%" + eventname + "%'"; } ssql = ssql + " order by ID"; RelationalDatabase db = new TrasenClasses.DatabaseAccess.MsSqlServer(); db.Initialize(strConnectionString); try { DataTable tb = db.GetDataTable(ssql); dv.DataSource = tb.DefaultView; } catch { dv.DataSource = null; } finally { db.Close(); db.Dispose(); } }
public void GetEventlog(int eventtype, int P_eventtype, string rq1, string rq2, string eventname, string bizid, bool bk, int finish, Trasen.Controls.DataGridView dv) { string ssql = "select cast(0 as smallint) 选择,a.id,a.event event,category,bizid,ts,message,finish_date,returndesc,getxml,WebService,isnull(b.id,0) as typeid,1 as sl,url " + " from eventlog a left join eventtype b on a.event=b.event where 1=1 "; //and url <> '' if (eventtype != 0) { ssql = ssql + " and b.id=" + eventtype + ""; } if (P_eventtype != 0) { ssql = ssql + " and b.pid=" + P_eventtype + ""; } if (finish == 0) { ssql = ssql + " and finish=" + finish + ""; } else if (finish > 0) { ssql = ssql + " and finish>=" + finish + ""; } ssql = ssql + " and ts>='" + rq1 + "' and ts<='" + rq2 + "'"; if (bizid.Trim() != "") { ssql = ssql + " and bizid='" + bizid + "'"; } if (eventname.Trim() != "") { ssql = ssql + " and A.event like '%" + eventname + "%'"; } ssql = ssql + " order by a.id"; DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql); //RelationalDatabase db = new TrasenClasses.DatabaseAccess.MsSqlServer(); //db.Initialize(""); dv.DataSource = tb.DefaultView; }