public String AddModule(String moduleParent, String text, String url, String tip, String target, String status, String operate)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
Sys_module sysModule = new Sys_module();
sysModule.Module_parent_code = moduleParent;
sysModule.Module_url = url;
sysModule.Module_type = moduleParent == "ROOT_MENU" ? "Folder" : "Document";
sysModule.Module_text = text;
sysModule.Module_tip = tip;
sysModule.Status = status;
sysModule.Module_target = target;
sysModule = sysModuleService.AddModule(sysModule, operate);
if (sysModule == null)
{
return("none");
}
else
{
return(JsonConvert.SerializeObject(sysModule));
}
}
/// <summary>
/// programmer:liuxubang
/// time:7-16 22:20
/// 根据SQL语句获得相应的模块信息
/// </summary>
/// <param name="sqlStr"></param>
/// <param name="param"></param>
/// <returns></returns>
private IList <Sys_module> GetAllModuleBySql(String sqlStr, params MySqlParameter[] param)
{
IList <Sys_module> list = new List <Sys_module>();
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(sqlStr, param))
{
while (reader.Read())
{
//Sys_module sysModule = new Sys_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));
Sys_module sysModule = new Sys_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 15:47
/// 通过子模块的编号获得相应的权限
/// </summary>
/// <param name="moduleCode"></param>
/// <returns></returns>
public IList <Sys_module_right> GetModuleRightByCode(String moduleCode)
{
IList <Sys_module_right> list = new List <Sys_module_right>();
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?moduleCode", moduleCode)
};
try
{
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(SELECT_BYCODE, param))
{
while (reader.Read())
{
Sys_module sysModule = new Sys_module();
sysModule.Module_code = reader.GetString(1);
Sys_module_operate sysModuleOperate = new Sys_module_operateService().GetModuleOperateByOperateId(reader.GetInt32(3));
//Sys_module_right sysModuleRight = new Sys_module_right(reader.GetInt32(0), sysModule, sysModuleOperate, reader.GetChar(2), reader.GetString(4));
Sys_module_right sysModuleRight = new Sys_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-18 22:10
/// 更新父模块的信息
/// </summary>
/// <param name="sysModule"></param>
/// <returns></returns>
public Boolean UpdateParentModule(Sys_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 UpdateSys_module(Sys_module sys_module)
{
try
{
return(sys_moduleService.UpdateSys_module(sys_module));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
public Boolean UpdateParentModule(String text, String tip, String moduleCode)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return(false);
}
Sys_module sysModule = new Sys_module();
sysModule.Module_code = moduleCode;
sysModule.Module_text = text;
sysModule.Module_tip = tip;
return(sysModuleService.UpdateParentModule(sysModule));
}
///<summary>
///添加方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2010-9-18 13:49:34
///</summary>
public Boolean AddSys_module(Sys_module sys_module)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Module_parent_code", sys_module.Module_parent_code),
new MySqlParameter("?Module_text", sys_module.Module_text),
new MySqlParameter("?Module_url", sys_module.Module_url),
new MySqlParameter("?Module_target", sys_module.Module_target),
new MySqlParameter("?status", sys_module.Status),
new MySqlParameter("?sorts", sys_module.Sorts),
new MySqlParameter("?BetGamesID", sys_module.BetGamesID),
new MySqlParameter("?Module_type", sys_module.Module_type),
new MySqlParameter("?Module_tip", sys_module.Module_tip)
};
return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0);
}
public Boolean UpdateChildModule(String text, String url, String tip, Int32 target, String moduleCode, String operate)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return(false);
}
Sys_module sysModule = new Sys_module();
sysModule.Module_code = moduleCode;
sysModule.Module_text = text;
sysModule.Module_tip = tip;
sysModule.Module_url = url;
return(sysModuleService.UpdateChildModule(sysModule, target, operate));
}
public Boolean UpdateChildModule(Sys_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 Sys_module AddModule(Sys_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 Sys_module_rightService().AddModuleRight(codeModule, int.Parse(OperateArr[i]), sysModule.Module_url);
}
}
else
{
new Sys_module_rightService().AddModuleRight(codeModule, 0, "");
}
sysModule.Module_code = codeModule;
return(sysModule);
}
else
{
return(null);
}
}
