public List <TuKhoaTraVe> getTuKhoaQuanHuyen(string tukhoa) { try { connect(); string query = "SELECT * FROM TUKHOAQUANHUYEN"; adapter = new SqlDataAdapter(query, connection); DataSet dataset = new DataSet(); adapter.Fill(dataset); ArrayList ls = ConvertDataSetToArrayList(dataset); List <TuKhoaTraVe> arr = new List <TuKhoaTraVe>(); //List<int> dem = new List<int>(); foreach (Object o in ls) { TuKhoaTraVe tk = new TuKhoaTraVe(); TuKhoaQuanHuyen tt = (TuKhoaQuanHuyen)o; ApproximatString A = new ApproximatString(tt.TuKhoaQuanHuyen1); int C = A.SoSanh(tukhoa); if (C != -1) { if (arr.Count == 0) { tk.ma = tt.MaQuanHuyen; tk.saiso = C; tk.bang = 5; arr.Add(tk); } else { for (int i = 0; i < arr.Count; i++) { if (arr[i].saiso > C) { tk.ma = tt.MaQuanHuyen; tk.saiso = C; tk.bang = 5; if (arr[i].ma != tt.MaQuanHuyen) { arr.Insert(i, tk); } else { arr[i] = tk; } i = arr.Count; } } } } } disconnect(); return(arr); } catch (Exception e) { return(null); } }
protected override object GetDataFromDataRow(DataTable dt, int i) { TuKhoaQuanHuyen tk = new TuKhoaQuanHuyen(); tk.MaTuKhoaQuanHuyen = dt.Rows[i].IsNull("MaTuKhoaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaTuKhoaQuanHuyen"]; tk.TuKhoaQuanHuyen1 = dt.Rows[i]["TuKhoaQuanHuyen"].ToString(); tk.MaQuanHuyen = dt.Rows[i].IsNull("MaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaQuanHuyen"]; return((object)tk); }
public bool insertTuKhoaQuanHuyen(TuKhoaQuanHuyen tkq) { try { connect(); string insertCommand = "INSERT INTO TUKHOAQUANHUYEN VALUES( N'" + tkq.TuKhoaQuanHuyen1 + "'," + tkq.MaQuanHuyen + ")"; executeNonQuery(insertCommand); disconnect(); return(true); } catch (Exception e) { return(false); } }
public bool updateTuKhoaQuanHuyen(TuKhoaQuanHuyen tk) { try { connect(); string updateCommand = "UPDATE TUKHOAQUANHUYEN SET TuKhoaQuanHuyen = '" + tk.TuKhoaQuanHuyen1 + "', MaQuanHuyen = " + tk.MaQuanHuyen + " WHERE MaTuKhoaQuanHuyen = " + tk.MaTuKhoaQuanHuyen; executeNonQuery(updateCommand); disconnect(); return(true); } catch (Exception e) { return(false); } }