/// <summary>
/// 插入模块
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int SystemModual_Insert(SystemModual obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.SystemModual_Insert(obj));
}
}
/// <summary>
/// 更新系统模块
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int SystemModual_UpdateBym_gid(SystemModual obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.SystemModual_UpdateBym_gid(obj));
}
}
public int SystemModual_Insert(SystemModual obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemModual_Insert");
db.AddOutParameter(dbCmd, "@m_id", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@m_gid", DbType.String, obj.m_gid);
db.AddInParameter(dbCmd, "@m_g_gid", DbType.String, obj.m_g_gid);
db.AddInParameter(dbCmd, "@m_name", DbType.String, obj.m_name);
db.AddInParameter(dbCmd, "@m_path", DbType.String, obj.m_path);
db.AddInParameter(dbCmd, "@m_parent", DbType.Int32, obj.m_parent);
db.AddInParameter(dbCmd, "@m_parent_gid", DbType.String, obj.m_parent_gid);
db.AddInParameter(dbCmd, "@m_Controller", DbType.String, obj.m_Controller);
db.AddInParameter(dbCmd, "@m_Action", DbType.String, obj.m_Action);
db.AddInParameter(dbCmd, "@m_createTime", DbType.String, obj.m_createTime);
db.AddInParameter(dbCmd, "@m_createUser", DbType.String, obj.m_createUser);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
int m_id = (int)dbCmd.Parameters["@m_id"].Value;
return(m_id);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 查询 用户对应 模块组下的模块信息
/// </summary>
/// <param name="u_gid"></param>
/// <param name="m_g_gid"></param>
/// <returns></returns>
public List <SystemModual> SystemModual_SelectByu_gid(string u_gid, string m_g_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemModual_SelectByu_gid");
db.AddInParameter(dbCmd, "@u_gid", DbType.String, u_gid);
db.AddInParameter(dbCmd, "@m_g_gid", DbType.String, m_g_gid);
List <SystemModual> list = new List <SystemModual>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
SystemModual obj = Obj2Model <SystemModual>(reader);
list.Add(obj);
}
}
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public List <SystemModual> SystemModual_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemModual_SelectPage");
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy);
db.AddInParameter(dbCmd, "@where", DbType.String, where);
List <SystemModual> list = new List <SystemModual>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
SystemModual obj = Obj2Model <SystemModual>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult ModuleEditView()
{
string m_gid = Request["m_gid"] ?? string.Empty;
string window = Request["window"] ?? string.Empty;
SystemModual info = null;
if (string.IsNullOrEmpty(m_gid))
{
info = new SystemModual();
}
else
{
info = SystemSeviceClass.SystemModual_SelectBym_gid(m_gid);
}
SystemGroupSearchInfo groupSearch = new SystemGroupSearchInfo();
int rowCount;
List <SystemGroup> gList = SystemSeviceClass.SystemGroup_SelectPage(groupSearch, 1, 100, out rowCount);
ViewData["window"] = window;
ViewData["gList"] = gList;
ViewData["info"] = info;
return(View());
}
public SystemModual SystemModual_SelectBym_gid(string m_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemModual_SelectBym_gid");
db.AddInParameter(dbCmd, "@m_gid", DbType.String, m_gid);
SystemModual obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
obj = Obj2Model <SystemModual>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult ModuleEdit()
{
string m_gid = Request["m_gid"] ?? string.Empty;
string m_name = Request["m_name"] ?? string.Empty;
string g_gid = Request["moduleGroup"] ?? string.Empty;
string moduleGrade = Request["moduleGrade"] ?? string.Empty;
string m_controller = Request["m_controller"] ?? string.Empty;
string m_action = Request["m_action"] ?? string.Empty;
string modulePart = Request["modulePart"] ?? string.Empty;
string m_path = Request["m_path"] ?? string.Empty;
SystemModual info = null;
if (string.IsNullOrEmpty(m_gid))
{
info = new SystemModual();
//新增
string guid = Guid.NewGuid().ToString().Substring(0, 8);
info.m_gid = guid;
info.m_g_gid = g_gid;
info.m_createTime = DateTime.Now;
info.m_createUser = SiteHelp.CurrentUserName;
}
else
{
info = SystemSeviceClass.SystemModual_SelectBym_gid(m_gid);
}
if (moduleGrade == "0")//一级元素
{
info.m_parent = 0;
info.m_parent_gid = string.Empty;
}
else if (moduleGrade == "1" && !string.IsNullOrEmpty(modulePart))//二级元素
{
info.m_parent = modulePart.Split(new[] { "-" }, StringSplitOptions.RemoveEmptyEntries)[0].ToInt32();
info.m_parent_gid = modulePart.Split(new[] { "-" }, StringSplitOptions.RemoveEmptyEntries)[1];
}
info.m_path = m_path;
info.m_name = m_name;
info.m_Controller = m_controller;
info.m_Action = m_action;
if (string.IsNullOrEmpty(m_gid))
{
int result = SystemSeviceClass.SystemModual_Insert(info);
if (result > 0)
{
return(Json(new { success = true, errors = new { text = "新增成功" } }));
}
else
{
return(Json(new { success = false, errors = new { text = "新增失败" } }));
}
}
else
{
int result = SystemSeviceClass.SystemModual_UpdateBym_gid(info);
if (result > 0)
{
return(Json(new { success = true, errors = new { text = "修改成功" } }));
}
else
{
return(Json(new { success = false, errors = new { text = "修改失败" } }));
}
}
}
