C/S权限系统（一）
父窗体的代码：
扩展Enter键相当于Tab键的思路：
1.创建 窗体的父类
2.在父类中重写Form中的ProcessCmdKey方法，在相关控件上按回车键相当于按了Tab 键
3.让窗体继承新建的窗体父类，共享父类的功能方法
#region 处理窗体上的Enter键--在非Button、Grid控件上Enter键相当于Tab键
protected override bool ProcessCmdKey(ref Message msg,Keys keyData)
{
string acString = this.ActiveControl.GetType().ToString();
if (acString != "System.Windows.Forms.Button"
&& acString != "DevExpress.XtraEditors.SimpleButton"
&& acString.IndexOf("System.Windows.Forms.DataGrid") < 0
&& acString.IndexOf(" DevExpress.XtraGrid") < 0)
{
if (keyData == Keys.Enter)
{
SelectNextControl(this.ActiveControl, true, true, true, true);
return true;
}
else
{
return base.ProcessCmdKey(ref msg, keyData);
}
}
else
{
return base.ProcessCmdKey(ref msg, keyData);
}
}
#endregion
#region 消息处理方法集
private const string topicTitle = "提示";
private const string warningTitle = "警告";
private const string errorTitle = "错误";
private const string successTitle = "成功";
private const string questionTitle = "请选择";
/// <summary>
/// 提示框
/// </summary>
/// <param name="message"></param>
public void ShowTopic(string message)
{
MessageBox.Show(message, topicTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 警告框
/// </summary>
/// <param name="message"></param>
public void ShowWarning(string message)
{
MessageBox.Show(message, warningTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
/// <summary>
/// 错误框
/// </summary>
/// <param name="message"></param>
public void ShowError(string message)
{
MessageBox.Show(message, errorTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
/// <summary>
/// 成功框
/// </summary>
/// <param name="message"></param>
public void ShowSucess(string message)
{
MessageBox.Show(message, successTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 选择框
/// </summary>
/// <param name="message"></param>
public DialogResult ShowQuestion(string message)
{
return MessageBox.Show(message, questionTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
#endregion
#region 绑定搜索组合框的通用方法
protected void BindSearchComboBox(SeachComboBox scb, DataTable source, string displayItem, string valueItem, string rowFilterExp, string sortColumn)
{
scb.DataSource = source;
scb.DisplayItem = displayItem;
scb.ValueItem = valueItem;
scb.RowFilterExpression = rowFilterExp;
scb.SortColumnName = sortColumn;
}
#endregion
用户信息CRUD 的代码：
public partial class FrmUserManager : FrmUIBase
{
public FrmUserManager()
{
InitializeComponent();
}
//全局变量创建等待条
WaitDialogForm wdf = new WaitDialogForm("正在努力加载中.....");
#region 事件代码
private void FrmUserManager_Load(object sender, EventArgs e)
{
this.BindAllUsers();
}
private void btnAdd_Click(object sender, EventArgs e)
{
AddUsers();
}
private void btnDel_Click(object sender, EventArgs e)
{
this.DeleteUser();
}
private void btnEdit_Click(object sender, EventArgs e)
{
GetEditUserId();
}
private void btnSearch_Click(object sender, EventArgs e)
{
SearchInfoByCondition();
}
private void btnPrint_Click(object sender, EventArgs e)
{
}
#endregion
#region 绑定用户信息
private void BindAllUsers()
{
GetUsers("");
}
private void GetUsers(string strWhere = "")
{
try
{
wdf.Show();
//调用业务逻辑层取数据
List<Accounts_User> aus = Accounts_UsersManager.GetAllUsers(strWhere);
//显示数据
this.gcUsers.DataSource = aus;
//去掉分组面板
this.grvUsers.OptionsView.ShowPreview = false;
wdf.Hide();
}
catch (Exception ex)
{
//显示异常信息
this.ShowError(ex.Message);
}
}
#endregion
#region 删除用户信息
private void DeleteUser()
{
try
{
//1.得到要删除的用户的编号
Accounts_User au = this.grvUsers.GetRow(this.grvUsers.GetSelectedRows()[0]) as Accounts_User;
DialogResult dr = this.ShowQuestion("您确定要删除选中的用户【" + au.RealName + "】的信息吗");
if (dr == System.Windows.Forms.DialogResult.Yes)
{
int iret = Accounts_UsersManager.DeleteUser(au.UserID);
if (iret == 1)
{
this.ShowSucess("删除成功！");
this.BindAllUsers();//重新绑定数据
}
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 增加用户信息
private void AddUsers()
{
FrmUserEdit frm = new FrmUserEdit();
//把当窗体赋值另外一个窗体的变量
// frm.frm = this;
//只是把方法赋值给另外一个窗体的指针(委托)
frm.at = this.BindAllUsers;
frm.ShowDialog();
}
#endregion
#region 查询和显示要编辑的用户的编号
private void GetEditUserId()
{
//1.得到要编辑的用户的编号
Accounts_User au = this.grvUsers.GetRow(this.grvUsers.GetSelectedRows()[0]) as Accounts_User;
if (au != null)
{
FrmUserEdit frm = new FrmUserEdit();
frm.userId = au.UserID;
frm.at = this.BindAllUsers;
frm.ShowDialog();
}
}
#endregion
#region 查询数据
private void SearchInfoByCondition()
{
string strCondition = string.Format(" and [UserName] like '%{0}%' or [RealName] like '%{0}%'", this.txtSearch.Text.Trim());
this.GetUsers(strCondition);
}
#endregion
}
Dal层：
//根据用户名查询用户信息
public static DataSet GetUserInfoByUserName(string userName)
{
#region 拼接sql语句
// //1.建立数据库的连击
// string connString = ConfigurationManager.ConnectionStrings["Permissions"].ToString();
// //2.根据连击字符串创建连接对象
// SqlConnection conn = new SqlConnection(connString);
// try
// {
// //要执行的Sql
// string sql = string.Format(@"select * from [dbo].[Accounts_Users]
// where UserName='{0}'", userName);
// //3.打开连击
// conn.Open();
// //执行sql语句取数据
// SqlCommand cmd = new SqlCommand(sql, conn);
// //取数据到内存仓库
// SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
// //创建一个临时仓库
// DataSet ds = new DataSet();
// dataAdapter.Fill(ds);
// //返回取到的数据
// return ds.Tables[0];
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// //关闭连击
// conn.Close();
// }
#endregion
try
{
// string sql = string.Format(@"select * from [dbo].[Accounts_Users]
// where UserName='{0}'", userName);
// return SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, sql, null);
//参数化的sql语句
// string sql = @"select * from [dbo].[Accounts_Users]
// where [UserName]=@UserName";
// SqlParameter para=new SqlParameter("@UserName",userName);
// return SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, sql, para);
string spName = "usp_GetUserInfoByUserNames";
string[] values = new string[] { userName };
return SqlHelper.ExecuteDataset(SqlHelper.connString, spName, values);
}
catch (Exception ex)
{
throw ex;
}
}
#region 查询所有的用户信息
/// <summary>
/// 查询所有的用户信息
/// </summary>
/// <returns>用户信息的泛型集合</returns>
public static List<Accounts_User> GetAllUsers(string strWhere = "")
{
try
{
#region sql语句
string sql = @"select * from [dbo].[Accounts_Users] where 1=1 " + strWhere;
#endregion
#region 用sqlhelper执行SQL语句
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connString
, CommandType.Text, sql, null))
{
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
//用来存放用户信息的泛型集合
List<Accounts_User> aus = new List<Accounts_User>();
//通过循环把表中每一行数据转换一个实体
foreach (DataRow dr in dt.Rows)
{//每循环一次就会创建一个实体对象
Accounts_User au = new Accounts_User();
if (dr["AddTime"].ToString() != "")
{
au.AddTime = DateTime.Parse(dr["AddTime"].ToString());
}
if (dr["Birthday"].ToString() != "")
{
au.Birthday = DateTime.Parse(dr["Birthday"].ToString());
}
//在取用户信息时根据用户表的部门编号 得到对应的部门信息
au.Department = Accounts_DepartmentsService.GetDepartmentByDtId(dr["DepartmentID"].ToString());
au.Email = dr["Email"].ToString();
au.IsDel = bool.Parse(dr["IsDel"].ToString());
au.Password = dr["Password"].ToString();
au.Phone = dr["Phone"].ToString();
au.RealName = dr["RealName"].ToString();
au.Sex = dr["Sex"].ToString();
au.UserID = int.Parse(dr["UserID"].ToString());
au.UserName = dr["UserName"].ToString();
au.HeaderImage = dr["HeaderImage"].ToString();
aus.Add(au);
}
return aus;
}
}
#endregion
return null;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 查询一个用户信息
/// <summary>
/// 查询一个用户信息
/// </summary>
/// <returns>查询到的用户对象</returns>
public static Accounts_User GetOneUser(int? userId)
{
try
{
#region sql语句
string sql = string.Format(@"select * from [dbo].[Accounts_Users]
where UserID ='{0}'", userId);
#endregion
#region 用sqlhelper执行SQL语句
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.connString
, CommandType.Text, sql, null))
{
if (reader.Read())
{
Accounts_User au = new Accounts_User();
if (reader["AddTime"].ToString() != "")
{
au.AddTime = DateTime.Parse(reader["AddTime"].ToString());
}
if (reader["Birthday"].ToString() != "")
{
au.Birthday = DateTime.Parse(reader["Birthday"].ToString());
}
//在取用户信息时根据用户表的部门编号 得到对应的部门信息
au.Department = Accounts_DepartmentsService.GetDepartmentByDtId(reader["DepartmentID"].ToString());
au.Email = reader["Email"].ToString();
au.IsDel = bool.Parse(reader["IsDel"].ToString());
au.Password = reader["Password"].ToString();
au.Phone = reader["Phone"].ToString();
au.RealName = reader["RealName"].ToString();
au.Sex = reader["Sex"].ToString();
au.UserID = int.Parse(reader["UserID"].ToString());
au.UserName = reader["UserName"].ToString();
return au;
}
}
#endregion
return null;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 增加用户信息
/// <summary>
/// 增加用户信息
/// <param name="usr">用户实体</param>
/// </summary>
public static int AddUser(Accounts_User usr)
{
try
{
#region sql准备
string sql = string.Format(@"
INSERT INTO [dbo].[Accounts_Users]
([UserName] ,[Password],[RealName],[Sex] ,[Birthday] ,[Phone]
,[Email]
,[DepartmentID]
,[IsDel]
,[AddTime])
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
,'{6}'
,'{7}'
,'{8}'
,'{9}')", usr.UserName, usr.Password, usr.RealName, usr.Sex, usr.Birthday, usr.Phone, usr.Email, usr.Department.depId, usr.IsDel, usr.AddTime);
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, null);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 删除用户信息
/// <summary>
/// 删除用户信息
/// <param name="userId">用户编号</param>
/// </summary>
public static int DeleteUser(int userId)
{
try
{
#region sql准备
string sql = string.Format(@"delete from [dbo].[Accounts_Users]
where UserID = '{0}'", userId);
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, null);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 修改用户信息
/// <summary>
/// 修改用户信息
/// <param name="usr">用户实体</param>
/// </summary>
public static int EditUser(Accounts_User usr)
{
try
{
#region sql准备
string sql = string.Format(@"
UPDATE [dbo].[Accounts_Users]
SET [UserName] = '{0}'
,[Password] = '{1}'
,[RealName] = '{2}'
,[Sex] = '{3}'
,[Birthday] = '{4}'
,[Phone] = '{5}'
,[Email] = '{6}'
,[DepartmentID] = '{7}'
,[IsDel] = '{8}'
,[AddTime] = '{9}'
WHERE [UserID] ='{10}'", usr.UserName, usr.Password, usr.RealName, usr.Sex, usr.Birthday, usr.Phone, usr.Email, usr.Department.depId, usr.IsDel, usr.AddTime, usr.UserID);
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, null);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
业务逻辑层：
public class Accounts_UsersManager
{
//实现系统登录
public static bool Login(string strLoginName, string strLoginPwd)
{
try
{
//1.调用数据访问层：根据用户名得到用户信息
DataSet dsUser = Accounts_UsersService.GetUserInfoByUserName(strLoginName);
DataTable dtUser = dsUser.Tables[0];
if (dtUser.Rows.Count > 0)
{
DataRow drUser = dtUser.Rows[0];
//2.把用户信息中的密码与表示层的密码进行对比
if (drUser["Password"].Equals(strLoginPwd))
{
//密码正确
return true;
}
else
{
return false;
}
}
else
{
//用户名不正确
return false;
}
}
catch (Exception ex)
{
throw ex; //出现的问题抛给表示层
}
}
/// <summary>
/// 查询所有的用户信息
/// </summary>
/// <returns>用户信息的泛型集合</returns>
public static List<Accounts_User> GetAllUsers(string strWhere = "")
{
try
{
return Accounts_UsersService.GetAllUsers(strWhere);
}
catch (Exception ex)
{ //抛出异常(表示层)
throw ex;
}
}
#region 业务三:增加用户信息
/// <summary>
/// 增加用户信息
/// <param name="usr">用户实体</param>
/// </summary>
public static int AddUser(Accounts_User usr)
{
try
{
return Accounts_UsersService.AddUser(usr);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务四:删除用户信息
/// <summary>
/// 删除用户信息
/// <param name="userId">用户编号</param>
/// </summary>
public static int DeleteUser(int userId)
{
try
{
return Accounts_UsersService.DeleteUser(userId);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务五:查询一个用户信息
/// <summary>
/// 查询一个用户信息
/// </summary>
/// <returns>查询到的用户对象</returns>
public static Accounts_User GetOneUser(int? userId)
{
try
{
return Accounts_UsersService.GetOneUser(userId);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务六:修改用户信息
/// <summary>
/// 修改用户信息
/// <param name="usr">用户实体</param>
/// </summary>
public static int EditUser(Accounts_User usr)
{
try
{
return Accounts_UsersService.EditUser(usr);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
修改的代码（UI）：
public partial class FrmUserEdit : FrmUIBase
{
#region 全局变量
//FrmUserManager 窗体的实体
public FrmUserManager frm = null;
//指向FrmUserManager 窗体中的BindeUsers方法的指针
public Action at = null;
//要修改的用户编号
public int? userId = null;
//保存要修改的用户对象
private Accounts_User auEdit = null;
#endregion
public FrmUserEdit()
{
InitializeComponent();
}
private void FrmUserAdd_Load(object sender, EventArgs e)
{
this.BindDeps();
GetEditUserInfo();
this.ActiveControl = this.txtUserName;
}
private void btnCancel_Click(object sender, EventArgs e)
{
}
private void scbBuMen_SelectValueChanged(object sender, EventArgs e)
{
//if (this.scbBuMen.SelectValue != null)
//{
// string buMenName = this.scbBuMen.GetCurrentSpecialColumnValue("部门编号").ToString();
// this.txtUserName.Text = buMenName;
//}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (ValidateInput())
{
if (userId == null)
{
this.AddUser();
}
else
{
this.EidtUser();
}
}
}
#region 绑定部门信息
//private void BindDeps()
//{
// try
// {
// List<Accounts_Department> ads = Accounts_DepartmentManager.GetDepartments();
// this.cboBuMen.DataSource = ads;
// this.cboBuMen.DisplayMember = "depName";
// this.cboBuMen.ValueMember = "depId";
// }
// catch (Exception ex)
// {
// this.ShowError(ex.Message);
// }
//}
private void BindDeps()
{
//隐藏不需要显示的列
ArrayList listHideColumns = new ArrayList();
listHideColumns.Add("depPid");
listHideColumns.Add("depRemark");
listHideColumns.Add("depIsDel");
listHideColumns.Add("depAddTime");
this.scbBuMen.HideCoolumnsList = listHideColumns;
//取出所有的部门信息
DataTable dt = new DataTable();
dt = Accounts_DepartmentManager.GetDepartmentsToTable();
//设置中文别名
dt.Columns["depId"].ColumnName = "部门编号";
dt.Columns["depName"].ColumnName = "部门名称";
dt.Columns["PinYin"].ColumnName = "拼音简写";
dt.Columns["WuBi"].ColumnName = "五笔简写";
string exp = "拼音简写 " + " like '*{0}*' or " + " 部门名称 " + " like '*{0}*' or" + " 五笔简写 " + " like '*{0}*' "; ;
BindSearchComboBox(this.scbBuMen, dt, "部门名称", "部门编号", exp, "部门编号");
}
#endregion
#region 添加用户信息
private void AddUser()
{
try
{
//创建一个要增加的实体类
Accounts_User usr = new Accounts_User();
usr.AddTime = DateTime.Now;
usr.Birthday = this.dtpBirthDay.Value;
//在增加用户信息时外键对象如何处理
usr.Department = new Accounts_Department();
usr.Department.depId = this.scbBuMen.GetCurrentSpecialColumnValue("部门编号").ToString();
usr.Email = this.txtEmail.Text;
usr.IsDel = this.chkEnabled.Checked ? true : false;
usr.Password = this.txtPassword.Text;
usr.Phone = this.txtPhone.Text;
usr.RealName = this.txtRealname.Text;
usr.Sex = this.cboGender.Text;
usr.UserName = this.txtUserName.Text;
//调用业务逻辑层的增加用户信息的方法
int iret = Accounts_UsersManager.AddUser(usr);
if (iret == 1)
{
this.ShowTopic("增加成功!");
//调用实例 中的方法
// frm.BindUsers();
//调用指针指向的方法
at();
if (this.chkClose.Checked)
{
this.Close();
}
this.ClearControls();
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 非空验证
private bool ValidateInput()
{
if(this.txtUserName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("用户名不能为空！");
this.txtUserName.Focus();
this.ActiveControl = this.txtUserName;
return false;
}
if (this.txtRealname.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("真实姓名不能为空！");
this.txtRealname.Focus();
this.ActiveControl = this.txtRealname;
return false;
}
if (this.cboGender.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("性别不能为空！");
this.cboGender.Focus();
this.ActiveControl = this.cboGender;
return false;
}
if (this.scbBuMen.SelectValue == null)
{
MessageBox.Show("所属部门不能为空不能为空！");
this.scbBuMen.Focus();
this.ActiveControl = this.scbBuMen;
return false;
}
if (this.txtPassword.Text.Trim().Equals(string.Empty) || this.txtConfirmPassword.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("密码框不能为空！");
this.txtPassword.Focus();
this.ActiveControl = this.txtPassword;
return false;
}
if (!this.txtPassword.Text.Trim().Equals(this.txtConfirmPassword.Text.Trim()))
{
MessageBox.Show("两次密码输入不一致！");
this.txtConfirmPassword.Text = "";
this.txtPassword.Text = "";
this.txtPassword.Focus();
this.ActiveControl = this.txtPassword;
return false;
}
return true;
}
#endregion
#region 清空输入控件
private void ClearControls()
{
try
{
foreach (Control control in this.grbOperatorAdd.Controls)
{
if (control.GetType().ToString().Equals("DevExpress.XtraEditors.TextEdit"))
{
(control as DevExpress.XtraEditors.TextEdit).Text = "";
}
if (control.GetType().ToString().Equals("System.Windows.Forms.ComboBox"))
{
(control as System.Windows.Forms.ComboBox).Text = "";
}
if (control.GetType().ToString().Equals("MyController.SeachComboBox"))
{
(control as MyController.SeachComboBox).Text = "";
}
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 根据用户编号得到用户信息
private void GetEditUserInfo()
{
if (userId != null)
{
try
{
auEdit = Accounts_UsersManager.GetOneUser(userId);
this.txtConfirmPassword.Text = auEdit.Password;
this.txtEmail.Text = auEdit.Email;
this.txtPassword.Text = auEdit.Password;
this.txtPhone.Text = auEdit.Phone;
this.txtRealname.Text = auEdit.RealName;
this.txtUserName.Text = auEdit.UserName;
this.cboGender.Text = auEdit.Sex;
this.dtpBirthDay.Value = auEdit.Birthday.Year < 9 ? DateTime.Now : auEdit.Birthday;
this.scbBuMen.SetSelectedItem(auEdit.Department.depId);
this.Text = "修改用户信息";
this.btnEdit.Text = "修改";
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
else
{
this.Text = "新增用户信息";
this.btnEdit.Text = "增加";
}
}
#endregion
#region 修改用户信息
private void EidtUser()
{
try
{
auEdit.AddTime = DateTime.Now;
auEdit.Birthday = this.dtpBirthDay.Value;
//在增加用户信息时外键对象如何处理
auEdit.Department = new Accounts_Department();
auEdit.Department.depId = this.scbBuMen.GetCurrentSpecialColumnValue("部门编号").ToString();
auEdit.Email = this.txtEmail.Text;
auEdit.IsDel = this.chkEnabled.Checked ? true : false;
auEdit.Password = this.txtPassword.Text;
auEdit.Phone = this.txtPhone.Text;
auEdit.RealName = this.txtRealname.Text;
auEdit.Sex = this.cboGender.Text;
auEdit.UserName = this.txtUserName.Text;
//调用业务逻辑层的增加用户信息的方法
int iret = Accounts_UsersManager.EditUser(auEdit);
if (iret == 1)
{
this.ShowTopic("修改成功!");
//调用实例 中的方法
// frm.BindUsers();
//调用指针指向的方法
at();
this.Close();
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
}
角色CRUD代码：（UI）
public partial class FrmRoleManager : FrmUIBase
{
public FrmRoleManager()
{
InitializeComponent();
}
#region 事件列表
private void btnAdd_Click(object sender, EventArgs e)
{
AddRole();
}
private void FrmRoleManager_Load(object sender, EventArgs e)
{
this.BindAllRoles();
}
private void btnDel_Click(object sender, EventArgs e)
{
this.DeleteRole();
}
private void btnEdit_Click(object sender, EventArgs e)
{
GetEditRoleId();
}
private void btnSearch_Click(object sender, EventArgs e)
{
SearchInfoByCondition();
}
#endregion
#region 功能列表
#region 绑定角色信息
private void BindAllRoles()
{
GetRoles("");
}
private void GetRoles(string strWhere = "")
{
try
{
//显示滚动条
WaitDialogForm wdf = new WaitDialogForm("正在努力加载中......");
wdf.Show();
//调用业务逻辑层取数据
List<Accounts_Role> aus = Accounts_RolesManager.GetAllRoles(strWhere);
//显示数据
this.gcRoles.DataSource = aus;
//去掉分组面板
this.grvRoles.OptionsView.ShowGroupPanel = false;
//隐藏滚动条
wdf.Close();
}
catch (Exception ex)
{
//显示异常信息
MessageBox.Show(ex.Message);
}
}
#endregion
#region 删除角色信息
private void DeleteRole()
{
try
{
//1.得到要删除的角色的编号
Accounts_Role au = this.grvRoles.GetRow(this.grvRoles.GetSelectedRows()[0]) as Accounts_Role;
DialogResult dr = this.ShowQuestion("您确定要删除选中的角色【" + au.rName + "】的信息吗");
if (dr == System.Windows.Forms.DialogResult.Yes)
{
int iret = Accounts_RolesManager.DeleteRole(au.rId);
if (iret == 1)
{
this.ShowSucess("删除成功！");
this.BindAllRoles();//重新绑定数据
}
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 查询和显示要编辑的角色的编号
private void GetEditRoleId()
{
//1.得到要编辑的角色的编号
Accounts_Role au = this.grvRoles.GetRow(this.grvRoles.GetSelectedRows()[0]) as Accounts_Role;
if (au != null)
{
FrmRoleEdit frm = new FrmRoleEdit();
frm.RoleId = au.rId;
frm.at = this.BindAllRoles;
frm.ShowDialog();
}
}
#endregion
#region 增加角色信息
private void AddRole()
{
FrmRoleEdit frm = new FrmRoleEdit();
//把当窗体赋值另外一个窗体的变量
frm.frm = this;
//只是把方法赋值给另外一个窗体的指针(委托)
frm.at = this.BindAllRoles;
frm.ShowDialog();
}
#endregion
#region 查询数据
private void SearchInfoByCondition()
{
string strCondition = string.Format(" and [rName] like '%{0}%' or [rRemark] like '%{0}%'", this.txtSearch.Text.Trim());
this.GetRoles(strCondition);
}
#endregion
#endregion
}
Dal层：
public class Accounts_RolesService
{
#region 查询所有的角色信息
/// <summary>
/// 查询所有的角色信息
/// </summary>
/// <returns>角色信息的泛型集合</returns>
public static List<Accounts_Role> GetAllRoles(string strWhere = "")
{
try
{
#region sql语句
string sql = @"select * from [dbo].[Accounts_Roles] where 1=1 " + strWhere;
#endregion
#region 用sqlhelper执行SQL语句
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connString
, CommandType.Text, sql, null))
{
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
//用来存放用户的角色信息的泛型集合
List<Accounts_Role> aus = new List<Accounts_Role>();
//通过循环把表中每一行数据转换一个实体
foreach (DataRow dr in dt.Rows)
{//每循环一次就会创建一个实体对象
Accounts_Role au = new Accounts_Role();
if (dr["rAddTime"].ToString() != "")
{
au.rAddTime = DateTime.Parse(dr["rAddTime"].ToString());
}
au.rId = int.Parse(dr["rId"].ToString());
au.rName = dr["rName"].ToString();
au.rRemark = dr["rRemark"].ToString();
au.rIsShow = bool.Parse(dr["rIsShow"].ToString());
au.rIsDel = bool.Parse(dr["rIsDel"].ToString());
aus.Add(au);
}
return aus;
}
}
#endregion
return null;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 查询一个角色信息
/// <summary>
/// 查询一个角色信息
/// </summary>
/// <returns>查询到的用户的角色对象</returns>
public static Accounts_Role GetOneRole(int? roleId)
{
try
{
#region sql语句
string sql = @"select * from [dbo].[Accounts_Roles]
where rId =@rId";
SqlParameter para = new SqlParameter("@rId", roleId);
#endregion
#region 用sqlhelper执行SQL语句
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.connString
, CommandType.Text, sql, para))
{
if (reader.Read())
{
Accounts_Role au = new Accounts_Role();
if (reader["rAddTime"].ToString() != "")
{
au.rAddTime = DateTime.Parse(reader["rAddTime"].ToString());
}
au.rId = int.Parse(reader["rId"].ToString());
au.rName = reader["rName"].ToString();
au.rRemark = reader["rRemark"].ToString();
au.rIsShow = bool.Parse(reader["rIsShow"].ToString());
au.rIsDel = bool.Parse(reader["rIsDel"].ToString());
return au;
}
}
#endregion
return null;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 增加角色信息
/// <summary>
/// 增加角色信息
/// <param name="usr">角色实体</param>
/// </summary>
public static int AddRole(Accounts_Role role)
{
try
{
#region sql准备
string sql = string.Format(@"
INSERT INTO [dbo].[Accounts_Roles]
([rName]
,[rRemark]
,[rIsShow]
,[rIsDel]
,[rAddTime])
VALUES
(@rName
,@rRemark
,@rIsShow
,@rIsDel
,@rAddTime)");
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@rName",role.rName),
new SqlParameter("@rRemark",role.rRemark),
new SqlParameter("@rIsShow",role.rIsShow),
new SqlParameter("@rIsDel",role.rIsDel),
new SqlParameter("@rAddTime",role.rAddTime)
};
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, paras);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 删除角色信息
/// <summary>
/// 删除角色信息
/// <param name="roleId">角色编号</param>
/// </summary>
public static int DeleteRole(int? roleId)
{
try
{
#region sql准备
string sql = @"delete from [dbo].[Accounts_Roles]
where rId =@rId";
SqlParameter para = new SqlParameter("@rId", roleId);
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, para);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 修改角色信息
/// <summary>
/// 修改角色信息
/// <param name="role">角色实体</param>
/// </summary>
public static int EditRole(Accounts_Role role)
{
try
{
#region sql准备
string sql = @"
UPDATE [dbo].[Accounts_Roles]
SET [rName] = @rName
,[rRemark] = @rRemark
,[rIsShow] = @rIsShow
,[rIsDel] = @rIsDel
,[rAddTime] = @rAddTime
WHERE [rId]= @rId";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@rName",role.rName),
new SqlParameter("@rRemark",role.rRemark),
new SqlParameter("@rIsShow",role.rIsShow),
new SqlParameter("@rIsDel",role.rIsDel),
new SqlParameter("@rAddTime",role.rAddTime),
new SqlParameter("@rId",role.rId)
};
#endregion
#region 通过sqlHelper执行增加操作
return SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text
, sql, paras);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
BLL层：
public class Accounts_RolesManager
{
#region 业务一:查询所有的角色信息
/// <summary>
/// 查询所有的角色信息
/// </summary>
/// <returns>角色信息的泛型集合</returns>
public static List<Accounts_Role> GetAllRoles(string strWhere = "")
{
try
{
return Accounts_RolesService.GetAllRoles(strWhere);
}
catch (Exception ex)
{ //抛出异常(表示层)
throw ex;
}
}
#endregion
#region 业务三:增加角色信息
/// <summary>
/// 增加角色信息
/// <param name="usr">角色实体</param>
/// </summary>
public static int AddRole(Accounts_Role usr)
{
try
{
return Accounts_RolesService.AddRole(usr);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务四:删除角色信息
/// <summary>
/// 删除角色信息
/// <param name="RoleId">角色编号</param>
/// </summary>
public static int DeleteRole(int RoleId)
{
try
{
return Accounts_RolesService.DeleteRole(RoleId);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务五:查询一个角色信息
/// <summary>
/// 查询一个角色信息
/// </summary>
/// <returns>查询到的角色对象</returns>
public static Accounts_Role GetOneRole(int? RoleId)
{
try
{
return Accounts_RolesService.GetOneRole(RoleId);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 业务六:修改角色信息
/// <summary>
/// 修改角色信息
/// <param name="usr">角色实体</param>
/// </summary>
public static int EditRole(Accounts_Role usr)
{
try
{
return Accounts_RolesService.EditRole(usr);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
修改的代码：（UI）
public partial class FrmRoleEdit : FrmUIBase
{
#region 全局变量
//FrmRoleManager窗体的实例
public FrmRoleManager frm = null;
//指向FrmRoleManager窗体中的BindRoles方法指针
public Action at = null;
/// <summary>
/// 要修改的用户编号
/// </summary>
public int? RoleId = null;
//保存要修改的用户对象
private Accounts_Role auEdit = null;
#endregion
public FrmRoleEdit()
{
InitializeComponent();
}
#region 事件列表
private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (ValidateInput())
{
if (RoleId == null)
{
this.AddRole();
}
else
{
this.EidtRole();
}
}
}
private void FrmRoleEdit_Load(object sender, EventArgs e)
{
GetEditRoleInfo();
this.ActiveControl = this.txtRoleName;
}
#endregion
#region 功能列表
#region 添加角色信息
private void AddRole()
{
try
{
//创建一个要增加的实体类
Accounts_Role role = new Accounts_Role();
role.rAddTime = DateTime.Now;
role.rIsDel = this.chkEnabled.Checked;
role.rIsShow = this.chkShow.Checked;
role.rName = this.txtRoleName.Text;
role.rRemark = this.txtRemark.Text;
//调用业务逻辑层的增加用户信息的方法
int iret = Accounts_RolesManager.AddRole(role);
if (iret == 1)
{
this.ShowTopic("增加成功！");
//调用实例中的方法
//frm.BindRoles();
//调用指针指向的方法
at();
if (this.chkClose.Checked)
{
this.Close();
}
this.ClearControls();
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 非空验证
private bool ValidateInput()
{
if (this.txtRoleName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("角色名不能为空！");
this.txtRoleName.Focus();
this.ActiveControl = this.txtRoleName;
return false;
}
if (this.txtRemark.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("角色说明不能为空！");
this.txtRemark.Focus();
this.ActiveControl = this.txtRemark;
return false;
}
return true;
}
#endregion
#region 清空输入控件
private void ClearControls()
{
try
{
foreach (Control control in this.grbOperatorAdd.Controls)
{
if (control.GetType().ToString().Equals("DevExpress.XtraEditors.TextEdit"))
{
(control as DevExpress.XtraEditors.TextEdit).Text = "";
}
if (control.GetType().ToString().Equals("System.Windows.Forms.ComboBox"))
{
(control as System.Windows.Forms.ComboBox).Text = "";
}
if (control.GetType().ToString().Equals("MyController.SeachComboBox"))
{
(control as MyController.SeachComboBox).Text = "";
}
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#region 根据角色编号得到角色编号
private void GetEditRoleInfo()
{
if (RoleId != null)
{
try
{
auEdit = Accounts_RolesManager.GetOneRole(RoleId);
this.txtRoleName.Text = auEdit.rName;
this.txtRemark.Text = auEdit.rRemark;
this.chkShow.Checked = auEdit.rIsShow;
this.chkEnabled.Checked = auEdit.rIsDel;
this.Text = "修改角色信息";
this.btnEdit.Text = "修改";
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
else
{
this.Text = "新增角色信息";
this.btnEdit.Text = "增加";
}
}
#endregion
#region 修改用户信息
private void EidtRole()
{
try
{
auEdit.rAddTime = DateTime.Now;
auEdit.rIsDel = this.chkEnabled.Checked;
auEdit.rIsShow = this.chkShow.Checked;
auEdit.rName = this.txtRoleName.Text;
auEdit.rRemark = this.txtRemark.Text;
//调用业务逻辑层的增加用户信息的方法
int iret = Accounts_RolesManager.EditRole(auEdit);
if (iret == 1)
{
this.ShowTopic("修改成功！");
//调用实例中的方法
//frm.BindRoles();
//调用指针指向的方法
at();
this.Close();
}
}
catch (Exception ex)
{
this.ShowError(ex.Message);
}
}
#endregion
#endregion
}
部门管理的代码Dal：
public class Accounts_DepartmentsService
{
#region 根据部门编号得到部门信息
/// <summary>
///根据部门编号得到部门信息
/// </summary>
/// <param name="id">部门编号</param>
/// <returns></returns>
public static Accounts_Department GetDepartmentByDtId(string id)
{
#region sql语句
string sql = string.Format(@"SELECT *
FROM [dbo].[Accounts_Departments] where [depId] = '{0}'", id);
#endregion
#region 根据sql语句再结合sqlhelper取数据
//创建集合来保存取出的数据
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text
, sql, null))
{
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
Accounts_Department ad = new Accounts_Department();
foreach (DataRow dr in dt.Rows)
{
//每循环一次，就把把一行数据转换成一个对象
ad.depId = dr["depId"].ToString();
ad.depPid = dr["depPid"].ToString();
ad.depName = dr["depName"].ToString();
ad.depRemark = dr["depRemark"].ToString();
ad.depIsDel = bool.Parse(dr["depIsDel"].ToString());
ad.depAddTime = DateTime.Parse(dr["depAddTime"].ToString());
}
return ad;
}
}
return null;
#endregion
}
#endregion
#region 得到所有部门信息
/// <summary>
///得到所有部门信息
/// </summary>
/// <returns></returns>
public static List<Accounts_Department> GetDepartments()
{
#region sql语句
string sql = string.Format(@"SELECT *
FROM [dbo].[Accounts_Departments]");
#endregion
#region 根据sql语句再结合sqlhelper取数据
//创建集合来保存取出的数据
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text
, sql, null))
{
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
List<Accounts_Department> ads = new List<Accounts_Department>();
foreach (DataRow dr in dt.Rows)
{
//每循环一次，就把把一行数据转换成一个对象
Accounts_Department ad = new Accounts_Department();
ad.depId = dr["depId"].ToString();
ad.depPid = dr["depPid"].ToString();
ad.depName = dr["depName"].ToString();
ad.depRemark = dr["depRemark"].ToString();
ad.depIsDel = bool.Parse(dr["depIsDel"].ToString());
ad.depAddTime = DateTime.Parse(dr["depAddTime"].ToString());
ads.Add(ad);
}
return ads;
}
}
return null;
#endregion
}
#endregion
#region 得到所有部门信息
/// <summary>
///得到所有部门信息
/// </summary>
/// <returns></returns>
public static DataTable GetDepartmentsToTable()
{
#region sql语句
string sql = string.Format(@"select *,[dbo].[fun_getPY]([depName]) as PinYin
,[dbo].[fun_getWB]([depName]) as WuBi
from [dbo].[Accounts_Departments]");
#endregion
#region 根据sql语句再结合sqlhelper取数据
//创建集合来保存取出的数据
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text
, sql, null))
{
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
return dt;
}
}
return null;
#endregion
}
#endregion
}
Bll层：
public class Accounts_DepartmentManager
{
#region 得到所有部门信息
/// <summary>
///得到所有部门信息
/// </summary>
/// <returns></returns>
public static List<Accounts_Department> GetDepartments()
{
try
{
return Accounts_DepartmentsService.GetDepartments();
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 得到所有部门信息
/// <summary>
///得到所有部门信息
/// </summary>
/// <returns></returns>
public static DataTable GetDepartmentsToTable()
{
try
{
return Accounts_DepartmentsService.GetDepartmentsToTable();
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
