private void btnCapnhatSP_Click(object sender, EventArgs e)
{
CTHDBanhang_DTO CTHDBH = new CTHDBanhang_DTO();
Sanpham_DTO SP = new Sanpham_DTO();
SP.SMaSP = txtMaSP.Text;
CTHDBH.SMaCTHDB = sMaCTHDBH;
CTHDBH.SMaHDB = txtMaHD.Text;
CTHDBH.SMaSP = txtMaSP.Text;
CTHDBH.ISoLuong = int.Parse(txtSL.Text);
HoadonBan_BUS.Update_CTHDBH(CTHDBH);
CTHDBanHang_Load(txtMaHD.Text);
txtTongtien.Text = TinhTongTien(txtMaHD.Text);
Update_Tongtien();
DataTable tblSL = HoadonBan_BUS.SP_LaySL(txtMaSP.Text);
string sTemp = tblSL.Rows[0][0].ToString();
int iTemp;
if (int.Parse(txtSL.Text) > sSL)
{
iTemp = int.Parse(txtSL.Text) - sSL;
SP.SSoLuong = int.Parse(sTemp) - iTemp;
HoadonBan_BUS.SP_Update_SL(SP);
}
else
if (int.Parse(txtSL.Text) < sSL)
{
iTemp = sSL - int.Parse(txtSL.Text);
SP.SSoLuong = int.Parse(sTemp) + iTemp;
HoadonBan_BUS.SP_Update_SL(SP);
}
sSL = int.Parse(txtSL.Text);
ResetSP();
LoadDgvCTHD();
}
private void LayTTCTHDBH(CTHDBanhang_DTO CTHDBH)
{
DataTable tbl = HoadonBan_BUS.CTHDBH_LoadTop1();
CTHDBH.SMaCTHDB = TuDongTangMaNV(tbl);
CTHDBH.SMaHDB = txtMaHD.Text;
CTHDBH.SMaSP = cbbTenSP.SelectedValue.ToString();
CTHDBH.ISoLuong = int.Parse(txtSL.Text);
}
public static void Update_CTHDBH(CTHDBanhang_DTO CTHDBH)
{
con = DataProvider.Ketnoi();
var cmd = new SqlCommand("CTHDBanHang_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MACTHDBH", SqlDbType.Char).Value = CTHDBH.SMaCTHDB;
cmd.Parameters.Add("@MAHDBH", SqlDbType.Char).Value = CTHDBH.SMaHDB;
cmd.Parameters.Add("@MASP", SqlDbType.Char).Value = CTHDBH.SMaSP;
cmd.Parameters.Add("@SOLUONG", SqlDbType.Int).Value = CTHDBH.ISoLuong;
cmd.ExecuteNonQuery();
DataProvider.Dongketnoi(con);
}
private void btnThemSP_Click(object sender, EventArgs e)
{
CTHDBanhang_DTO CTHDBH = new CTHDBanhang_DTO();
DataTable tblCheck = new DataTable();
tblCheck = HoadonBan_BUS.CheckSPinHDBH(txtMaSP.Text, txtMaHD.Text);
if (tblCheck.Rows.Count == 0)
{
if (txtSL.Text != "")
{
LayTTCTHDBH(CTHDBH);
sMaCTHDBH = CTHDBH.SMaCTHDB;
HoadonBan_BUS.ThemCTHDBH(CTHDBH);
CTHDBanHang_Load(txtMaHD.Text);
txtTongtien.Text = TinhTongTien(txtMaHD.Text);
Update_Tongtien();
SP_CapnhatSL("-");
txtSL.Enabled = false;
ResetSP();
}
else
{
MessageBox.Show("Mời bạn nhập số lượng cho sản phẩm!", "Thông báo");
}
}
else
{
DialogResult Lenh = MessageBox.Show("Sản phẩm này đã được thêm, bạn có muốn thêm sản phẩm này nữa không!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Lenh == DialogResult.Yes)
{
DataTable tblSL = HoadonBan_BUS.SP_LaySL(txtMaSP.Text);
int iSL = int.Parse(tblCheck.Rows[0][3].ToString()) + int.Parse(txtSL.Text);
HoadonBan_BUS.UpdateSL_CTHDBH(tblCheck.Rows[0][0].ToString(), txtMaSP.Text, iSL);
CTHDBanHang_Load(txtMaHD.Text);
SP_CapnhatSL("-");
}
}
}
public static void Update_CTHDBH(CTHDBanhang_DTO CTHDBH)
{
HoadonBan_DAO.Update_CTHDBH(CTHDBH);
}
public static void ThemCTHDBH(CTHDBanhang_DTO CTHDBH)
{
HoadonBan_DAO.ThemCTHDBH(CTHDBH);
}