/// <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());
}
