/// <summary>
/// 新增权限
/// </summary>
/// <param name="pEntity"></param>
/// <returns></returns>
public static int AddPrivileges(PrivilegeEntity pEntity)
{
string sqlCommand = string.Format(@"INSERT INTO Base_Privilege ( PrivilegeId,PrivilegeName,PrivilegeCode,ParentPrivilegeId,ParentPrivilegeName,PrivilegeType,Library,NameSpace,MenuPic,Displayorder,Status,Remark )
VALUES ( '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}' )", pEntity.PrivilegeId, pEntity.PrivilegeName, pEntity.PrivilegeCode, pEntity.ParentPrivilegeId,
pEntity.ParentPrivilegeName, (int)pEntity.PrivilegeType, pEntity.Library, pEntity.NameSpace, pEntity.MenuPic, pEntity.Displayorder, (int)pEntity.Status, pEntity.Remark);
return(DbHelper.ExecuteNonQuery(sqlCommand));
}
/// <summary>
/// 修改权限
/// </summary>
/// <param name="pEntity"></param>
/// <returns></returns>
public static int UpdatePrivileges(PrivilegeEntity pEntity)
{
string sqlCommand = string.Format(@"UPDATE Base_Privilege SET PrivilegeName = '{1}',PrivilegeCode = '{2}',ParentPrivilegeId = '{3}',ParentPrivilegeName = '{4}',
PrivilegeType = '{5}',Library = '{6}',NameSpace = '{7}',MenuPic = '{8}',Displayorder = '{9}',Status = '{10}',
Remark = '{10}' WHERE PrivilegeId = '{0}'", pEntity.PrivilegeId, pEntity.PrivilegeName, pEntity.PrivilegeCode, pEntity.ParentPrivilegeId,
pEntity.ParentPrivilegeName, (int)pEntity.PrivilegeType,
pEntity.Library, pEntity.NameSpace, pEntity.MenuPic,
pEntity.Displayorder, (int)pEntity.Status, pEntity.Remark);
return(DbHelper.ExecuteNonQuery(sqlCommand));
}
internal static PrivilegeEntity ToPrivilegeEntity(PrivilegeInfo privilegeInfo)
{
PrivilegeEntity privilegeEntity = new PrivilegeEntity();
privilegeEntity.Check = privilegeInfo.Check;
privilegeEntity.ParentPrivilegeId = privilegeInfo.ParentPrivilegeID;
privilegeEntity.ParentPrivilegeName = privilegeInfo.ParentPrivilegeName;
privilegeEntity.PrivilegeId = privilegeInfo.PrivilegeId;
privilegeEntity.PrivilegeName = privilegeInfo.PrivilegeName;
privilegeEntity.Displayorder = privilegeInfo.Displayorder;
return privilegeEntity;
}
