private void FormSuaChiTietMua_Load(object sender, EventArgs e)
{
cbbKieuSP.DataSource = ct.LayKieuSP();
cbbKieuSP.DisplayMember = "TenKieuSP";
cbbKieuSP.ValueMember = "MaKieuSP";
cbbLoaiSP.DataSource = ct.LayLoaiSP();
cbbLoaiSP.DisplayMember = "TenLoaiSP";
cbbLoaiSP.ValueMember = "MaLoaiSP";
CTPhieuMua_DTO a = new CTPhieuMua_DTO();
a = ct.Lay1ChiTiet(Sopm, STT);
txtDonGiaMua.Text = a.DonGia.ToString();
txtSoLuong.Text = a.SoLuong.ToString();
//txtTongTien.Text = a.ThanhTien.ToString();
SanPham_DTO b = ct.Lay1SP(a.MaSP);
cbbKieuSP.SelectedValue = b.MaKieuSP;
cbbLoaiSP.SelectedValue = b.MaLoaiSP;
}
public List <CTPhieuMua_DTO> Search(CTPhieuMua_DTO a, int kieusp, int loaisp)
{
var pmh = DB.CTPhieuMuaSearch(a.SoPhieuMua, a.STT, a.SoLuong, a.DonGia, a.ThanhTien, kieusp, loaisp);
var MyQuery = (from mh in pmh
select new CTPhieuMua_DTO
{
SoPhieuMua = mh.SoPhieuMua,
STT = mh.STT,
SoLuong = mh.SoLuong ?? default(int),
DonGia = mh.DonGia ?? default(int),
ThanhTien = mh.ThanhTien ?? default(decimal),
MaSP = mh.MaSP ?? default(int),
TenKieuSP = mh.TenKieuSP,
TenLoaiSP = mh.TenLoaiSP,
MaKieuSP = mh.MaKieuSP ?? default(int),
MaLoaiSP = mh.MaLoaiSP ?? default(int)
});
return(MyQuery.ToList());
}
public void CapNhapCTPhieuMH(CTPhieuMua_DTO a)
{
decimal tamp;
int tam;
var b = DB.CTPHIEUMUAs.Single(x => x.SoPhieuMua == a.SoPhieuMua && x.STT == a.STT);
b.MaSP = a.MaSP;
b.DonGia = a.DonGia;
tam = (a.SoLuong - b.SoLuong) ?? default(int);
b.SoLuong = a.SoLuong;
tamp = a.ThanhTien - b.ThanhTien ?? default(decimal);
b.ThanhTien = a.ThanhTien;
DB.SubmitChanges();
var obj = DB.PHIEUMUAHANGs.Single(x => x.SoPhieuMua == a.SoPhieuMua);
//obj.TongTien = a.TongTien;
obj.TongTien += tamp;
var c = DB.SANPHAMs.Single(x => x.MaSP == a.MaSP);
c.SoLuongTon += tam;
DB.SubmitChanges();
}
public void ThemChiTietMua(CTPhieuMua_DTO a)
{
DB = new VBDQDataContext();
CTPHIEUMUA b = new CTPHIEUMUA();
b.SoPhieuMua = a.SoPhieuMua;
b.STT = this.LayKhoaMoi(b.SoPhieuMua) + 1;
b.MaSP = a.MaSP;
b.DonGia = a.DonGia;
b.SoLuong = a.SoLuong;
b.ThanhTien = a.ThanhTien;
DB.CTPHIEUMUAs.InsertOnSubmit(b);
DB.SubmitChanges();
var obj = DB.PHIEUMUAHANGs.Single(x => x.SoPhieuMua == a.SoPhieuMua);
//obj.TongTien = a.TongTien;
obj.TongTien += b.ThanhTien;
var c = DB.SANPHAMs.Single(x => x.MaSP == a.MaSP);
c.SoLuongTon += a.SoLuong;
DB.SubmitChanges();
}
private void btnThem_Click(object sender, EventArgs e)
{
int kieusp = Int16.Parse(cbbKieuSP.SelectedValue.ToString());
int loaisp = Int16.Parse(cbbLoaiSP.SelectedValue.ToString());
int sopm = Int16.Parse(cbbSoPhieuMua.Text);
if (txtDonGiaMua.Text == "" || txtSoLuong.Text == "")
{
MessageBox.Show("Bạn còn dữ liệu chưa nhập");
return;
}
int masp = 0;
if (ct.KiemTraSP(kieusp, loaisp) == -1)
{
DialogResult dr = MessageBox.Show("Sản phẩm này chưa được lưu trong cơ sở dữ liệu, bạn có muốn thêm sản phẩm mới không?", "Cảnh Báo", MessageBoxButtons.OKCancel);
if (dr == DialogResult.OK)
{
FormThemSP them = new FormThemSP();
them.ShowDialog();
if (them.DialogResult == DialogResult.Cancel)
{
cbbKieuSP.DataSource = ct.LayKieuSP();
cbbKieuSP.DisplayMember = "TenKieuSP";
cbbKieuSP.ValueMember = "MaKieuSP";
cbbLoaiSP.DataSource = ct.LayLoaiSP();
cbbLoaiSP.DisplayMember = "TenLoaiSP";
cbbLoaiSP.ValueMember = "MaLoaiSP";
}
if (ct.KiemTraSP(kieusp, loaisp) == -1)
{
return;
}
masp = ct.KiemTraSP(kieusp, loaisp);
}
else
{
return;
}
}
else
{
masp = ct.KiemTraSP(kieusp, loaisp);
}
CTPhieuMua_DTO ctpm = new CTPhieuMua_DTO();
ctpm.SoPhieuMua = sopm;
ctpm.MaSP = masp;
ctpm.SoLuong = Int16.Parse(txtSoLuong.Text);
ctpm.DonGia = Int16.Parse(txtDonGiaMua.Text);
ctpm.ThanhTien = ctpm.DonGia * ctpm.SoLuong;
if (ctpm.SoLuong == 0)
{
MessageBox.Show("Số lượng phải lớn hơn 0");
return;
}
if (ctpm.DonGia == 0)
{
MessageBox.Show("Đơn giá phải lớn hơn 0");
return;
}
ct.ThemChiTietMua(ctpm);
MessageBox.Show("Thêm thành công");
RefToMom.load();
}
private void btnSearch_Click(object sender, EventArgs e)
{
CTPhieuMua_DTO a = new CTPhieuMua_DTO();
//a.SoPhieuMua = Int16.Parse(cbbSoPhieuMua.SelectedValue.ToString());
int kieusp = -1;
int loaisp = -1;
a.STT = -1;
if (txtSoPhieuMua.Text == "")
{
a.SoPhieuMua = -1;
}
else
{
a.SoPhieuMua = Int16.Parse(txtSoPhieuMua.Text);
}
if (txtSoLuong.Text == "")
{
a.SoLuong = -1;
}
else
{
a.SoLuong = Int16.Parse(txtSoLuong.Text);
}
if (txtCtTongTien.Text == "")
{
a.ThanhTien = -1;
}
else
{
a.ThanhTien = Int16.Parse(txtCtTongTien.Text);
}
if (txtDonGiaMua.Text == "")
{
a.DonGia = -1;
}
else
{
a.DonGia = Int16.Parse(txtDonGiaMua.Text);
}
if (cbbKieuSP.Text != "")
{
kieusp = Int16.Parse(cbbKieuSP.SelectedValue.ToString());
}
if (cbbLoaiSP.Text != "")
{
loaisp = Int16.Parse(cbbLoaiSP.SelectedValue.ToString());
}
dataGridView1.DataSource = ct.Search(a, kieusp, loaisp);
dataGridView1.Columns["MaSP"].Visible = false;
dataGridView1.Columns["MaKieuSP"].Visible = false;
dataGridView1.Columns["MaLoaiSP"].Visible = false;
dataGridView1.Columns["SoLuong"].HeaderText = "Số lượng";
dataGridView1.Columns["DonGia"].HeaderText = "Đơn giá";
dataGridView1.Columns["ThanhTien"].HeaderText = "Thành Tiền";
dataGridView1.Columns["TenKieuSP"].HeaderText = "Kiểu sản phẩm";
dataGridView1.Columns["TenLoaiSP"].HeaderText = "Loại sản phẩm";
dataGridView1.Columns["TenKieuSP"].DisplayIndex = 2;
dataGridView1.Columns["TenLoaiSP"].DisplayIndex = 3;
dataGridView1.Columns["SoPhieuMua"].Visible = false;
}
