/// <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); }