public bool ThemChiTietNhaCungCap(ChiTietNhaCungCap ncc)
{
try
{
return this._NhaCungCapDAL.ThemChiTietNhaCungCap(ncc);
}
catch (System.Exception ex)
{
Console.WriteLine("Message= {1}", ex.Message);
}
return false;
}
public bool ThemChiTietNhaCungCap(ChiTietNhaCungCap ncc)
{
try
{
SqlParameter[] para = new SqlParameter[4];
para[0] = new SqlParameter("@p_MaMatHang", ncc.MaMatHang);
para[1] = new SqlParameter("@p_MaNhaCungCap", ncc.MaNhaCungCap);
para[2] = new SqlParameter("@p_MaDonGia", ncc.MaDonGia);
para[3] = new SqlParameter("@p_GhiChu", ncc.GhiChu);
int result = this.ExecuteNonQuery("CT_NHACUNGCAP_Ins_new_L", para);
if (result != 0)
{
return true;
}
}
catch (System.Exception ex)
{
Console.WriteLine("Message= {1}", ex.Message);
}
return false;
}
private void sbLuuDonGia_Click(object sender, EventArgs e)
{
DataTable DanhSachMatHang = gcDanhSachMatHang.DataSource as DataTable;
DataTable DanhSachNhaCungCap = gcDanhSachNhaCungCap.DataSource as DataTable;
if (DanhSachMatHang != null && DanhSachMatHang.Rows.Count > 0
&& DanhSachNhaCungCap != null && DanhSachNhaCungCap.Rows.Count > 0)
{
int luachonmathang = gvDanhSachMatHang.GetSelectedRows()[0];
int luachonnhacungcap = gvDanhSachNhaCungCap.GetSelectedRows()[0];
if (luachonmathang != -1 && luachonnhacungcap != -1)
{
DonGia dg = new DonGia();
dg.MaMatHang = DanhSachMatHang.Rows[luachonmathang].ItemArray[0].ToString();
DataTable DanhSachMaDonGia = _DonGiaBUS.LayMaDonGiaBangMaSanPham(dg);
//xoa chi tiet nha cung cap trong bang chi tiet nha cung cap
_NhaCungCapBUS.XoaChiTietNhaCungCap(dg.MaMatHang);
foreach (DataRow dr in DanhSachMaDonGia.Rows)
{
_DonGiaBUS.XoaDonGia(dr.ItemArray[0].ToString());
}
DataTable DanhSachDonGia = gcChiTietDonGia.DataSource as DataTable;
if (DanhSachDonGia != null && DanhSachDonGia.Rows.Count > 0)
{
foreach (DataRow dr in DanhSachDonGia.Rows)
{
DonGia dg2 = new DonGia();
dg2.GiaNhap= Convert.ToDecimal(dr.ItemArray[4].ToString());
dg2.GiaXuat = Convert.ToDecimal(dr.ItemArray[5].ToString());
string madongia = _DonGiaBUS.ThemDonGiaVaLayMaDonGia(dg2);
ChiTietNhaCungCap ctncc = new ChiTietNhaCungCap();
ctncc.MaDonGia = madongia;
ctncc.GhiChu = "";
ctncc.MaMatHang = dr.ItemArray[0].ToString();
ctncc.MaNhaCungCap = dr.ItemArray[2].ToString();
_NhaCungCapBUS.ThemChiTietNhaCungCap(ctncc);
}
MessageBox.Show("Lưu Thành Công", "Thông Báo",MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
MessageBox.Show("Đơn giá trống nhưng vẫn lưu thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
