private void Init()
{
lsvReportType.Items.Clear();
ListViewItem lv;
DataTable dt = DBOpt.dbHelper.GetDataTable("select ID,NAME,OTHER_LANGUAGE_DESCR,ORDER_ID from DMIS_SYS_REPORT_TYPE order by ORDER_ID");
for (int i = 0; i < dt.Rows.Count; i++)
{
lv = new ListViewItem(dt.Rows[i][0].ToString());
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
lv.SubItems.Add(dt.Rows[i][j].ToString());
}
}
lsvReportType.Items.Add(lv);
}
CMix.SetListViewAlternatingBackColor(lsvReportType, Color.Gray, Color.Lime);
}
private void initMemeber(string departId)
{
lsvMemeber.Items.Clear();
ListViewItem lv;
DataTable dt = DBOpt.dbHelper.GetDataTable("select ID,CODE,NAME,FLAG,ORDER_ID from DMIS_SYS_MEMBER where DEPART_ID=" + departId + " order by ORDER_ID");
for (int i = 0; i < dt.Rows.Count; i++)
{
lv = new ListViewItem(dt.Rows[i][0].ToString());
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
lv.SubItems.Add(dt.Rows[i][j].ToString());
}
}
lsvMemeber.Items.Add(lv);
}
CMix.SetListViewAlternatingBackColor(lsvMemeber, Color.SkyBlue, Color.Lime);
}
private void initRole()
{
lsvRole.Items.Clear();
ListViewItem lv;
DataTable dt = DBOpt.dbHelper.GetDataTable("select ID,NAME,DESCR,OTHER_LANGUAGE_DESCR from DMIS_SYS_ROLE order by ID");
for (int i = 0; i < dt.Rows.Count; i++)
{
lv = new ListViewItem(dt.Rows[i][0].ToString());
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
lv.SubItems.Add(dt.Rows[i][j].ToString());
}
}
lsvRole.Items.Add(lv);
}
CMix.SetListViewAlternatingBackColor(lsvRole, Color.SkyBlue, Color.Lime);
}
private void btnQuery_Click(object sender, EventArgs e)
{
DateTime dtStart = dtpStartDate.Value;
DateTime dtEnd = dtpEndDate.Value;
if (dtStart > dtEnd)
{
MessageBox.Show("起止日期不能大于终止日期");
return;
}
TimeSpan ts = dtEnd - dtStart;
if (ts.Days > 31)
{
MessageBox.Show("时间范围不能超过31天！");
return;
}
lsvLog.Items.Clear();
ListViewItem lv;
sql = "select OPT_TIME,MEMBER_NAME,MEMBER_ID,IP,LOG_TYPE,STATE,CONTENT from DMIS_SYS_LOG where convert(char(8),OPT_TIME,112)>='" +
dtStart.ToString("yyyyMMdd") + "' and convert(char(8),OPT_TIME,112)<='" + dtEnd.ToString("yyyyMMdd") + "' order by OPT_TIME desc";
_dt = DBOpt.dbHelper.GetDataTable(sql);
for (int i = 0; i < _dt.Rows.Count; i++)
{
lv = new ListViewItem(_dt.Rows[i][0].ToString());
for (int j = 1; j < _dt.Columns.Count; j++)
{
if (_dt.Rows[i][j] != null)
{
lv.SubItems.Add(_dt.Rows[i][j].ToString());
}
}
lsvLog.Items.Add(lv);
}
CMix.SetListViewAlternatingBackColor(lsvLog, Color.SkyBlue, Color.Lime);
}
