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