Syteline System Authorizations二次开发

最新推荐文章于 2023-01-16 16:58:33 发布
最新推荐文章于 2023-01-16 16:58:33 发布
阅读量159 收藏
点赞数
文章标签： ui

前段时间写了一些SQL语句或存储过程，可以参考此篇：http://www.cnblogs.com/insus/articles/1899336.html 原本只是为了自己方便工作，但是用户永远满足不了，他们也有跟自己需求一样，只有写成一个类别，并在asp.net界面显示出来。Authorizations.cs 代码片断：

代码
using  System;
 using  System.Collections.Generic;
 using  System.Data;
 using  System.Linq;
 using  System.Web;

 ///   <summary>
///  Summary description for Authorizations
 ///   </summary>
namespace  Insus.NET
{
     public   class  Authorizations
    {
        BusinessBase objBusinessBase  =   new  BusinessBase();

         public  Authorizations()
        {
             //
             //  TODO: Add constructor logic here
             //
         }

         // Get all group
         public  DataTable GetGroupNames()
        {
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetGroupNames " ).Tables[ 0 ];
        }

         // Get all user
         public  DataTable GetUserNames()
        {
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetUserNames " ).Tables[ 0 ];
        }

         //  Get user by user id
         public  DataTable GetUserNamesByUserId( string  userId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @UserId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(userId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetUserNamesByUserId " , parameter).Tables[ 0 ];
        }

         // Get user  by group id
         public  DataTable GetUserNamesByGroupId( string  groupId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @GroupId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(groupId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetUserNamesByGroup " , parameter).Tables[ 0 ];
        }

         // Get group by user id
         public  DataTable GetGroupNamesByUser( string  userId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @UserId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(userId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetGroupNamesByUser " , parameter).Tables[ 0 ];
        }

         // Get group by group id
         public  DataTable GetGroupNamesByGroupId( string  groupId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @GroupId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(groupId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetGroupNamesByGroup " , parameter).Tables[ 0 ];
        }

         // Get user account authorization
         public  DataTable GetAccountAuthorizationsByUser( string  userId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @UserId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(userId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetAccountAuthorizationsByUser " , parameter).Tables[ 0 ];
        }

         // Get group account authorization
         public  DataTable GetAccountAuthorizationsByGroup( string  groupId)
        {
            Parameter[] parameter  =  { 
                                         new  Parameter ( " @GroupId " ,SqlDbType.Decimal, 9 ,ConvertData.ToDecimal(groupId))
                                    };
             return  objBusinessBase.GetDataToDataSet( " usp_SyteLine_GetAccountAuthorizationsByGroup " , parameter).Tables[ 0 ];
        }
    }
}

  

Users.aspx代码片断：

代码
< table  border ="0"  cellpadding ="0"  cellspacing ="3"  width ="100%" >
     < tr >
         < td  width ="270"  valign ="top" >
             < asp:GridView  ID ="GvUsers"  runat ="server"  SkinID ="gridviewSkin"  DataKeyNames ="UserId"
                OnRowCreated ="GvUsers_RowCreated" >
                 < AlternatingRowStyle  BackColor ="White"   />
                 < RowStyle  BackColor ="WhiteSmoke"   />
                 < Columns >
                     < asp:TemplateField  HeaderText ="User Id" >
                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemTemplate >
                             <% #  Eval ( " username " )  %>
                         </ ItemTemplate >
                     </ asp:TemplateField >
                     < asp:TemplateField  HeaderText ="User Description" >
                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemTemplate >
                             <% #  Eval ( " userDesc " ) %>
                         </ ItemTemplate >
                     </ asp:TemplateField >
                     < asp:TemplateField  HeaderText ="Details" >
                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Width ="30px"   />
                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Width ="30px"  HorizontalAlign ="Center"   />
                         < ItemTemplate >
                             < asp:ImageButton  ID ="ImageButtonDetails"  runat ="server"  ImageAlign ="Absmiddle"  CausesValidation ="false"
                                ImageUrl ="~/System/Image/details.gif"   />
                         </ ItemTemplate >
                     </ asp:TemplateField >
                 </ Columns >
             </ asp:GridView >
         </ td >
         < td  width ="10" >
         </ td >
         < td  valign ="top" >
             < fieldset  id ="fd_User_label"  runat ="server" >
                 < div  style ="height: 5px;" >
                 </ div >
                 < asp:Label  ID ="lbShowUserId"  runat ="server"  ForeColor ="#003399" ></ asp:Label >
                 < div  style ="height: 5px;" >
                 </ div >
             </ fieldset >
             < table  border ="0"  cellpadding ="0"  cellspacing ="3" >
                 < tr >
                     < td  valign ="top" >
                         < fieldset  id ="fd_group"  runat ="server" >
                             < legend > Groups </ legend >
                             < asp:GridView  ID ="GvGroups"  runat ="server"  SkinID ="gridviewSkin"  DataKeyNames ="GroupId" >
                                 < AlternatingRowStyle  BackColor ="White"   />
                                 < RowStyle  BackColor ="WhiteSmoke"   />
                                 < Columns >
                                     < asp:TemplateField  HeaderText ="Group Name" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " GroupName " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Group Description" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " GroupDesc " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                 </ Columns >
                             </ asp:GridView >
                         </ fieldset >
                     </ td >
                     < td  valign ="top" >
                         < fieldset  id ="fd_Authorizations"  runat ="server" >
                             < legend > User Authorizations </ legend >
                             < asp:GridView  ID ="GvAuthorizations"  runat ="server"  SkinID ="gridviewSkin" >
                                 < AlternatingRowStyle  BackColor ="White"   />
                                 < RowStyle  BackColor ="WhiteSmoke"   />
                                 < Columns >
                                     < asp:TemplateField  HeaderText ="Object Name" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ObjectName1 " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Delete Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " DeletePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Edit Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " EditPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Execute Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ExecutePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Insert Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " InsertPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Read Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ReadPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Bulk Update" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " BulkUpdatePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Update Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " UpdatePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                 </ Columns >
                             </ asp:GridView >
                         </ fieldset >
                     </ td >
                 </ tr >
             </ table >
         </ td >
     </ tr >
</ table >

   

users.aspx.cs代码片断：

代码
using  System;
 using  System.Collections.Generic;
 using  System.Data;
 using  System.Linq;
 using  System.Web;
 using  System.Web.UI;
 using  System.Web.UI.WebControls;
 using  Insus.NET;

 public   partial   class  System_SyteLine_Authorizations_Users : BasePage
{
    Authorizations objAuthorizations  =   new  Authorizations();

     protected   void  Page_Load( object  sender, EventArgs e)
    {
        if  ( ! IsPostBack)
        {
            Data_Binding();
        }

         this .SystemPageSubject1.SetSubject  =   " Users " ;
    }

     private   void  Data_Binding()
    {
         this .GvUsers.DataSource  =  objAuthorizations.GetUserNames();
         this .GvUsers.DataBind();
    }

     protected   void  GvUsers_RowCreated( object  sender, GridViewRowEventArgs e)
    {
        InsusBase.GridView_RowCreated(GvUsers, e,  " Peachpuff " );

         if  (e.Row.RowType  ==  DataControlRowType.DataRow)
        {
             if  (e.Row.FindControl( " ImageButtonDetails " )  !=   null )
            {
                ImageButton ImageButtonDetails  =  (ImageButton)e.Row.FindControl( " ImageButtonDetails " );
                ImageButtonDetails.Click  +=   new  ImageClickEventHandler(ImageButtonDetails_Click);
            }
        }
    }

     private   void  ImageButtonDetails_Click( object  sender, ImageClickEventArgs e)
    {
        ImageButton imageButton  =  (ImageButton)sender;
        GridViewRow gvr  =  (GridViewRow)imageButton.Parent.Parent;
         string  primaryKey  =  GvUsers.DataKeys[gvr.RowIndex].Value.ToString();
       
        DataRow dataRow  =  objAuthorizations.GetUserNamesByUserId(primaryKey).Rows[ 0 ];
         this .lbShowUserId.Text  =   " User Id:  "   +  dataRow[ " username " ].ToString()  +   " ( "   +  dataRow[ " userDesc " ].ToString()  +   " ) " ;

         this .GvGroups.DataSource  =  objAuthorizations.GetGroupNamesByUser(primaryKey);
         this .GvGroups.DataBind();

         this .GvAuthorizations.DataSource  =  objAuthorizations.GetAccountAuthorizationsByUser(primaryKey);
         this .GvAuthorizations.DataBind();
    }
}

 
Groups.aspx代码片断： 

代码
< table  border ="0"  cellpadding ="0"  cellspacing ="3"  width ="100%" >
     < tr >
         < td  width ="270"  valign ="top" >
             < asp:GridView  ID ="GvGroups"  runat ="server"  SkinID ="gridviewSkin"  DataKeyNames ="GroupId"
                OnRowCreated ="GvGroups_RowCreated" >
                 < AlternatingRowStyle  BackColor ="White"   />
                 < RowStyle  BackColor ="WhiteSmoke"   />
                 < Columns >
                     < asp:TemplateField  HeaderText ="Group Name" >
                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                         < ItemTemplate >
                             <% #  Eval ( " GroupName " ) %>
                         </ ItemTemplate >
                     </ asp:TemplateField >
                     < asp:TemplateField  HeaderText ="Details" >
                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Width ="30px"   />
                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Width ="30px"  HorizontalAlign ="Center"   />
                         < ItemTemplate >
                             < asp:ImageButton  ID ="ImageButtonDetails"  runat ="server"  ImageAlign ="Absmiddle"  CausesValidation ="false"
                                ImageUrl ="~/System/Image/details.gif"   />
                         </ ItemTemplate >
                     </ asp:TemplateField >
                 </ Columns >
             </ asp:GridView >
         </ td >
         < td  width ="10" >
         </ td >
         < td  valign ="top" >
             < fieldset  id ="fd_Group_label"  runat ="server" >
                 < div  style ="height: 5px;" >
                 </ div >
                 < asp:Label  ID ="lbGroupName"  runat ="server"  ForeColor ="#003399" ></ asp:Label >
                 < div  style ="height: 5px;" >
                 </ div >
             </ fieldset >
             < table  border ="0"  cellpadding ="0"  cellspacing ="3" >
                 < tr >
                     < td  valign ="top" >
                         < fieldset  id ="fd_group"  runat ="server" >
                             < legend > Users </ legend >
                             < asp:GridView  ID ="GvUsers"  runat ="server"  SkinID ="gridviewSkin"  Width ="270" >
                                 < AlternatingRowStyle  BackColor ="White"   />
                                 < RowStyle  BackColor ="WhiteSmoke"   />
                                 < Columns >
                                     < asp:TemplateField  HeaderText ="User Id" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " username " )  %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="User Description" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " userDesc " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                 </ Columns >
                             </ asp:GridView >
                         </ fieldset >
                     </ td >
                     < td  valign ="top" >
                         < fieldset  id ="fd_Authorizations"  runat ="server" >
                             < legend > Group Authorizations </ legend >
                             < asp:GridView  ID ="GvAuthorizations"  runat ="server"  SkinID ="gridviewSkin" >
                                 < AlternatingRowStyle  BackColor ="White"   />
                                 < RowStyle  BackColor ="WhiteSmoke"   />
                                 < Columns >                                 
                                     < asp:TemplateField  HeaderText ="Object Name" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ObjectName1 " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Delete Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " DeletePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Edit Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " EditPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Execute Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ExecutePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Insert Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " InsertPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Read Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " ReadPrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Update Privilege" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " UpdatePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                     < asp:TemplateField  HeaderText ="Bulk Update" >
                                         < HeaderStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"  Font-Bold ="false"   />
                                         < ItemStyle  BorderColor ="#c0c0c0"  BorderWidth ="1"   />
                                         < ItemTemplate >
                                             <% #  Eval ( " BulkUpdatePrivilege " ) %>
                                         </ ItemTemplate >
                                     </ asp:TemplateField >
                                 </ Columns >
                             </ asp:GridView >
                         </ fieldset >
                     </ td >
                 </ tr >
             </ table >
         </ td >
     </ tr >
</ table >

 

 Groups.aspx.cs代码片断： 

代码
using  System;
 using  System.Collections.Generic;
 using  System.Data;
 using  System.Linq;
 using  System.Web;
 using  System.Web.UI;
 using  System.Web.UI.WebControls;
 using  Insus.NET;

 public   partial   class  System_SyteLine_Authorizations_Groups : BasePage
{
    Authorizations objAuthorizations  =   new  Authorizations();

     protected   void  Page_Load( object  sender, EventArgs e)
    {
        InsusBase.SystemPath  =  Request.RawUrl;
        InsusBase.SystemLoginAuthorizationed();
        
         if  ( ! IsPostBack)
        {
            Data_Binding();
        }

         this .SystemPageSubject1.SetSubject  =   " Groups " ;
    }

     private   void  Data_Binding()
    {
         this .GvGroups.DataSource  =  objAuthorizations.GetGroupNames();
         this .GvGroups.DataBind();
    }

     protected   void  GvGroups_RowCreated( object  sender, GridViewRowEventArgs e)
    {
        InsusBase.GridView_RowCreated(GvGroups, e,  " Peachpuff " );

         if  (e.Row.RowType  ==  DataControlRowType.DataRow)
        {
             if  (e.Row.FindControl( " ImageButtonDetails " )  !=   null )
            {
                ImageButton ImageButtonDetails  =  (ImageButton)e.Row.FindControl( " ImageButtonDetails " );
                ImageButtonDetails.Click  +=   new  ImageClickEventHandler(ImageButtonDetails_Click);
            }
        }
    }

     private   void  ImageButtonDetails_Click( object  sender, ImageClickEventArgs e)
    {
        ImageButton imageButton  =  (ImageButton)sender;
        GridViewRow gvr  =  (GridViewRow)imageButton.Parent.Parent;
         string  primaryKey  =  GvGroups.DataKeys[gvr.RowIndex].Value.ToString();

        DataRow dataRow  =  objAuthorizations.GetGroupNamesByGroupId(primaryKey).Rows[ 0 ];

         string  message  =   string .Empty;
         if  (dataRow[ " GroupDesc " ].ToString().Length  ==   0 )
        {
            message  +=  dataRow[ " GroupName " ].ToString();
        }
         else
        {
            message  +=  dataRow[ " GroupName " ].ToString()  +   " ( "   +  dataRow[ " GroupDesc " ].ToString()  +   " ) " ;
        }

         this .lbGroupName.Text  =   " Group Name:  "   +  message;

         this .GvUsers.DataSource  =  objAuthorizations.GetUserNamesByGroupId(primaryKey);
         this .GvUsers.DataBind();

         this .GvAuthorizations.DataSource  =  objAuthorizations.GetAccountAuthorizationsByGroup(primaryKey);
         this .GvAuthorizations.DataBind();
    }
}

 
下图是Groups界面截图：


 以上代码片码，仅供参考，您无法直接拷贝运行。如有什么问题，可以留言与以博客园联系方式联系Insus.NET。

weixin_34034670
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
图文解读 Infor10 ERP SyteLine的功能
12-07 1114
【IT168信息化】 　　当前，我们看到在企业中存在这样一种现象，企业的ERP软件很难快速交付?软件的二次开发以及修改越来越困难?软件不能帮助企业解决行业很特别的需要?针对于这些现状，首先要求我们的CIO要了解企业的运作、熟悉...
infor syteline ERP自定义IDO属性及表单.pdf
12-10
原创 教程 自定义IDO属性及表单 IDO属新更新处理流程； 表单设计流程； 表单设计失误无法运行处理流程 表单实像演示（收货单行）
SyteLine 表单个性开发
02-11
SyteLine的基础操作和表单的开发教程！！
中华财务for Syteline7说明书.pdf
08-22
SyteLine 中华财务 中华财务for Syteline7说明书.pdf
SyteLine实现字段过滤
weixin_34015336的博客
10-15 125
如果说某个下拉列表，想过滤某些选项，该怎样来做呢，在Infor Syteline实现起来是一件很容易的事情。如在Fixed Assets窗口中的Class Code的下拉列表中，如果不想"_OB"的选项显示出来。  首先打开Fixed Assets窗口，切换至Design模式： 此时它会显示一个Identify Your Editing Scope的窗口，你需要要Scope下拉列表，选择"Si...
Infor SyteLine 8.02 Utility Server SyteLine Setup And Configuration
weixin_34289454的博客
08-24 123
Infor SyteLine Utility Server中，SyteLine的安装与配置，整个过程中，重点部分，我都截屏出来。 选择Infor ERP SyteLine组件：                                              ...
Syteline系统操作手册
09-29
Syteline ERP 操作说明 通熟易懂！
Syteline 7采购标准教程
04-08
Syteline 7采购标准教程 。
The Infor ERP SyteLine Smart Framework
03-17
The Infor ERP SyteLine Smart Framework
Syteline重设sa帐户密码
最新发布
qq_24510215的博客
01-16 162
在Configuration Manager窗口，选择configuration Names > 点Edit铵钮，打开另一个窗口，可以从下面二个方法实现，一是使用另一个有super权限用户来登录系统，打开users窗口，找到sa用户，然后可以更改了。公司使用的是Infor Syteline 8.xx版本的ERP，如何方便与快捷去更改sa帐户的密码。参考上面箭头指示，就可以轻易把sa帐户的密码修改。
SL采购退货
10-16
SyteLine 9 采购退货，包含已入库未开票的退货或已入库已开票的退货
Infor CloudSuite Industrial (SyteLine) 工序外协基本流程
EvanZhao798
06-29 895
Infor CloudSuite Industrial (SyteLine) 工序外协基本流程 实际操作流程 1.打开表单 车间管理参数 如下设置 2.定义外协资源、资源组、工作中心 PCAL=7*24 设置三者的关联 3.设置物料外协工序 使用固定排产时数 注意数量选择 批次或单位 4.作业报工 10 完成 20 完成 30接收 20 过账到30后 系统就为作业单30工序创建采购单 30对应的采购单数量为作业单数量（可在车间参数调整为多行） 5.作业物料——工序30 外协作业物料
[Syteline]SyteLine ERP系统 "僵尸"处理方式
数据库天地
12-15 404
在跑SytelineERP系统的后台任务的过程中,偶尔产生僵尸的现象 又没有工具去杀死这个进程,在ORACLE JDE中,有队列的概念,其中一个死掉就会造成阻塞,也可以调整优先级! 但在syteline中没有工作 只能在数据库中去删除. 方法如下: Another solution about kill a process in SQL is as below : Kill a Pro...
[Syteline]其他发出-调整存货
德仔
10-24 1913
通常在月末仓库盘点存在一些问题. 回冲料 调整 可以在其他发出做调整。发出对应的批次库存。 注意事项: 仓库，数量，批次，货位，原因
Infor SyteLine如何快速锁定用户
weixin_34120274的博客
10-16 142
使用Infor Syteline ERP系统，当需要做系统维护时，我们需要通知所有用户退出系统，在维护期间，严禁用户登录，这样的话，我们需要锁定用户。对于这个问题，很多管理员会打开SL的Users窗口，切换至Login Information标签内，把User Login Status的Active改变为Disabled。   系统维护完毕，再改回来。这样的做法，只能针对少量的用户。如果你的系...
SyteLine表单定制教程：从基础到高级
SyteLine是一款强大的企业资源计划（ERP）软件，特别专注于表单个性化开发。该教程旨在帮助用户深入理解并掌握SyteLine的各项核心功能，包括但不限于制造业中的物料清单、工程变更通知单、客户订单处理、预估、人力...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值