/// <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;
}
