public ActionResult LapPhieu(FormCollection collection) { PhieuChuyenKho PCK = new PhieuChuyenKho(); List <PhieuCK> listPCK = LayPhieu(); PCK.SoLuongChuyen = TongSoLuong(); PCK.FromKho = int.Parse(User.TenCuaHang()); PCK.NgayTao = DateTime.Now; PCK.ToKho = int.Parse(collection["KhoHangId"]); PCK.TrangThaiId = 0; db.PhieuChuyenKhos.Add(PCK); foreach (var item in listPCK) { CTPhieuChuyenKho CTPCK = new CTPhieuChuyenKho(); CTPCK.PhieuChuyenKhoId = PCK.PhieuChuyenKhoId; CTPCK.SanPhamId = item.pSanPhamId; CTPCK.SoLuongChuyen = item.pSoLuongChuyen; db.CTPhieuChuyenKhos.Add(CTPCK); var get = db.SanPhams.SingleOrDefault(n => n.SanPhamId == item.pSanPhamId); get.tempSoLuong = (get.SoLuong - item.pSoLuongChuyen); db.Entry(get).State = EntityState.Modified; } db.SaveChanges(); InformMailAsync(); Session["PhieuCK"] = null; return(RedirectToAction("PhieuChuyenHang")); }
private void BtnLuu_Click(object sender, EventArgs e) { if (gvPhieuChuyenKho.Rows.Count <= 1) { MessageBox.Show("Dữ liệu trống, không thể lưu"); return; } if (lkueNguoiChuyen.EditValue == null) { MessageBox.Show("Vui lòng chọn Người nhận"); return; } if (lkueKhoNhan.EditValue == null) { MessageBox.Show("Chưa chọn Kho Nhận"); return; } PhieuChuyenKho pck = new PhieuChuyenKho(); pck.MaPhieuChuyen = txtMaPhieu.Text; pck.KhoXuatHang = lkueKhoXuat.EditValue.ToString(); pck.KhoNhanHang = lkueKhoNhan.EditValue.ToString(); pck.NVChuyen = lkueNguoiChuyen.EditValue.ToString(); pck.NVNhan = lkueNguoiNhan.EditValue.ToString(); pck.NgayLap = DateTime.Parse(deNgayLap.EditValue.ToString()); pck.GhiChu = rtxtGhiChu.Text; pck.PhieuChuyenTay = txtPhieuChuyenTay.Text; List <CT_PhieuChuyenKho> lstCT_PCK = new List <CT_PhieuChuyenKho>(); for (int i = 0; i < gvPhieuChuyenKho.Rows.Count - 1; i++) { CT_PhieuChuyenKho ct_pck = new CT_PhieuChuyenKho(); ct_pck.MaPhieuChuyen = pck.MaPhieuChuyen; ct_pck.MaHang = gvPhieuChuyenKho.Rows[i].Cells["colMaHang"].Value.ToString(); ct_pck.SoLuong = int.Parse(gvPhieuChuyenKho.Rows[i].Cells["colSoLuong"].Value.ToString()); lstCT_PCK.Add(ct_pck); } nv_pck.ThemPhieuChuyenKho(pck); foreach (CT_PhieuChuyenKho ct in lstCT_PCK) { nv_ctpc.ThemCTPhieuChuyen(ct); } AddNhatKy("Thêm", TenChucNang); MessageBox.Show("Thêm thành công"); if (cbInSauKhiLuu.Checked) { //print preview AddNhatKy("In", TenChucNang); PrintPreview(); } }
public int ThemPhieuChuyenKho(PhieuChuyenKho pc) { string sql = "insert into PHIEUCHUYENKHO(MaPhieuChuyen,KhoXuatHang,KhoNhanHang,NVChuyen," + "NVNhan,PhieuChuyenTay,GhiChu,NgayLap) " + string.Format("values ('{0}','{1}','{2}','{3}',", pc.MaPhieuChuyen, pc.KhoXuatHang, pc.KhoNhanHang, pc.NVChuyen) + string.Format("'{0}','{1}',N'{2}','{3}')", pc.NVNhan, pc.PhieuChuyenTay, pc.GhiChu, pc.NgayLap); return(Execute.InsertUpdateDelete(sql)); }
public int ThemPhieuChuyenKho(PhieuChuyenKho pc) { return(xl_pc.ThemPhieuChuyenKho(pc)); }