/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.RoleApp实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(BizProcess.Data.Model.RoleApp model)
{
string sql = @"INSERT INTO RoleApp
(ID,ParentID,RoleID,AppID,Title,Params,Sort,Ico,Type)
VALUES(:ID,:ParentID,:RoleID,:AppID,:Title,:Params,:Sort,:Ico,:Type)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Char, 36)
{
Value = model.ID
},
new OracleParameter(":ParentID", OracleDbType.Char, 36)
{
Value = model.ParentID
},
new OracleParameter(":RoleID", OracleDbType.Char, 36)
{
Value = model.RoleID
},
model.AppID == null ? new OracleParameter(":AppID", OracleDbType.Char, 36)
{
Value = DBNull.Value
} : new OracleParameter(":AppID", OracleDbType.Char, 36)
{
Value = model.AppID
},
new OracleParameter(":Title", OracleDbType.NVarchar2, 400)
{
Value = model.Title
},
model.Params == null ? new OracleParameter(":Params", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":Params", OracleDbType.Clob)
{
Value = model.Params
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
},
model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 200)
{
Value = DBNull.Value
} : new OracleParameter(":Ico", OracleDbType.Varchar2, 200)
{
Value = model.Ico
},
new OracleParameter(":Type", OracleDbType.Int32)
{
Value = model.Type
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult AddApp(FormCollection collection)
{
BizProcess.Platform.AppLibrary bappLibrary = new BizProcess.Platform.AppLibrary();
BizProcess.Platform.RoleApp broleApp = new BizProcess.Platform.RoleApp();
BizProcess.Data.Model.RoleApp roleApp = null;
string id = Request.QueryString["id"];
if (collection != null)
{
roleApp = broleApp.Get(id.ToGuid());
if (!Request.Form["Save"].IsNullOrEmpty())
{
string name = Request.Form["Name"];
string type = Request.Form["Type"];
string appid = Request.Form["AppID"];
string params1 = Request.Form["Params"];
string ico = Request.Form["Ico"];
BizProcess.Data.Model.RoleApp roleApp1 = new BizProcess.Data.Model.RoleApp();
roleApp1.ID = Guid.NewGuid();
roleApp1.ParentID = id.ToGuid();
roleApp1.RoleID = roleApp.RoleID;
roleApp1.Title = name.Trim();
roleApp1.ParentID = roleApp.ID;
roleApp1.Sort = broleApp.GetMaxSort(roleApp.ID);
roleApp1.Type = 0;
if (appid.IsGuid())
{
roleApp1.AppID = appid.ToGuid();
}
else
{
roleApp1.AppID = null;
}
roleApp1.Params = params1.IsNullOrEmpty() ? null : params1.Trim();
if (!ico.IsNullOrEmpty())
{
roleApp1.Ico = ico;
}
broleApp.Add(roleApp1);
broleApp.ClearAllDataTableCache();
BizProcess.Platform.Log.Add("添加了应用模板", roleApp1.Serialize(), BizProcess.Platform.Log.Types.角色应用);
string refreshID = id;
ViewBag.Script = "alert('添加成功');parent.frames[0].reLoad('" + refreshID + "');";
}
}
ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions();
return(View());
}
public ActionResult AddRole(FormCollection collection)
{
string name = Request.Form["Name"];
string note = Request.Form["Note"];
string useMember = Request.Form["UseMember"];
BizProcess.Data.Model.Role role = new BizProcess.Data.Model.Role();
if (collection != null)
{
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
role.ID = Guid.NewGuid();
role.Name = name.Trim();
if (!useMember.IsNullOrEmpty())
{
role.UseMember = useMember;
BizProcess.Platform.UsersRole busersRole = new BizProcess.Platform.UsersRole();
var users = new BizProcess.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
BizProcess.Data.Model.UsersRole ur = new BizProcess.Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
if (!note.IsNullOrEmpty())
{
role.Note = note.Trim();
}
new BizProcess.Platform.Role().Add(role);
//添加一个根应用
BizProcess.Data.Model.RoleApp roleApp = new BizProcess.Data.Model.RoleApp();
roleApp.ID = Guid.NewGuid();
roleApp.ParentID = Guid.Empty;
roleApp.RoleID = role.ID;
roleApp.Sort = 1;
roleApp.Title = "管理目录";
new BizProcess.Platform.RoleApp().Add(roleApp);
trans.Complete();
ViewBag.Script = "alert('添加成功!');new BPUI.Window().reloadOpener();new BPUI.Window().close();";
}
}
return(View(role));
}
/// <summary>
/// 将个人应用加入列表
/// </summary>
/// <param name="userID"></param>
/// <param name="parentID">上级ID</param>
/// <param name="appList"></param>
public void AppendUserApps(Guid userID, Guid parentID, List <BizProcess.Data.Model.RoleApp> appList)
{
var userApps = GetUserDataRows(userID);
foreach (var userApp in userApps)
{
if (userApp["ParentID"].ToString().ToGuid() == parentID)
{
BizProcess.Data.Model.RoleApp app = new BizProcess.Data.Model.RoleApp();
app.ID = userApp["ID"].ToString().ToGuid();
app.AppID = userApp["AppID"].ToString().ToGuid();
app.Ico = userApp["Ico"].ToString();
app.Params = userApp["Params"].ToString();
app.ParentID = userApp["ParentID"].ToString().ToGuid();
app.RoleID = userApp["RoleID"].ToString().ToGuid();
app.Sort = userApp["Sort"].ToString().ToInt();
app.Title = userApp["Title"].ToString();
app.Type = 1;
appList.Add(app);
}
}
}
/// <summary>
/// 更新
/// </summary>
public int Update(BizProcess.Data.Model.RoleApp model)
{
return(dataRoleApp.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(BizProcess.Data.Model.RoleApp model)
{
return(dataRoleApp.Add(model));
}
public ActionResult Body(FormCollection collection)
{
BizProcess.Platform.AppLibrary bappLibrary = new BizProcess.Platform.AppLibrary();
BizProcess.Platform.RoleApp broleApp = new BizProcess.Platform.RoleApp();
BizProcess.Data.Model.RoleApp roleApp = null;
string id = Request.QueryString["id"];
string name = string.Empty;
string type = string.Empty;
string appid = string.Empty;
string params1 = string.Empty;
string ico = string.Empty;
Guid appID;
if (id.IsGuid(out appID))
{
roleApp = broleApp.Get(appID);
}
if (!Request.Form["Save"].IsNullOrEmpty())
{
name = Request.Form["Name"];
type = Request.Form["Type"];
appid = Request.Form["AppID"];
params1 = Request.Form["Params"];
ico = Request.Form["Ico"];
string oldXML = roleApp.Serialize();
roleApp.Title = name.Trim();
if (appid.IsGuid())
{
roleApp.AppID = appid.ToGuid();
}
else
{
roleApp.AppID = null;
}
roleApp.Params = params1.IsNullOrEmpty() ? null : params1.Trim();
if (!ico.IsNullOrEmpty())
{
roleApp.Ico = ico;
}
else
{
roleApp.Ico = null;
}
broleApp.Update(roleApp);
broleApp.ClearAllDataTableCache();
BizProcess.Platform.Log.Add("修改了应用模板", "", BizProcess.Platform.Log.Types.角色应用, oldXML, roleApp.Serialize());
string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString();
ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');alert('保存成功!');";
}
if (!Request.Form["Delete"].IsNullOrEmpty())
{
int i = broleApp.DeleteAndAllChilds(roleApp.ID);
broleApp.ClearAllDataTableCache();
BizProcess.Platform.Log.Add("删除了模板及其所有下级共" + i.ToString() + "项", roleApp.Serialize(), BizProcess.Platform.Log.Types.角色应用);
string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString();
ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');window.location='Body?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "';";
}
if (roleApp != null && roleApp.AppID.HasValue)
{
var app = new BizProcess.Platform.AppLibrary().Get(roleApp.AppID.Value);
if (app != null)
{
type = app.Type.ToString();
}
}
ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(type);
ViewBag.AppID = roleApp.AppID.ToString();
return(View(roleApp));
}
