public IHttpActionResult Put([FromBody]  CTPhieuXuat x)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest("Not a valid data"));
     }
     CTPhieuXuatDAO.Instance.Update(x.MaCTPX, x.MaPX, x.MaHH, x.SoLuong, x.GiaXuat);
     return(Ok());
 }
        public IHttpActionResult Post([FromBody] CTPhieuXuat x)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Not a valid model"));
            }

            CTPhieuXuatDAO.Instance.Create(x.MaCTPX, x.MaPX, x.MaHH, x.SoLuong, x.GiaXuat);//string MaCTPX, string MaPX, string MaHH, string SoLuong, string GiaXuat
            return(Ok());
        }
예제 #3
0
        public List <CTPhieuXuat> GetList()
        {
            List <CTPhieuXuat> list = new List <CTPhieuXuat>();

            DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.CTPHIEUXUAT");

            foreach (DataRow item in data.Rows)
            {
                CTPhieuXuat obj = new CTPhieuXuat(item);
                list.Add(obj);
            }
            return(list);
        }
        public static List <CTPhieuXuat> ChuyenDoiDTOCTPhieuXuat(DataTable bang)
        {
            List <CTPhieuXuat> kq = new List <CTPhieuXuat>();

            foreach (DataRow dong in bang.Rows)
            {
                CTPhieuXuat a = new CTPhieuXuat();
                a.MaChiTietXuat = dong["MaChiTietXuat"].ToString();
                a.MaPhieuXuat   = dong["MaPhieuXuat"].ToString();
                a.MaSP          = dong["MaSP"].ToString();
                a.DonGiaSP      = float.Parse(dong["DonGiaSP"].ToString());
                a.ThanhTien     = float.Parse(dong["ThanhTien"].ToString());
                a.Thue          = float.Parse(dong["Thue"].ToString());
                a.SoLuongMua    = int.Parse(dong["SoLuongMua"].ToString());
                kq.Add(a);
            }
            return(kq);
        }
예제 #5
0
        public bool DeleteCTPhieuXuat(CTPhieuXuat px)
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(baseAddress);

                //HTTP POST
                var postTask = client.DeleteAsync("ctphieuxuat?MaCTPX=" + px.MaCTPX);
                postTask.Wait();

                var result = postTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    ListCTPhieuXuat = GetListCTPhieuXuat();
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
예제 #6
0
        public bool PutCTPhieuXuat(CTPhieuXuat px)
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(baseAddress);

                //HTTP POST
                var postTask = client.PutAsJsonAsync <CTPhieuXuat>("ctphieuxuat", px);
                postTask.Wait();

                var result = postTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    ListCTPhieuXuat = GetListCTPhieuXuat();
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
예제 #7
0
 // Xóa chi tiết phiếu xuất
 public void XoaCTPX(CTPhieuXuat ctpx)
 {
     dah.ThucThiCauLenhSQL("DELETE FROM tblCTPX where MaPX ='" + ctpx.Mapx + "'");
 }
예제 #8
0
 // Sửa chi tiết phiếu xuất
 public void SuaCTPX(CTPhieuXuat ctpx)
 {
     dah.ThucThiCauLenhSQL("UPDATE tblCTPX SET SoLuongXuat ='" + ctpx.Soluongxuat + "', DonGiaXuat ='" + ctpx.Dongiaxuat + "', ThanhTien =(" + ctpx.Soluongxuat + " * " + ctpx.Dongiaxuat + "), DonViTinh ='" + ctpx.Donvitinh + "' where MaPX ='" + ctpx.Mapx + "'");
 }
예제 #9
0
 // Thêm chi tiết phiếu xuất
 public void ThemCTPX(CTPhieuXuat ctpx)
 {
     dah.ThucThiCauLenhSQL("INSERT INTO tblCTPX VALUES('" + ctpx.Mapx + "','" + ctpx.Masp + "','" + ctpx.Soluongxuat + "','" + ctpx.Dongiaxuat + "',(" + ctpx.Soluongxuat + " * " + ctpx.Dongiaxuat + "),'" + ctpx.Donvitinh + "')");
 }
        private void buttonThem_Click(object sender, EventArgs e)
        {
            //load du lieu
            loadPhieuXuat(XL_PhieuXuat.LayDuLieuPhieuXuat());
            //co hieu
            int cohieu = 1;
            //phieu nhap
            string maphieuxuat       = textBoxMaPhieuXuat.Text;
            string ngayxuat          = dateTimePickerNgayXuat.Value.ToString();
            string manhanvien        = gridLookUpEditNhanVien.Text;
            string khachang          = gridLookUpEditMaKhachHang.Text;
            string dieukhoan         = gridLookUpEditDieuKhoanThanhToan.Text;
            string hinhthucthanhtoan = gridLookUpEditHinhThucThanhToan.Text;
            string hanthanhtoan      = dateTimePickerHanThanhToan.Value.ToString();
            string tientratruoc      = textBoxTienTraTruoc.Text;
            string ngaygiao          = dateTimePickerNgayGiao.Value.ToString();
            //tien
            double TongTien = 0;
            int    soluong;
            float  gia;

            for (int i = 0; i < dataGridViewCTPhieuXuat.Rows.Count; i++)
            {
                //object m = dataGridViewCTPhieuXuat["SoLuong", i].Value;
                //object n = dataGridViewCTPhieuXuat["GiaLucNhap", i].Value;
                object n = dataGridViewCTPhieuXuat.Rows[i].Cells["GiaLucNhap"].Value;
                object m = dataGridViewCTPhieuXuat.Rows[i].Cells["SoLuong"].Value;
                if (m != null && n != null)
                {
                    soluong = int.Parse(m.ToString());
                    gia     = float.Parse(n.ToString());
                    double thue = (soluong * gia) * 0.1;
                    TongTien += ((soluong * gia) + thue);
                }
            }
            textBoxTongTien.Text = TongTien.ToString();
            //xet ma px
            for (int i = 0; i < px.Count; i++)
            {
                if (maphieuxuat == px[i].MaPhieuXuat)
                {
                    cohieu = 0;
                    break;
                }
            }

            //phieunhap
            if (maphieuxuat != "" && cohieu == 1 && ngayxuat != "" && hanthanhtoan != "" && manhanvien != "" && ngaygiao != "" && TongTien != 0 &&
                khachang != "" && dieukhoan != "" && hinhthucthanhtoan != "" && tientratruoc != "" && dataGridViewCTPhieuXuat.Rows.Count - 1 != 0)
            {
                bool ThemPhieuXuat = XL_PhieuXuat.ThemPhieuXuat(maphieuxuat, ngayxuat, manhanvien, khachang, hinhthucthanhtoan, dieukhoan, TongTien, hanthanhtoan, tientratruoc, ngaygiao);
                if (ThemPhieuXuat == true)
                {
                    List <bool> ThemCTPhieuXuat = new List <bool>();
                    int         lengt           = dataGridViewCTPhieuXuat.Rows.Count;
                    //ct phieu nhap
                    int sl = ctpx.Count;
                    for (int i = 0; i < lengt; i++)
                    {
                        //
                        object m     = dataGridViewCTPhieuXuat.Rows[i].Cells["MaSP"].Value;
                        object n     = dataGridViewCTPhieuXuat.Rows[i].Cells["GiaLucNhap"].Value;
                        object o     = dataGridViewCTPhieuXuat.Rows[i].Cells["SoLuong"].Value;
                        object makho = dataGridViewCTPhieuXuat.Rows[i].Cells["MaKho"].Value;
                        if (m != null && n != null && o != null)
                        {
                            CTPhieuXuat temp = new CTPhieuXuat();
                            //cap phat ma ct phieu xuat tu dong
                            sl += 1;
                            temp.MaChiTietXuat = string.Format("CTPX" + sl.ToString());

                            temp.MaPhieuXuat = maphieuxuat;
                            temp.MaSP        = m.ToString();
                            temp.MaKho       = makho.ToString();
                            temp.DonGiaSP    = float.Parse(n.ToString());
                            temp.SoLuongMua  = int.Parse(o.ToString());
                            float thue = 0.1f;
                            temp.Thue = thue;
                            //tien moi loai sp
                            float  soluongsp = int.Parse(o.ToString());
                            float  giasp     = float.Parse(n.ToString());
                            double tienthue  = (soluongsp * giasp * 0.1);
                            double tien      = ((soluongsp * giasp) + tienthue);
                            temp.ThanhTien = float.Parse(tien.ToString());

                            bool Them = XL_CTPhieuXuat.ThemCTPhieuXuat(temp.MaChiTietXuat, temp.MaPhieuXuat, temp.MaSP, temp.MaKho, temp.DonGiaSP, temp.ThanhTien, temp.Thue, temp.SoLuongMua);
                            bool Sua  = XL_SanPham.CapNhatSanPham(temp.MaKho, temp.MaSP, temp.SoLuongMua);

                            //  ThemCTPhieuNhap.Add(Them);
                        }
                    }
                    //bien dem xem co luu dc tat ca k
                    int dem = 0;
                    for (int i = 0; i < ThemCTPhieuXuat.Count; i++)
                    {
                        if (ThemCTPhieuXuat[i] == true)
                        {
                            dem++;
                        }
                    }
                    if (dem == ThemCTPhieuXuat.Count)
                    {
                        MessageBox.Show("Thêm thành công!");
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Thêm thất bại!");
                        this.Close();
                    }
                }
            }
        }
예제 #11
0
 // Xóa chi tiết phiếu xuất
 public void XoaCTPX(CTPhieuXuat ctpx)
 {
     dal.XoaCTPX(ctpx);
 }
예제 #12
0
 // Sửa chi tiết phiếu xuất
 public void SuaCTPX(CTPhieuXuat ctpx)
 {
     dal.SuaCTPX(ctpx);
 }
예제 #13
0
 // Thêm chi tiết phiếu xuất
 public void ThemCTPX(CTPhieuXuat ctpx)
 {
     dal.ThemCTPX(ctpx);
 }