public int Insert(MatHang mh) { if (Load_DAL("select * from MatHang where MaHang='" + mh.MaHang + "'").Rows.Count > 0) { return(2); } else if (Load_DAL("select * from MatHang where TenHang='" + mh.TenHang + "'").Rows.Count > 0) { return(3); } else { SqlCommand cmd = new SqlCommand("Insert_MatHang", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ma", mh.MaHang)); cmd.Parameters.Add(new SqlParameter("@ten", mh.TenHang)); cmd.Parameters.Add(new SqlParameter("@malh", mh.MaLH)); cmd.Parameters.Add(new SqlParameter("@dvt", mh.DVT)); try { if (con.State != ConnectionState.Open) { con.Open(); } } catch { return(-2); } try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } }
void TimKiemHang() { DataTable dt = new DataTable(); dt = MatHang.findhang(txtSerchhang.Text.Trim()); dgvTimKiem.DataSource = dt; }
void TimKiemGiaNhap() { DataTable dt = new DataTable(); dt = MatHang.findgianhap(txtSearchGiaNhap.Text.Trim()); dgvTimKiem.DataSource = dt; }
public ActionResult CreateLan2(MatHang mathang) { ThongBaoMvc thongbao; var item = db.MatHangs.SingleOrDefault(s => s.ItemId == bientam.ItemId); if (!string.IsNullOrEmpty(mathang.Propertynames)) { item.Propertynames = mathang.Propertynames; try { db.SaveChanges(); thongbao = new ThongBaoMvc { CssClassName = "success", Message = "Cập nhật chi tiết sản phẩm thành công" }; TempData["ResultAction"] = thongbao; LogMgr.AddLog(User.Identity.Name, 5, "Cập nhập chi tiết sản phẩm " + item.Name + "-" + item.ItemId); return(RedirectToAction("Index", "Item")); } catch (Exception ex) { log.Error("Lỗi ở CreateLan2" + ex.Message); thongbao = new ThongBaoMvc { CssClassName = "danger", Message = "Lỗi" }; TempData["ResultAction"] = thongbao; } } var tt = item.LoaiCap3.PropertyNames.ToString().Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); ViewBag.Info = tt; return(View()); }
void TimKiemTen() { DataTable dt = new DataTable(); dt = MatHang.findname(txtSearch.Text.Trim()); dgvTimKiem.DataSource = dt; }
public List <MatHang> LoadData() { try { dp.Connect(); string sqlstr = "SELECT * FROM MatHang"; List <MatHang> list = new List <MatHang>(); SqlDataReader dr = dp.ExecuteReader(sqlstr); //List<MatHang> list = new List<MatHang>(); while (dr.Read()) { string maMatHang = dr.GetString(0); string tenMatHang = dr.GetString(1); string maNhaCungCap = dr.GetString(2); string tenNhaCungCap = dr.GetString(3); int donGia = dr.GetInt32(4); int giaBan = dr.GetInt32(5); string maLoaiTien = dr.GetString(6); int namSanXuat = dr.GetInt32(7); MatHang N = new MatHang(maMatHang, tenMatHang, maNhaCungCap, tenNhaCungCap, donGia, giaBan, maLoaiTien, namSanXuat); list.Add(N); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.Disconnect(); } }
public ActionResult SuaSP(MatHang g, HttpPostedFileBase fileUpload) { //Kiểm tra đường dẫn if (ModelState.IsValid) { if (fileUpload != null) { var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/Images/Product/"), fileName); //Lưu hình fileUpload.SaveAs(path); g.Anhbia = "/Product/" + fileName; } //Lưu vào CSDL var obj = db.MatHangs.SingleOrDefault(p => p.MaHang == g.MaHang); obj.MaDM = g.MaDM; obj.MaThuongHieu = g.MaThuongHieu; obj.TenHang = g.TenHang; obj.SoLuongBan = g.SoLuongBan; obj.SoLuongTon = g.SoLuongTon; obj.NgayCapNhat = g.NgayCapNhat; obj.Mau = g.Mau; obj.Mota = g.Mota; obj.Anhbia = g.Anhbia; obj.Giaban = g.Giaban; obj.Size = g.Size; db.SubmitChanges(); return(RedirectToAction("QuanLySanPham")); } //Đưa dữ liệu vào dropdown ViewBag.MaDM = new SelectList(db.DanhMucs.OrderBy(n => n.TenDM), "MaDM", "TenDM");; ViewBag.MaNXB = new SelectList(db.ThuongHieus.OrderBy(n => n.TenThuongHieu), "MaThuongHieu", "TenThuongHieu"); return(View(g)); }
private void btnThem_Click(object sender, EventArgs e) { int i = -1; string s = ""; try { MatHang ob = new MatHang(txtMaMH.Text, txtTenMH.Text, cbxMaLH.SelectedValue.ToString(), txtDVT.Text); i = mh.Insert(ob); } catch { s = "Dữ liệu đã nhập không phù hợp!\n Mời nhập lại!!"; } switch (i) { case -2: s = "Lỗi kết nối!!"; break; case 1: s = "Thêm thành công!!"; Frm_MatHang_Load(sender, e); break; case 2: s = "Không thể thêm dữ liệu!!\n Mã mặt hàng này đã tồn tại!!"; break; case 3: s = "Không thể thêm dữ liệu!!\n Hãy chọn tên mặt hàng khác, tên mặt hàng này đã có trong hệ thống!!"; break; case 0: s = "Lỗi!! Không thể thêm dữ liệu!!"; break; } MessageBox.Show(s, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public ActionResult Themmoimathang(MatHang mathang, HttpPostedFileBase fileUpload) { ViewBag.MSLH = new SelectList(db.LoaiHangs.ToList().OrderBy(n => n.TenLoaiHang), "MSLH", "TenLoaiHang"); if (fileUpload == null) { ViewBag.Thongbao = "Vui lòng chọn ảnh bìa"; return(View()); } else { if (ModelState.IsValid) { var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName); if (System.IO.File.Exists(path)) { ViewBag.Thongbao = "Hình ảnh đã tồn tại"; } else { fileUpload.SaveAs(path); } mathang.HinhAnh = fileName; db.MatHangs.InsertOnSubmit(mathang); db.SubmitChanges(); } return(RedirectToAction("MatHang")); } }
public DataTable TenMH(MatHang mathang) { string query = "sp_TenMH_TheoMa '" + mathang.MaMH + "'"; DataTable result = DataProvider.Instance.ExecuteQuery(query); return(result); }
public int Delete(MatHang mh) { if (Load_DAL("select * from MatHang where MaHang='" + mh.MaHang + "'").Rows.Count == 0) { return(2); } else if (Load_DAL("select * from CTPN where MaHang='" + mh.MaHang + "'").Rows.Count > 0) { return(3); } else if (Load_DAL("select * from CTPX where MaHang='" + mh.MaHang + "'").Rows.Count > 0) { return(4); } else if (Load_DAL("select * from CTMH where MaHang='" + mh.MaHang + "'").Rows.Count > 0) { return(5); } else { SqlCommand cmd = new SqlCommand("Delete_MatHang", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ma", mh.MaHang)); try { if (con.State != ConnectionState.Open) { con.Open(); } } catch { return(-2); } try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } }
public async Task <ActionResult> MH_Sua(MatHang mh, HttpPostedFileBase fileUpload) { ViewBag.MSLH = new SelectList(db.LoaiHangs, "MSLH", "TenLoaiHang", mh.MSLH); if (fileUpload == null) { ViewBag.ThongBao = "Vui lòng chọn ảnh"; return(View()); } else { if (ModelState.IsValid) { var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName); if (System.IO.File.Exists(path)) { ViewBag.ThongBao = "Hình ảnh đã tồn tại"; } else { fileUpload.SaveAs(path); } MatHang mhh = db.MatHangs.Where(x => x.MSMH == mh.MSMH).Single <MatHang>(); mhh.TenHang = mh.TenHang; mhh.MSLH = mh.MSLH; mhh.SoLuong = mh.SoLuong; mhh.TrangThai = mh.TrangThai; mhh.DonGia = mh.DonGia; mhh.HinhAnh = fileName; mhh.NgayCapNhat = mh.NgayCapNhat; await db.SaveChangesAsync(); } } return(RedirectToAction("MatHang")); }
public void AddMH(MatHang m) { PBL3 db = new PBL3(); db.MatHang.Add(m); db.SaveChanges(); }
public IHttpActionResult PostMatHang(MatHang matHang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.matHangs.Add(matHang); try { db.SaveChanges(); } catch (DbUpdateException) { if (MatHangExists(matHang.IDMH)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = matHang.IDMH }, matHang)); }
// // GET: /XemChiTietSP/ public ActionResult Index(long?id) { var db = new ProductDB(); MatHang mathang = db.getProductByID(id); return(View(mathang)); }
public async Task <IActionResult> Edit(string id, [Bind("MaMH,Ten,MaLH,MaDVT,NgaySanXuat,SoLuongNhap,SoLuongBan,GiaBan,GiaMua,VAT,MoTa,NgayNhap,NgayHetHan,HinhMinhHoa")] MatHang matHang) { if (id != matHang.MaMH) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(matHang); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MatHangExists(matHang.MaMH)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["MaDVT"] = new SelectList(_context.DonViTinhs, "MaDVT", "MaDVT", matHang.MaDVT); ViewData["MaLH"] = new SelectList(_context.LoaiHangs, "MaLH", "MaLH", matHang.MaLH); return(View(matHang)); }
//Thêm 1 mặt hàng public Result InsertMatHang(string pMaHang, string pTenMatHang, string pMaLoaiMatHang, string pDVT, decimal?pGiaBan, decimal?pGiaNhap, string pMaNhaCC, byte?pBaoHanh, string pTinhTrangHang) { if (checkPrimaryKeyMatHang(pMaHang) == false) { return(Result.PRIMARY_KEY); } if (checkUniqueNameMatHang(pTenMatHang) == false) { return(Result.UNIQUE_NAME); } try { mh = new MatHang(); mh.MaHang = pMaHang; mh.TenMatHang = pTenMatHang; mh.MaLoaiMatHang = pMaLoaiMatHang; mh.DVT = pDVT; mh.GiaBan = pGiaBan; mh.GiaNhap = pGiaNhap; mh.MaNhaCC = pMaNhaCC; mh.BaoHanh = pBaoHanh; mh.TinhTrangHang = "Chưa nhập hàng"; qlch.MatHangs.InsertOnSubmit(mh); qlch.SubmitChanges(); return(Result.SUCCESS); } catch { return(Result.FAILED); } }
private void btThemHang_Click(object sender, EventArgs e) { MatHang matHang = (MatHang)matHangList[lvMatHang.SelectedIndices[0]]; int pos = kiemTraMatHang(matHang); if (pos == -1) { matHangChoList.Insert(0, new MatHang(matHang.id, matHang.tenMatHang, matHang.idNganhHang, matHang.donGia, Convert.ToInt32(nudSoLuongTinhTien.Value))); string[] row = { matHang.tenMatHang, nudSoLuongTinhTien.Value.ToString(), matHang.donGia.ToString() }; ListViewItem viewItem = new ListViewItem(row); lvChiTietHoaDon.Items.Add(viewItem); } else { MatHang matHang1 = (MatHang)matHangChoList[pos]; ((MatHang)matHangChoList[pos]).soLuong = matHang1.soLuong + Convert.ToInt32(nudSoLuongTinhTien.Value); lvChiTietHoaDon.Items.Clear(); foreach (MatHang matHang2 in matHangChoList) { string[] row = { matHang2.tenMatHang, matHang2.soLuong.ToString(), matHang2.donGia.ToString() }; ListViewItem viewItem = new ListViewItem(row); lvChiTietHoaDon.Items.Add(viewItem); } } lvMatHang.SelectedItems[0].SubItems[1].Text = (Convert.ToInt32(lvMatHang.SelectedItems[0].SubItems[1].Text) - (int)nudSoLuongTinhTien.Value).ToString(); ((MatHang)matHangList[lvMatHang.SelectedIndices[0]]).soLuong += -(int)nudSoLuongTinhTien.Value; nudSoLuongTinhTien.Maximum = ((MatHang)matHangList[lvMatHang.SelectedIndices[0]]).soLuong; loadTinhTien(); }
public static ArrayList getAllMatHangFromNganhHang(int idNganhHang) { ArrayList dataList = new ArrayList(); try { DataSet dataSet = MatHangDAO.getMatHangFromIdNganhHang(idNganhHang); foreach (DataRow row in dataSet.Tables[0].Rows) { int id = Convert.ToInt32(row["id"]); string tenMatHang = row["tenMatHang"].ToString(); //int idNganhHang1 = Convert.ToInt32(row["idNganhHang"]); float donGian = (float)Convert.ToDouble(row["donGia"]); int soLuong = Convert.ToInt32(row["soLuong"]); MatHang matHang = new MatHang(id, tenMatHang, idNganhHang, donGian, soLuong); dataList.Insert(0, matHang); } } catch (SqlException e) { } return(dataList); }
public frmUpdateHangHoa(MatHang transmission) { InitializeComponent(); xeDien = transmission; showInforMatHang(); }
public async Task <ActionResult> MH_Them(MatHang mh, HttpPostedFileBase fileupload) { ViewBag.MSLH = new SelectList(db.LoaiHangs, "MSLH", "TenLoaiHang", mh.MSLH); if (fileupload == null) { ViewBag.ThongBao = "Vui lòng chọn ảnh"; return(View()); } else { if (ModelState.IsValid) { var fileName = Path.GetFileName(fileupload.FileName); var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName); if (System.IO.File.Exists(path)) { ViewBag.ThongBao = "Hình ảnh đã tồn tại"; } else { fileupload.SaveAs(path); } mh.HinhAnh = fileName; db.MatHangs.Add(mh); await db.SaveChangesAsync(); } return(RedirectToAction("MatHang")); } }
public async Task <IActionResult> ChiTietDonHang(int?id) { var donHang = await _context.DonHang .SingleOrDefaultAsync(m => m.ID == id); var dsChiTiet = from ct in _context.ChiDietDonHang where ct.DonHangID == id select ct; var dsMatHang = new List <MatHang>(); foreach (var ct in dsChiTiet) { var sanPham = await _context.SanPham.SingleOrDefaultAsync(sp => sp.ID == ct.SanPhamID); var mh = new MatHang(); mh.sanPham = sanPham; mh.soLuong = ct.SoLuong; mh.tongTien = ct.TongTien; dsMatHang.Add(mh); } var duLieuChiTiet = new DuLieuChiTietDonHang(); duLieuChiTiet.donHang = donHang; duLieuChiTiet.chiTietDonHang = dsMatHang; return(View(duLieuChiTiet)); }
private void btnMH_Click(object sender, EventArgs e) { pnContainer.Controls.Clear(); MatHang mathang = new MatHang(); pnContainer.Controls.Add(mathang); }
public IHttpActionResult PutMatHang(string id, MatHang matHang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != matHang.IDMH) { return(BadRequest()); } db.Entry(matHang).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MatHangExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(long id) { MatHang mathang = db.MatHangs.Find(id); db.MatHangs.Remove(mathang); db.SaveChanges(); return(RedirectToAction("Index")); }
public float getGiaNhapById(int id) { string query = string.Format("SELECT * FROM dbo.MatHang WHERE id = {0}", id); DataTable data = ExcuteQuery(query); MatHang mh = new MatHang(data.Rows[0]); return(mh.gianhap); }
// Token: 0x06000188 RID: 392 RVA: 0x0002CF30 File Offset: 0x0002B130 public frmMatHang(string strtitle, string strtenSP, MatHang matHang) { this.InitializeComponent(); this.strTitle = strtitle; this.Text += this.strTitle; this.strTenSP = strtenSP; this.MatHangSelected = matHang; }
public int getIdByName(string name) { string query = string.Format("SELECT * FROM dbo.MatHang WHERE name = N'{0}'", name); DataTable data = ExcuteQuery(query); MatHang mh = new MatHang(data.Rows[0]); return(mh.id); }
private void btnLuuN_Click(object sender, EventArgs e) { id = 0; int dem = -1; NhapHangBLL bll = new NhapHangBLL(); MatHangBLL mhb = new MatHangBLL(); for (int i = 0; i < lvMHN.Items.Count; i++) { NhapHang nh = new NhapHang(); // nh.id = int.Parse(lvMHN.Items[i].SubItems[0].Text); nh.idMH = int.Parse(lvMHN.Items[i].SubItems[0].Text); nh.idNCC = int.Parse(lvMHN.Items[i].SubItems[1].Text); nh.idNV = int.Parse(lvMHN.Items[i].SubItems[2].Text); nh.soluong = int.Parse(lvMHN.Items[i].SubItems[3].Text); nh.thanhtien = float.Parse(lvMHN.Items[i].SubItems[4].Text); MatHang mh = mhb.getDetailsById(nh.idMH); mh.soluong += nh.soluong; nh.thanhtien = nh.soluong * mhb.getGiaNhapById(nh.idMH); try { if ((id = bll.getIdAndInsert(nh)) != 0) { dem++; mhb.update(mh); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } if (ckReportN.Checked == true) { id = id - dem; tcAdd.Controls.Clear(); tcAdd.Controls.Add(HoaDonNhap); loadReport(1); } else { if (lvMHN.Items.Count != 0) { MessageBox.Show("Lưu thành công"); Close(); } else { MessageBox.Show("Chưa có dữ liệu"); } } }
/// <summary> /// Sự kiện hiển thị thông tin của sản phẩm được click. /// </summary> private void PicHang_Click(object sender, EventArgs e) { MatHang result = ((sender as PictureBox).Tag) as MatHang; //Sao chép dữ liệu của đối tượng để truyền dữ liệu sang form khác làm việc frmInforMatHang frm = new frmInforMatHang(result, account); frm.ShowDialog(); loadListXe(MatHangBUS.Instance.getListMatHang()); }