public frmTonKho()
{
InitializeComponent();
db = new Data_QLKDataContext(SqlHelper.ConnectionString);
Danh_Sach_Kho_Hang();
bbiXem_ItemClick(this, null);
}
public frmXuatKho()
{
InitializeComponent();
bm.SetPopupContextMenu(gcList, pm);
Khach_Hang();
Hang_Hoa();
Kho_Hang();
Nhan_Vien();
Nap_Hinh_Thuc_Thu_Chi();
Nap_Hinh_Thuc_Cong_No();
db = new Data_QLKDataContext(SqlHelper.ConnectionString);
bbiTaoMoi_ItemClick(this, null);
_mColumn = new Column();
_mColumn = Column.None;
tinh_trang = "them";
}
public frmNhapKho(string ma)
{
InitializeComponent();
bm.SetPopupContextMenu(gcList, pm);
Khach_Hang();
Hang_Hoa();
Kho_Hang();
Nhan_Vien();
Nap_Hinh_Thuc_Thu_Chi();
Nap_Hinh_Thuc_Thanh_Toan();
db = new Data_QLKDataContext(SqlHelper.ConnectionString);
bbiTaoMoi_ItemClick(this, null);
_mColumn = new Column();
_mColumn = Column.None;
tinh_trang = "sua";
var ct = (from c in db.CHUNG_TUs
where c.Ma_Chung_Tu == ma
select c).FirstOrDefault();
txtMaChungTu.Text = ct.Ma_Chung_Tu;
txtMaChungTu.Properties.ReadOnly = true;
txtMaHoaDon.Text = ct.Ma_Hoa_Don;
txtNgay.EditValue = ct.Ngay;
txtNhanVien.EditValue = ct.Nhan_Vien;
txtKhachHang.EditValue = ct.Ma_Khach_Hang;
txtDiaChi.Text = ct.Dia_Chi;
txtLyDo.Text = ct.Ly_Do;
txtGhiChu.Text = ct.Ghi_Chu;
txtChietKhauPhanTram.Value = ct.Chiet_Khau_Phan_Tram ?? 0;
txtVATPhanTram.Value = ct.VAT_Phan_Tram ?? 0;
txtChietKhauThanhTien.Value = ct.Chiet_Khau_Thanh_Tien ?? 0;
txtVATThanhTien.Value = ct.VAT_Thanh_Tien ?? 0;
txtThanhTien.Value = ct.Thanh_Tien ?? 0;
txtHinhThucCongNo.EditValue = ct.Hinh_Thuc_Cong_No ?? 0;
txtHinhThucThuChi.EditValue = ct.Hinh_Thuc_Thu_Chi ?? 0;
txtThanhToan.Value = ct.Thanh_Toan ?? 0;
cHUNG_TU_CHI_TIETTableAdapter.Connection.ConnectionString = SqlHelper.ConnectionString;
cHUNG_TU_CHI_TIETTableAdapter.ClearBeforeFill = true;
cHUNG_TU_CHI_TIETTableAdapter.Fill(dsNhapKho.CHUNG_TU_CHI_TIET, txtMaChungTu.Text);
}
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
return;
var db = new Data_QLKDataContext(SqlHelper.ConnectionString);
var ma = gbList.GetFocusedRowCellValue(colMa_Khu_Vuc);
if (ma == null)
return;
int[] selectedRows = gbList.GetSelectedRows();
string[] khuvuc = new string[selectedRows.Length];
for (int i = selectedRows.Length; i > 0; i--)
{
var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa_Khu_Vuc);
if (arg == null)
continue;
khuvuc[i-1] = arg.ToString();
}
var kv = from k in db.KHU_VUCs
//where k.Ma_Khu_Vuc == ma.ToString()
where khuvuc.Contains(k.Ma_Khu_Vuc)
select k;
foreach (var k in kv)
{
db.KHU_VUCs.DeleteOnSubmit(k);
}
try
{
db.SubmitChanges();
bbiXem_ItemClick(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
return;
var db = new Data_QLKDataContext(SqlHelper.ConnectionString);
int[] selectedRows = gbList.GetSelectedRows();
string[] nhanvien = new string[selectedRows.Length];
for (int i = selectedRows.Length; i > 0; i--)
{
var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa_Nhan_Vien);
if (arg == null)
continue;
nhanvien[i - 1] = arg.ToString();
}
var nv = from h in db.NHAN_VIENs
where nhanvien.Contains(h.Ma_Nhan_Vien)
select h;
foreach (var n in nv)
{
db.NHAN_VIENs.DeleteOnSubmit(n);
}
try
{
db.SubmitChanges();
bbiXem_ItemClick(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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();
}
string Luu_Chi_Tiet(Data_QLKDataContext database)
{
var result = "OK";
var dt = dsNhapKho.CHUNG_TU_CHI_TIET;
var id = "";
var row = 0;
for (var i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i].RowState != DataRowState.Deleted)
{
row++;
if (dt.Rows[i]["Ma_Hang_Hoa"] == DBNull.Value)
{
MessageBox.Show("Vui lòng chọn mặt hàng.", "Thông báo",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
result = "Chưa chọn mặt hàng";
gbList.FocusedRowHandle = row;
gbList.SetColumnError(colMa_Hang_Hoa, "Chưa chọn mặt hàng");
return result;
}
if (dt.Rows[i]["Ma_Kho_Hang"] == DBNull.Value)
{
MessageBox.Show("Chưa chọn kho hàng.", "Thông báo",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
result = "Chưa chọn kho hàng";
gbList.FocusedRowHandle = row;
gbList.SetColumnError(colMa_Kho_Hang, "Chưa chọn kho hàng");
return result;
}
id = dt.Rows[i]["Ma_Chi_Tiet"].ToString();
}
var dr = dt.Rows[i];
switch (dr.RowState)
{
case DataRowState.Added:
var chung_tu_chi_tiet = new CHUNG_TU_CHI_TIET
{
Ma_Chi_Tiet = Guid.NewGuid(),
Ma_Chung_Tu = txtMaChungTu.Text,
Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(),
Loai_Chung_Tu = 1, //1 nhap kho 2 xuat kho
Tinh_Trang = true, //true nhap kho false xuat kho
Ma_Kho_Hang = dt.Rows[i]["Ma_Kho_Hang"].ToString(),
So_Luong = Convert.ToDecimal(dt.Rows[i]["So_Luong"]),
Don_Gia = Convert.ToDecimal(dt.Rows[i]["Don_Gia"]),
Thanh_Tien = Convert.ToDecimal(dt.Rows[i]["Thanh_Tien"]),
Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString(),
So_Thu_Tu = 0
};
database.CHUNG_TU_CHI_TIETs.InsertOnSubmit(chung_tu_chi_tiet);
break;
case DataRowState.Modified:
var chi_tiet_sua = (from ctct in database.CHUNG_TU_CHI_TIETs
where ctct.Ma_Chi_Tiet == new Guid(id)
select ctct).FirstOrDefault();
chi_tiet_sua.Ma_Chi_Tiet = new Guid(id);
chi_tiet_sua.Ma_Chung_Tu = txtMaChungTu.Text;
chi_tiet_sua.Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString();
chi_tiet_sua.Loai_Chung_Tu = 1; //1 nhap kho 2 xuat kho
chi_tiet_sua.Tinh_Trang = true; //true nhap kho false xuat kho
chi_tiet_sua.Ma_Kho_Hang = dt.Rows[i]["Ma_Kho_Hang"].ToString();
chi_tiet_sua.So_Luong = Convert.ToDecimal(dt.Rows[i]["So_Luong"]);
chi_tiet_sua.Don_Gia = Convert.ToDecimal(dt.Rows[i]["Don_Gia"]);
chi_tiet_sua.Thanh_Tien = Convert.ToDecimal(dt.Rows[i]["Thanh_Tien"]);
chi_tiet_sua.Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString();
chi_tiet_sua.So_Thu_Tu = 0;
break;
case DataRowState.Deleted:
var chi_tiet_xoa = (from ctct in database.CHUNG_TU_CHI_TIETs
where ctct.Ma_Chi_Tiet == new Guid(id)
select ctct).FirstOrDefault();
database.CHUNG_TU_CHI_TIETs.DeleteOnSubmit(chi_tiet_xoa);
break;
}
database.SubmitChanges();
}
return result;
}
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
gbList.FocusedRowHandle += 1;
gbList.UpdateCurrentRow();
if (!Kiem_Tra())
{
return;
}
Data_QLKDataContext database = new Data_QLKDataContext(SqlHelper.ConnectionString);
try
{
database.Connection.Open();
System.Data.Common.DbTransaction transaction = database.Connection.BeginTransaction();
database.Transaction = transaction;
if (tinh_trang == "them")
{
CHUNG_TU chung_tu = new CHUNG_TU
{
Ma_Chung_Tu = txtMaChungTu.Text,
Ma_Hoa_Don = txtMaHoaDon.Text,
Ngay = txtNgay.DateTime,
Loai_Chung_Tu = 1, //1 la nhap kho 2 la xuat kho
Ma_Khach_Hang = string.IsNullOrEmpty(txtKhachHang.Text) ? "" : txtKhachHang.EditValue.ToString(),
Dia_Chi = txtDiaChi.Text,
Ly_Do = txtLyDo.Text,
VAT_Phan_Tram = txtVATPhanTram.Value,
VAT_Thanh_Tien = txtVATThanhTien.Value,
Chiet_Khau_Phan_Tram = txtChietKhauPhanTram.Value,
Chiet_Khau_Thanh_Tien = txtChietKhauThanhTien.Value,
Thanh_Tien = txtThanhTien.Value,
Hinh_Thuc_Cong_No = Convert.ToInt32(txtHinhThucCongNo.EditValue),
Hinh_Thuc_Thu_Chi = Convert.ToInt32(txtHinhThucThuChi.EditValue),
Thanh_Toan = txtThanhToan.Value,
Ghi_Chu = txtGhiChu.Text,
So_Thu_Tu = 0,
Nhan_Vien = string.IsNullOrEmpty(txtNhanVien.Text) ? "" : txtNhanVien.EditValue.ToString()
};
database.CHUNG_TUs.InsertOnSubmit(chung_tu);
}
else
{
var chung_tu = (from ct in database.CHUNG_TUs
where ct.Ma_Chung_Tu == txtMaChungTu.Text
select ct).FirstOrDefault();
chung_tu.Ma_Chung_Tu = txtMaChungTu.Text;
chung_tu.Ma_Hoa_Don = txtMaHoaDon.Text;
chung_tu.Ngay = txtNgay.DateTime;
chung_tu.Loai_Chung_Tu = 1; //1 la nhap kho 2 la xuat kho
chung_tu.Ma_Khach_Hang = string.IsNullOrEmpty(txtKhachHang.Text) ? "" : txtKhachHang.EditValue.ToString();
chung_tu.Dia_Chi = txtDiaChi.Text;
chung_tu.Ly_Do = txtLyDo.Text;
chung_tu.VAT_Phan_Tram = txtVATPhanTram.Value;
chung_tu.VAT_Thanh_Tien = txtVATThanhTien.Value;
chung_tu.Chiet_Khau_Phan_Tram = txtChietKhauPhanTram.Value;
chung_tu.Chiet_Khau_Thanh_Tien = txtChietKhauThanhTien.Value;
chung_tu.Thanh_Tien = txtThanhTien.Value;
chung_tu.Hinh_Thuc_Cong_No = Convert.ToInt32(txtHinhThucCongNo.EditValue);
chung_tu.Hinh_Thuc_Thu_Chi = Convert.ToInt32(txtHinhThucThuChi.EditValue);
chung_tu.Thanh_Toan = txtThanhToan.Value;
chung_tu.Ghi_Chu = txtGhiChu.Text;
chung_tu.Nhan_Vien = string.IsNullOrEmpty(txtNhanVien.Text) ? "" : txtNhanVien.EditValue.ToString();
chung_tu.So_Thu_Tu = 0;
}
if (Luu_Chi_Tiet(database) == "OK")
{
database.SubmitChanges();
database.Transaction.Commit();
RaiseReloadEventHander();
Close();
}
else
{
database.Transaction.Rollback();
}
}
catch (Exception ex)
{
database.Transaction.Rollback();
MessageBox.Show(ex.ToString());
}
}
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
return;
var db = new Data_QLKDataContext(SqlHelper.ConnectionString);
int[] selectedRows = gbList.GetSelectedRows();
string[] chungtu = new string[selectedRows.Length];
for (int i = selectedRows.Length; i > 0; i--)
{
var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa_Chung_Tu);
if (arg == null)
continue;
chungtu[i - 1] = arg.ToString();
}
var ct = from c in db.CHUNG_TUs
where chungtu.Contains(c.Ma_Chung_Tu)
select c;
foreach (var c in ct)
{
db.CHUNG_TUs.DeleteOnSubmit(c);
}
try
{
db.SubmitChanges();
bbiXem_ItemClick(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
