private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { DataTable dsBanHang = new DataTable(); dsBanHang = con.GetDataInfo("SELECT NGUOIBAN.ID,NGUOIMUA.SDT,NGUOIMUA.TEN,NGUOIMUA.DIACHI,THUTIEN.PHUONGTHUCTHANHTOAN,THUTIEN.SOTIEN,BANHANG.GIAMGIA,BANHANG.TRANGTHAI FROM BANHANG INNER JOIN NGUOIBAN ON BANHANG.NGUOIBAN_ID = NGUOIBAN.ID INNER JOIN NGUOIMUA ON BANHANG.NGUOIMUA_ID = NGUOIMUA.ID INNER JOIN THUTIEN ON BANHANG.ID = THUTIEN.BANHANG_ID WHERE THUTIEN.BANHANG_ID = " + dataGridView1.Rows[e.RowIndex].Cells["id"].Value + ""); string idBanHang = dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString(); string idNguoiGui = dsBanHang.Rows[0]["ID"].ToString(); string sdtNguoiNhan_txt = dsBanHang.Rows[0]["SDT"].ToString(); string tenNguoiNhan_txt = dsBanHang.Rows[0]["TEN"].ToString(); string diaChiNguoiNhan = dsBanHang.Rows[0]["DIACHI"].ToString(); string nganHang_txt = dsBanHang.Rows[0]["PHUONGTHUCTHANHTOAN"].ToString(); string tienCoctxt = dsBanHang.Rows[0]["SOTIEN"].ToString(); string giamGiatxt = dsBanHang.Rows[0]["GIAMGIA"].ToString(); string trangthaibanhang = dsBanHang.Rows[0]["TRANGTHAI"].ToString(); List <string> soLuongHangBan = new List <string>(); List <string> giaBanHang = new List <string>(); for (int i = 0; i < dgv_temp.Rows.Count; i++) { soLuongHangBan.Add(con.LaySoLuongHangPhieuXuat(idBanHang, dgv_temp.Rows[i].Cells["ID"].Value.ToString())); giaBanHang.Add(con.LayGiaHangPhieuXuat(idBanHang, dgv_temp.Rows[i].Cells["ID"].Value.ToString())); //MessageBox.Show(soLuongHangBan[i] + "-"+giaBanHang[i]); } XUATHANG xUATHANG = new XUATHANG(idBanHang, idNguoiGui, sdtNguoiNhan_txt, tenNguoiNhan_txt, diaChiNguoiNhan, nganHang_txt, tienCoctxt, giamGiatxt, soLuongHangBan, giaBanHang, false, trangthaibanhang); xUATHANG.Show(); }
public async Task <IHttpActionResult> GetXUATHANG(int id) { XUATHANG xUATHANG = await db.XUATHANG.FindAsync(id); if (xUATHANG == null) { return(NotFound()); } return(Ok(xUATHANG)); }
public async Task <IHttpActionResult> PostXUATHANG(XUATHANG xUATHANG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.XUATHANG.Add(xUATHANG); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = xUATHANG.ID }, xUATHANG)); }
public async Task <IHttpActionResult> DeleteXUATHANG(int id) { XUATHANG xUATHANG = await db.XUATHANG.FindAsync(id); if (xUATHANG == null) { return(NotFound()); } db.XUATHANG.Remove(xUATHANG); await db.SaveChangesAsync(); return(Ok(xUATHANG)); }
private void btnXuatHang_Click(object sender, EventArgs e) { foreach (LAYHANG l in lstLAYHANG) { XUATHANG xh = new XUATHANG(); xh.NHAPHANG_ID = l.IDNHAP; xh.CHITIETDH_ID = CTDH.ID; xh.SOLUONGXUAT = l.SOLUONGLAY; xh.GIANHAP = l.GIANHAP; xh.GIABAN = CTDH.DONGIA; xhDAO.insertXUATHANG(xh); //CHITIETNHAPHANG ctnh = new NhapHangDAO().GetCTNHbyId(xh.NHAPHANG_ID); //ctnh.SOLUONGCONLAI = ctnh.SOLUONGNHAP - xh.SOLUONGXUAT; //new NhapHangDAO().updateNHAPHANG(ctnh); } MessageBox.Show("Xong!"); }
public async Task <IHttpActionResult> PutXUATHANG(XUATHANG xUATHANG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Entry(xUATHANG).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { } return(StatusCode(HttpStatusCode.NoContent)); }
public void insertXUATHANG(XUATHANG xh) { cn.Post <XUATHANG>("api/XUATHANG/", xh); }