?? frmusermanage.cs
字號:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace SMS.Help
{
public partial class frmUserManage : Form
{
public frmUserManage()
{
InitializeComponent();
}
SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();
SMS.BaseClass.DataOperate doperate = new SMS.BaseClass.DataOperate();
private void frmUserManage_Load(object sender, EventArgs e)
{
DataSet myds = datacon.getds("select UserID as 用戶編號,UserName as 用戶名,UserPwd as 用戶密碼,"
+ "UserRight as 用戶權限 from tb_User", "tb_User");
dgvUInfo.DataSource=myds.Tables["tb_User"];
doperate.cboxBind("select UserName from tb_User", "tb_User", "UserName", cboxUName);
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
int P_int_returnValue = doperate.InsertUser(cboxUName.Text.Trim(), txtUPwd.Text.Trim(), cboxURight.Text.Trim());
if (P_int_returnValue == 100)
{
MessageBox.Show("該用戶已經存在", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("用戶信息添加成功!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmUserManage_Load(sender, e);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
doperate.updateUser(Convert.ToInt32(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value),
txtUPwd.Text.Trim(), cboxURight.Text.Trim());
MessageBox.Show("用戶信息修改成功!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmUserManage_Load(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnDel_Click(object sender, EventArgs e)
{
try
{
datacon.getcom("delete from tb_User where UserID="
+ Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + "");
MessageBox.Show("刪除用戶信息成功!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmUserManage_Load(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void dgvUInfo_CellClick(object sender, DataGridViewCellEventArgs e)
{
cboxUName.Text = Convert.ToString(dgvUInfo[1,dgvUInfo.CurrentCell.RowIndex].Value).Trim();
txtUPwd.Text = Convert.ToString(dgvUInfo[2, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
cboxURight.Text = Convert.ToString(dgvUInfo[3, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
}
private void frmUserManage_FormClosed(object sender, FormClosedEventArgs e)
{
this.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -