public JsonResult SaveData(string maphieunhap, string mancc, string ngaynhap, string masp, int soluongnhap, int dongia) { int thanhtien = soluongnhap * dongia; PhieuNhap pn = new PhieuNhap(); pn.MaPhieuNhap = maphieunhap; pn.MaNCC = mancc; pn.NgayNhap = DateTime.Parse(ngaynhap); pn.ThanhTien = thanhtien; ChiTietPN cpn = new ChiTietPN(); cpn.MaPhieuNhap = maphieunhap; cpn.MaSP = masp; cpn.SoLuongNhap = soluongnhap; cpn.DonGia = dongia; NhapHangBus mhb = new NhapHangBus(); mhb.SuaHang(pn, thanhtien, cpn); ChiTietPNModel pnb = new ChiTietPNModel(); //var ds = ssp.LaySanPham(masp); //ds.SoLuongTon += soluongnhap; //ds.NgayCapNhat = DateTime.Parse(ngaynhap); return(Json(new { success = true, ms = "thanh cong" }, JsonRequestBehavior.AllowGet)); }
public List <ChiTietPN> LayDsPnTheoMaFull(string ma) { dt = db.LayDuLieu("select cp.MaPhieuNhap,cp.MaSP,cp.SoLuongNhap,cp.DonGia,p.MaNCC,p.NgayNhap,p.ThanhTien from ChiTietPN cp inner join PhieuNhap p on cp.MaPhieuNhap = p.MaPhieuNhap where p.MaPhieuNhap = '" + ma + "'"); List <ChiTietPN> ds = new List <ChiTietPN>(); foreach (DataRow r in dt.Rows) { ChiTietPN l = new ChiTietPN(); l.MaPhieuNhap = Convert.ToString(r[0]); l.MaSP = Convert.ToString(r[1]); l.SoLuongNhap = Convert.ToInt32(r[2]); l.DonGia = Convert.ToInt32(r[3]); var MaNCC = Convert.ToString(r[4]); l.PhieuNhap = new PhieuNhap { MaNCC = Convert.ToString(r[4]), NgayNhap = Convert.ToDateTime(r[5]), ThanhTien = Convert.ToInt32(r[6]) }; //try //{ // l.PhieuNhap.MaNCC = MaNCC; // l.PhieuNhap.NgayNhap = Convert.ToDateTime(r[5]); // l.PhieuNhap.NgayNhap = Convert.ToDateTime(r[6]); //} //catch (NullReferenceException e) //{ // var aa = e.ToString(); //} ds.Add(l); } return(ds); }
private void btnIn_Click(object sender, EventArgs e) { string maPN = cbxPhieuNhap.SelectedValue.ToString(); DataRow pn = handle.phieunhap.find(maPN); if (pn != null) { DataRow nguoidung = handle.nguoidung.findID(pn["ID_NV"].ToString()); ChiTietPN rpt = new ChiTietPN(); DataTable CTPN = handle.phieunhap.getTableCTPN(maPN); rpt.SetDataSource(CTPN); rpt.SetParameterValue("MaPN", maPN); rpt.SetParameterValue("HoTen", nguoidung["HOTEN"]); rpt.SetParameterValue("DienThoai", nguoidung["DIENTHOAI"]); rpt.SetParameterValue("DiaChi", nguoidung["DIACHI"]); rpt.SetParameterValue("ThanhToan", CTPN.AsEnumerable().Sum(t => t.Field <Int64>("THANHTIEN"))); rpt.SetParameterValue("NgayXuatHD", pn["NGAYNHAP"]); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.Refresh(); } }
public IActionResult Post([FromBody] ChiTietPN ctPn) { var roweffect = _chiTietPNService.addChiTietPN(ctPn); //if (roweffect == 400) // return Created("Thông báo", "Mã hóa đơn đã tồn tại"); return(Ok(roweffect)); }
public void SuaHang(PhieuNhap kh, int thanhtien, ChiTietPN ds) { PhieuNhapModel ddb = new PhieuNhapModel(); //kh.NgayNhap = DateTime.Now; kh.ThanhTien = thanhtien; ddb.UpdatePN(kh); ChiTietPNModel cdb = new ChiTietPNModel(); cdb.SuaCTPN(ds); //int sl = cdb.LaySoluongTheoMaSPN(ma, ds.MaSP); //SanPhamModel ssp = new SanPhamModel(); //SanPham dss = ssp.LaySanPhamTheoMa(ds.MaSP); //dss.SoLuongTon += sl; }
public ActionResult NhapHangDon(PhieuNhap model, ChiTietPN ctpn) { ViewBag.MaNCC = new SelectList(db.NhaCungCaps.OrderBy(n => n.TenNCC), "MaNCC", "TenNCC", model.MaNCC); model.NgayNhap = DateTime.Now; model.DaXoa = false; db.PhieuNhaps.Add(model); db.SaveChanges(); ctpn.MaPN = model.MaPN; SanPham sp = db.SanPhams.Single(n => n.MaSP == ctpn.MaSP); sp.SoLuongTon += ctpn.SoLuongNhap; db.ChiTietPNs.Add(ctpn); db.SaveChanges(); return(View()); }
public List <ChiTietPN> LayDsPnTheoMa(string ma) { dt = db.LayDuLieu("select * from ChiTietPN inner join PhieuNhap on ChiTietPN.MaPhieuNhap = PhieuNhap.MaPhieuNhap where PhieuNhap.MaPhieuNhap='" + ma + "'"); List <ChiTietPN> ds = new List <ChiTietPN>(); foreach (DataRow r in dt.Rows) { ChiTietPN l = new ChiTietPN(); l.MaPhieuNhap = Convert.ToString(r[0]); l.MaSP = Convert.ToString(r[1]); l.SoLuongNhap = Convert.ToInt32(r[2]); l.DonGia = Convert.ToInt32(r[3]); ds.Add(l); } return(ds); }
public ActionResult NhapHang(string mancc, string masp, string ngaynhap, int soluongnhap, int dongia) { int tongtien = soluongnhap * dongia; PhieuNhap sp = new PhieuNhap(); //sp.MaPhieuNhap = mapn; sp.MaNCC = mancc; sp.NgayNhap = DateTime.Parse(ngaynhap); ChiTietPN pn = new ChiTietPN(); pn.MaSP = masp; pn.SoLuongNhap = soluongnhap; pn.DonGia = dongia; NhapHangBus mhb = new NhapHangBus(); mhb.NhaphangDon(sp, tongtien, pn); ChiTietPNModel pnb = new ChiTietPNModel(); //var ds = ssp.LaySanPham(masp); //ds.SoLuongTon += soluongnhap; //ds.NgayCapNhat = DateTime.Parse(ngaynhap); return(Json(new { success = true, ms = "thanh cong" }, JsonRequestBehavior.AllowGet)); }
public void NhaphangDon(PhieuNhap kh, int thanhtien, ChiTietPN ds) { string ngay = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); PhieuNhapModel ddb = new PhieuNhapModel(); string MHMax = ddb.LayDonHangCungNgay(ngay); //Xử lý sinh mã hóa đơn theo quy tắc string ma = SinhMa(MHMax, ngay); //End kh.MaPhieuNhap = ma; //kh.NgayNhap = DateTime.Now; kh.ThanhTien = thanhtien; ddb.ThemDonHang(kh); ChiTietPNModel cdb = new ChiTietPNModel(); ds.MaPhieuNhap = ma; cdb.LuuCTPN(ds); int sl = cdb.LaySoluongTheoMaSPN(ma, ds.MaSP); SanPhamModel ssp = new SanPhamModel(); SanPham dss = ssp.LaySanPhamTheoMa(ds.MaSP); dss.SoLuongTon += sl; }
public ChiTietPN LayPnTheoMaSP(string ma) { dt = db.LayDuLieu("select cp.MaPhieuNhap,cp.MaSP,cp.SoLuongNhap,cp.DonGia,p.MaNCC,p.NgayNhap,p.ThanhTien from ChiTietPN cp inner join PhieuNhap p on cp.MaPhieuNhap = p.MaPhieuNhap where cp.MaPhieuNhap = '" + ma + "'"); ChiTietPN l = new ChiTietPN(); if (dt.Rows.Count > 0) { l.MaPhieuNhap = Convert.ToString(dt.Rows[0][0]); l.MaSP = Convert.ToString(dt.Rows[0][1]); l.SoLuongNhap = Convert.ToInt32(dt.Rows[0][2]); l.DonGia = Convert.ToInt32(dt.Rows[0][3]); l.PhieuNhap = new PhieuNhap { MaNCC = Convert.ToString(dt.Rows[0][4]), NgayNhap = Convert.ToDateTime(dt.Rows[0][5]), ThanhTien = Convert.ToInt32(dt.Rows[0][6]) }; } else { l = null; } return(l); }
public int addChiTietPN(ChiTietPN chiTietPN) { var roweffect = _dbConnection.Execute($"Insert into ChitietPN values('{chiTietPN.masp}', '{chiTietPN.soluong}')", commandType: CommandType.Text); return(roweffect); }
public int addChiTietPN(ChiTietPN chiTietPN) { var roweffect = _chiTietPNRepository.addChiTietPN(chiTietPN); return(roweffect); }
public void SuaCTPN(ChiTietPN l) { string se = "update ChiTietPN set SoLuongNhap='" + l.SoLuongNhap + "',DonGia='" + l.DonGia + "' where MaPhieuNhap='" + l.MaPhieuNhap + "' and MaSP='" + l.MaSP + "'"; db.ExcuteNonQuery(se); }
public void LuuCTPN(ChiTietPN l) { string se = "insert into ChiTietPN values('" + l.MaPhieuNhap + "', '" + l.MaSP + "', '" + l.SoLuongNhap + "', '" + l.DonGia + "')"; db.ExcuteNonQuery(se); }
public Boolean Update(ChiTietPN l) { return(db.ExcuteNonQuery("update ChiTietPN set MaSP='" + l.MaSP + "',SoLuongNhap='" + l.SoLuongNhap + "',DonGia='" + l.DonGia + "' where MaPhieuNhap='" + l.MaPhieuNhap + "'")); }
public Boolean Insert(ChiTietPN l) { return(db.ExcuteNonQuery("insert into ChiTietPN values('" + l.MaPhieuNhap + "','" + l.MaSP + "','" + l.SoLuongNhap + "','" + l.DonGia + "')")); }
public int updateChiTietPN(ChiTietPN chiTietPN) { var roweffect = _dbConnection.Execute($"Update ChiTietPN SET masp = '{chiTietPN.masp}', soluong = '{chiTietPN.soluong}' where mapn = '{chiTietPN.mapn}'", commandType: CommandType.Text); return(roweffect); }
public IActionResult Put([FromBody] ChiTietPN chiTietPN) { var roweffect = _chiTietPNService.updateChiTietPN(chiTietPN); return(Ok(roweffect)); }
public int updateChiTietPN(ChiTietPN chiTietPN) { var roweffect = _chiTietPNRepository.updateChiTietPN(chiTietPN); return(roweffect); }