private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!Check()) { return; } if (tinh_trang == "them") { KHO_HANG kho = new KHO_HANG(); 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; kho.CreatedDate = DateTime.Now; kho.IsDeleted = false; db.KHO_HANGs.InsertOnSubmit(kho); db.SubmitChanges(); RaiseSendDataEventHander(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; kho.ModifiedDate = DateTime.Now; db.SubmitChanges(); RaiseSendDataEventHander(kho); } RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!Check()) { return; } if (tinh_trang == "them") { HANG_HOA hh = new HANG_HOA(); hh.Ma_Hang = txtMaHangHoa.Text; hh.Ten_Hang = txtTenHangHoa.Text; hh.Nhom_Hang_Id = string.IsNullOrEmpty(txtNhomHang.Text) ? 0 : Convert.ToInt64(txtNhomHang.EditValue); hh.Don_Vi = txtDonVi.Text; hh.Ghi_Chu = txtGhiChu.Text; hh.IsDeleted = false; hh.CreatedDate = DateTime.Now; db.HANG_HOAs.InsertOnSubmit(hh); db.SubmitChanges(); RaiseSendDataEventHander(hh); } else { var hh = (from h in db.HANG_HOAs where h.Id == this.Id select h).FirstOrDefault(); hh.Ma_Hang = txtMaHangHoa.Text; hh.Ten_Hang = txtTenHangHoa.Text; hh.Nhom_Hang_Id = string.IsNullOrEmpty(txtNhomHang.Text) ? 0 : Convert.ToInt64(txtNhomHang.EditValue); hh.Don_Vi = txtDonVi.Text; hh.Ghi_Chu = txtGhiChu.Text; hh.ModifiedDate = DateTime.Now; db.SubmitChanges(); RaiseSendDataEventHander(hh); } RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void CalculateWareHouse(Data_QLKDataContext db, decimal quantity, long productId, string batch, string serialNo, long warehouseId, int type) //1: nhap, 2 xuat { try { if (quantity != 0 && productId != 0) { if (warehouseId != 0) { var tonkho = (from tk in db.TON_KHOs where tk.Vat_Tu_Id == productId && tk.Kho_Id == warehouseId && tk.Lo_Vat_Tu == batch && tk.Serial_No == serialNo && !tk.IsDeleted.Value select tk).FirstOrDefault(); if (tonkho != null) { if (type == 1) { tonkho.So_Luong += quantity; } else { tonkho.So_Luong -= quantity; } tonkho.ModifiedDate = DateTime.Now; } else { var item = new TON_KHO(); item.CreatedDate = DateTime.Now; item.IsDeleted = false; item.Kho_Id = warehouseId; item.Lo_Vat_Tu = batch; item.Serial_No = serialNo; if (type == 1) { item.So_Luong = quantity; } else { item.So_Luong = (quantity * -1); } item.Vat_Tu_Id = productId; db.TON_KHOs.InsertOnSubmit(item); } db.SubmitChanges(); } } } catch (Exception ex) { throw ex; } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!Kiem_Tra()) { return; } try { if (tinh_trang == "them") { THU_CHI thuchi = new THU_CHI(); thuchi.Ma_Chung_Tu = txtMaChungTu.Text; thuchi.Ngay = txtNgay.DateTime; thuchi.Ma_Khach_Hang = string.IsNullOrEmpty(txtKhachHang.Text) ? "" : txtKhachHang.EditValue.ToString(); thuchi.Ten_Khach_Hang = txtKhachHang.Text; thuchi.Dia_Chi = txtDiaChi.Text; thuchi.So_Tien = txtSoTien.Value; thuchi.Ly_Do = txtLyDo.Text; thuchi.Chung_Tu_Ban_Hang = txtChungTuBanHang.Text; thuchi.Loai_Chung_Tu = Convert.ToInt32(txtLoaiChungTu.EditValue); thuchi.Hinh_Thuc_Cong_No = Convert.ToInt32(txtHinhThucCongNo.EditValue); thuchi.Ghi_Chu = txtGhiChu.Text; db.THU_CHIs.InsertOnSubmit(thuchi); } else { var thuchi = (from tc in db.THU_CHIs where tc.Ma_Chung_Tu == txtMaChungTu.Text select tc).FirstOrDefault(); thuchi.Ma_Chung_Tu = txtMaChungTu.Text; thuchi.Ngay = txtNgay.DateTime; thuchi.Ma_Khach_Hang = string.IsNullOrEmpty(txtKhachHang.Text) ? "" : txtKhachHang.EditValue.ToString(); thuchi.Ten_Khach_Hang = txtKhachHang.Text; thuchi.Dia_Chi = txtDiaChi.Text; thuchi.So_Tien = txtSoTien.Value; thuchi.Ly_Do = txtLyDo.Text; thuchi.Chung_Tu_Ban_Hang = txtChungTuBanHang.Text; thuchi.Loai_Chung_Tu = Convert.ToInt32(txtLoaiChungTu.EditValue); thuchi.Hinh_Thuc_Cong_No = Convert.ToInt32(txtHinhThucCongNo.EditValue); thuchi.Ghi_Chu = txtGhiChu.Text; } db.SubmitChanges(); RaiseReloadEventHander(); Close(); } catch (Exception ex) { 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); var ma = gbList.GetFocusedRowCellValue(colMa_Chung_Tu); if (ma == null) { return; } int[] selectedRows = gbList.GetSelectedRows(); string[] thuchi = 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; } thuchi[i - 1] = arg.ToString(); } var tc = from tc_ in db.THU_CHIs //where k.Ma_Khu_Vuc == ma.ToString() where thuchi.Contains(tc_.Ma_Chung_Tu) select tc_; foreach (var t in tc) { db.THU_CHIs.DeleteOnSubmit(t); } try { db.SubmitChanges(); bbiXem_ItemClick(this, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { 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(colId); if (ma == null) { return; } int[] selectedRows = gbList.GetSelectedRows(); long[] khuvuc = new long[selectedRows.Length]; for (int i = selectedRows.Length; i > 0; i--) { var arg = gbList.GetRowCellValue(selectedRows[i - 1], colId); if (arg == null) { continue; } khuvuc[i - 1] = Convert.ToInt64(arg); } var kv = from k in db.KHU_VUCs where khuvuc.Contains(k.Id) select k; foreach (var k in kv) { k.IsDeleted = true; k.DeletedDate = DateTime.Now; //db.KHU_VUCs.DeleteOnSubmit(k); } db.SubmitChanges(); bbiXem_ItemClick(this, null); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { 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(); long[] nhomhang = new long[selectedRows.Length]; for (int i = selectedRows.Length; i > 0; i--) { var arg = gbList.GetRowCellValue(selectedRows[i - 1], colId); if (arg == null) { continue; } nhomhang[i - 1] = Convert.ToInt64(arg); } var nh = from n in db.NHOM_HANGs where nhomhang.Contains(n.Id) select n; foreach (var n in nh) { n.IsDeleted = true; n.DeletedDate = DateTime.Now; //db.NHOM_HANGs.DeleteOnSubmit(n); } db.SubmitChanges(); bbiXem_ItemClick(this, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!Check()) { return; } try { if (tinh_trang == "them") { KHU_VUC kv = new KHU_VUC(); kv.Ma_Khu_Vuc = txtMaKhuVuc.Text; kv.Ten_Khu_Vuc = txtTenKhuVuc.Text; kv.Ghi_Chu = txtGhiChu.Text; kv.IsDeleted = false; kv.CreatedDate = DateTime.Now; db.KHU_VUCs.InsertOnSubmit(kv); } else { var kv = (from k in db.KHU_VUCs where k.Id == Id select k).FirstOrDefault(); kv.Ma_Khu_Vuc = txtMaKhuVuc.Text; kv.Ten_Khu_Vuc = txtTenKhuVuc.Text; kv.Ghi_Chu = txtGhiChu.Text; kv.ModifiedDate = DateTime.Now; } db.SubmitChanges(); RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!Check()) { return; } if (tinh_trang == "them") { NHOM_HANG nh = new NHOM_HANG(); nh.Ma_Nhom_Hang = txtMaNhomHang.Text; nh.Ten_Nhom_Hang = txtTenNhomHang.Text; nh.Ghi_Chu = txtGhiChu.Text; nh.IsDeleted = false; nh.CreatedDate = DateTime.Now; db.NHOM_HANGs.InsertOnSubmit(nh); } else { var nh = (from n in db.NHOM_HANGs where n.Ma_Nhom_Hang == txtMaNhomHang.Text select n).FirstOrDefault(); nh.Ma_Nhom_Hang = txtMaNhomHang.Text; nh.Ten_Nhom_Hang = txtTenNhomHang.Text; nh.Ghi_Chu = txtGhiChu.Text; nh.ModifiedDate = DateTime.Now; } db.SubmitChanges(); RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (XtraMessageBox.Show(this, "Có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } var db = new Data_QLKDataContext(SqlHelper.ConnectionString); int[] selectedRows = gbList.GetSelectedRows(); long[] chungtu = new long[selectedRows.Length]; for (int i = selectedRows.Length; i > 0; i--) { var arg = gbList.GetRowCellValue(selectedRows[i - 1], colId); if (arg == null) { continue; } chungtu[i - 1] = Convert.ToInt64(arg); } var ct = from c in db.CHUNG_TUs where chungtu.Contains(c.Id) select c; foreach (var c in ct) { c.IsDeleted = true; c.DeletedDate = DateTime.Now; } try { db.SubmitChanges(); bbiXem_ItemClick(this, null); } catch (Exception ex) { XtraMessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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[] cuahang = new string[selectedRows.Length]; for (int i = selectedRows.Length; i > 0; i--) { var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa_Cua_Hang); if (arg == null) { continue; } cuahang[i - 1] = arg.ToString(); } var chs = from ch in db.CUA_HANGs where cuahang.Contains(ch.Ma_Cua_Hang) select ch; foreach (var c in chs) { db.CUA_HANGs.DeleteOnSubmit(c); } try { db.SubmitChanges(); bbiXem_ItemClick(this, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!Check()) { return; } if (tinh_trang == "them") { NHAN_VIEN nhanvien = new NHAN_VIEN(); nhanvien.Ma_Nhan_Vien = txtMaNhanVien.Text; nhanvien.Ho_Ten = txtHoTen.Text; nhanvien.Dia_Chi = txtDiaChi.Text; nhanvien.Nam_Sinh = txtNamSinh.Text; nhanvien.Dien_Thoai = txtDienThoai.Text; nhanvien.Ngay_Vao_Lam = txtNgayVaoLam.Text; nhanvien.Chuc_Vu = txtChucVu.Text; nhanvien.Bo_Phan = txtBoPhan.Text; nhanvien.Ghi_Chu = txtGhiChu.Text; nhanvien.IsDeleted = false; nhanvien.CreatedDate = DateTime.Now; db.NHAN_VIENs.InsertOnSubmit(nhanvien); db.SubmitChanges(); RaiseSendDataEventHander(nhanvien); } else { var nhanvien = (from nv in db.NHAN_VIENs where nv.Id == this.Id select nv).FirstOrDefault(); nhanvien.Ma_Nhan_Vien = txtMaNhanVien.Text; nhanvien.Ho_Ten = txtHoTen.Text; nhanvien.Dia_Chi = txtDiaChi.Text; nhanvien.Nam_Sinh = txtNamSinh.Text; nhanvien.Dien_Thoai = txtDienThoai.Text; nhanvien.Ngay_Vao_Lam = txtNgayVaoLam.Text; nhanvien.Chuc_Vu = txtChucVu.Text; nhanvien.Bo_Phan = txtBoPhan.Text; nhanvien.Ghi_Chu = txtGhiChu.Text; nhanvien.ModifiedDate = DateTime.Now; db.SubmitChanges(); RaiseSendDataEventHander(nhanvien); } RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!Check()) { return; } if (tinh_trang == "them") { KHACH_HANG kh = new KHACH_HANG(); kh.Ma_Khach_Hang = txtMaKhachHang.Text; kh.Ten_Khach_Hang = txtTenKhachHang.Text; kh.Khu_Vuc_Id = string.IsNullOrEmpty(txtKhuVuc.Text) ? 0 : Convert.ToInt64(txtKhuVuc.EditValue); kh.Dia_Chi = txtDiaChi.Text; kh.Ma_So_Thue = txtMaSoThue.Text; kh.Dien_Thoai = txtDienThoai.Text; kh.Fax = txtFax.Text; kh.Email = txtEmail.Text; kh.Di_Dong = txtDiDong.Text; kh.Website = txtWebsite.Text; kh.Nguoi_Lien_He = txtNguoiLienHe.Text; kh.Tai_Khoan_Ngan_Hang = txtTaiKhoanNganHang.Text; kh.Ten_Ngan_Hang = txtTenNganHang.Text; kh.Ghi_Chu = txtGhiChu.Text; kh.IsDeleted = false; kh.CreatedDate = DateTime.Now; db.KHACH_HANGs.InsertOnSubmit(kh); db.SubmitChanges(); RaiseSendDataEventHander(kh); } else { var kh = (from k in db.KHACH_HANGs where k.Id == this.Id select k).FirstOrDefault(); kh.Ma_Khach_Hang = txtMaKhachHang.Text; kh.Ten_Khach_Hang = txtTenKhachHang.Text; kh.Khu_Vuc_Id = string.IsNullOrEmpty(txtKhuVuc.Text) ? 0 : Convert.ToInt64(txtKhuVuc.EditValue); kh.Dia_Chi = txtDiaChi.Text; kh.Ma_So_Thue = txtMaSoThue.Text; kh.Dien_Thoai = txtDienThoai.Text; kh.Fax = txtFax.Text; kh.Email = txtEmail.Text; kh.Di_Dong = txtDiDong.Text; kh.Website = txtWebsite.Text; kh.Nguoi_Lien_He = txtNguoiLienHe.Text; kh.Tai_Khoan_Ngan_Hang = txtTaiKhoanNganHang.Text; kh.Ten_Ngan_Hang = txtTenNganHang.Text; kh.Ghi_Chu = txtGhiChu.Text; kh.ModifiedDate = DateTime.Now; db.SubmitChanges(); RaiseSendDataEventHander(kh); } RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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; long chungTuId = 0; if (tinh_trang == "them") { CHUNG_TU chung_tu = new CHUNG_TU(); chung_tu.Ma_Chung_Tu = txtMaChungTu.Text; chung_tu.Ngay = txtNgay.DateTime; chung_tu.Loai_Chung_Tu = this.loai; //1 la nhap kho 2 la xuat kho chung_tu.Ly_Do = txtLyDo.Text; chung_tu.Ghi_Chu = txtGhiChu.Text; chung_tu.CreateDate = DateTime.Now; chung_tu.IsDeleted = false; if (loai == 1) { chung_tu.Dau_Ky = cbNhapDauKy.Checked; } database.CHUNG_TUs.InsertOnSubmit(chung_tu); database.SubmitChanges(); chungTuId = chung_tu.Id; } else { var chung_tu = (from ct in database.CHUNG_TUs where ct.Id == this.id select ct).FirstOrDefault(); chung_tu.Ma_Chung_Tu = txtMaChungTu.Text; chung_tu.Ngay = txtNgay.DateTime; chung_tu.Loai_Chung_Tu = this.loai; //1 la nhap kho 2 la xuat kho chung_tu.Ly_Do = txtLyDo.Text; chung_tu.Ghi_Chu = txtGhiChu.Text; chung_tu.ModifiedDate = DateTime.Now; if (loai == 1) { chung_tu.Dau_Ky = cbNhapDauKy.Checked; } chungTuId = chung_tu.Id; } if (Luu_Chi_Tiet(database, chungTuId) == "OK") { database.SubmitChanges(); database.Transaction.Commit(); RaiseReloadEventHander(); Close(); } else { database.Transaction.Rollback(); } } catch (Exception ex) { database.Transaction.Rollback(); XtraMessageBox.Show(this, JsonConvert.SerializeObject(ex), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
string Luu_Chi_Tiet(Data_QLKDataContext database, long chungTuId) { var result = "OK"; var dt = dsNhapVatTu.CHUNG_TU_CHI_TIET; long id = 0; var row = 0; CalulateInventory calulateInventory = new CalulateInventory(); long vatTuId = 0; long khoNhap = 0; long khoXuat = 0; decimal soLuong = 0; string loVatTu = ""; string serialNo = ""; decimal orgSoLuong = 0; for (var i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].RowState != DataRowState.Deleted) { row++; if (dt.Rows[i]["Hang_Hoa_Id"] == DBNull.Value || Convert.ToInt64(dt.Rows[i]["Hang_Hoa_Id"]) == 0) { MessageBox.Show(this, String.Format("Dòng {0}: Vui lòng chọn mặt hàng.", row.ToString()), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); 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]["Kho_Hang_Id"] == DBNull.Value || Convert.ToInt64(dt.Rows[i]["Kho_Hang_Id"]) == 0) { MessageBox.Show(this, String.Format("Dòng {0}: Vui lòng chọn kho hàng.", row.ToString()), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); 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 = Convert.ToInt64(dt.Rows[i]["Id"]); } var dr = dt.Rows[i]; switch (dr.RowState) { case DataRowState.Added: var chi_tiet_them = new CHUNG_TU_CHI_TIET(); chi_tiet_them.Chung_Tu_Id = chungTuId; chi_tiet_them.Hang_Hoa_Id = Convert.ToInt64(dt.Rows[i]["Hang_Hoa_Id"]); chi_tiet_them.Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(); chi_tiet_them.Ten_Hang_Hoa = dt.Rows[i]["Ten_Hang_Hoa"].ToString(); chi_tiet_them.Loai_Chung_Tu = this.loai; //1 nhap kho 2 xuat kho chi_tiet_them.Tinh_Trang = true; //true nhap kho false xuat kho chi_tiet_them.Kho_Hang_Id = Convert.ToInt64(dt.Rows[i]["Kho_Hang_Id"]); chi_tiet_them.Ma_Kho_Hang = dt.Rows[i]["Ma_Kho_Hang"].ToString(); chi_tiet_them.So_Luong = Convert.ToDecimal(dt.Rows[i]["So_Luong"]); chi_tiet_them.Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString(); chi_tiet_them.Serial_No = dt.Rows[i]["Serial_No"].ToString(); chi_tiet_them.Lo_Vat_Tu = dt.Rows[i]["Lo_Vat_Tu"].ToString(); chi_tiet_them.Don_Vi = dt.Rows[i]["Don_Vi"].ToString(); chi_tiet_them.Nhan_Vien_Id = Convert.ToInt64(dt.Rows[i]["Nhan_Vien_Id"] == DBNull.Value ? 0 : dt.Rows[i]["Nhan_Vien_Id"]); chi_tiet_them.Khach_Hang_Id = Convert.ToInt64(dt.Rows[i]["Khach_Hang_Id"] == DBNull.Value ? 0 : dt.Rows[i]["Khach_Hang_Id"]); chi_tiet_them.So_Thu_Tu = i; chi_tiet_them.CreatedDate = DateTime.Now; database.CHUNG_TU_CHI_TIETs.InsertOnSubmit(chi_tiet_them); if (this.loai == 1) { khoNhap = chi_tiet_them.Kho_Hang_Id.Value; } else { khoXuat = chi_tiet_them.Kho_Hang_Id.Value; } vatTuId = chi_tiet_them.Hang_Hoa_Id.Value; soLuong = chi_tiet_them.So_Luong.Value; loVatTu = chi_tiet_them.Lo_Vat_Tu; serialNo = chi_tiet_them.Serial_No; break; case DataRowState.Modified: var chi_tiet_sua = (from ctct in database.CHUNG_TU_CHI_TIETs where ctct.Id == id select ctct).FirstOrDefault(); chi_tiet_sua.Chung_Tu_Id = chungTuId; chi_tiet_sua.Hang_Hoa_Id = Convert.ToInt64(dt.Rows[i]["Hang_Hoa_Id"]); chi_tiet_sua.Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(); chi_tiet_sua.Ten_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(); chi_tiet_sua.Loai_Chung_Tu = this.loai; //1 nhap kho 2 xuat kho chi_tiet_sua.Tinh_Trang = true; //true nhap kho false xuat kho chi_tiet_sua.Kho_Hang_Id = Convert.ToInt64(dt.Rows[i]["Kho_Hang_Id"]); 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.Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString(); chi_tiet_sua.Serial_No = dt.Rows[i]["Serial_No"].ToString(); chi_tiet_sua.Lo_Vat_Tu = dt.Rows[i]["Lo_Vat_Tu"].ToString(); chi_tiet_sua.Don_Vi = dt.Rows[i]["Don_Vi"].ToString(); chi_tiet_sua.Nhan_Vien_Id = Convert.ToInt64(dt.Rows[i]["Nhan_Vien_Id"] == DBNull.Value ? 0 : dt.Rows[i]["Nhan_Vien_Id"]); chi_tiet_sua.Khach_Hang_Id = Convert.ToInt64(dt.Rows[i]["Khach_Hang_Id"] == DBNull.Value ? 0 : dt.Rows[i]["Khach_Hang_Id"]); chi_tiet_sua.So_Thu_Tu = i; chi_tiet_sua.ModifiedDate = DateTime.Now; orgSoLuong = Convert.ToDecimal(dt.Rows[i]["So_Luong", DataRowVersion.Original]); if (this.loai == 1) { khoNhap = chi_tiet_sua.Kho_Hang_Id.Value; } else { khoXuat = chi_tiet_sua.Kho_Hang_Id.Value; } vatTuId = chi_tiet_sua.Hang_Hoa_Id.Value; soLuong = chi_tiet_sua.So_Luong.Value - orgSoLuong; loVatTu = chi_tiet_sua.Lo_Vat_Tu; serialNo = chi_tiet_sua.Serial_No; break; case DataRowState.Deleted: var idDetail = Convert.ToInt64(dt.Rows[i]["Id", DataRowVersion.Original]); //dt.Rows[i]["Ma_Chi_Tiet", DataRowVersion.Original]; var chi_tiet_xoa = (from ctct in database.CHUNG_TU_CHI_TIETs where ctct.Id == idDetail select ctct).FirstOrDefault(); chi_tiet_xoa.IsDeleted = true; chi_tiet_xoa.DeletetedDate = DateTime.Now; orgSoLuong = Convert.ToDecimal(dt.Rows[i]["So_Luong", DataRowVersion.Original]); if (this.loai == 1) { khoNhap = chi_tiet_xoa.Kho_Hang_Id.Value; } else { khoXuat = chi_tiet_xoa.Kho_Hang_Id.Value; } vatTuId = chi_tiet_xoa.Hang_Hoa_Id.Value; soLuong = chi_tiet_xoa.So_Luong.Value - orgSoLuong; loVatTu = chi_tiet_xoa.Lo_Vat_Tu; serialNo = chi_tiet_xoa.Serial_No; //database.CHUNG_TU_CHI_TIETs.DeleteOnSubmit(chi_tiet_xoa); break; } database.SubmitChanges(); calulateInventory.ProcessCalculate(database, soLuong, vatTuId, loVatTu, serialNo, khoNhap, khoXuat); } return(result); }
string Luu_Chi_Tiet(Data_QLKDataContext database, long chungTuId) { var result = "OK"; var dt = dsXuatKho.CHUNG_TU_CHI_TIET; long id = 0; 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 = Convert.ToInt64(dt.Rows[i]["Ma_Chi_Tiet"]); } var dr = dt.Rows[i]; switch (dr.RowState) { case DataRowState.Added: var chung_tu_chi_tiet = new CHUNG_TU_CHI_TIET { Chung_Tu_Id = chungTuId, Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(), Loai_Chung_Tu = 2, //1 nhap kho 2 xuat kho Tinh_Trang = false, //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.Id == id select ctct).FirstOrDefault(); //chi_tiet_sua.Ma_Chi_Tiet = new Guid(id); chi_tiet_sua.Chung_Tu_Id = chungTuId; chi_tiet_sua.Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(); chi_tiet_sua.Loai_Chung_Tu = 2; //1 nhap kho 2 xuat kho chi_tiet_sua.Tinh_Trang = false; //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.Id == 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 = 2, //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, Nhan_Vien = string.IsNullOrEmpty(txtNhanVien.Text) ? "" : txtNhanVien.EditValue.ToString(), So_Thu_Tu = 0 }; 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 = 2; //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, 0) == "OK") { database.SubmitChanges(); database.Transaction.Commit(); RaiseReloadEventHander(); Close(); } else { database.Transaction.Rollback(); } } catch (Exception ex) { database.Transaction.Rollback(); MessageBox.Show(ex.ToString()); } }
private void btnLuu_Click(object sender, EventArgs e) { if (!Check()) { return; } try { if (tinh_trang == "them") { CUA_HANG cuahang = new CUA_HANG(); cuahang.Ma_Cua_Hang = txtMaCuaHang.Text; cuahang.Ten_Cua_Hang = txtTenCuaHang.Text; cuahang.Dia_Chi = txtDiaChi.Text; cuahang.Ma_So_Thue = txtMaSoThue.Text; cuahang.Dien_Thoai = txtDienThoai.Text; cuahang.Email = txtEmail.Text; cuahang.Fax = txtFax.Text; cuahang.Di_Dong = txtDiDong.Text; cuahang.Quan_Ly = txtQuanLy.Text; cuahang.Ghi_Chu = txtGhiChu.Text; if (picAnh.Image != null) { Image anh = picAnh.Image; MemoryStream ms = new MemoryStream(); anh.Save(ms, anh.RawFormat); byte[] anh_Bytes = ms.GetBuffer(); ms.Close(); cuahang.Anh = anh_Bytes; } db.CUA_HANGs.InsertOnSubmit(cuahang); } else { var cuahang = (from ch in db.CUA_HANGs where ch.Ma_Cua_Hang == txtMaCuaHang.Text select ch).FirstOrDefault(); cuahang.Ma_Cua_Hang = txtMaCuaHang.Text; cuahang.Ten_Cua_Hang = txtTenCuaHang.Text; cuahang.Dia_Chi = txtDiaChi.Text; cuahang.Ma_So_Thue = txtMaSoThue.Text; cuahang.Dien_Thoai = txtDienThoai.Text; cuahang.Email = txtEmail.Text; cuahang.Fax = txtFax.Text; cuahang.Di_Dong = txtDiDong.Text; cuahang.Quan_Ly = txtQuanLy.Text; cuahang.Ghi_Chu = txtGhiChu.Text; if (picAnh.Image != null) { Image anh = picAnh.Image; MemoryStream ms = new MemoryStream(); anh.Save(ms, anh.RawFormat); byte[] anh_Bytes = ms.GetBuffer(); ms.Close(); cuahang.Anh = anh_Bytes; } else { cuahang.Anh = null; } } db.SubmitChanges(); RaiseReloadEventHander(); Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }