public DataTable getCities(out THC_Library.Error error)
{
error = null;
DataTable addrTable = null;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select distinct city,sec from taiwan_map order by sec";
THC_Library.DataBase.DataBaseControl dbCtl = new THC_Library.DataBase.DataBaseControl();
try
{
dbCtl.Open();
addrTable = dbCtl.GetDataTable(strSQL, paraList);
}
catch (Exception ex)
{
error = new Error();
error.Number = 100;
error.ErrorMessage = "系統錯誤";
}
finally
{
dbCtl.Close();
}
return(addrTable);
}
public DataTable getRoad(string city, string town, out THC_Library.Error error)
{
error = null;
DataTable addrTable = null;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select road from taiwan_map where city=@city and town=@town order by road";
THC_Library.DataBase.DataBaseControl dbCtl = new THC_Library.DataBase.DataBaseControl();
try
{
dbCtl.Open();
paraList.Add(new SqlParameter("@city", city));
paraList.Add(new SqlParameter("@town", town));
addrTable = dbCtl.GetDataTable(strSQL, paraList);
}
catch (Exception ex)
{
error = new Error();
error.Number = 100;
error.ErrorMessage = "系統錯誤";
}
finally
{
dbCtl.Close();
}
return(addrTable);
}
public bool checkLocalAccount(string account, out Error error)
{
error = null;
bool bExisted = false;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select CM002 from consumer_member where CM002=@CM002";
paraList.Add(new SqlParameter("@CM002", account));
DataBaseControl dbCtl = new DataBaseControl();
try
{
dbCtl.Open();
IDataReader dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
bExisted = true;
}
dataReader.Close();
}
catch (Exception ex)
{
error = new THC_Library.Error();
error.Number = THC_Library.THCException.SYSTEM_ERROR;
error.ErrorMessage = ex.Message;
}
finally
{
dbCtl.Close();
}
return(bExisted);
}
