private void InitMemeber(string departId) { lsMemeber.Items.Clear(); ListViewItem lv; DataTable dt = DBOpt.dbHelper.GetDataTable("select ID,CODE,NAME,PASSWORD,FLAG,HOME_PHONE,OFFICE_PHONE,MOBILE,EMAIL,ADDRESS,THEME,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.Columns[j].ColumnName != "PASSWORD") { if (dt.Rows[i][j] != null) { lv.SubItems.Add(dt.Rows[i][j].ToString()); } } else { lv.SubItems.Add("***"); } } lsMemeber.Items.Add(lv); } CMix.SetListViewAlternatingBackColor(lsMemeber, Color.SkyBlue, Color.Lime); }
private void trvTreeMenu_AfterSelect(object sender, TreeViewEventArgs e) { _sql = "select * from DMIS_SYS_TREEMENU where ID=" + trvTreeMenu.SelectedNode.Tag.ToString(); _dt = DBOpt.dbHelper.GetDataTable(_sql); txtID.Text = trvTreeMenu.SelectedNode.Tag.ToString();; txtPARENT_ID.Text = _dt.Rows[0]["PARENT_ID"].ToString(); txtNAME.Text = trvTreeMenu.SelectedNode.Text; txtFILE_NAME.Text = _dt.Rows[0]["FILE_NAME"].ToString(); cbbTARTGET.Text = _dt.Rows[0]["TARTGET"].ToString(); txtEXPAND_IMAGE.Text = _dt.Rows[0]["EXPAND_IMAGE"] == Convert.DBNull ? "" : _dt.Rows[0]["EXPAND_IMAGE"].ToString(); txtOTHER_LANGUAGE_DESCR.Text = _dt.Rows[0]["OTHER_LANGUAGE_DESCR"] == Convert.DBNull ? "" : _dt.Rows[0]["OTHER_LANGUAGE_DESCR"].ToString(); if (_dt.Rows[0]["REPORT_ID"] == Convert.DBNull || _dt.Rows[0]["REPORT_ID"].ToString() == "") { cbbREPORT_ID.SelectedIndex = -1; } else { cbbREPORT_ID.SelectedIndex = CMix.GetComboBoxIndexByValue(cbbREPORT_ID, "ID=" + _dt.Rows[0]["REPORT_ID"].ToString()); } txtTABLE_IDS.Text = _dt.Rows[0]["TABLE_IDS"] == Convert.DBNull ? "" : _dt.Rows[0]["TABLE_IDS"].ToString(); txtORDER_ID.Text = _dt.Rows[0]["ORDER_ID"] == Convert.DBNull ? "" : _dt.Rows[0]["ORDER_ID"].ToString(); txtORDERS.Text = _dt.Rows[0]["ORDERS"] == Convert.DBNull ? "" : _dt.Rows[0]["ORDERS"].ToString(); txtOTHER_PARA.Text = _dt.Rows[0]["OTHER_PARA"] == Convert.DBNull ? "" : _dt.Rows[0]["OTHER_PARA"].ToString(); }
private void InitTable(TreeNode e) { if (e == null) { return; } lsvTable.Items.Clear(); ListViewItem lv; _sql = "select ID,OWNER,NAME,DESCR,PAGE_ROWS,ORDER_ID,DISPLAY_STYLE,OTHER_LANGUAGE_DESCR from DMIS_SYS_TABLES where TYPE_ID=" + e.Tag.ToString() + " order by ORDER_ID"; DataTable 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] is System.DBNull) { lv.SubItems.Add(""); } else { lv.SubItems.Add(dt.Rows[i][j].ToString()); } } lsvTable.Items.Add(lv); } CMix.SetListViewAlternatingBackColor(lsvTable, Color.SkyBlue, Color.Lime); }
private void InitColumns() { if (trvTables.SelectedNode == null) { return; } ListViewItem lv; _tableId = trvTables.SelectedNode.Tag.ToString(); lvColumns.Items.Clear(); //列的顺序要和左边的LISTVIEW控件的列的顺序一样,建表的脚本的列的顺序最后也一样,好查错。 _sql = "select ID,NAME,DESCR,OTHER_LANGUAGE_DESCR,TYPE,ISPRIMARY,ISNULL,CUSTOM_CONTROL_NAME,CUSTOM_CONTROL_TYPE,CUSTOM_CONTROL_SVAE_TYPE,LENGTH,ISDISPLAY,ORDER_ID," + "CONTROL_LIST_WIDTH,CONTROL_LIST_DISPLAY_FORMAT,CONTROL_LIST_DISPLAY_ALIGN," + "CONTROL_HEIGHT,FILL_EXPRESSION,RELATING_COLUMN,CONTROL_DISPLAY_ONE_ROW,RELATING_CONDITION " + " from DMIS_SYS_COLUMNS where TABLE_ID=" + trvTables.SelectedNode.Tag.ToString() + " order by ORDER_ID"; DataTable 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] is System.DBNull) { lv.SubItems.Add(""); } else { if (dt.Columns[j].ColumnName == "ISPRIMARY" || dt.Columns[j].ColumnName == "ISNULL" || dt.Columns[j].ColumnName == "ISDISPLAY" || dt.Columns[j].ColumnName == "CONTROL_DISPLAY_ONE_ROW") { if (dt.Rows[i][j].ToString() == "1") { lv.SubItems.Add(yes); } else { lv.SubItems.Add(no); } } else { lv.SubItems.Add(dt.Rows[i][j].ToString()); } } } lvColumns.Items.Add(lv); } CMix.SetListViewAlternatingBackColor(lvColumns, Color.SkyBlue, Color.Lime); }
private void Init() { lsvDepartType.Items.Clear(); ListViewItem lv; DataTable dt = DBOpt.dbHelper.GetDataTable("select ID,NAME from DMIS_SYS_DEPART_TYPE 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()); } } lsvDepartType.Items.Add(lv); } CMix.SetListViewAlternatingBackColor(lsvDepartType, 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); }