public Kho GetKhobyID_Kho(int ID_Kho) { Kho s = new Kho(); foreach (Kho i in GetAllKho()) { if (i.ID_Kho == ID_Kho) { s = i; } } return(s); }
public List <Kho> GetKho(string DiaChi, string Ten) { Kho data = new Kho(); foreach (Khuvuc i in CSDL_OOP.Instance.GetAllKhuvuc()) { if (i.DiaChi == DiaChi) { data.ID_KV = i.ID_KV; } } List <Kho> k = new List <Kho>(); foreach (DataRow i in CSDL.Instance.DTKho.Rows) { if (data.ID_KV == 0) { if (Ten != "") { if (i["Ten"].ToString().Contains(Ten)) { k.Add(GetKho(i)); } } else { k.Add(GetKho(i)); } } else { if (Ten != "") { if (i["Ten"].ToString().Contains(Ten) && Convert.ToInt32(i["ID_KV"]) == data.ID_KV) { k.Add(GetKho(i)); } } else { if (Convert.ToInt32(i["ID_KV"]) == data.ID_KV) { k.Add(GetKho(i)); } } } } return(k); }
public void ExecuteDB(Kho s) { bool check = false; foreach (Kho i in GetAllKho()) { if (i.ID_Kho == s.ID_Kho) { check = true; } } if (check) { CSDL.Instance.EditDataRow(s); } else { CSDL.Instance.AddDataRow(s); } }
private void btOK_Click(object sender, EventArgs e) { Kho s = new Kho(); s.ID_Kho = Convert.ToInt32(tbIDKho.Text); s.Ten = tbTen.Text; Khuvuc data = new Khuvuc(); foreach (Khuvuc i in CSDL_OOP.Instance.GetAllKhuvuc()) { if (i.DiaChi == data.DiaChi) { s.ID_KV = i.ID_KV; } } data.DiaChi = cbbKhuvuc.SelectedItem.ToString(); s.DienTich = Convert.ToDouble(tbDienTich.Text); s.TrangThai = cbbTrangThai.SelectedItem.ToString(); CSDL_OOP.Instance.ExecuteDB(s); d(0, null); this.Dispose(); }
public List <Kho> Sort(string s, int ID_KV, string Name) { List <Kho> listKho = CSDL_OOP.Instance.GetListKho(ID_KV, Name); Mydel compare; for (int i = 0; i < listKho.Count - 1; i++) { for (int j = i + 1; j < listKho.Count; j++) { switch (s) { case "ID_Kho": { compare = new Mydel(CSDL.CompareIDKho); if (compare(listKho[i], listKho[j])) { Kho temp = listKho[i]; listKho[i] = listKho[j]; listKho[j] = temp; } break; } case "Ten": { compare = new Mydel(CSDL.CompreTenKho); if (compare(listKho[i], listKho[j])) { Kho temp = listKho[i]; listKho[i] = listKho[j]; listKho[j] = temp; } break; } case "DienTich": { compare = new Mydel(CSDL.CompareDienTichKho); if (compare(listKho[i], listKho[j])) { Kho temp = listKho[i]; listKho[i] = listKho[j]; listKho[j] = temp; } break; } case "TrangThai": { compare = new Mydel(CSDL.CompareTrangThai); if (compare(listKho[i], listKho[j])) { Kho temp = listKho[i]; listKho[i] = listKho[j]; listKho[j] = temp; } break; } case "ID_KV": { compare = new Mydel(CSDL.CompareID_KV); if (compare(listKho[i], listKho[j])) { Kho temp = listKho[i]; listKho[i] = listKho[j]; listKho[j] = temp; } break; } } } } return(listKho); }