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