public IList <Book.Model.RoleOperation> SelectbyOperatorsKeyTag(Book.Model.Operators operations, string keytag)
        {
            Hashtable ht = new Hashtable();

            ht.Add("operatorsId", operations == null ? null : operations.OperatorsId);
            ht.Add("keytag", keytag);

            return(sqlmapper.QueryForList <Model.RoleOperation>("RoleOperation.select_byOperatorsKeyTag", ht));
        }
        public bool IsHasGiveUpAudited(Book.Model.Operators operations, string invoiceid, string TableName)
        {
            Hashtable ht = new Hashtable();

            ht.Add("operatorsId", operations.OperatorsId);
            ht.Add("invoiceid", invoiceid);
            ht.Add("TableName", TableName);
            return(sqlmapper.QueryForObject <bool>("RoleAuditing.select_IsHasGiveUpAudited", ht));
        }
Example #3
0
 public IList <Book.Model.Role> SelectRole(Book.Model.Operators operators)
 {
     if (operators != null)
     {
         string sql = "SELECT * FROM Role WHERE roleId IN (select RoleId from OperationRole where OperatorsId = '" + operators.OperatorsId + "' and IsHold=1)";
         return(this.DataReaderBind <Model.Role>(sql, null, CommandType.Text));
     }
     else
     {
         return(null);
     }
 }
Example #4
0
 public IList <Book.Model.RoleOperation> SelectbyOperatorsKeyTag(Book.Model.Operators operations, string keytag)
 {
     return(accessor.SelectbyOperatorsKeyTag(operations, keytag));
 }
Example #5
0
 /// <summary>
 /// 根据操作员查询 拥有查询功能窗体
 /// </summary>
 /// <param name="operations"></param>
 /// <returns></returns>
 public IList <Book.Model.RoleOperation> SelectIsSearch(Book.Model.Operators operations)
 {
     return(accessor.SelectIsSearch(operations));
 }
Example #6
0
 public IList <Book.Model.Role> SelectRole(Book.Model.Operators operators)
 {
     return(accessor.SelectRole(operators));
 }
 public IList <Book.Model.RoleOperation> SelectIsSearch(Book.Model.Operators operations)
 {
     return(sqlmapper.QueryForList <Model.RoleOperation>("RoleOperation.select_byOperatorsId", operations.OperatorsId));
 }
Example #8
0
 public bool IsHasGiveUpAudited(Book.Model.Operators operations, string invoiceid, string TableName)
 {
     return(accessor.IsHasGiveUpAudited(operations, invoiceid, TableName));
 }