public static int xoa_PN(PhieuNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPN", a.MaPN),
};
return(Dataprovider.ExecuteNonQuery("xoa_PN", para));
}
public static int xoa_HH(HangHoa a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maHH", a.MaHH),
};
return(Dataprovider.ExecuteNonQuery("xoa_HH", para));
}
public static int xoa_NCC(NCC a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maNCC", a.MaNCC),
};
return(Dataprovider.ExecuteNonQuery("xoa_NCC", para));
}
public static int xoa_CTX(ChiTietXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTX", a.MaCTX),
};
return(Dataprovider.ExecuteNonQuery("xoa_CTX", para));
}
public static int xoa_PX(PhieuXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPX", a.MaPX),
};
return(Dataprovider.ExecuteNonQuery("xoa_PX", para));
}
public static int sua_HH(HangHoa a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@tenHH", a.TenHH),
new SqlParameter("@maNCC", a.MaNCC),
};
return(Dataprovider.ExecuteNonQuery("sua_HH", para));
}
public static int them_PN(PhieuNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPN", a.MaPN),
new SqlParameter("@ngayNhap", a.NgayNhap),
new SqlParameter("@tongTien", a.TongTien),
};
return(Dataprovider.ExecuteNonQuery("them_PN", para));
}
public static int them_PX(PhieuXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maPX", a.MaPX),
new SqlParameter("@ngayXuat", a.NgayXuat),
new SqlParameter("@tongTien", a.TongTien),
};
return(Dataprovider.ExecuteNonQuery("them_PX", para));
}
//sua
public static int sua_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTN", a.MaCTN),
new SqlParameter("@maPN", a.MaPN),
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@soLuong", a.SoLuong),
new SqlParameter("@donGia", a.DonGia),
};
return(Dataprovider.ExecuteNonQuery("sua_CTN", para));
}
public static int them_CTX(ChiTietXuat a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTX", a.MaCTX),
new SqlParameter("@maPX", a.MaPX),
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@soLuong", a.SoLuong),
new SqlParameter("@donGia", a.DonGia),
};
return(Dataprovider.ExecuteNonQuery("them_CTX", para));
}
public static int them_NCC(NCC a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maNCC", a.MaNCC),
new SqlParameter("@tenNCC", a.TenNCC),
new SqlParameter("@diaChi", a.DiaChi),
new SqlParameter("@SDT", a.SoDT),
new SqlParameter("@email", a.Email),
};
return(Dataprovider.ExecuteNonQuery("them_NCC", para));
}
public static DataTable tk_nhap()
{
return(Dataprovider.GetData("tk_nhap"));
}
//thống kê
public static DataTable tk_hh()
{
return(Dataprovider.GetData("tk_hh"));
}
public static DataTable xuat_ncc()
{
return(Dataprovider.GetData("xuat_NCC"));
}
public static DataTable xuat_hh_tk()
{
return(Dataprovider.GetData("xuat_hh_tk"));
}
public static DataTable xuat_ctx(string ma)
{
return(Dataprovider.GetData("xuat_CTX2" + "'" + ma + "'"));
}
public static DataTable xuat_px()
{
return(Dataprovider.GetData("xuat_PX"));
}
public static DataTable tk_xuat()
{
return(Dataprovider.GetData("tk_xuat"));
}