毅世纪OA管理系统C#、winfrom管理

开发语言：C#
实例大小：24.49M
实例类别：C#数据库操作
【实例简介】
毅世纪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();
///
/// 注册
///
///
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 查询
///
/// 查询所有用户信息
///
///
public DataTable GetAll()
{
string sql = “select * from userinfo where isdelete=0”;
return SqlHelper.ExecuteDateSet(sql, CommandType.Text, null).Tables[0];
}
///
/// 根据账号、密码、角色类型查询是否存在账号
///
///
///
///
///
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;
}
///
///通过用户名和密码查询数据
///
///
///
///
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;
}
///
/// 根据名字搜索数据
///
///
///
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];
}
///
/// 根据登录名搜索数据
///
///
///
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];
}
///
/// 通过Uid查询信息
///
///
///
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 修改
///
/// 根据uid修改登录信息
///
///
///
///
///
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;
}
///
/// 根据Uid修改用户信息
///
///
///
///
///
///
///
///
///
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;
}
///
/// 通过Uid 逻辑删除部门信息
///
///
///
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 权限
///
/// 添加权限
///
///
///
///
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;
}
///
/// 通过Uid先删除权限数据
///
///
///
public bool DeleteByUID(int uid)
{
string sql = “delete from Userinfopage where uID=” uid;
return SqlHelper.ExecuteNonQuery(sql, CommandType.Text, null) > 0 ? true : false;
}
///
/// 通过登陆id获得权限信息
///
///
///
public DataTable GetDatasToPower(int uid)
{
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter(“uid”,uid)
};
return SqlHelper.ExecuteDateSet(“UserInfopage_SelectToPower”, CommandType.StoredProcedure, sps).Tables[0];
}
///
/// 获得所有信息
///
///
public DataTable GetAllInfo(string realname)
{
SqlParameter[] sps = new SqlParameter[] {
new SqlParameter("@realname",realname)
};
return SqlHelper.ExecuteDateSet(“UserInfo_SelectAll”, CommandType.StoredProcedure, sps).Tables[0];
}
///
/// 用户部门权限获得所有的页面信息
///
///
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
}
}
内容转载自网站： 阁楼网源 -最干净的资源网站