public int Insertphieuxuathang(Phieuxuathang phieuxuathang)
{
string sql = string.Format("Insert into Phieuxuathang(Madonhang,Makh,Makho,Manv,Ngaylap,Tongtien) Values('{0}','{1}','{2}','{3}','{4}','{5}')", phieuxuathang.Madonhang, phieuxuathang.Makh, phieuxuathang.Makho, phieuxuathang.Manv, phieuxuathang.Ngaylap, phieuxuathang.Tongtien);
var rs = db.thesuadulieu(sql);
return(rs);
}
public Phieuxuathang layinfoPXH(string Value)
{
Phieuxuathang phieuxuathang = new Phieuxuathang();
for (int i = 0; i < phieuxuathangs.Count; i++)
{
if (phieuxuathangs[i].Madonhang == Value)
{
phieuxuathang = phieuxuathangs[i];
break;
}
}
return(phieuxuathang);
}
private void GridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "Maphieuxuathang")
{
var Value = gridView1.GetRowCellValue(e.RowHandle, e.Column);
if (Value.ToString() != "")
{
phieuxuathang = layinfoPXH(Value.ToString());
}
if (phieuxuathang != null)
{
gridView1.SetRowCellValue(e.RowHandle, "Ngaylapphieu", phieuxuathang.Ngaylap);
gridView1.SetRowCellValue(e.RowHandle, "Tongtienphieuthu", phieuxuathang.Tongtien);
if (gridView1.GetFocusedRowCellValue(Tientra) == null)
{
tientra = 0;
}
else
{
tientra = Convert.ToDecimal(gridView1.GetFocusedRowCellValue(Tientra));
if (phieuxuathang.Tongtien < tientra)
{
MessageBox.Show("Số tiền nhập lớn hơn tiền nợ " + phieuxuathang.Tongtien);
}
else
{
tongtien = Convert.ToDecimal(gridView1.GetFocusedRowCellValue(Tongtienphieuthu));
tienno = tongtien - tientra;
gridView1.SetFocusedRowCellValue(Tienno, tienno);
}
}
}
}
if (e.Column == Tientra)
{
tientra = Convert.ToDecimal(gridView1.GetFocusedRowCellValue(Tientra));
if (phieuxuathang.Tongtien < tientra)
{
MessageBox.Show("Số tiền nhập lớn hơn tiền nợ " + phieuxuathang.Tongtien);
}
else
{
tongtien = Convert.ToDecimal(gridView1.GetFocusedRowCellValue(Tongtienphieuthu));
tienno = tongtien - tientra;
gridView1.SetFocusedRowCellValue(Tienno, tienno);
}
}
}
private void Btnthnahtoan_Click_1(object sender, EventArgs e)
{
Phieuxuathang phieuxuathang = new Phieuxuathang();
phieuxuathang.Madonhang = txtmadonhang.Text;
phieuxuathang.Makho = int.Parse(cbbKho.EditValue.ToString());
phieuxuathang.Makh = int.Parse(txtmakh.Text);
phieuxuathang.Manv = int.Parse(cbbnhanvien.EditValue.ToString());
phieuxuathang.Ngaylap = txtngaylap.Text;
phieuxuathang.Tongtien = tongtien();
banhangBUS.Insertphieuxuathang(phieuxuathang);
var id = banhangBUS.IDphieuuxuathang(phieuxuathang.Madonhang);
int soluong;
CTPhieuxuatnhaphang ctPhieuxuathang = new CTPhieuxuatnhaphang();
for (int i = 0; i < lstluoixuathang.Count; i++)
{
ctPhieuxuathang.Maphieuxuathang = int.Parse(id.ToString());
ctPhieuxuathang.Masp = lstluoixuathang[i].Idsp;
ctPhieuxuathang.SoLuong = lstluoixuathang[i].Soluong;
ctPhieuxuathang.Dongiahientai = lstluoixuathang[i].Giahientai;
ctPhieuxuathang.Thanhtien = lstluoixuathang[i].Tongthanhtoan;
banhangBUS.InsertCTphieuxuathang(ctPhieuxuathang);
sanpham = laysanpham(lstluoixuathang[i].Idsp);
soluong = sanpham.SoLuong - lstluoixuathang[i].Soluong;
banhangBUS.UpdateSoluonghang(soluong, lstluoixuathang[i].Idsp);
}
if (checkin.Checked == true)
{
Inphieuthuchi dsnguoidung = new Inphieuthuchi();
dsnguoidung.DataSource = lstluoixuathang;
ReportPrintTool report = new ReportPrintTool(dsnguoidung);
dsnguoidung.txttenkhachang.Text = cbbChonKh.Text;
dsnguoidung.txtkhooxuat.Text = cbbKho.Text;
dsnguoidung.txtmaphieuthu.Text = txtmadonhang.Text;
dsnguoidung.txtngaylap.Text = txtngaylap.Text;
dsnguoidung.txtsodienthoai.Text = txtsodienthoai.Text;
dsnguoidung.txttonggt.Text = tongtien().ToString();
report.ShowPreview();
}
}
public int Insertphieuxuathang(Phieuxuathang phieuxuathang)
{
return(db.Insertphieuxuathang(phieuxuathang));
}
