public int UpdateRole(Entity.User.UserRole role)
{
string sqlstr = @"update t_R_Role set RoleName='" + role.CName + "'" +
",LevelID=" + role.ILevel +
",ReadRight='" + role.ReadRight + "'" +
",WriteRight='" + role.WriteRight + "'" +
",ImportRight='" + role.ImportRight + "'" +
",ExportRight='" + role.ExportRight + "'" +
",UpLoadRight='" + role.UpLoadRight + "'" +
",CheckRight='" + role.CheckRight + "'" +
",bAdmin='" + role.Admin + "'" +
" where RoleID='" + role.ID + "'";
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.Text, sqlstr, prams);
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
/// 获取所有角色
/// </summary>
/// <returns></returns>
public List <Entity.User.UserRole> GetAllUserRole()
{
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
List <Entity.User.UserRole> list = null;
Entity.User.UserRole entity = null;
try
{
IDbDataParameter[] prams = { };
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_GetAllRoles", prams);
list = new List <Entity.User.UserRole>();
while (dataReader.Read())
{
entity = new Entity.User.UserRole();
entity.ID = int.Parse(dataReader["ID"].ToString());
entity.CName = dataReader["cName"].ToString();
entity.IRole = int.Parse(dataReader["iRole"].ToString());
entity.CImage = dataReader["cImage"].ToString();
list.Add(entity);
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(list);
}
public List <Entity.User.UserRole> ListUserRole(int searchlevel, string role, int level)
{
Entity.User.UserRole entity = null;
List <Entity.User.UserRole> list = new List <Entity.User.UserRole>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
string constr = "";
if (searchlevel != 0)
{
constr += " and t_R_Level.id=" + searchlevel + "";
}
if (role != "")
{
constr = " and RoleName like '%" + role + "%'";
}
IDbDataParameter[] prams =
{
};
string strSql = "select * from t_R_Role inner join t_R_Level on t_R_Role.LevelID=t_R_Level.id where t_R_Level.id>=" + level + "" + constr;
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
entity = new Entity.User.UserRole();
entity.ID = int.Parse(dataReader["RoleID"].ToString());
entity.CName = dataReader["RoleName"].ToString();
entity.ILevel = int.Parse(dataReader["ILevel"].ToString());
entity.ReadRight = int.Parse(dataReader["ReadRight"].ToString());
entity.WriteRight = int.Parse(dataReader["WriteRight"].ToString());
entity.ImportRight = int.Parse(dataReader["ImportRight"].ToString());
entity.ExportRight = int.Parse(dataReader["ExportRight"].ToString());
entity.UpLoadRight = int.Parse(dataReader["UpLoadRight"].ToString());
entity.CheckRight = int.Parse(dataReader["CheckRight"].ToString());
entity.Admin = int.Parse(dataReader["bAdmin"].ToString());
list.Add(entity);
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(list);
}
public List <Entity.User.UserRole> RoleList(int ILevel)
{
Entity.User.UserRole entity = null;
List <Entity.User.UserRole> list = new List <Entity.User.UserRole>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
string constr = "";
IDbDataParameter[] prams =
{
};
string strSql = "select * from t_R_Role inner join t_R_UserLevel on t_R_UserLevel.id=t_R_Role.LevelID where LevelID>'" + ILevel + "' ";
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
entity = new Entity.User.UserRole();
entity.ID = int.Parse(dataReader["RoleID"].ToString());
entity.CName = dataReader["RoleName"].ToString();
entity.ILevel = int.Parse(dataReader["LevelID"].ToString());
entity.ReadRight = int.Parse(dataReader["ReadRight"].ToString());
entity.WriteRight = int.Parse(dataReader["WriteRight"].ToString());
entity.ImportRight = int.Parse(dataReader["ImportRight"].ToString());
entity.ExportRight = int.Parse(dataReader["ExportRight"].ToString());
entity.UpLoadRight = int.Parse(dataReader["UpLoadRight"].ToString());
entity.CheckRight = int.Parse(dataReader["CheckRight"].ToString());
if (dataReader["bAdmin"].ToString() != "")
{
entity.Admin = int.Parse(dataReader["bAdmin"].ToString());
}
else
{
entity.Admin = 0;
}
list.Add(entity);
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(list);
}
public int AddRole(Entity.User.UserRole role)
{
// string sqlstr = "insert into t_R_Role(RoleName,LevelID,ReadRight,WriteRight,ImportRight,ExportRight,UpLoadRight,CheckRight)values('" + role.CName + "'," + role.ILevel + ",'" + role.ReadRight + "','" + role.WriteRight + "','" + role.ImportRight + "','" + role.ExportRight + "','" + role.UpLoadRight + "','" + role.CheckRight + "')";
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@RoleName", DBTypeConverter.ConvertCsTypeToOriginDBType(role.CName.GetType().ToString()), role.CName, 50),
dbFactory.MakeInParam("@LevelID", DBTypeConverter.ConvertCsTypeToOriginDBType(role.ILevel.GetType().ToString()), role.ILevel, 0),
dbFactory.MakeInParam("@ReadRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.ReadRight.GetType().ToString()), role.ReadRight, 0),
dbFactory.MakeInParam("@WriteRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.WriteRight.GetType().ToString()), role.WriteRight, 0),
dbFactory.MakeInParam("@ImportRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.ImportRight.GetType().ToString()), role.ImportRight, 0),
dbFactory.MakeInParam("@ExportRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.ExportRight.GetType().ToString()), role.ExportRight, 0),
dbFactory.MakeInParam("@UpLoadRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.UpLoadRight.GetType().ToString()), role.UpLoadRight, 0),
dbFactory.MakeInParam("@CheckRight", DBTypeConverter.ConvertCsTypeToOriginDBType(role.CheckRight.GetType().ToString()), role.CheckRight, 0),
dbFactory.MakeInParam("@bAdmin", DBTypeConverter.ConvertCsTypeToOriginDBType(role.Admin.GetType().ToString()), role.Admin, 0),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AddRole", prams);
int roleid = int.Parse(prams[9].Value.ToString());
DAl.Menu.Menu menu = new Menu.Menu();
List <Entity.Menu> MenuList = menu.GetMenusByIsShow(1);
foreach (Entity.Menu entity in MenuList)
{
string str = @"insert into t_R_RoleMenu(MenuID,RoleID,checked,createuser,createdate)values('" + entity.ID + "','" + roleid + "','0','" + role.CreateUser + "','" + role.CreateDate + "')";
db.ExecuteNonQueryTrans(trans, CommandType.Text, str, prams);
}
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
public Entity.User.UserRole GetUserRole(int UserID)
{
Entity.User.UserRole entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string strSql = "select * from Users inner join t_R_Role on t_R_Role.RoleID=Users.iRoleType where Users.ID='" + UserID + "'";;
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
entity = new Entity.User.UserRole();
entity.ID = int.Parse(dataReader["RoleID"].ToString());
entity.CName = dataReader["RoleName"].ToString();
entity.ILevel = int.Parse(dataReader["LevelID"].ToString());
entity.ReadRight = int.Parse(dataReader["ReadRight"].ToString());
entity.WriteRight = int.Parse(dataReader["WriteRight"].ToString());
entity.ImportRight = int.Parse(dataReader["ImportRight"].ToString());
entity.ExportRight = int.Parse(dataReader["ExportRight"].ToString());
entity.UpLoadRight = int.Parse(dataReader["UpLoadRight"].ToString());
entity.CheckRight = int.Parse(dataReader["CheckRight"].ToString());
entity.Admin = int.Parse(dataReader["bAdmin"].ToString());
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(entity);
}
public int CheckRoleUserRole(string role, int RoleID)
{
int ret = 0;
Entity.User.UserRole entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string strSql = "select * from t_R_Role inner join t_R_Level on t_R_Role.LevelID=t_R_Level.id where RoleName='" + role + "'";;
if (RoleID != 0)
{
strSql = "select * from t_R_Role inner join t_R_Level on t_R_Role.LevelID=t_R_Level.id where t_R_Role.RoleID!='" + RoleID + "' and RoleName='" + role + "'";;
}
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
ret = 1;
}
}
catch (Exception ex)
{
ret = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(ret);
}