using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
namespace NetWorkAddressCollection
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
private string _userName=null;
DataGridView dgvDisplayNetAddress = new DataGridView();//定义一个DataGridView 控件
Label lblHello = new Label(); //定义一个Lable控件
private void userLogonToolStripMenuItem_Click(object sender, EventArgs e)
{
LogonForm logon = new LogonForm();
if (logon.ShowDialog() == DialogResult.OK)
{
_userName = logon.UserName;
tsmiZhuXiao.Enabled = tsmiCollection.Enabled = !(tsmiLogon.Enabled = false);
//设置Lable属性
lblHello.Text = string.Format("用户 {0} 你好,欢迎使用本系统!",logon.UserName);
lblHello.Font = new Font("华文隶书", 20f, FontStyle.Bold | FontStyle.Italic, GraphicsUnit.Pixel);
lblHello.AutoSize = true;
lblHello.Name = "lblHello";
Graphics g = CreateGraphics();
SizeF s = g.MeasureString(lblHello.Text, lblHello.Font);
lblHello.Location = new Point((int)(ClientRectangle.Width - s.Width) / 2, (int)(ClientRectangle.Height - s.Height) / 2);
lblHello.Show();
//将写好的lable控件放在窗体上
Controls.Add(lblHello);
}
}
private void MainForm_Load(object sender, EventArgs e)
{
}
private void tsmiShowCollection_Click(object sender, EventArgs e)
{
dgvDisplayNetAddress.Columns.Clear();
dgvDisplayNetAddress.AutoGenerateColumns = false;
//
DataGridViewTextBoxColumn textUrlid = new DataGridViewTextBoxColumn();
textUrlid.HeaderText = "urlid";
textUrlid.DataPropertyName = "id";
dgvDisplayNetAddress.Columns.Add(textUrlid);
DataGridViewTextBoxColumn textUrl = new DataGridViewTextBoxColumn();
textUrl.HeaderText = "url";
textUrl.DataPropertyName = "Bm_url";
dgvDisplayNetAddress.Columns.Add(textUrl);
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.HeaderText = "操作";
btn.Text = "Del";
btn.FlatStyle = FlatStyle.Popup;
btn.DefaultCellStyle.ForeColor = Color.Black;
btn.DefaultCellStyle.BackColor = Color.FromKnownColor(KnownColor.ButtonFace);
btn.UseColumnTextForButtonValue = true;
dgvDisplayNetAddress.Columns.Add(btn);
//
SQLServer server = new SQLServer();
dgvDisplayNetAddress.DataSource = server.GetTable(_userName);
//
Controls.Remove(Controls["lblHello"]);//将此Lable删除, 以便显示DataGridView 控件
dgvDisplayNetAddress.Name = "dgv";
dgvDisplayNetAddress.Location = new Point(this.ClientRectangle.X, this.ClientRectangle.Y + msMain.Height);
dgvDisplayNetAddress.Width = this.ClientRectangle.Width;
dgvDisplayNetAddress.Height = this.ClientRectangle.Height - msMain.Height;
//将以上写好的DataGridView控件放入窗体
Controls.Add(dgvDisplayNetAddress);
//dgvDisplayNetAddress.DefaultCellStyle.SelectionBackColor = Color.FromArgb(150, 50, 100, 200);
//
dgvDisplayNetAddress.CellContentClick += new DataGridViewCellEventHandler(dgvDisplayNetAddress_CellContentClick);
}
void dgvDisplayNetAddress_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 2&&e.RowIndex!=dgvDisplayNetAddress.Rows.Count-1)
{
SQLServer server = new SQLServer();
bool isDeleteRow=server.DeleteRow((int)dgvDisplayNetAddress.Rows[e.RowIndex].Cells[0].Value);
if (isDeleteRow)
dgvDisplayNetAddress.DataSource = server.GetTable(_userName);
}
}
private void tsmiNew_Click(object sender, EventArgs e)
{
LoginForm login = new LoginForm();
login.Show();
}
private void tsmiAddCollection_Click(object sender, EventArgs e)
{
AddForm add = new AddForm(_userName);
add.Show();
}
private void tsmiZhuXiao_Click(object sender, EventArgs e)
{
_userName = null;
this.tsmiLogon.Enabled = true;
tsmiZhuXiao.Enabled = tsmiCollection.Enabled = false;
lblHello.Text = "用户请登录!";
this.Controls.Remove(Controls["dgv"]);
}
}
}