GIS_cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/XiTongGuanLi/RiZhi.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WWPipeLine.MapBasic.Conditions;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic;
using Sunny.UI;
namespace WWPipeLine.MapTools.Conditions.XiTongGuanLi
{
	public partial class RiZhi : ConditionPanel
	{
		public RiZhi()
		{
			this.ConditionPanelName = "系统日志管理";
			this.SetSize(1000, 685);
			InitializeComponent();
			this.IsShowPanelFooter = false;
		}
		public override bool ShowModal()
		{
			return true;
		}
		protected override void OnLoad(EventArgs e)
		{
			DataTable dt = new NpgsqlHelper().ExecuteQuery("select id,lgname,lgip,lgcup,lgtime,outtime from userlogin ORDER BY id desc").Tables[0];
			uidgvlog.DataSource = dt;

			foreach (DataGridViewColumn c in uidgvlog.Columns)
			{
				c.SortMode = DataGridViewColumnSortMode.NotSortable;
				switch (c.Name.ToLower())
				{
					case "id": c.Visible = false; break;
					case "lgname": c.HeaderText = "登录账号"; break;
					case "lgtime": c.HeaderText = "登录时间"; break;
					case "outtime": c.HeaderText = "退出时间"; break;
					case "lgip": c.HeaderText = "登录IP地址"; break;
					case "lgcup": c.HeaderText = "登录电脑名称"; break;
					default: c.HeaderText = ""; break;
				}
			}
			uidgvlog.SelectedIndex = 0;
			foreach (DataGridViewColumn c in uidgvlognm.Columns)
			{
				c.SortMode = DataGridViewColumnSortMode.NotSortable;
				switch (c.Name.ToLower())
				{
					case "id": c.Visible = false; break;
					case "lgid": c.Visible = false; break;
					case "czms": c.HeaderText = "操作描述"; break;
					case "cztime": c.HeaderText = "操作时间"; break;
					default: c.HeaderText = ""; break;
				}
			}

			uicbxName.Items.Add("全部"); uicbxName.SelectedIndex = 0;
			uicbxIP.Items.Add("全部"); uicbxIP.SelectedIndex = 0;
			uicbxCup.Items.Add("全部"); uicbxCup.SelectedIndex = 0;
			DataSet dtBind = new NpgsqlHelper().ExecuteQuery("select lgname from userlogin GROUP BY lgname");
			if (dtBind.Tables.Count == 1)
			{
				foreach (DataRow dr in dtBind.Tables[0].Rows)
				{
					uicbxName.Items.Add(dr["lgname"].ToString());
				}
			}
			dtBind = new NpgsqlHelper().ExecuteQuery("select lgip from userlogin GROUP BY lgip");
			if (dtBind.Tables.Count == 1)
			{
				foreach (DataRow dr in dtBind.Tables[0].Rows)
				{
					uicbxIP.Items.Add(dr["lgip"].ToString());
				}
			}
			dtBind = new NpgsqlHelper().ExecuteQuery("select lgcup from userlogin GROUP BY lgcup");
			if (dtBind.Tables.Count == 1)
			{
				foreach (DataRow dr in dtBind.Tables[0].Rows)
				{
					uicbxCup.Items.Add(dr["lgcup"].ToString());
				}
			}
		}

		private void uidgvlog_SelectIndexChange(object sender, int index)
		{
			if (uidgvlog.SelectedRows == null || uidgvlog.SelectedRows.Count != 1) return;
			int logid = ComsStatic.StringToInt(uidgvlog.SelectedRows[0].Cells["id"].Value);
			if (logid == 0) return;
			DataSet dt = new NpgsqlHelper().ExecuteQuery(string.Format("select id,lgid,czms,cztime from userloginm where lgid={0} ORDER BY id desc", logid));
			if (dt.Tables.Count != 1) return;
			uidgvlognm.DataSource = dt.Tables[0];
		}

		private void uiButton1_Click(object sender, EventArgs e)
		{
			List<string> wheres = new List<string>();
			if (uicbxName.SelectedItem.ToString() != "全部")
				wheres.Add(string.Format(" lgname='{0}'", uicbxName.SelectedItem.ToString()));
			if (uicbxIP.SelectedItem.ToString() != "全部")
				wheres.Add(string.Format(" lgip='{0}'", uicbxIP.SelectedItem.ToString()));
			if (uicbxCup.SelectedItem.ToString() != "全部")
				wheres.Add(string.Format(" lgcup='{0}'", uicbxCup.SelectedItem.ToString()));
			string sql = ComsStatic.GetSql("select id,lgname,lgip,lgcup,lgtime,outtime from userlogin ", wheres, " ORDER BY id desc");
			DataTable dt = new NpgsqlHelper().ExecuteQuery(sql).Tables[0];
			uidgvlog.DataSource = dt;
		}



	}
}