private void ShowInfoDonNhapHang(DonNhapHang donNhapHang) { txtMaHD.Text = donNhapHang.MaDNH; nhaCungCap = nhacungcapBLL.GetNhaCungCapByID(donNhapHang.MaNCC); txtTenNCC.Text = nhaCungCap.Ten; txtNgayLap.Text = donNhapHang.NgayLap.ToString(); txtSDT.Text = nhaCungCap.SoDienThoai; txtDiaChi.Text = nhaCungCap.DiaChi; txtEmail.Text = nhaCungCap.Email; dgvCTDNH.Rows.Clear(); dgvCTDNH.Refresh(); foreach (HangHoa hh in donNhapHang.DSHangHoa) { DataGridViewRow row = (DataGridViewRow)dgvCTDNH.Rows[0].Clone(); row.Cells[0].Value = hh.MaHH; row.Cells[3].Value = hh.GiaGoc; row.Cells[4].Value = hh.SoLuong; int thanhtien = hh.GiaGoc * hh.SoLuong; row.Cells[5].Value = thanhtien.ToString(); HangHoa hh2 = hangBLL.GetHangHoaByID(hh.MaHH); row.Cells[1].Value = hh2.TenHH; row.Cells[2].Value = hh2.LoaiHang; dgvCTDNH.Rows.Add(row); } lblTotalPrice.Text = donNhapHang.TongTien.ToString(); lblDaTra.Text = donNhapHang.DaTra.ToString(); lblConLai.Text = donNhapHang.ConLai.ToString(); }
public bool updateDonDatHang(DonNhapHang _donNhapHang) { try { SqlCommand cmd = new SqlCommand("DONHAPHANG_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaDNH; cmd.Parameters.Add(new SqlParameter("@ngayLap", SqlDbType.Date)).Value = _donNhapHang.NgayLap; cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaNV; cmd.Parameters.Add(new SqlParameter("@maNCC", SqlDbType.VarChar, 10)).Value = _donNhapHang.MaNCC; cmd.Parameters.Add(new SqlParameter("@tongTien", SqlDbType.Int)).Value = _donNhapHang.TongTien; cmd.Parameters.Add(new SqlParameter("@ngayGiaoDuKien", SqlDbType.Date)).Value = _donNhapHang.NgayGiaoDuKien; cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.VarChar, 100)).Value = _donNhapHang.GhiChu; cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = _donNhapHang.IsActive; if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(false); } }
private void btn_yeucaunhaphang_Click(object sender, EventArgs e) { DonNhapHang dnh = new DonNhapHang() { LyDo = txt_lydo.Text, NguoiLap = this.NhanVien.ID, NCC = ((NhaCungCap)comb_ncc.SelectedItem).ID, NgayLap = DateTime.Now }; DonNhapHang kq = DonNhapHang_BUL.Them(dnh); if (kq != null) { bool rs1 = ChiTietDonNhapHang_BUL.themList(kq.ID, this.ListChiTietDNH); if (rs1) { MessageSucess(); } else { MesageFaild(); } } else { MesageFaild(); } }
private void dgvDSDonNhapHang_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1) { donNhapHang = donnhaphangBLL.GetDonNhapHangByID(dgvDSDonNhapHang.Rows[e.RowIndex].Cells[0].Value.ToString()); ShowInfoDonNhapHang(donNhapHang); } }
private void frmAddDonNhapHang_Load(object sender, EventArgs e) { donNhapHang = new DonNhapHang(); dgvHangHoa.DataSource = hangBLL.LoadDanhSachHHCungCap(); cboLoaiHang.DataSource = loaiBLL.LoadAll(); cboLoaiHang.DisplayMember = "TenLoai"; cboLoaiHang.ValueMember = "ID"; cboLoaiHang.SelectedIndex = -1; }
public HttpResponseMessage PostDonNhapHang(DonNhapHang item) { DonNhapHangServices.AddDonNhapHang(item); var response = Request.CreateResponse <DonNhapHang>(HttpStatusCode.Created, null); string uri = Url.Link("DefaultApi", null); response.Headers.Location = new Uri(uri); return(response); }
public bool CapNhatCongNo(DonNhapHang dnh, int traThem) { string spName = "UPDATE_DONNHAPHANG"; string[] pNames = { "@MADNH", "@MANCC", "@NGAYNHAP", "@TONGTIEN", "@DATRA" }; object[] pValues = { dnh.MaDNH, dnh.MaNCC, dnh.NgayLap, dnh.TongTien, dnh.DaTra + traThem }; int count = db.ExecuteStoredProcedure(spName, pNames, pValues); return(count > 0); }
public bool Them(DonNhapHang dnh) { string query = "Insert INTO DonNhapHang( MaDNH, MaDTBH, MaNV, NgayLap, LydoNhap, TongTien) VALUES ( @MaDTH , @MaDTBH , @MaNV , @NgayLap , @LyDoNhap , @TongTien ) "; object[] para = new object[] { dnh.MaDNH, dnh.MaDT, dnh.MaNV, dnh.NgayLap, dnh.LyDo, dnh.TongTien }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }
public frmCapNhatCongNo(DonNhapHang donNhapHang, string tenNCC) { InitializeComponent(); this.donNhapHang = donNhapHang; lblMaHD.Text = donNhapHang.MaDNH; lblTen.Text = tenNCC; lblNgayLap.Text = donNhapHang.NgayLap.ToString(); lblTongTien.Text = donNhapHang.TongTien.ToString(); lblConNo.Text = donNhapHang.ConLai.ToString(); lblConLai.Text = donNhapHang.ConLai.ToString(); }
static public DonNhapHang Them(DonNhapHang dnh) { DonNhapHang rs = null; using (PTTKHTEntities context = new PTTKHTEntities()) { context.DonNhapHangs.Add(dnh); context.SaveChanges(); rs = dnh; } return(rs); }
private void dgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1) { donNhapHangBLL = new DonNhapHangBLL(); string maHD = dgvHoaDon.Rows[e.RowIndex].Cells[0].Value.ToString(); donNhapHang = donNhapHangBLL.GetDonNhapHangByID(maHD); txtMaHD.Text = donNhapHang.MaDNH; txtNgayLap.Text = donNhapHang.NgayLap.ToString(); txtConNo.Text = donNhapHang.ConLai.ToString(); txtTongTien.Text = donNhapHang.TongTien.ToString(); } }
public DonNhapHang GetDonNhapHangByID(string id) { DonNhapHang lh = new DonNhapHang(); foreach (DonNhapHang hd in list) { if (hd.MaDNH == id) { lh = hd; break; } } return(lh); }
public static List <DonNhapHang> GetList() { DataAccessHelper db = new DataAccessHelper(); DataTable dt = db.GetDataTable("SELECT * FROM DonNhapHang"); List <DonNhapHang> list = new List <DonNhapHang>(); foreach (DataRow item in dt.Rows) { DonNhapHang hd = new DonNhapHang(item); hd.DSHangHoa = GetHangHoaTrongDonNhapHang(hd.MaDNH); list.Add(hd); } return(list); }
public bool AddNewChiTietDNH(DonNhapHang dnh) { int count = 1; string spName = "Insert_CTDNH"; string maHD = GetMaDNHLastest(dnh.MaNCC, dnh.NgayLap); foreach (var hh in dnh.DSHangHoa) { string[] pNames = { "@MaDNH", "@MaHH", "@SoLuong" }; object[] pValues = { maHD, hh.MaHH, hh.SoLuong }; count *= db.ExecuteStoredProcedure(spName, pNames, pValues); } return(count > 0); }
public bool AddNewDonNhapHang(DonNhapHang dnh) { string spName = "Insert_DonNhapHang"; string[] pNames = { "@MaNCC", "@NgayNhap", "@TongTien", "@DaTra" }; object[] pValues = { dnh.MaNCC, dnh.NgayLap, dnh.TongTien, dnh.DaTra }; int count = db.ExecuteStoredProcedure(spName, pNames, pValues); if (count > 0) { return(AddNewChiTietDNH(dnh)); } else { return(false); } }
public static bool XacNhanDonNhap(int IDDonTra, int IDNguoiXacNhan) { bool rs = false; using (PTTKHTEntities context = new PTTKHTEntities()) { DonNhapHang abc = context.DonNhapHangs.SingleOrDefault(b => b.ID == IDDonTra); abc.NguoiXacNhan = IDNguoiXacNhan; abc.NgayXacNhan = DateTime.Now; foreach (ChiTietDonNhapHang ct in abc.ChiTietDonNhapHangs) { ct.HangHoa.SoLuongTra += ct.SoLuong; } int index = context.SaveChanges(); rs = true; } return(rs); }
public static void AddDonNhapHang(DonNhapHang donNhapHang) { HttpClient client = new HttpClient(); client.BaseAddress = new Uri("https://localhost:44396/api/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); try { HttpResponseMessage response = client.PostAsJsonAsync("DonNhapHang", donNhapHang).Result; response.EnsureSuccessStatusCode(); } catch (Exception e) { throw e; } }
private void btnLapDon_Click(object sender, EventArgs e) { DonNhapHang dnh = new DonNhapHang(int.Parse(tbMaDNH.Text), int.Parse(cbDT.SelectedValue.ToString()), int.Parse(cbMaNV.SelectedValue.ToString()), DateTime.ParseExact(dtpk_NgayLap.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture), tbLyDoNhap.Text, 0); if (DonNhapHangBUS.Instance.Them(dnh)) { MessageBox.Show("Thêm thành công"); dtgvDNH.DataSource = DonNhapHangBUS.Instance.HienThi(); //MHDonNhapHang_Load(sender, e); MessageBox.Show("Thêm chi tiết đơn nhập hàng"); MHCTDonNhapHang nh = new MHCTDonNhapHang(); this.Hide(); nh.Show(); } else { MessageBox.Show("Lỗi"); } }
public bool addDonNhapHang(DonNhapHang _donNhapHang) { try { SqlCommand cmd = new SqlCommand("DONHAPHANG_Insert", conn); cmd.CommandType = CommandType.StoredProcedure; _maDNH = cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10)); _ngayLap = cmd.Parameters.Add(new SqlParameter("@ngayLap", SqlDbType.Date)); _maNV = cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.NVarChar, 10)); _maNCC = cmd.Parameters.Add(new SqlParameter("@maNCC", SqlDbType.NVarChar, 10)); _tongTien = cmd.Parameters.Add(new SqlParameter("@tongTien", SqlDbType.Int)); _ngayGiaoDuKien = cmd.Parameters.Add(new SqlParameter("@ngayGiaoDuKien", SqlDbType.Date)); _ghiChu = cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.NVarChar, 100)); _isActive = cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)); //Get value to parameters: _maDNH.Value = _donNhapHang.MaDNH; _ngayLap.Value = _donNhapHang.NgayLap; _maNV.Value = _donNhapHang.MaNV; _maNCC.Value = _donNhapHang.MaNCC; _tongTien.Value = _donNhapHang.TongTien; _ngayGiaoDuKien.Value = _donNhapHang.NgayGiaoDuKien; _ghiChu.Value = _donNhapHang.GhiChu; _isActive.Value = _donNhapHang.IsActive; if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(false); } }
public DonNhapHang DocThongTin(int madth) { string query = "Select * From DonNhapHang where MaDTH = @MaDTH "; object[] para = new object[] { madth }; DataTable data = DataProvider.Instance.ExecuteQuery(query, para); foreach (DataRow item in data.Rows) { int MaDNH = (int)item["MaDNH"]; int MaDT = (int)item["MaDTBH"]; int MaNV = (int)item["MaNV"]; DateTime NgayLap = DateTime.Parse(item["NgayLap"].ToString()); string Lydo = item["LyDoNhap"].ToString(); int TongTien = (int)item["TongTien"]; DonNhapHang newdnh = new DonNhapHang(MaDNH, MaDT, MaNV, NgayLap, Lydo, TongTien); return(newdnh); } return(null); }
public async Task <DonNhapHang> UpdateById(string id, DonNhapHangForUpdateDto donNhapHang) { var oldRecord = await _context.DanhSachDonNhapHang.AsNoTracking().FirstOrDefaultAsync(x => x.MaDonNhapHang == id); var tinhTrang = ""; if (donNhapHang.DaThanhToan == 0) { tinhTrang = "Chưa thanh toán"; } else if (donNhapHang.DaThanhToan != donNhapHang.ThanhTien && donNhapHang.DaThanhToan > 0) { tinhTrang = "Đã thanh toán một phần"; } else { tinhTrang = "Đã thanh toán"; } var donNhapHangToUpdateById = new DonNhapHang { MaDonNhapHang = id, MaNhaCungCap = donNhapHang.MaNhaCungCap, MaNhanVien = donNhapHang.MaNhanVien, NgayGiaoHang = donNhapHang.NgayGiaoHang, NgayLap = donNhapHang.NgayLap, GhiChu = donNhapHang.GhiChu, ThanhTien = donNhapHang.ThanhTien, DaThanhToan = donNhapHang.DaThanhToan, TinhTrang = tinhTrang, TrangThai = donNhapHang.TrangThai, ThoiGianTao = oldRecord.ThoiGianTao, DaXoa = oldRecord.DaXoa }; _context.DanhSachDonNhapHang.Update(donNhapHangToUpdateById); await _context.SaveChangesAsync(); return(donNhapHangToUpdateById); }
public async Task <DonNhapHang> Create(DonNhapHangForCreateDto donNhapHang) { var tinhTrang = ""; if (donNhapHang.DaThanhToan == 0) { tinhTrang = "Chưa thanh toán"; } else if (donNhapHang.DaThanhToan != donNhapHang.ThanhTien && donNhapHang.DaThanhToan > 0) { tinhTrang = "Đã thanh toán một phần"; } else { tinhTrang = "Đã thanh toán"; } var newDonNhapHang = new DonNhapHang { MaDonNhapHang = GenerateId(), MaNhaCungCap = donNhapHang.MaNhaCungCap, MaNhanVien = donNhapHang.MaNhanVien, NgayGiaoHang = donNhapHang.NgayGiaoHang, NgayLap = donNhapHang.NgayLap, GhiChu = donNhapHang.GhiChu, ThanhTien = donNhapHang.ThanhTien, DaThanhToan = donNhapHang.DaThanhToan, TinhTrang = tinhTrang, ThoiGianCapNhat = DateTime.Now, ThoiGianTao = DateTime.Now, TrangThai = 1, DaXoa = 0 }; await _context.DanhSachDonNhapHang.AddAsync(newDonNhapHang); await _context.SaveChangesAsync(); return(newDonNhapHang); }
public bool lapdonnhaphang(int PNVQL) { DataTable Sanpham = Dal_hanghoa.GetNhapHang(PNVQL); foreach (DataRow row in Sanpham.Rows) { DonNhapHang dnh = new DonNhapHang(); dnh.Masp = row.Field <int>("MASP"); dnh.NCC = row.Field <int>("NCC"); dnh.NVPhuTrach = PNVQL; dnh.Soluong = row.Field <int>("SLToiDa") - row.Field <int>("SLTonKho"); DateTime NgayNhap = DateTime.Now; dnh.NgayNhap = NgayNhap.Date.ToString("MM/dd/yyyy"); dnh.Lydo = "HET HANG"; dnh.XacNhan = 0; if (!Dal_hanghoa.InsertNhapHang(dnh)) { return(false); } } return(true); }
public bool InsertNhapHang(DonNhapHang DNH) { try { SqlConnection conn = DBUtils.GetDBConnection(); SqlCommand com = new SqlCommand("insert into LICHSU_NHAP_NHACUNGCAP (MASP, NGAYNHAP, SOLUONG, NVPHUTRACH, XACNHAN, NCC,LYDONHAPHANG,QUANLY) values (@MASP,@NGAYNHAP,@SOLUONG,@NVPHUTRACH,@XACNHAN,@NCC,@LYDO,NULL)", conn); conn.Open(); com.Parameters.AddWithValue("@MASP", DNH.Masp); com.Parameters.AddWithValue("@NGAYNHAP", DNH.NgayNhap); com.Parameters.AddWithValue("@SOLUONG", DNH.Soluong); com.Parameters.AddWithValue("@NVPHUTRACH", DNH.NVPhuTrach); com.Parameters.AddWithValue("@XACNHAN", DNH.XacNhan); com.Parameters.AddWithValue("@NCC", DNH.NCC); com.Parameters.AddWithValue("@LYDO", DNH.Lydo); com.ExecuteNonQuery(); conn.Close(); return(true); } catch { return(false); } }
public static void AddDonNhapHang(DonNhapHang item) { try { string connectionString = String.Format("Server={0};Database={1};Integrated Security={2};", Properties.Resources.ServerName, Properties.Resources.DatabaseName, Properties.Resources.Integrated_Security ); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("ADD_DONNHAPHANG", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@NGAYLAP", item.NgayLap)); cmd.Parameters.Add(new SqlParameter("@MANV", item.MaNV)); cmd.ExecuteNonQuery(); } } catch { throw; } }
public DonNhapHang getDonNhapHang(string _maDonNhapHang) { try { SqlCommand cmd = new SqlCommand("DONNHAPHANG_getDonNhapHang", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maDNH", SqlDbType.VarChar, 10)).Value = _maDNH; if (conn.State != ConnectionState.Open) { conn.Open(); } SqlDataReader dr = cmd.ExecuteReader(); DonNhapHang donnhaphang = null; if (dr.Read()) { donnhaphang = new DonNhapHang(); donnhaphang.MaDNH = dr["MaNV"].ToString(); donnhaphang.NgayLap = (DateTime)dr["NgayLap"]; donnhaphang.MaNV = dr["MaNV"].ToString(); donnhaphang.MaNCC = dr["MaNCC"].ToString(); donnhaphang.TongTien = (int)dr["TongTien"]; donnhaphang.NgayGiaoDuKien = (DateTime)dr["NgayGiaoDuKien"]; donnhaphang.GhiChu = dr["GhiChu"].ToString(); donnhaphang.IsActive = (Convert.ToInt32(dr["IsActive"]) == 1) ? true : false; } conn.Close(); return(donnhaphang); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(null); } }
public bool updateDonDatHang(DonNhapHang _donnhaphang) { return(objDNH.updateDonDatHang(_donnhaphang)); }
public bool AddNewHoaDon(DonNhapHang dnh) { return(dal.AddNewDonNhapHang(dnh)); }
public bool Them(DonNhapHang dth) { return(DonNhapHangDAC.Instance.Them(dth)); }
public bool CapNhatCongNo(DonNhapHang dnh, int traThem) { return(dal.CapNhatCongNo(dnh, traThem)); }