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