protected void btnHuyPhieuXuat_Click(object sender, EventArgs e) { data = new dtPhieuXuatTra(); int ID = Int32.Parse(IDPhieuXuatTra_Temp.Value.ToString()); data.XoaPhieuXuatTra_Temp(ID); data.XoaChiTietPhieuXuatTra_Temp(IDPhieuXuatTra_Temp.Value.ToString()); Response.Redirect("DanhSachPhieuXuatTra.aspx"); }
protected void gridDanhSachHangHoa_Temp_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { int ID = Int32.Parse(e.Keys[0].ToString()); data = new dtPhieuXuatTra(); data.XoaChiTietPhieuXuatTra_Temp_ID(ID); e.Cancel = true; gridDanhSachHangHoa_Temp.CancelEdit(); LoadGrid(IDPhieuXuatTra_Temp.Value.ToString()); }
protected void btnThem_Click(object sender, EventArgs e) { if (cmbHangHoa.Text != "" && txtSoLuong.Text != "" && txtDonGia.Text != "") { double SoLuong = double.Parse(txtSoLuong.Value.ToString()); if (SoLuong > 0) { double SLTon = double.Parse(txtTonKho.Text); string IDHangHoa = cmbHangHoa.Value.ToString(); string IDPhieuXuatTra = IDPhieuXuatTra_Temp.Value.ToString(); string GhiChu = txtGhiChuHH.Text == null ? "" : txtGhiChuHH.Text.ToString(); string TonKho = txtTonKho.Text.ToString(); double GiaMua = double.Parse(txtDonGia.Text.ToString()); if (dtSetting.KT_ChuyenAm() == 0) { if (SLTon < SoLuong) { txtSoLuong.Text = SLTon.ToString(); Response.Write("<script language='JavaScript'> alert('Hàng hóa tồn kho không đủ.'); </script>"); } else { DataTable db = data.KTChiTietPhieuXuatTra_Temp(IDHangHoa, IDPhieuXuatTra); if (db.Rows.Count == 0) { data = new dtPhieuXuatTra(); data.ThemChiTietPhieuXuatTra_Temp(IDPhieuXuatTra, IDHangHoa, cmbDonViTinh.Value.ToString(), SoLuong, GhiChu, dtHangHoa.LayMaHang(IDHangHoa), TonKho, GiaMua); Clear(); } else { data = new dtPhieuXuatTra(); data.UpdatePhieuXuatTra_temp(IDPhieuXuatTra, IDHangHoa, SoLuong, GhiChu, GiaMua); Clear(); } LoadGrid(IDPhieuXuatTra); } } else { DataTable db = data.KTChiTietPhieuXuatTra_Temp(IDHangHoa, IDPhieuXuatTra); if (db.Rows.Count == 0) { data = new dtPhieuXuatTra(); data.ThemChiTietPhieuXuatTra_Temp(IDPhieuXuatTra, IDHangHoa, cmbDonViTinh.Value.ToString(), SoLuong, GhiChu, dtHangHoa.LayMaHang(IDHangHoa), TonKho, GiaMua); Clear(); } else { data = new dtPhieuXuatTra(); data.UpdatePhieuXuatTra_temp(IDPhieuXuatTra, IDHangHoa, SoLuong, GhiChu, GiaMua); Clear(); } if (SLTon < SoLuong) { Response.Write("<script language='JavaScript'> alert('Số hàng tồn trong kho hiện tại không đủ.'); </script>"); } LoadGrid(IDPhieuXuatTra); } } else { Response.Write("<script language='JavaScript'> alert('Số Lượng phải > 0.'); </script>"); } } else { Response.Write("<script language='JavaScript'> alert('Bạn chưa chọn hàng hóa.'); </script>"); } }
protected void btnThemPhieuXuat_Click(object sender, EventArgs e) { if (cmbNhaCungCap.Text != "" && txtNgayXuat.Text != "") { string IDPhieuXuatTra = IDPhieuXuatTra_Temp.Value.ToString(); data = new dtPhieuXuatTra(); DataTable db = data.LayDanhSachPhieuXuatTra_Temp(IDPhieuXuatTra); if (db.Rows.Count != 0) { string SoDonXuat = txtSoDonXuat.Text.ToString(); string IDNhaCungCap = cmbNhaCungCap.Value.ToString(); string IDNhanVien = Session["IDNhanVien"].ToString(); string IDKhoLap = Session["IDKho"].ToString(); DateTime NgayLapPhieu = DateTime.Parse(cmbNgayLapPhieu.Text); DateTime NgayXuat = DateTime.Parse(txtNgayXuat.Text); string GhiChu = txtGhiChu.Text == null ? "" : txtGhiChu.Text.ToString(); double TongTien = 0; foreach (DataRow dr in db.Rows) { double ThanhTien = double.Parse(dr["ThanhTien"].ToString()); TongTien = TongTien + ThanhTien; } data = new dtPhieuXuatTra(); object ID = data.ThemPhieuXuatTra_Temp(SoDonXuat, IDNhanVien, NgayLapPhieu, NgayXuat, TongTien.ToString(), GhiChu, IDNhaCungCap); if (ID != null) { dtCongNo dt1 = new dtCongNo(); dt1.CapNhatCongNo(IDNhaCungCap, TongTien);// trừ công nợ NCC foreach (DataRow dr in db.Rows) { string IDHangHoa = dr["IDHangHoa"].ToString(); string SoLuong = dr["SoLuong"].ToString(); string MaHang = dr["MaHang"].ToString(); string DonGia = dr["DonGia"].ToString(); string ThanhTien = dr["ThanhTien"].ToString(); string GhiChuHH = dr["GhiChu"].ToString(); string TonKho = dr["TonKho"].ToString(); string IDDonViTinh = dr["IDDonViTinh"].ToString(); data = new dtPhieuXuatTra(); data.ThemChiTietPhieuXuatTra(ID, IDHangHoa, IDDonViTinh, SoLuong, MaHang, DonGia, GhiChu, TonKho, ThanhTien); if (double.Parse(SoLuong) > 0) { //object TheKho = dtTheKho.ThemTheKho(SoDonXuat, "Phiếu xuất trả ", "0", "", (Int32.Parse(dtCapNhatTonKho.SoLuong_TonKho(IDHangHoa, Session["IDKho"].ToString()).ToString()) - Int32.Parse(SoLuong)).ToString(), Session["IDNhanVien"].ToString(), Session["IDKho"].ToString(), IDHangHoa, "Xuất", "0", SoLuong, "0"); //if (TheKho != null) //{ dtCapNhatTonKho.TruTonKho(IDHangHoa, SoLuong, Session["IDKho"].ToString()); //} } } // dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Phiếu Xuất Trả", Session["IDKho"].ToString(), "Nhập xuất tồn", "Thêm"); data = new dtPhieuXuatTra(); data.XoaChiTietPhieuXuatTra_Temp(IDPhieuXuatTra); Response.Redirect("DanhSachPhieuXuatTra.aspx"); } } else { Response.Write("<script language='JavaScript'> alert('Danh sách hàng hóa rỗng.'); </script>"); } } else { Response.Write("<script language='JavaScript'> alert('Vui lòng chọn Nhà cung cấp.'); </script>"); } }
private void LoadGrid(string IDPhieuXuatTra) { data = new dtPhieuXuatTra(); gridDanhSachHangHoa_Temp.DataSource = data.LayDanhSachPhieuXuatTra_Temp(IDPhieuXuatTra); gridDanhSachHangHoa_Temp.DataBind(); }
private void LoadGrid(string IDPhieuXuatTra) { data = new dtPhieuXuatTra(); gridChiTietPhieuXuatTra.DataSource = data.DanhSachChiTietPhieuXuatTra_ID(IDPhieuXuatTra); gridChiTietPhieuXuatTra.DataBind(); }
private void LoadGrid() { data = new dtPhieuXuatTra(); gridPhieuXuatTra.DataSource = data.DanhSachPhieuXuatTra(); gridPhieuXuatTra.DataBind(); }