/// <summary>
/// 执行一条SQL 语句
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static bool ControlRole(string sql)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format(sql);
bool bSuced = false;
bSuced = dCurService.ExecOleSql(strSql);
return(bSuced);
}
/// <summary>
/// 更新单位信息
/// </summary>
/// <param name="BM_fzr"></param>
/// <param name="BM_tel"></param>
/// <param name="BM_JS"></param>
/// <param name="BM_Name"></param>
/// <returns></returns>
public static bool UpdateDEPInfo(string BM_fzr, string BM_tel, string BM_JS, string BM_Name)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "update department set BM_fzr='" + BM_fzr + "', BM_tel='" + BM_tel + "', BM_JS='" + BM_JS + "' where bm_name='" + BM_Name + "'";
bool bSuced = false;
bSuced = dCurService.ExecOleSql(strSql);
return(bSuced);
}
/// <summary>
/// 添加单位信息
/// </summary>
/// <param name="BM_fzr"></param>
/// <param name="BM_tel"></param>
/// <param name="BM_JS"></param>
/// <param name="BM_Name"></param>
/// <returns></returns>
public static bool AddDEPInfo(string BM_fzr, string BM_tel, string BM_JS, string BM_Name)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "insert into department (bm_name,BM_fzr, BM_tel,BM_JS) values('" + BM_Name + "','" + BM_fzr + "','" + BM_tel + "', '" + BM_JS + "')";
bool bSuced = false;
bSuced = dCurService.ExecOleSql(strSql);
return(bSuced);
}
/// <summary>
/// 删除用户选中的权限
/// </summary>
/// <param name="szUserCode"></param>
/// <param name="szRole"></param>
/// <returns></returns>
public static bool DelRoleMenu(long RoleId, long MenuId)
{
bool bSeced = false;
string strSql = "delete from ROLE_MENU where ROLE_ID =" + RoleId + " and NODEID =" + MenuId;
Jin.DataService.DataService dService = new Jin.DataService.DataService();
bSeced = dService.ExecOleSql(strSql);
return(bSeced);
}
/// <summary>
/// 授予用户选中的权限
/// </summary>
/// <param name="szUserCode"></param>
/// <param name="szRole"></param>
/// <returns></returns>
public static bool AddRoleMenu(long RoleId, long MenuId)
{
bool bSeced = false;
string strSql = string.Format("Insert Into role_menu(ROLE_ID,NODEID) Values({0},{1})", RoleId, MenuId);
Jin.DataService.DataService dService = new Jin.DataService.DataService();
bSeced = dService.ExecOleSql(strSql);
return(bSeced);
}
/// <summary>
/// 角色增加
/// </summary>
/// <param name="szUserCode"></param>
/// <param name="szRole"></param>
/// <returns></returns>
public static bool AddRole(string roleName)
{
bool bSeced = false;
string strSql = string.Format("Insert Into role(Role_name) Values('{0}')", roleName);
Jin.DataService.DataService dService = new Jin.DataService.DataService();
bSeced = dService.ExecOleSql(strSql);
return(bSeced);
}
public static bool UpdateUserrole(long szUserCode, string szUserName, long RoleId)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("Update user_role set username='******',ROLE_ID={2} where user_id={0}", szUserCode, szUserName, RoleId);
bool bSuced = false;
bSuced = dCurService.ExecOleSql(strSql);
return(bSuced);
}
/// <summary>
/// 授权用户角色
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static bool GrantUserRole(long uid, string UserName, long RoleId)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("insert into user_role (user_id,username,ROLE_ID) values ({0},'{1}',{2})", uid, UserName, RoleId);
bool bSuced = false;
bSuced = dCurService.ExecOleSql(strSql);
return(bSuced);
}
