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