private void btnthem_Click(object sender, EventArgs e) { if (txttensp.Text == "" || txtdongia.Text == "" || txtsoluong.Text == "" || IsNumber(txtsoluong.Text) == false || IsNumber(txtdongia.Text) == false) { MessageBox.Show("Thông tin sản phẩm chưa đầy đủ, vui lòng kiểm tra lại !"); } else { Sanpham_DTO spDTO = new Sanpham_DTO(); spDTO.STenSP = txttensp.Text; spDTO.SSoLuong = int.Parse(txtsoluong.Text); spDTO.SDonGia = int.Parse(txtdongia.Text); spDTO.STGBH = int.Parse(cbtgbh.Text); spDTO.STrangThai = cbtrangthai.Text; spDTO.SMaSP = txtmasp.Text; spDTO.SMaLoai = cbmaloai.SelectedValue.ToString(); spDTO.SMaNCC = cbmancc.SelectedValue.ToString(); if (Sanpham_BUS.Themsp(spDTO) == true) { MessageBox.Show("Lưu thành công"); LoadDgvSanPham(); } else { MessageBox.Show("Thất bại!"); } btncapnhat.Enabled = true; btnxoa.Enabled = true; } }
private void btncapnhat_Click(object sender, EventArgs e) { //btnthem.Enabled = false; Sanpham_DTO spDTO = new Sanpham_DTO(); spDTO.SMaSP = txtmasp.Text; spDTO.STenSP = txttensp.Text; spDTO.SSoLuong = int.Parse(txtsoluong.Text); spDTO.SDonGia = int.Parse(txtdongia.Text); spDTO.STGBH = int.Parse(cbtgbh.Text); spDTO.STrangThai = cbtrangthai.Text; spDTO.SMaSP = txtmasp.Text; spDTO.SMaLoai = cbmaloai.SelectedValue.ToString(); spDTO.SMaNCC = cbmancc.SelectedValue.ToString(); if (Sanpham_BUS.Suasp(spDTO) == true) { MessageBox.Show("Cập nhật thành công"); LoadDgvSanPham(); } else { MessageBox.Show("Thất bại!"); } }
//private void dgvdmsp_CellContentClick(object sender, DataGridViewCellEventArgs e) //{ // DataGridViewRow dr = dgvdmsp.SelectedRows[0]; // txtmasp.Text = dr.Cells["SMaSP"].Value.ToString(); // txttensp.Text = dr.Cells["STenSP"].Value.ToString(); // cbtgbh.Text = dr.Cells["STGBH"].Value.ToString(); // txtsoluong.Text = dr.Cells["SSoLuong"].Value.ToString(); // cbtrangthai.Text = dr.Cells["STrangThai"].Value.ToString(); // txtdongia.Text = dr.Cells["SDonGia"].Value.ToString(); // cbmaloai.SelectedValue = dr.Cells["SMaLoai"].Value.ToString(); // cbmancc.SelectedValue = dr.Cells["SMaNCC"].Value.ToString(); //} private void btnxoa_Click(object sender, EventArgs e) { Sanpham_DTO spDTO = new Sanpham_DTO(); spDTO.SMaSP = txtmasp.Text; //MessageBox.Show(spDTO.SMaSP); //if (Sanpham_BUS.Xoasp(spDTO) == true) //{ // MessageBox.Show("Xoa thanh cong"); // LoadDgvSanPham(); //} //else // MessageBox.Show("Xoa that bai!"); if (Sanpham_BUS.Checkxoasp(txtmasp.Text)) { if (Sanpham_BUS.Xoasp(spDTO) == true) { MessageBox.Show("Đã xóa"); LoadDgvSanPham(); } } else { MessageBox.Show("Thất bại!"); } }
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(); }
public static List <Sanpham_DTO> LocSPTT(string txtTukhoa) { string sTruyvan = "select * from SANPHAM where TRANGTHAI LIKE '%" + txtTukhoa + "%' "; con = DataProvider.Ketnoi(); DataTable dt = DataProvider.LayDataTable(sTruyvan, con); if (dt.Rows.Count == 0) { return(null); } List <Sanpham_DTO> listnv = new List <Sanpham_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { Sanpham_DTO nv = new Sanpham_DTO(); nv.SMaSP = dt.Rows[i]["MASP"].ToString(); nv.STenSP = dt.Rows[i]["TENSP"].ToString(); nv.STGBH = int.Parse(dt.Rows[i]["TGBAOHANH"].ToString()); nv.SSoLuong = int.Parse(dt.Rows[i]["SOLUONG"].ToString()); nv.STrangThai = dt.Rows[i]["TRANGTHAI"].ToString(); nv.SDonGia = int.Parse(dt.Rows[i]["DONGIA"].ToString()); nv.SMaLoai = dt.Rows[i]["MALOAI"].ToString(); nv.SMaNCC = dt.Rows[i]["MANCC"].ToString(); listnv.Add(nv); } return(listnv); }
public static void SP_Update_SL(Sanpham_DTO SP) { con = DataProvider.Ketnoi(); var cmd = new SqlCommand("SANPHAM_CapnhatSL", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MASP", SqlDbType.Char).Value = SP.SMaSP; cmd.Parameters.Add("@SOLUONG", SqlDbType.Int).Value = SP.SSoLuong; cmd.ExecuteNonQuery(); DataProvider.Dongketnoi(con); }
public static String MaSPTutang() { Sanpham_DTO TGBH = new Sanpham_DTO(); con = DataProvider.Ketnoi(); var cmd = new SqlCommand("SanPham_MASP_TOP1", con); cmd.CommandType = CommandType.StoredProcedure; var Adapter = new SqlDataAdapter(cmd); var table = new DataTable(); Adapter.Fill(table); string sMaSP = table.Rows[0]["MASP"].ToString(); DataProvider.Dongketnoi(con); return(sMaSP); }
public static bool ThemSP(Sanpham_DTO ThemSP) { string sTruyvan = string.Format(@"insert into SANPHAM (MASP,TENSP, TGBAOHANH, SOLUONG, TRANGTHAI, DONGIA, MALOAI, MANCC) values ('{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}','N{7}') ", ThemSP.SMaSP, ThemSP.STenSP, ThemSP.STGBH, ThemSP.SSoLuong, ThemSP.STrangThai, ThemSP.SDonGia, ThemSP.SMaLoai, ThemSP.SMaNCC); //string sTruyvan = "insert into khoa values('" + txtMASP+ "',N'" + txtTENSP.Text + "')"; con = DataProvider.Ketnoi(); try { DataProvider.ThucThiTruyVanNonQuerry(sTruyvan, con); DataProvider.Dongketnoi(con); return(true); } catch (Exception ex) { DataProvider.Dongketnoi(con); return(false); } }
public static bool XoaSP(Sanpham_DTO XoaSP) { string sTruyvan = string.Format(" DELETE FROM SANPHAM WHERE MASP='{0}'", XoaSP.SMaSP); //string sTruyvan = "insert into khoa values('" + txtMASP+ "',N'" + txtTENSP.Text + "')"; con = DataProvider.Ketnoi(); try { DataProvider.ThucThiTruyVanNonQuerry(sTruyvan, con); DataProvider.Dongketnoi(con); return(true); } catch (Exception ex) { DataProvider.Dongketnoi(con); return(false); } }
public static bool SuaSP(Sanpham_DTO SuaSP) { string sTruyvan = string.Format(" Update SANPHAM set TENSP=N'{0}',TGBAOHANH='{1}',SOLUONG='{2}',TRANGTHAI=N'{3}',DONGIA='{4}',MALOAI=N'{5}',MANCC=N'{6}' WHERE MASP=N'{7}'", SuaSP.STenSP, SuaSP.STGBH, SuaSP.SSoLuong, SuaSP.STrangThai, SuaSP.SDonGia, SuaSP.SMaLoai, SuaSP.SMaNCC, SuaSP.SMaSP); //string sTruyvan = "insert into khoa values('" + txtMASP+ "',N'" + txtTENSP.Text + "')"; con = DataProvider.Ketnoi(); try { DataProvider.ThucThiTruyVanNonQuerry(sTruyvan, con); DataProvider.Dongketnoi(con); return(true); } catch (Exception ex) { DataProvider.Dongketnoi(con); return(false); } }
private void SP_CapnhatSL(string sChuoi) { Sanpham_DTO SP = new Sanpham_DTO(); int iNewSL = 0; DataTable tblSL = HoadonBan_BUS.SP_LaySL(txtMaSP.Text); string sTemp = tblSL.Rows[0][0].ToString(); switch (sChuoi) { case "-": iNewSL = int.Parse(sTemp) - int.Parse(txtSL.Text); break; case "+": iNewSL = int.Parse(sTemp) + int.Parse(txtSL.Text); break; } SP.SSoLuong = iNewSL; SP.SMaSP = txtMaSP.Text; HoadonBan_BUS.SP_Update_SL(SP); }
public static void SP_Update_SL(Sanpham_DTO SP) { HoadonBan_DAO.SP_Update_SL(SP); }
public static bool Xoasp(Sanpham_DTO XoaSP) { return(Sanpham_DAO.XoaSP(XoaSP)); }
public static bool Suasp(Sanpham_DTO SuaSP) { return(Sanpham_DAO.SuaSP(SuaSP)); }
public static bool Themsp(Sanpham_DTO ThemSP) { return(Sanpham_DAO.ThemSP(ThemSP)); }