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)); }
public DataTable SelectUsers(string loginName, string userName) { QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService(); return(gs.SearchUsers(groupId, loginName, userName)); }
public DataTable SelectUsers(string loginName, string userName) { QJVRMS.Business.GroupWS.GroupService gs = new QJVRMS.Business.GroupWS.GroupService(); return gs.SearchUsers(groupId, loginName, userName); }
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); }