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