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; } }