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