Пример #1
0
        public bool InsertChiTietPhieuNhap(ChiTietPhieuNhap chiTiet)
        {
            int result = 0;

            result = DatabaseDAL.ExecuteNonQuery("exec USP_InsertChitiet_PhieuNhap @sochungtu , @mahang , @soluong , @dongia , @thanhtien , @donvitinh ", new object[] { chiTiet.SoChungTu, chiTiet.MaHang, chiTiet.SoLuongNhap, chiTiet.DonGia, chiTiet.ThanhTien, chiTiet.DonViTinh });
            return(result > 0);
        }
Пример #2
0
 public void delete(String id)
 {
     using (CellphoneComponentEntities db = new CellphoneComponentEntities())
     {
         ChiTietPhieuNhap ctpn = (from item in db.ChiTietPhieuNhaps
                                  where item.MaChiTietPhieuNhap == id
                                  select item).SingleOrDefault();
         db.ChiTietPhieuNhaps.Remove(ctpn);
         db.SaveChanges();
     }
 }
        public bool them(ChiTietPhieuNhap item)
        {
            try
            {
                ketNoi.ChiTietPhieuNhaps.InsertOnSubmit(item);
                ketNoi.SubmitChanges();

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
Пример #4
0
        public void insert(DTO_ChiTietPhieuNhap obj)
        {
            using (CellphoneComponentEntities db = new CellphoneComponentEntities())
            {
                var resultMaHangHoa = db.Database
                                      .SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'")
                                      .FirstOrDefault();
                ChiTietPhieuNhap ctpn = new ChiTietPhieuNhap();
                ctpn.MaChiTietPhieuNhap = obj.MaChiTietPhieuNhap;
                ctpn.MaHangHoa          = resultMaHangHoa;
                ctpn.MaPhieuNhap        = obj.MaPhieuNhap;
                ctpn.SoLuong            = obj.SoLuong;
                ctpn.GiaNhap            = obj.GiaNhap;
                ctpn.ThanhTien          = obj.ThanhTien;

                db.ChiTietPhieuNhaps.Add(ctpn);
                db.SaveChanges();
            }
        }
Пример #5
0
        public void update(DTO_ChiTietPhieuNhap obj)
        {
            using (CellphoneComponentEntities db = new CellphoneComponentEntities())
            {
                var resultMaHangHoa = db.Database
                                      .SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'")
                                      .FirstOrDefault();
                ChiTietPhieuNhap ctpn = new ChiTietPhieuNhap();
                ctpn.MaChiTietPhieuNhap = obj.MaChiTietPhieuNhap;
                ctpn.MaHangHoa          = resultMaHangHoa;
                ctpn.MaPhieuNhap        = obj.MaPhieuNhap;
                ctpn.SoLuong            = obj.SoLuong;
                ctpn.GiaNhap            = obj.GiaNhap;
                ctpn.ThanhTien          = obj.ThanhTien;

                db.ChiTietPhieuNhaps.Attach(ctpn);
                db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
            }
        }
Пример #6
0
 //Thêm loại chi tiết hóa đơn
 public Result InsertCTHD(string maPN, string maHang, string giaNhap, string soluong)
 {
     if (checkPrimaryKeyMaChiTietHoaDon(maPN, maHang) == false)
     {
         return(Result.PRIMARY_KEY);
     }
     try
     {
         ChiTietPhieuNhap hd = new ChiTietPhieuNhap();
         hd.MaPN        = maPN;
         hd.MaHang      = maHang;
         hd.MaKho       = "KHO001";
         hd.SoLuongNhap = int.Parse(soluong);
         hd.GiaNhap     = decimal.Parse(giaNhap);
         hd.ThanhTien   = hd.SoLuongNhap * hd.GiaNhap;
         qlch.ChiTietPhieuNhaps.InsertOnSubmit(hd);
         qlch.SubmitChanges();
         return(Result.SUCCESS);
     }
     catch
     {
         return(Result.FAILED);
     }
 }