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