private void Nap_Danh_Sach_Kho_Hang() { var db = new Data_QLKDataContext(SqlHelper.ConnectionString); var khoHangs = (from kh in db.KHO_HANGs select kh).ToList(); var tatCa = new KHO_HANG(); tatCa.Ma_Kho = "all"; tatCa.Ten_Kho = "Tất cả"; //khoHangs.Add(tatCa); khoHangs.Insert(0, tatCa); txtKhoHang.Properties.DataSource = khoHangs; if(khoHangs.Count() > 0) { txtKhoHang.EditValue = "all"; } txtKhoHang_View.BestFitColumns(); }
partial void DeleteKHO_HANG(KHO_HANG instance);
partial void InsertKHO_HANG(KHO_HANG instance);
partial void UpdateKHO_HANG(KHO_HANG instance);
private void btnLuu_Click(object sender, EventArgs e) { if (!Check()) { return; } try { if (tinh_trang == "them") { KHO_HANG kho = new KHO_HANG { Ma_Kho = txtMaKho.Text, Ten_Kho = txtTenKho.Text, Dia_Chi = txtDiaChi.Text, Email = txtEmail.Text, Dien_Thoai = txtDienThoai.Text, Fax = txtFax.Text, Di_Dong = txtDiDong.Text, Thu_Kho = txtThuKho.Text, Ghi_Chu = txtGhiChu.Text }; db.KHO_HANGs.InsertOnSubmit(kho); } else { var kho = (from k in db.KHO_HANGs where k.Ma_Kho == txtMaKho.Text select k).FirstOrDefault(); kho.Ma_Kho = txtMaKho.Text; kho.Ten_Kho = txtTenKho.Text; kho.Dia_Chi = txtDiaChi.Text; kho.Email = txtEmail.Text; kho.Dien_Thoai = txtDienThoai.Text; kho.Fax = txtFax.Text; kho.Di_Dong = txtDiDong.Text; kho.Thu_Kho = txtThuKho.Text; kho.Ghi_Chu = txtGhiChu.Text; } db.SubmitChanges(); RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }