Popedom | 用户权限清单 | Popedom_No | 权限序号 | int | NOT NULL | IDENTITY (1,1) | |||
Popedom | 用户权限清单 | UserID | 用户编号 | char | 6 | NULL | |||
Popedom | 用户权限清单 | Branch | 部门 | char | 20 | NULL | |||
Popedom | 用户权限清单 | ProgrameId | 权限名称 | varchar | 8 | NOT NULL | |||
Programes | 权限列表 | ProgrameId | 权限ID | varchar | 8 | NOT NULL | Primary Key | ||
Programes | 权限列表 | ProgrameName | 权限名称 | varchar | 50 | NULL |
tbmenu | 菜单表 | id | 菜单ID | int | NOT NULL | Primary Key | |||
tbmenu | 菜单表 | fmuname | 父菜单名 | varchar | 30 | NULL | |||
tbmenu | 菜单表 | fmuid | 父菜单id | int | NULL | ||||
tbmenu | 菜单表 | menuname | 菜单中文名称 | varchar | 30 | NULL | |||
tbmenu | 菜单表 | menucap | 菜单英文名称 | varchar | 60 | NULL | |||
tbrolemenu | 角色菜单表 | roleid | 角色ID | varchar | 8 | NOT NULL | |||
tbrolemenu | 角色菜单表 | menuid | 菜单ID | int | NOT NULL |
using System;
namespace xjy.Model
{
/// <summary>
/// 实体类Popedom 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public class Popedom
{
public Popedom()
{}
#region Model
private int _popedom_no;
private string _userid;
private string _branch;
private string _programeid;
/// <summary>
///
/// </summary>
public int Popedom_No
{
set{ _popedom_no=value;}
get{return _popedom_no;}
}
/// <summary>
///
/// </summary>
public string UserID
{
set{ _userid=value;}
get{return _userid;}
}
/// <summary>
///
/// </summary>
public string Branch
{
set{ _branch=value;}
get{return _branch;}
}
/// <summary>
///
/// </summary>
public string ProgrameId
{
set { _programeid = value; }
get { return _programeid; }
}
#endregion Model
}
}
using System;
namespace xjy.Model
{
/// <summary>
/// 实体类Programes 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public class Programes
{
public Programes()
{}
#region Model
private string _programeid;
private string _programename;
/// <summary>
///
/// </summary>
public string ProgrameId
{
set { _programeid = value; }
get { return _programeid; }
}
/// <summary>
///
/// </summary>
public string ProgrameName
{
set { _programename = value; }
get { return _programename; }
}
#endregion Model
}
}
using System;
namespace xjy.Model
{
/// <summary>
/// 实体类tbmenu 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public class tbmenu
{
public tbmenu()
{}
#region Model
private int _id;
private string _fmuname;
private int? _fmuid;
private string _menuname;
private string _menucap;
/// <summary>
///
/// </summary>
public int id
{
set{ _id=value;}
get{return _id;}
}
/// <summary>
///
/// </summary>
public string fmuname
{
set{ _fmuname=value;}
get{return _fmuname;}
}
/// <summary>
///
/// </summary>
public int? fmuid
{
set{ _fmuid=value;}
get{return _fmuid;}
}
/// <summary>
///
/// </summary>
public string menuname
{
set{ _menuname=value;}
get{return _menuname;}
}
/// <summary>
///
/// </summary>
public string menucap
{
set{ _menucap=value;}
get{return _menucap;}
}
#endregion Model
}
}
using System;
namespace xjy.Model
{
/// <summary>
/// 实体类tbrolemenu 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public class tbrolemenu
{
public tbrolemenu()
{}
#region Model
private string _roleid;
private int? _menuid;
/// <summary>
///
/// </summary>
public string roleid
{
set{ _roleid=value;}
get{return _roleid;}
}
/// <summary>
///
/// </summary>
public int? menuid
{
set{ _menuid=value;}
get{return _menuid;}
}
#endregion Model
}
}
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace xjy.DAL
{
/// <summary>
/// 数据访问类Popedom。
/// </summary>
public class Popedom
{
public Popedom()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Popedom_No)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from Popedom");
strSql.Append(" where Popedom_No=@Popedom_No ");
SqlParameter[] parameters = {
new SqlParameter("@Popedom_No", SqlDbType.Int,4)};
parameters[0].Value = Popedom_No;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(xjy.Model.Popedom model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Popedom(");
strSql.Append("UserID,Branch,ProgrameId)");
strSql.Append(" values (");
strSql.Append("@UserID,@Branch,@ProgrameId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Char,6),
new SqlParameter("@Branch", SqlDbType.Char,20),
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Branch;
parameters[2].Value = model.ProgrameId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.Popedom model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Popedom set ");
strSql.Append("UserID=@UserID,");
strSql.Append("Branch=@Branch,");
strSql.Append("ProgrameId=@ProgrameId");
strSql.Append(" where Popedom_No=@Popedom_No ");
SqlParameter[] parameters = {
new SqlParameter("@Popedom_No", SqlDbType.Int,4),
new SqlParameter("@UserID", SqlDbType.Char,6),
new SqlParameter("@Branch", SqlDbType.Char,20),
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8)};
parameters[0].Value = model.Popedom_No;
parameters[1].Value = model.UserID;
parameters[2].Value = model.Branch;
parameters[3].Value = model.ProgrameId;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int Popedom_No)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from Popedom ");
strSql.Append(" where Popedom_No=@Popedom_No ");
SqlParameter[] parameters = {
new SqlParameter("@Popedom_No", SqlDbType.Int,4)};
parameters[0].Value = Popedom_No;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一个用户权限
/// </summary>
public void DelUser(string user_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Popedom ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Char,6)};
parameters[0].Value = user_id;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.Popedom GetModel(int Popedom_No)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Popedom_No,UserID,Branch,ProgrameId from Popedom ");
strSql.Append(" where Popedom_No=@Popedom_No ");
SqlParameter[] parameters = {
new SqlParameter("@Popedom_No", SqlDbType.Int,4)};
parameters[0].Value = Popedom_No;
xjy.Model.Popedom model=new xjy.Model.Popedom();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["Popedom_No"].ToString()!="")
{
model.Popedom_No=int.Parse(ds.Tables[0].Rows[0]["Popedom_No"].ToString());
}
model.UserID=ds.Tables[0].Rows[0]["UserID"].ToString();
model.Branch=ds.Tables[0].Rows[0]["Branch"].ToString();
model.ProgrameId = ds.Tables[0].Rows[0]["ProgrameId"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select Popedom_No,UserID,Branch,ProgrameId ");
strSql.Append(" FROM Popedom ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ");
if(Top>0)
{
strSql.Append(" top "+Top.ToString());
}
strSql.Append(" Popedom_No,UserID,Branch,ProgrameId ");
strSql.Append(" FROM Popedom ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
strSql.Append(" order by " + filedOrder);
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "Popedom";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace xjy.DAL
{
/// <summary>
/// 数据访问类Programes。
/// </summary>
public class Programes
{
public Programes()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(String ProgrameId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from Programes");
strSql.Append(" where ProgrameId=@ProgrameId ");
SqlParameter[] parameters = {
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8)};
parameters[0].Value = ProgrameId;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(xjy.Model.Programes model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Programes(");
strSql.Append("ProgrameId,ProgrameName)");
strSql.Append(" values (");
strSql.Append("@ProgrameId,@ProgrameName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8),
new SqlParameter("@ProgrameName", SqlDbType.VarChar,50)};
parameters[0].Value = model.ProgrameId;
parameters[1].Value = model.ProgrameName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.Programes model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Programes set ");
strSql.Append("ProgrameName=@ProgrameName,");
strSql.Append(" where ProgrameId=@ProgrameId ");
SqlParameter[] parameters = {
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8),
new SqlParameter("@ProgrameName", SqlDbType.VarChar,50)};
parameters[0].Value = model.ProgrameId;
parameters[1].Value = model.ProgrameName;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(String ProgrameId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from Programes ");
strSql.Append(" where ProgrameId=@ProgrameId ");
SqlParameter[] parameters = {
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8)};
parameters[0].Value = ProgrameId;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.Programes GetModel(String ProgrameId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ProgrameId,ProgrameName from Programes ");
strSql.Append(" where ProgrameId=@ProgrameId ");
SqlParameter[] parameters = {
new SqlParameter("@ProgrameId", SqlDbType.VarChar,8)};
parameters[0].Value = ProgrameId;
xjy.Model.Programes model = new xjy.Model.Programes();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if (ds.Tables[0].Rows[0]["ProgrameId"].ToString() != "")
{
model.ProgrameId = ds.Tables[0].Rows[0]["ProgrameId"].ToString();
}
model.ProgrameName = ds.Tables[0].Rows[0]["ProgrameName"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ProgrameId,ProgrameName ");
strSql.Append(" FROM Programes ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ");
if(Top>0)
{
strSql.Append(" top "+Top.ToString());
}
strSql.Append(" ProgrameId,ProgrameName ");
strSql.Append(" FROM Programes ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
strSql.Append(" order by " + filedOrder);
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "Popedom";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace xjy.DAL
{
/// <summary>
/// 数据访问类tbmenu。
/// </summary>
public class tbmenu
{
public tbmenu()
{}
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return DbHelperSQL.GetMaxID("id", "tbmenu");
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from tbmenu");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(xjy.Model.tbmenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tbmenu(");
strSql.Append("id,fmuname,fmuid,menuname,menucap)");
strSql.Append(" values (");
strSql.Append("@id,@fmuname,@fmuid,@menuname,@menucap)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@fmuname", SqlDbType.VarChar,30),
new SqlParameter("@fmuid", SqlDbType.Int,4),
new SqlParameter("@menuname", SqlDbType.VarChar,30),
new SqlParameter("@menucap", SqlDbType.VarChar,60)};
parameters[0].Value = model.id;
parameters[1].Value = model.fmuname;
parameters[2].Value = model.fmuid;
parameters[3].Value = model.menuname;
parameters[4].Value = model.menucap;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.tbmenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tbmenu set ");
strSql.Append("fmuname=@fmuname,");
strSql.Append("fmuid=@fmuid,");
strSql.Append("menuname=@menuname,");
strSql.Append("menucap=@menucap");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@fmuname", SqlDbType.VarChar,30),
new SqlParameter("@fmuid", SqlDbType.Int,4),
new SqlParameter("@menuname", SqlDbType.VarChar,30),
new SqlParameter("@menucap", SqlDbType.VarChar,60)};
parameters[0].Value = model.id;
parameters[1].Value = model.fmuname;
parameters[2].Value = model.fmuid;
parameters[3].Value = model.menuname;
parameters[4].Value = model.menucap;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from tbmenu ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.tbmenu GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,fmuname,fmuid,menuname,menucap from tbmenu ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
xjy.Model.tbmenu model=new xjy.Model.tbmenu();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["id"].ToString()!="")
{
model.id=int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.fmuname=ds.Tables[0].Rows[0]["fmuname"].ToString();
if(ds.Tables[0].Rows[0]["fmuid"].ToString()!="")
{
model.fmuid=int.Parse(ds.Tables[0].Rows[0]["fmuid"].ToString());
}
model.menuname=ds.Tables[0].Rows[0]["menuname"].ToString();
model.menucap=ds.Tables[0].Rows[0]["menucap"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select id,fmuname,fmuid,menuname,menucap ");
strSql.Append(" FROM tbmenu ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/// <summary>
/// 获得父菜单列表
/// </summary>
public DataSet GetList(string strWhere,bool isfmuid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select distinct fmuid,fmuname");
strSql.Append(" FROM tbmenu ");
if (strWhere.Trim() != "")
{
strSql.Append(" where fmuid <> 0 and " + strWhere);
}
DataSet ds = DbHelperSQL.Query(strSql.ToString());
string menuid = "id in (";
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
menuid += ds.Tables[0].Rows[i]["fmuid"].ToString();
if (i < ds.Tables[0].Rows.Count - 1)
{
menuid += ",";
}
else
{
menuid += ")";
}
}
}
return GetList(menuid);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ");
if(Top>0)
{
strSql.Append(" top "+Top.ToString());
}
strSql.Append(" id,fmuname,fmuid,menuname,menucap ");
strSql.Append(" FROM tbmenu ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
strSql.Append(" order by " + filedOrder);
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "tbmenu";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace xjy.DAL
{
/// <summary>
/// 数据访问类tbrolemenu。
/// </summary>
public class tbrolemenu
{
public tbrolemenu()
{}
#region 成员方法
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(xjy.Model.tbrolemenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tbrolemenu(");
strSql.Append("roleid,menuid)");
strSql.Append(" values (");
strSql.Append("@roleid,@menuid)");
SqlParameter[] parameters = {
new SqlParameter("@roleid", SqlDbType.VarChar,8),
new SqlParameter("@menuid", SqlDbType.Int,4)};
parameters[0].Value = model.roleid;
parameters[1].Value = model.menuid;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.tbrolemenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tbrolemenu set ");
strSql.Append("roleid=@roleid,");
strSql.Append("menuid=@menuid");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@roleid", SqlDbType.VarChar,8),
new SqlParameter("@menuid", SqlDbType.Int,4)};
parameters[0].Value = model.roleid;
parameters[1].Value = model.menuid;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete()
{
//该表无主键信息,请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from tbrolemenu ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.tbrolemenu GetModel()
{
//该表无主键信息,请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 roleid,menuid from tbrolemenu ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
xjy.Model.tbrolemenu model=new xjy.Model.tbrolemenu();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
model.roleid=ds.Tables[0].Rows[0]["roleid"].ToString();
if(ds.Tables[0].Rows[0]["menuid"].ToString()!="")
{
model.menuid=int.Parse(ds.Tables[0].Rows[0]["menuid"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select roleid,menuid ");
strSql.Append(" FROM tbrolemenu ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ");
if(Top>0)
{
strSql.Append(" top "+Top.ToString());
}
strSql.Append(" roleid,menuid ");
strSql.Append(" FROM tbrolemenu ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
strSql.Append(" order by " + filedOrder);
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "tbrolemenu";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Collections.Generic;
using LTP.Common;
using xjy.Model;
namespace xjy.BLL
{
/// <summary>
/// 业务逻辑类Popedom 的摘要说明。
/// </summary>
public class Popedom
{
private readonly xjy.DAL.Popedom dal=new xjy.DAL.Popedom();
public Popedom()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Popedom_No)
{
return dal.Exists(Popedom_No);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(xjy.Model.Popedom model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.Popedom model)
{
dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int Popedom_No)
{
dal.Delete(Popedom_No);
}
/// <summary>
/// 删除一个用户权限
/// </summary>
public void DelUser(string user_id)
{
dal.DelUser(user_id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.Popedom GetModel(int Popedom_No)
{
return dal.GetModel(Popedom_No);
}
/// <summary>
/// 得到一个对象实体,从缓存中。
/// </summary>
public xjy.Model.Popedom GetModelByCache(int Popedom_No)
{
string CacheKey = "PopedomModel-" + Popedom_No;
object objModel = LTP.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(Popedom_No);
if (objModel != null)
{
int ModelCache = LTP.Common.ConfigHelper.GetConfigInt("ModelCache");
LTP.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch{}
}
return (xjy.Model.Popedom)objModel;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
return dal.GetList(Top,strWhere,filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.Popedom> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.Popedom> DataTableToList(DataTable dt)
{
List<xjy.Model.Popedom> modelList = new List<xjy.Model.Popedom>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
xjy.Model.Popedom model;
for (int n = 0; n < rowsCount; n++)
{
model = new xjy.Model.Popedom();
if(dt.Rows[n]["Popedom_No"].ToString()!="")
{
model.Popedom_No=int.Parse(dt.Rows[n]["Popedom_No"].ToString());
}
model.UserID=dt.Rows[n]["UserID"].ToString();
model.Branch=dt.Rows[n]["Branch"].ToString();
model.ProgrameId = dt.Rows[n]["ProgrameId"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 获取用户权限
/// </summary>
/// <param name="UserID">用户ID</param>
/// <returns>权限</returns>
public string SelectArign(string UserID)
{
string strWhere = "UserID = '" + UserID + "'";
DataSet ds = GetList(strWhere);
string arign = "";
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
arign += ds.Tables[0].Rows[i]["ProgrameId"].ToString();
if (i < ds.Tables[0].Rows.Count - 1)
{
arign += "','";
}
}
}
return arign;
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Collections.Generic;
using LTP.Common;
using xjy.Model;
namespace xjy.BLL
{
/// <summary>
/// 业务逻辑类Programes 的摘要说明。
/// </summary>
public class Programes
{
private readonly xjy.DAL.Programes dal = new xjy.DAL.Programes();
public Programes()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(String ProgrameId)
{
return dal.Exists(ProgrameId);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(xjy.Model.Programes model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.Programes model)
{
dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(String ProgrameId)
{
dal.Delete(ProgrameId);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.Programes GetModel(String ProgrameId)
{
return dal.GetModel(ProgrameId);
}
/// <summary>
/// 得到一个对象实体,从缓存中。
/// </summary>
public xjy.Model.Programes GetModelByCache(String ProgrameId)
{
string CacheKey = "ProgramesModel-" + ProgrameId;
object objModel = LTP.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(ProgrameId);
if (objModel != null)
{
int ModelCache = LTP.Common.ConfigHelper.GetConfigInt("ModelCache");
LTP.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch{}
}
return (xjy.Model.Programes)objModel;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
return dal.GetList(Top,strWhere,filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.Programes> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.Programes> DataTableToList(DataTable dt)
{
List<xjy.Model.Programes> modelList = new List<xjy.Model.Programes>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
xjy.Model.Programes model;
for (int n = 0; n < rowsCount; n++)
{
model = new xjy.Model.Programes();
if (dt.Rows[n]["ProgrameId"].ToString() != "")
{
model.ProgrameId = dt.Rows[n]["ProgrameId"].ToString();
}
model.ProgrameName = dt.Rows[n]["ProgrameName"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Collections.Generic;
using LTP.Common;
using xjy.Model;
namespace xjy.BLL
{
/// <summary>
/// 业务逻辑类tbmenu 的摘要说明。
/// </summary>
public class tbmenu
{
private readonly xjy.DAL.tbmenu dal=new xjy.DAL.tbmenu();
public tbmenu()
{}
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return dal.GetMaxId();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
return dal.Exists(id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(xjy.Model.tbmenu model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.tbmenu model)
{
dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int id)
{
dal.Delete(id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.tbmenu GetModel(int id)
{
return dal.GetModel(id);
}
/// <summary>
/// 得到一个对象实体,从缓存中。
/// </summary>
public xjy.Model.tbmenu GetModelByCache(int id)
{
string CacheKey = "tbmenuModel-" + id;
object objModel = LTP.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(id);
if (objModel != null)
{
int ModelCache = LTP.Common.ConfigHelper.GetConfigInt("ModelCache");
LTP.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch{}
}
return (xjy.Model.tbmenu)objModel;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得父菜单列表
/// </summary>
public DataSet GetList(string strWhere, bool isfmuid)
{
return dal.GetList(strWhere,isfmuid);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
return dal.GetList(Top,strWhere,filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.tbmenu> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.tbmenu> DataTableToList(DataTable dt)
{
List<xjy.Model.tbmenu> modelList = new List<xjy.Model.tbmenu>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
xjy.Model.tbmenu model;
for (int n = 0; n < rowsCount; n++)
{
model = new xjy.Model.tbmenu();
if(dt.Rows[n]["id"].ToString()!="")
{
model.id=int.Parse(dt.Rows[n]["id"].ToString());
}
model.fmuname=dt.Rows[n]["fmuname"].ToString();
if(dt.Rows[n]["fmuid"].ToString()!="")
{
model.fmuid=int.Parse(dt.Rows[n]["fmuid"].ToString());
}
model.menuname=dt.Rows[n]["menuname"].ToString();
model.menucap=dt.Rows[n]["menucap"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion 成员方法
}
}
using System;
using System.Data;
using System.Collections.Generic;
using LTP.Common;
using xjy.Model;
namespace xjy.BLL
{
/// <summary>
/// 业务逻辑类tbrolemenu 的摘要说明。
/// </summary>
public class tbrolemenu
{
private readonly xjy.DAL.tbrolemenu dal=new xjy.DAL.tbrolemenu();
public tbrolemenu()
{}
#region 成员方法
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(xjy.Model.tbrolemenu model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(xjy.Model.tbrolemenu model)
{
dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete()
{
//该表无主键信息,请自定义主键/条件字段
dal.Delete();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public xjy.Model.tbrolemenu GetModel()
{
//该表无主键信息,请自定义主键/条件字段
return dal.GetModel();
}
/// <summary>
/// 得到一个对象实体,从缓存中。
/// </summary>
public xjy.Model.tbrolemenu GetModelByCache()
{
//该表无主键信息,请自定义主键/条件字段
string CacheKey = "tbrolemenuModel-" ;
object objModel = LTP.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel();
if (objModel != null)
{
int ModelCache = LTP.Common.ConfigHelper.GetConfigInt("ModelCache");
LTP.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch{}
}
return (xjy.Model.tbrolemenu)objModel;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
return dal.GetList(Top,strWhere,filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.tbrolemenu> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<xjy.Model.tbrolemenu> DataTableToList(DataTable dt)
{
List<xjy.Model.tbrolemenu> modelList = new List<xjy.Model.tbrolemenu>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
xjy.Model.tbrolemenu model;
for (int n = 0; n < rowsCount; n++)
{
model = new xjy.Model.tbrolemenu();
model.roleid=dt.Rows[n]["roleid"].ToString();
if(dt.Rows[n]["menuid"].ToString()!="")
{
model.menuid=int.Parse(dt.Rows[n]["menuid"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 获取用户权限对于菜单ID
/// </summary>
/// <param name="whereArign">权限ID字符串</param>
/// <returns>菜单ID</returns>
public string SelectMenuid(string whereArign)
{
string strWhere = "roleid in ('" + whereArign + "')";
DataSet ds = GetList(strWhere);
string menuid = "";
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
menuid += ds.Tables[0].Rows[i]["menuid"].ToString();
if (i < ds.Tables[0].Rows.Count - 1)
{
menuid += ",";
}
}
}
return menuid;
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion 成员方法
}
}
/// <summary>
/// 根据权限设置菜单
/// </summary>
public void SetMenu()
{
Popedom pm = new Popedom();
string arign = pm.SelectArign(_userId);//取得用户权限
tbrolemenu trm = new tbrolemenu();
string menuid = trm.SelectMenuid(arign);//取得用户菜单ID号
tbmenu tm = new tbmenu();
string strWhere = "id in (" + menuid + ")";
DataSet ds = tm.GetList(strWhere,true);//取得一级菜单名列表
EnabledmainMenu(ds, strWhere);//设置一级菜单
}
/// <summary>
/// 设置可用的一级菜单
/// </summary>
/// <param name="ds">一级菜单名列表</param>
/// <param name="strWhere">条件语句</param>
private void EnabledmainMenu(DataSet ds, string strWhere)
{
string tmpWhere;
DataSet ds2;
tbmenu tm = new tbmenu();
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
ToolStripMenuItem item = new ToolStripMenuItem();
item.Name = dr["menucap"].ToString();//一级菜单的menuname
mainMenu.Items[item.Name].Enabled = true;//各一级菜单是主菜单mainMenu集合的项
tmpWhere = strWhere + " and fmuid = " + dr["id"].ToString();
ds2 = tm.GetList(tmpWhere);//取得二级菜单名列表
EnabledMenu(ds2, mainMenu.Items[item.Name]);//设置二级菜单
}
}
else
{
}
}
/// <summary>
/// 设置可用的二级菜单
/// </summary>
/// <param name="ds">二级菜单名列表</param>
/// <param name="item">一级菜单</param>
private void EnabledMenu(DataSet ds, ToolStripItem item)
{
string mname = item.Name;
ToolStripMenuItem pItem = (ToolStripMenuItem)item;
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
ToolStripMenuItem subItem = new ToolStripMenuItem();
subItem.Name = dr["menucap"].ToString();
try
{
pItem.DropDownItems[subItem.Name].Enabled = true;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
else
{
}
}
/// <summary>
/// 设置全部菜单不可用
/// </summary>
public void FlushMenu()
{
tbmenu tm = new tbmenu();
DataSet ds = tm.GetList("", true);//取得一级菜单名列表
HidemainMenu(ds);//设置一级菜单
}
/// <summary>
/// 将一级菜单设置不可用
/// </summary>
/// <param name="ds">一级菜单名列表</param>
private void HidemainMenu(DataSet ds)
{
string tmpWhere;
DataSet ds2;
tbmenu tm = new tbmenu();
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
ToolStripMenuItem item = new ToolStripMenuItem();
item.Name = dr["menucap"].ToString();//一级菜单的menuname
mainMenu.Items[item.Name].Enabled = false;//各一级菜单是主菜单mainMenu集合的项
tmpWhere = " fmuid = " + dr["id"].ToString();
ds2 = tm.GetList(tmpWhere);//取得二级菜单名列表
HideMenu(ds2, mainMenu.Items[item.Name]);//设置二级菜单
}
}
else
{
}
}
/// <summary>
/// 将二级菜单设置不可用
/// </summary>
/// <param name="ds">二级菜单名列表</param>
/// <param name="item">一级菜单</param>
private void HideMenu(DataSet ds, ToolStripItem item)
{
string mname = item.Name;
ToolStripMenuItem pItem = (ToolStripMenuItem)item;
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
ToolStripMenuItem subItem = new ToolStripMenuItem();
subItem.Name = dr["menucap"].ToString();
try
{
pItem.DropDownItems[subItem.Name].Enabled = false;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
else
{
}
}
private void btnOk_Click(object sender, EventArgs e)
{
BLL.Popedom po = new xjy.BLL.Popedom();
Model.Popedom pom = new xjy.Model.Popedom();
pom.UserID = this._usm.UserID;
pom.Branch = this._usm.Branch;
po.DelUser(this._usm.UserID.Trim());
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
bool select = Convert.ToBoolean(this.dataGridView1.Rows[i].Cells[0].Value);
if (select)
{
pom.ProgrameId = this.dataGridView1.Rows[i].Cells["ProgrameID"].Value.ToString();
po.Add(pom);
}
}
MessageBox.Show("修改成功!");
this.Close();
}