public static string GetAutoRelyInfoString() { string str = "select distinct a.userId from GpsUser_Online a"; SqlDataAccess access = new SqlDataAccess(); DataTable table = null; try { table = access.getDataBySql(str); } catch { } if ((table == null) || (table.Rows.Count <= 0)) { return string.Empty; } string str2 = string.Empty; string key = string.Empty; foreach (DataRow row in table.Rows) { key = row["userid"] as string; if (_userIDCarList.ContainsKey(key)) { string str4 = str2; str2 = str4 + _userIDCarList[key].ToString() + "|" + key + " "; } } return str2; }
public static string GetWorkIdByUserId(string string_0) { string format = "select top 1 a.Id from GpsUser_Online a where a.userId = '{0}' order by logintime desc"; format = string.Format(format, string_0); SqlDataAccess access = new SqlDataAccess(); DataTable table = null; try { table = access.getDataBySql(format); } catch { } if ((table != null) && (table.Rows.Count > 0)) { return table.Rows[0]["Id"].ToString(); } return string.Empty; }