/// <summary> /// 判断是否存在 /// </summary> /// <param name="connectionString">连接字符串</param> /// <param name="strOracle">sql命令</param> /// <returns></returns> public static bool Exists(string connectionString, string cmdText) { object obj = AccessHelper.GetSingle(connectionString, cmdText); int cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = 0; } else { cmdresult = int.Parse(obj.ToString()); } if (cmdresult == 0) { return(false); } else { return(true); } }
/// <summary> /// 根据城市获取省份 /// </summary> /// <param name="city">城市</param> /// <returns>省份</returns> public static string getProvinceByCity(string city) { var province = AccessHelper.GetSingle(AccessHelper.conn, String.Format("select COUNTY_NAME from CITY where CITY_NAME='{0}'", city)); return(province.ToString()); }