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