private void btnXoa_ItemClick(object sender, ItemClickEventArgs e) { DialogResult da = XtraMessageBox.Show("Bạn muốn xóa tất cả trong HD", "Thông báo", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); O_HOADON GD = (GVHD.GetRow(GVHD.GetSelectedRows()[0]) as O_HOADON); List <O_HOADON> lst = hoaDonOs.Where(w => w.SoChungTu.Equals(GD.SoChungTu) && w.IDKhachHang.Equals(GD.IDKhachHang) && w.NgayThucHien.ToString("ddMMyyy").Equals(GD.NgayThucHien.ToString("ddMMyyy"))).ToList(); long A = 0; switch (da) { case DialogResult.Yes: List <object> s = new List <object>(); foreach (O_HOADON z in lst) { s.Add(z.ID); } A = _HoaDonD.XoaNhieu1Ban(s); DuLieu(); break; case DialogResult.No: A = _HoaDonD.Xoa(GD.ID); DuLieu(); break; case DialogResult.Cancel: return; } }
private void btnThemRow_ItemClick(object sender, ItemClickEventArgs e) { O_HOADON GD = (GVHD.GetRow(GVHD.GetSelectedRows()[0]) as O_HOADON); frmHoaDonThem frm = new frmHoaDonThem(GD); frm.ShowDialog(ParentForm); }
private GVHD GetGVHDFromDataRow(DataRow row) { GVHD s = new GVHD(); s.Ma_Huong_NC = row["Ma_Huong_NC"].ToString(); s.Ten = row["Ten"].ToString(); s.ID_GVHD = row["ID_GVHD"].ToString(); return(s); }
public GVHD[] getAllGVHD() { string sqlCmd = "SELECT * FROM GVHD"; DataTable d = DBHelper.DBExcuteQuery(sqlCmd); int count = d.Rows.Count; GVHD[] results = new GVHD[count]; for (int i = 0; i < count; i++) { results[i] = GetGVHDFromDataRow(d.Rows[i]); } return(results); }
public void DuLieu() { string _Query = string.Empty; if (!XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.ShowWaitForm(); } if (chk1.Checked) { _Query = DuLieuTaoSan.ThoiGianRutGon("NgayThucHien")[idThoiGian].Substring(3); } else if (chk2.Checked) { if (bdtpTu.EditValue != null && bdtpDen.EditValue != null) { _Query = string.Format("(convert(date, NgayThucHien) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd")); } } else if (chk3.Checked && _SV_MC.Length > 0) { _Query += string.Format("REPLACE(COALESCE(SoVe,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC)); } else if (chk4.Checked && _SV_MC.Length > 0) { _Query += string.Format("REPLACE(COALESCE(MaCho,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC)); } else if (chk5.Checked && _SV_MC.Length > 0) { _Query += string.Format("REPLACE(COALESCE(MaHD,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC)); } if (_Query.Length > 0) { hoaDonOs = hoaDonD.DuLieu(_Query); hoaDonOBindingSource.DataSource = hoaDonOs; GVHD.BestFitColumns(); } if (XuLyGiaoDien.wait.IsSplashFormVisible) { XuLyGiaoDien.wait.CloseWaitForm(); } }
private void grvDatCho_DoubleClick(object sender, EventArgs e) { O_HOADON GD = (GVHD.GetRow(GVHD.GetSelectedRows()[0]) as O_HOADON); List <O_HOADON> lst = new List <O_HOADON>(); lst = hoaDonOs.Where(w => w.SoChungTu.Equals(GD.SoChungTu) && w.IDKhachHang.Equals(GD.IDKhachHang) && w.NgayThucHien.ToString("ddMMyyy").Equals(GD.NgayThucHien.ToString("ddMMyyy"))).ToList(); if (lst.Count() > 1) { if (XtraMessageBox.Show("Bạn muốn chỉnh sửa tất cả", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { lst = hoaDonOs.Where(w => w.ID.Equals(GD.ID)).ToList(); } } else { lst = hoaDonOs.Where(w => w.ID.Equals(GD.ID)).ToList(); } frmHoaDonThem frm = new frmHoaDonThem(lst); frm.ShowDialog(ParentForm); }