/// <summary>
/// Programmer:liuxubang
/// time:7-18 15:47
/// 通过子模块的编号获得相应的权限
/// </summary>
/// <param name="moduleCode"></param>
/// <returns></returns>
public IList <System_module_right> GetModuleRightByCode(String moduleCode)
{
IList <System_module_right> list = new List <System_module_right>();
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?moduleCode", moduleCode)
};
try
{
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(SELECT_BYCODE, param))
{
while (reader.Read())
{
System_module sysModule = new System_module();
sysModule.Module_code = reader.GetString(1);
System_module_operate sysModuleOperate = new System_module_operateService().GetModuleOperateByOperateId(reader.GetInt32(3));
//System_module_right sysModuleRight = new System_module_right(reader.GetInt32(0), sysModule, sysModuleOperate, reader.GetChar(2), reader.GetString(4));
System_module_right sysModuleRight = new System_module_right();
sysModuleRight.Module_right_id = reader.GetInt32("Module_right_id");
sysModuleRight.Module_code = reader.GetString("Module_code");
sysModuleRight.OperateID = reader.GetInt32("OperateID");
sysModuleRight.Status = reader.GetString("status");
sysModuleRight.Right_page = reader.GetString("right_page");
list.Add(sysModuleRight);
}
reader.Close();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(list);
}
/// <summary>
/// programmer:liuxubang
/// time:7-16 22:20
/// 根据SQL语句获得相应的模块信息
/// </summary>
/// <param name="sqlStr"></param>
/// <param name="param"></param>
/// <returns></returns>
private IList <System_module> GetAllModuleBySql(String sqlStr, params MySqlParameter[] param)
{
IList <System_module> list = new List <System_module>();
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(sqlStr, param))
{
while (reader.Read())
{
//System_module sysModule = new System_module(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetChar(5), reader.GetString(6), reader.GetChar(7));
System_module sysModule = new System_module();
sysModule.Module_code = reader.GetString("Module_code");
sysModule.Module_parent_code = reader.GetString("Module_parent_code");
sysModule.Module_type = reader.GetString("Module_type");
sysModule.Module_text = reader.GetString("Module_text");
sysModule.Module_url = reader.GetString("Module_url");
sysModule.Module_target = reader.GetString("Module_target");
sysModule.Module_tip = reader.GetString("Module_tip");
sysModule.Status = reader.GetString("Status");
list.Add(sysModule);
}
reader.Close();
}
return(list);
}
/// <summary>
/// Programmer:liuxubang
/// time:7-18 22:10
/// 更新父模块的信息
/// </summary>
/// <param name="sysModule"></param>
/// <returns></returns>
public Boolean UpdateParentModule(System_module sysModule)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?moduleText", sysModule.Module_text),
new MySqlParameter("?moduleTip", sysModule.Module_tip),
new MySqlParameter("?moduleCode", sysModule.Module_code)
};
return(MySqlHelper.ExecuteNonQuery(UPDATE_PARENT_MODULE, param) > 0);
}
///<sumary>
///修改信息
///时间：2010-9-14 23:53:09
///</sumary>
public static Boolean UpdateSystem_module(System_module system_module)
{
try
{
return(system_moduleService.UpdateSystem_module(system_module));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
///<summary>
///添加方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2010-9-18 13:49:34
///</summary>
public Boolean AddSystem_module(System_module system_module)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Module_parent_code", system_module.Module_parent_code),
new MySqlParameter("?Module_text", system_module.Module_text),
new MySqlParameter("?Module_url", system_module.Module_url),
new MySqlParameter("?Module_target", system_module.Module_target),
new MySqlParameter("?status", system_module.Status),
new MySqlParameter("?sorts", system_module.Sorts),
new MySqlParameter("?BetGamesID", system_module.BetGamesID),
new MySqlParameter("?Module_type", system_module.Module_type),
new MySqlParameter("?Module_tip", system_module.Module_tip)
};
return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0);
}
public Boolean UpdateChildModule(System_module sysModule, Int32 target, String operate)
{
Boolean con = false;
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?moduleText", sysModule.Module_text),
new MySqlParameter("?moduleTip", sysModule.Module_tip),
new MySqlParameter("?moduleUrl", sysModule.Module_url),
new MySqlParameter("?moduleTarget", target),
new MySqlParameter("?moduleCode", sysModule.Module_code)
};
con = MySqlHelper.ExecuteNonQuery(UPDATE_CHILD_MODULE, param) > 0;
if (con)
{
if (operate != "")
{
//删除不存在的模块操作
sysModuleRightService.DeleteByModuleCodeAndOperate(sysModule.Module_code, operate);
String[] operateStr = operate.Split(',');
for (int i = 0; i < operateStr.Length; i++)
{
if (operateStr[i] == "1")
{
continue;
}
String status = sysModuleRightService.GetModuleRightByCodeAndOperateId(sysModule.Module_code, operateStr[i]);
if (status == String.Empty) //不存在这条记录
{
sysModuleRightService.AddModuleRight(sysModule.Module_code, Convert.ToInt32(operateStr[i]), sysModule.Module_url);
}
else
{
String num = status == "1" ? "1" : "0";
sysModuleRightService.UpdateStatusByCode(sysModule.Module_code, num, Convert.ToInt32(operateStr[i]));
}
}
}
}
return(con);
}
/// <summary>
/// Programmer:liuxubang
/// time:7-16 15:05
/// </summary>
/// <param name="sysModule"></param>
/// <returns></returns>
public System_module AddModule(System_module sysModule, String operate)
{
Boolean con = false;
String lastModule = GetLastModule(sysModule.Module_parent_code);
String codeModule = String.Empty; //产生一个新的Module_code
if (lastModule != "" && lastModule != null) //表示有父模块
{
Int32 codeNum = Convert.ToInt32(lastModule.Remove(0, 1)) + 1;
if (sysModule.Module_parent_code == "ROOT_MENU") //添加一个大的模块
{
if (codeNum.ToString().Length == 1)
{
codeModule = "L0" + codeNum;
}
else
{
codeModule = "L" + codeNum;
}
}
else //添加一个子模块
{
codeModule = sysModule.Module_parent_code + codeNum.ToString().Substring(codeNum.ToString().Length - 2);
}
}
else
{
if (sysModule.Module_parent_code == "ROOT_MENU") //添加一个大的模块
{
codeModule = "L01";
}
else //添加一个子模块
{
codeModule = sysModule.Module_parent_code + "01";
}
}
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ModuleCode", codeModule),
new MySqlParameter("?ModuleParentCode", sysModule.Module_parent_code),
new MySqlParameter("?ModuleType", sysModule.Module_type),
new MySqlParameter("?ModuleText", sysModule.Module_text),
new MySqlParameter("?ModuleUrl", sysModule.Module_url),
new MySqlParameter("?ModuleTarget", sysModule.Module_target),
new MySqlParameter("?ModuleTip", sysModule.Module_tip),
new MySqlParameter("?status", sysModule.Status)
};
con = MySqlHelper.ExecuteNonQuery(INSERT_MODULE, param) > 0;
if (con)
{
if (operate != "" && sysModule.Module_parent_code != "ROOT_MENU")
{
String[] OperateArr = operate.Split(',');
for (int i = 0; i < OperateArr.Length; i++)
{
new System_module_rightService().AddModuleRight(codeModule, int.Parse(OperateArr[i]), sysModule.Module_url);
}
}
else
{
new System_module_rightService().AddModuleRight(codeModule, 0, "");
}
sysModule.Module_code = codeModule;
return(sysModule);
}
else
{
return(null);
}
}
