实例介绍
【实例简介】
毅世纪OA管理系统，近期才写好的一个完整的管理系统，数据库离不开”增删改查“，简约型风格
C# winfrom 窗体页面，动态生成页面，业务逻辑流通，可以修改，文档说明！
动态生成方法：直接在数据库操作即可 不懂的可以看文档交流
【实例截图】
【核心代码】
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
namespace DAL
{
public class UserInfoDAL
{
UserInfo ui = new UserInfo();
/// <summary>
/// 注册
/// </summary>
/// <returns></returns>
public bool Add(string loginName, string loginPwd, string email, string realName, string phone, string address, DateTime birthday, int ur_id, int ud_id, int uj_id, string sex, string remark)
{
string sql = string.Format("insert into userinfo(ur_id,ud_id,uj_id,LoginName,loginPwd,realName,Email,address,birthday,sex,phone,remark) values({0},{1},{2},'{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", ur_id, ud_id, uj_id, loginName, loginPwd, realName, email, address, birthday, sex, phone, remark);
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
#region 查询
/// <summary>
/// 查询所有用户信息
/// </summary>
/// <returns></returns>
public DataTable GetAll()
{
string sql = "select * from userinfo where isdelete=0";
return SqlHelper.ExecuteDateSet(sql, CommandType.Text, null).Tables[0];
}
/// <summary>
/// 根据账号、密码、角色类型查询是否存在账号
/// </summary>
/// <param name="loginName"></param>
/// <param name="loginPwd"></param>
/// <param name="ur_id"></param>
/// <returns></returns>
public bool GetDataByLoginNameAndPwd(string loginName, string loginPwd)
{
string sql = string.Format("select * from UserInfo where LoginName = '{0}' and LoginPwd = '{1}'and isdelete = 0", loginName, loginPwd);
return SqlHelper.ExecuteScaler(sql, CommandType.Text, null) == null ? false : true;
}
/// <summary>
///通过用户名和密码查询数据
/// </summary>
/// <param name="lName"></param>
/// <param name="lPwd"></param>
/// <returns></returns>
public UserInfo GetDataByLNameAndLPwd(string lName, string lPwd)
{
UserInfo ui = new UserInfo();
string sql = "select * from UserInfo where LoginName='" lName "' and LoginPwd='" lPwd "'and isdelete =0";
SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, null);
while (reader.Read())
{
ui.UID = (int)reader["UID"];
ui.RolesManage.RID = (int)reader["ur_id"];
ui.DepartmentManage.DID = (int)reader["ud_id"];
ui.JobManage.JID = (int)reader["uj_id"];
ui.LoginName = reader["LoginName"].ToString();
ui.LoginPwd = reader["LoginPwd"].ToString();
ui.RealName = reader["RealName"].ToString();
ui.Email = reader["Email"].ToString();
ui.Birthday = Convert.ToDateTime(reader["Birthday"]);
ui.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
ui.Address = reader["Address"].ToString();
ui.Phone = reader["Phone"].ToString();
ui.Sex = reader["Sex"].ToString();
ui.Remark = reader["Remark"].ToString();
ui.IsDelete = (bool)reader["isdelete"];
}
return ui;
}
/// <summary>
/// 根据名字搜索数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public DataTable GetDataByName(string name)
{
string sql = "select * from UserInfo where RealName like '%" name "%' and isdelete=0";
return SqlHelper.ExecuteDateSet(sql, CommandType.Text, null).Tables[0];
}
/// <summary>
/// 根据登录名搜索数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public DataTable GetDataByLoginName(string name)
{
string sql = "select * from UserInfo where LoginName like '%" name "%' and isdelete=0";
return SqlHelper.ExecuteDateSet(sql, CommandType.Text, null).Tables[0];
}
/// <summary>
/// 通过Uid查询信息
/// </summary>
/// <param name="did"></param>
/// <returns></returns>
public UserInfo GetInfoByUid(int uid)
{
UserInfo ui = new UserInfo();
string sql = "select * from UserInfo where uid=" uid "and isdelete =0";
SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, null);
while (reader.Read())
{
ui.UID = (int)reader["UID"];
ui.RolesManage.RID = (int)reader["ur_id"];
ui.DepartmentManage.DID = (int)reader["ud_id"];
ui.JobManage.JID = (int)reader["uj_id"];
ui.LoginName = reader["LoginName"].ToString();
ui.LoginPwd = reader["LoginPwd"].ToString();
ui.RealName = reader["RealName"].ToString();
ui.Email = reader["Email"].ToString();
ui.Address = reader["Address"].ToString();
ui.Birthday = Convert.ToDateTime(reader["Birthday"]);
ui.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
ui.Sex = reader["Sex"].ToString();
ui.Phone = reader["Phone"].ToString();
ui.Remark = reader["remark"].ToString();
}
return ui;
}
#endregion
#region 修改
/// <summary>
/// 根据uid修改登录信息
/// </summary>
/// <param name="uid"></param>
/// <param name="loginName"></param>
/// <param name="loginPwd"></param>
/// <returns></returns>
public bool UpdataLoginByUid(int uid, string loginName, string loginPwd)
{
string sql = string.Format("update userinfo set LoginName='{0}',LoginPwd='{1}' where uid={2}", loginName, loginPwd, uid);
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
/// <summary>
/// 根据Uid修改用户信息
/// </summary>
/// <param name="uid"></param>
/// <param name="name"></param>
/// <param name="address"></param>
/// <param name="phone"></param>
/// <param name="birthday"></param>
/// <param name="sex"></param>
/// <param name="remark"></param>
/// <returns></returns>
public bool UpdataInfoByUid(int uid, string name, string address, string phone, DateTime birthday, string sex, string remark)
{
string sql = string.Format("update userinfo set realname='{0}',address='{1}',phone='{2}',birthday='{3}',sex='{4}',remark='{5}' where uid={6}", name, address, phone, birthday, sex, remark, uid);
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
/// <summary>
/// 通过Uid 逻辑删除部门信息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public bool DeleteUserInfoByDId(int uid)
{
string sql = "update UserInfo set isdelete=1 where uID=" uid;
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
#endregion
#region 权限
/// <summary>
/// 添加权限
/// </summary>
/// <param name="uid"></param>
/// <param name="pid"></param>
/// <returns></returns>
public bool AddPower(int uid, int pid)
{
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter("@uid",uid),
new SqlParameter("@pid",pid)
};
return SqlHelper.ExecuteNonQuery("UserInfoPage_Add", CommandType.StoredProcedure, sps) > 0 ? true : false;
}
/// <summary>
/// 通过Uid先删除权限数据
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public bool DeleteByUID(int uid)
{
string sql = "delete from Userinfopage where uID=" uid;
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
/// <summary>
/// 通过登陆id获得权限信息
/// </summary>
/// <param name="loginId"></param>
/// <returns></returns>
public DataTable GetDatasToPower(int uid)
{
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter("uid",uid)
};
return SqlHelper.ExecuteDateSet("UserInfopage_SelectToPower", CommandType.StoredProcedure, sps).Tables[0];
}
/// <summary>
/// 获得所有信息
/// </summary>
/// <returns></returns>
public DataTable GetAllInfo(string realname)
{
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter("@realname",realname)
};
return SqlHelper.ExecuteDateSet("UserInfo_SelectAll", CommandType.StoredProcedure, sps).Tables[0];
}
/// <summary>
/// 用户部门权限获得所有的页面信息
/// </summary>
/// <returns></returns>
public DataTable getDatasToAllPower(int uid)
{
SqlParameter[] sps = new SqlParameter[]
{
new SqlParameter("@uid",uid)
};
DataTable dt = new DataTable();
DataSet ds = SqlHelper.ExecuteDateSet("UserInfoPage_SelectToPower", CommandType.StoredProcedure, sps);
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return dt;
}
#endregion
}
}
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)