internal List <AddressCodeListObj> DistrictList(string code)
{
string txtQuery = string.Format("SELECT * FROM {0} WHERE (Code LIKE @code) and Amphoe_TH != '' and Tambon_TH = '' order by Amphoe_TH", this.tableName);
try
{
List <AddressCodeListObj> items = new List <AddressCodeListObj>();
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@code", code + "%");
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
items.Add(new AddressCodeListObj("0", "กรุณาเลือกจังหวัด", "กรุณาเลือกอำเภอ", "กรุณาเลือกตำบล"));
while (dr.Read())
{
AddressCodeListObj obj = new AddressCodeListObj();
obj.code = dr["Code"].ToString();
obj.changwat_th = dr["Changwat_TH"].ToString();
obj.amphoe_th = dr["Amphoe_TH"].ToString();
obj.tambon_th = dr["Tambon_TH"].ToString();
items.Add(obj);
}
}
}
}
return(items);
}
catch (Exception ex)
{
throw ex;
}
}
internal AddressCodeListObj select(string code)
{
while (code.Length < 8)
{
code = code + "0";
}
string txtQuery = string.Format("SELECT * FROM {0} WHERE Code = @code", this.tableName);
try
{
AddressCodeListObj data = new AddressCodeListObj();
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@code", code);
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
data.code = dr["Code"].ToString();
data.changwat_th = dr["Changwat_TH"].ToString();
data.amphoe_th = dr["Amphoe_TH"].ToString();
data.tambon_th = dr["Tambon_TH"].ToString();
}
}
}
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
