Esempio n. 1
0
        public DataTable SelectUsers(string sqlWhere)
        {
            //string sql = "select * from users where GroupId='{0}'";

            //sql = string.Format(sql, this.groupId.ToString());

            //if (!string.IsNullOrEmpty(sqlWhere))
            //{
            //    sql += " and " + sqlWhere;


            //}

            //return SqlHelper.ExecuteDataset(SqlHelper.SqlCon_QJVRMS, CommandType.Text, sql).Tables[0];

            QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService();
            return(gs.SearchUsers(sqlWhere));
        }
Esempio n. 2
0
 public DataTable SelectUsers(string loginName, string userName)
 {
     QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService();
     return(gs.SearchUsers(groupId, loginName, userName));
 }
Esempio n. 3
0
 public DataTable SelectUsers(string loginName, string userName)
 {
     QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService();
     return gs.SearchUsers(groupId, loginName, userName);
 }
Esempio n. 4
0
        public DataTable SelectUsers(string sqlWhere)
        {
            //string sql = "select * from users where GroupId='{0}'";

            //sql = string.Format(sql, this.groupId.ToString());

            //if (!string.IsNullOrEmpty(sqlWhere))
            //{
            //    sql += " and " + sqlWhere;


            //}

            //return SqlHelper.ExecuteDataset(SqlHelper.SqlCon_QJVRMS, CommandType.Text, sql).Tables[0];

            QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService();
            return gs.SearchUsers(sqlWhere);
        }