private void simpleButton1_Click_1(object sender, EventArgs e)
{
int idDaiLy = dsIdDL[cbDaiLy.SelectedIndex];
DateTime ngayXuat = dtNgayLap.Value;
//Console.WriteLine(ngayXuat.ToString("yyyy-MM-dd"));
float tienCon = (float)Convert.ToDouble(txtTienCon.Text);
float tienNo = BUS_DaiLy.GetTienNo(idDaiLy);
float tienNoMoi = tienCon + tienNo;
int kqUpdate = BUS_DaiLy.UpdateTienNo(idDaiLy, tienNoMoi);
if (kqUpdate == 1)
{
string cmnd = taiKhoan.Cmnd;
DTO_PhieuXuatHang phieuXuatHang = new DTO_PhieuXuatHang(0, ngayXuat, idDaiLy, cmnd);
int idPhieuXuat = BUS_PhieuXuat.ThemPhieuXuatGetId(phieuXuatHang);
foreach (DataRow r in tb.Rows)
{
DTO_ChiTietXuat ctx = new DTO_ChiTietXuat(idPhieuXuat, (int)r[0], (int)r[2], (float)r[4], r[3].ToString(), (float)r[5]);
BUS_ChiTietXuat.ThemChiTietXuat(ctx);
}
}
else
{
}
}
/*
* CapNhatChiTietXuat trả về
* 1:thành công
* 0:thất bại
*/
public static int CapNhatChiTietXuat(DTO_ChiTietXuat ctx)
{
string query = "update ChiTietXuatHang set IdMatHang =" + ctx.IdMatHang + ",SoLuong=" + ctx.SoLuong + ",DonGia=" + ctx.DonGia + " ,DonViTinh=" + ctx.DonViTinh + ",ThanhTien=" + ctx.ThanhTien + " where IdPhieuXuat=" + ctx.IdPhieuXuat;
int result = ResultQuery.GetResultQuery(conn, query);
return(result);
}
public static ArrayList DSPhieuXuat()
{
ArrayList arrList = new ArrayList();
DataTable dt = new DataTable();
dt = ResultQuery.GetTableResult(conn, "SELECT * FROM ChiTietXuatHang ");
int idPhieuXuat;
int idMatHang;
int soLuong;
float donGia;
string donViTinh;
float thanhTien;
foreach (DataRow r in dt.Rows)
{
idPhieuXuat = (int)r["IdPhieuXuat"];
idMatHang = (int)r["IdMatHang"];
soLuong = (int)r["SoLuong"];
donGia = (float)Convert.ToDouble(r["DonGia"]);
donViTinh = r["DonViTinh"].ToString();
thanhTien = (float)Convert.ToDouble(r["ThanhTien"]);
DTO_ChiTietXuat ctx = new DTO_ChiTietXuat(idPhieuXuat, idMatHang, soLuong, donGia, donViTinh, thanhTien);
arrList.Add(ctx);
}
return(arrList);
}
/*
* ThemChiTietXuat trả về
* 1:thành công
* 0:thất bại
*/
public static int ThemChiTietXuat(DTO_ChiTietXuat ctx)
{
int kq = 0;
string query = "insert into ChiTietXuatHang(IdPhieuXuat, IdMatHang, SoLuong, DonGia, DonViTinh, ThanhTien) values(" + ctx.IdPhieuXuat + "," + ctx.IdMatHang + "," + ctx.SoLuong + "," + ctx.DonGia + ", N'" +
ctx.DonViTinh + "', " + ctx.ThanhTien + ")";
kq = ResultQuery.GetResultQuery(conn, query);
return(kq);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtTienCon.Text.Equals("") == false)
{
int idDaiLy = dsIdDL[cbDaiLy.SelectedIndex];
DateTime ngayXuat = dtNgayLap.Value;
//Console.WriteLine(ngayXuat.ToString("yyyy-MM-dd"));
float tienCon = (float)Convert.ToDouble(txtTienCon.Text);
float tienNo = BUS_DaiLy.GetTienNo(idDaiLy);
Console.WriteLine(tienNo);
float tienNoMoi = tienCon + tienNo;
int kqUpdate = BUS_DaiLy.UpdateTienNo(idDaiLy, tienNoMoi);
if (kqUpdate == 1)
{
string cmnd = taiKhoan.Cmnd;
DTO_PhieuXuatHang phieuXuatHang = new DTO_PhieuXuatHang(0, ngayXuat, idDaiLy, cmnd);
int idPhieuXuat = BUS_PhieuXuat.ThemPhieuXuatGetId(phieuXuatHang);
foreach (DataRow r in tb.Rows)
{
int idMatHang = (int)r[0];
int soLuong = int.Parse(r[2].ToString());
float donGia = (float)Convert.ToDouble(r[4]);
string donViTinh = r[3].ToString();
float thanhTien = (float)Convert.ToDouble(r[5]);
// DTO_ChiTietXuat ctx = new DTO_ChiTietXuat(idPhieuXuat, (int)r[0], (int)r[2], (float)Convert.ToDouble(r[4]), r[3].ToString(), (float)Convert.ToDouble(r[5]));
DTO_ChiTietXuat ctx = new DTO_ChiTietXuat(idPhieuXuat, idMatHang, soLuong, donGia, donViTinh, thanhTien);
BUS_ChiTietXuat.ThemChiTietXuat(ctx);
}
MessageBox.Show("Xuất thành công");
}
else if (kqUpdate == 2)
{
MessageBox.Show("Số tiền còn lại cộng với nợ cũ vượt quy định");
}
else
{
MessageBox.Show("Xuất thất bại");
}
//tb.Columns.Add("Id", typeof(int));
//tb.Columns.Add("Mặt hàng", typeof(string));
//tb.Columns.Add("Số lượng", typeof(string));
//tb.Columns.Add("đơn vị tính", typeof(string));
//tb.Columns.Add("Đơn giá", typeof(string));
//tb.Columns.Add("Thành tiền", typeof(string));
}
}
public static int ThemChiTietXuat(DTO_ChiTietXuat ct)
{
return(DAL_ChiTietXuat.ThemChiTietXuat(ct));
}