protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
{
SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.MaSanPham.ToString() == GridView3.Rows[GridView3.SelectedIndex].Cells[0].Text.ToString());
ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.MaSanPham == sanpham.MaSanPham && p.SoHoaDon.ToString() == GridView3.Rows[GridView3.SelectedIndex].Cells[6].Text);
txtSoHD.Enabled = false;
txtThongSoKyThuat.Enabled = false;
txtTenSP.Enabled = false;
txtNhaSanXuat.Enabled = false;
txtLoaiSP.Enabled = false;
FileUpload1.Enabled = false;
btnupload.Enabled = false;
txtNhaSanXuat.Enabled = false;
txtThongSoKyThuat.Enabled = false;
txtBaoHanh.Enabled = false;
if (sanpham.HinhAnh != null)
{
hinhanh.ImageUrl = sanpham.HinhAnh;
hinhanh.DataBind();
}
txtNhaSanXuat.SelectedItem.Text = sanpham.NhaSanXuat;
txtSoHD.SelectedItem.Text = chitietnhap.SoHoaDon.ToString();
txtNhaCungCap.SelectedItem.Text = chitietnhap.NhaCungCap.TenNhaCungCap;
txtSoLuong.Text = chitietnhap.SoLuongNhap.ToString();
txtTenSP.SelectedItem.Text = sanpham.TenSP;
txtGiaNhap.Text = chitietnhap.GiaNhap.ToString();
txtGhichu.Text = chitietnhap.GhiChu;
}
private void btnluu2_Click(object sender, EventArgs e)
{
if (them2)
{
ChiTietNhap a = new ChiTietNhap();
a.MaPN = txtma_PN.Text.Trim();
a.MaCTN = txtmaCTN.Text.Trim();
a.MaHH = txtmaHH.Text.Trim();
a.DonGia = float.Parse(txtdonGia.Text);
a.SoLuong = int.Parse(txt_soLuong.Text);
if (BUS.BUS.them_ctn(a) != 0)
{
MessageBox.Show("Them thanh cong");
dgvCTN.DataSource = BUS.BUS.xuat_ctn(txtma_PN.Text);
}
them2 = false;
dgvphieuNhap.DataSource = BUS.BUS.xuat_pn();
}
else if (sua2)
{
ChiTietNhap a = new ChiTietNhap();
a.MaPN = txtma_PN.Text.Trim();
a.MaCTN = txtmaCTN.Text.Trim();
a.MaHH = txtmaHH.Text.Trim();
a.DonGia = float.Parse(txtdonGia.Text);
a.SoLuong = int.Parse(txt_soLuong.Text);
if (BUS.BUS.sua_ctn(a) != 0)
{
MessageBox.Show("sua thanh cong");
dgvCTN.DataSource = BUS.BUS.xuat_ctn(txtma_PN.Text);
}
sua2 = false;
dgvphieuNhap.DataSource = BUS.BUS.xuat_pn();
}
}
protected void btnSua_Click(object sender, EventArgs e)
{
SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.TenSP == txtTenSP.Text);
ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.SoHoaDon.ToString() == txtSoHD.Text && p.MaSanPham == sanpham.MaSanPham);
if (chitietnhap == null)
{
CustomValidator1.ErrorMessage = "Bạn hãy chọn một chi tiết nhập để sửa ";
CustomValidator1.IsValid = false;
}
else
{
updatesoluongsp("update", chitietnhap);
chitietnhap.SoLuongNhap = Convert.ToInt32(txtSoLuong.Text);
chitietnhap.GiaNhap = Convert.ToDouble(txtGiaNhap.Text);
db.SubmitChanges();
LoadTatCaSP();
}
txtSoHD.Enabled = true;
txtThongSoKyThuat.Enabled = true;
txtTenSP.Enabled = true;
txtNhaSanXuat.Enabled = true;
txtLoaiSP.Enabled = true;
FileUpload1.Enabled = true;
btnupload.Enabled = true;
txtNhaSanXuat.Enabled = true;
txtThongSoKyThuat.Enabled = true;
}
public static int Delete_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mapn", a.MaPN),
};
return(DataProvider.ExecuteNonQuery("Delete_CTN", para));
}
public ActionResult DeleteConfirmed(int id)
{
ChiTietNhap chiTietNhap = db.ChiTietNhaps.Find(id);
db.ChiTietNhaps.Remove(chiTietNhap);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//xóa
public static int xoa_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTN", a.MaCTN),
};
return(Dataprovider.ExecuteNonQuery("xoa_CTN", para));
}
private void btn_save_Click(object sender, EventArgs e)
{
PhieuNhap pn2 = new PhieuNhap();
pn2.MaPN = txt_MaPN.Text;
pn2.NgayLap = date_NL.Value;
pn2.MaNCC = cmb_NCC.SelectedValue.ToString();
pn2.MaTT = cmb_TenTT.SelectedValue.ToString();
ChiTietNhap ctn = new ChiTietNhap();
ctn.MaPN = txt_MaPN.Text;
ctn.MaTS = cmb_TenTS.SelectedValue.ToString();
ctn.SoLuong = int.Parse(txt_SL.Text);
ctn.DonGia = int.Parse(txt_Gia.Text);
if (insert)
{
if (MessageBox.Show("Bạn muốn lưu dữ liệu được thêm mơi không???", "SAVE", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
DataTable test = new DataTable(); // kiểm tra mã đã có trong bảng chưa???
string sql = "select *from PhieuNhap where MaPN= '" + txt_MaPN.Text + "'";
test = DataProvider.GetData(sql);
int i = test.Rows.Count;
if (i > 0)
{
BUS.Insert_CTN(ctn);
MessageBox.Show("Đã thêm chi tiết mượn vào " + txt_MaPN.Text, "Thông Báo !!!", MessageBoxButtons.OK, MessageBoxIcon.Information);
gridControl2.DataSource = BUS.Select_PN();
}
else
{
BUS.Insert_PN(pn2);
BUS.Insert_CTN(ctn);
MessageBox.Show("Đã lưu thành công");
gridControl2.DataSource = BUS.Select_PN();
}
}
}
if (update)
{
if (MessageBox.Show("Bạn muốn lưu thay đổi không???", "SAVE", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
gridControl2.DataSource = BUS.Update_PN(pn2);
gridControl2.DataSource = BUS.Update_CTN(ctn);
MessageBox.Show("Đã lưu thành công");
gridControl2.DataSource = BUS.Select_PN();
}
}
txt_MaPN.Enabled = false;
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_delete.Enabled = true;
btn_update.Enabled = true;
btn_insert.Enabled = true;
}
public JsonResult CreateCT_PNK(string ma_pnk, string ma_hang_s, string ma_kho_s, string so_luong_s, string don_gia_s)
{
bool success = true;
string message = "Kết quả: Hoàn thành việc nhập kho!";
var daoCT = new ChiTietNhapDao();
var daoHH = new HangHoaDao();
var daoKho = new KhoHangDao();
string[] lst_ma_hang = ma_hang_s.Split(',');
string[] lst_so_luong = so_luong_s.Split(',');
string[] lst_don_gia = don_gia_s.Split(',');
string[] lst_ma_kho = ma_kho_s.Split(',');
try
{
for (int i = 0; i < lst_ma_hang.Length; i++)
{
ChiTietNhap obj = new ChiTietNhap();
obj.NhapID = ma_pnk;
obj.MaHH = lst_ma_hang[i].ToString();
obj.SoLuong = int.Parse(lst_so_luong[i].ToString());
obj.DonGia = decimal.Parse(lst_don_gia[i].ToString());
obj.MaKho = int.Parse(lst_ma_kho[i].ToString());
obj.CreatedDate = DateTime.Now;
obj.CreateBy = Session["UserName"].ToString();
obj.TongTien = decimal.Parse(lst_don_gia[i].ToString()) * int.Parse(lst_so_luong[i].ToString());
daoCT.Insert(obj);
daoHH.NhapHang(lst_ma_hang[i].ToString(), int.Parse(lst_so_luong[i].ToString()),
decimal.Parse(lst_don_gia[i].ToString()), Session["UserName"].ToString());
if (daoKho.CheckKho(int.Parse(lst_ma_kho[i].ToString()), lst_ma_hang[i].ToString()))
{
daoKho.NhapThemHang(int.Parse(lst_ma_kho[i].ToString()),
lst_ma_hang[i].ToString(), int.Parse(lst_so_luong[i].ToString()));
}
else
{
KhoHang kho_hang = new KhoHang();
kho_hang.MaKho = int.Parse(lst_ma_kho[i].ToString());
kho_hang.MaHH = lst_ma_hang[i].ToString();
kho_hang.SoLuong = int.Parse(lst_so_luong[i].ToString());
daoKho.Insert(kho_hang);
}
}
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
return(Json(new
{
success = success,
message = message
}));
}
public ActionResult Edit(ChiTietNhap ctn)
{
if (ModelState.IsValid)
{
db.Entry(ctn).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ctn));
}
public ActionResult Edit([Bind(Include = "STT,MaPhieuNhap,MaThuoc,MaNCC,SoLuong,NgayNhap")] ChiTietNhap chiTietNhap)
{
if (ModelState.IsValid)
{
db.Entry(chiTietNhap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chiTietNhap));
}
public ActionResult Create(ChiTietNhap ctn)
{
if (ModelState.IsValid)
{
db.ChiTietNhaps.Add(ctn);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public static int Update_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mapn", a.MaPN),
new SqlParameter("@mats", a.MaTS),
new SqlParameter("@soluong", a.SoLuong),
new SqlParameter("@dongia", a.DonGia),
};
return(DataProvider.ExecuteNonQuery("Update_CTN", para));
}
public ActionResult Create([Bind(Include = "STT,MaPhieuNhap,MaThuoc,MaNCC,SoLuong,NgayNhap")] ChiTietNhap chiTietNhap)
{
if (ModelState.IsValid)
{
db.ChiTietNhaps.Add(chiTietNhap);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chiTietNhap));
}
//thêm
public static int them_CTN(ChiTietNhap a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTN", a.MaCTN),
new SqlParameter("@maPN", a.MaPN),
new SqlParameter("@maHH", a.MaHH),
new SqlParameter("@soLuong", a.SoLuong),
new SqlParameter("@donGia", a.DonGia),
};
return(Dataprovider.ExecuteNonQuery("them_CTN", para));
}
public ActionResult Edit([Bind(Include = "STT,MaPN,MaHH,SoLuong,NgayNhap,MaNCC")] ChiTietNhap chiTietNhap)
{
if (ModelState.IsValid)
{
db.Entry(chiTietNhap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHH = new SelectList(db.HangHoas, "MaHH", "TenHH", chiTietNhap.MaHH);
ViewBag.MaPN = new SelectList(db.PhieuNhaps, "MaPN", "NhaCC_MaNCC", chiTietNhap.MaPN);
return(View(chiTietNhap));
}
public static ChiTietNhapDTO MappingChiTietNhapDTO(this ChiTietNhap chitietnhap)//Tên biết viết đầu là chữ thường để phân biệt với kiểu dữ liệu
{
return(new ChiTietNhapDTO
{
MaNhap = chitietnhap.MaNhap,
MaMon = chitietnhap.MaMon,
DVT = chitietnhap.DVT,
Ngay = chitietnhap.Ngay,
TongTien = chitietnhap.TongTien,
SoLuong = chitietnhap.SoLuong
});
}
public ActionResult Edit([Bind(Include = "STT,MaPhieuNhap,MaVatTu,SoLuong,NgayNhap,MaNCC")] ChiTietNhap chiTietNhap)
{
if (ModelState.IsValid)
{
db.Entry(chiTietNhap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaNCC = new SelectList(db.NCCs, "MaNCC", "TenNCC", chiTietNhap.MaNCC);
ViewBag.MaPhieuNhap = new SelectList(db.PhieuNhaps, "MaPhieuNhap", "MaNCC", chiTietNhap.MaPhieuNhap);
ViewBag.MaVatTu = new SelectList(db.VatTus, "MaVatTu", "TenVatTu", chiTietNhap.MaVatTu);
return(View(chiTietNhap));
}
private void btnxoa2_Click(object sender, EventArgs e)
{
ChiTietNhap a = new ChiTietNhap();
a.MaCTN = txtmaCTN.Text.Trim();
if (BUS.BUS.xoa_CTN(a) != 0)
{
MessageBox.Show("xoa thanh cong");
dgvCTN.DataSource = BUS.BUS.xuat_ctn(txtma_PN.Text);
}
dgvphieuNhap.DataSource = BUS.BUS.xuat_pn();
}
// GET: ChiTietNhaps/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietNhap chiTietNhap = db.ChiTietNhaps.Find(id);
if (chiTietNhap == null)
{
return(HttpNotFound());
}
return(View(chiTietNhap));
}
// GET: ChiTietNhaps/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietNhap chiTietNhap = db.ChiTietNhap.Find(id);
if (chiTietNhap == null)
{
return(HttpNotFound());
}
ViewBag.MaPN = new SelectList(db.PhieuNhapSP, "MaPN", "MaNCC", chiTietNhap.MaPN);
ViewBag.SerialNumber = new SelectList(db.SanPham, "SerialNumber", "SerialNumber", chiTietNhap.SerialNumber);
return(View(chiTietNhap));
}
// GET: ChiTietNhaps/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietNhap chiTietNhap = db.ChiTietNhaps.Find(id);
if (chiTietNhap == null)
{
return(HttpNotFound());
}
ViewBag.MaHH = new SelectList(db.HangHoas, "MaHH", "TenHH", chiTietNhap.MaHH);
ViewBag.MaPN = new SelectList(db.PhieuNhaps, "MaPN", "NhaCC_MaNCC", chiTietNhap.MaPN);
return(View(chiTietNhap));
}
// GET: ChiTietNhaps/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietNhap chiTietNhap = db.ChiTietNhaps.Find(id);
if (chiTietNhap == null)
{
return(HttpNotFound());
}
ViewBag.MaNCC = new SelectList(db.NCCs, "MaNCC", "TenNCC", chiTietNhap.MaNCC);
ViewBag.MaPhieuNhap = new SelectList(db.PhieuNhaps, "MaPhieuNhap", "MaNCC", chiTietNhap.MaPhieuNhap);
ViewBag.MaVatTu = new SelectList(db.VatTus, "MaVatTu", "TenVatTu", chiTietNhap.MaVatTu);
return(View(chiTietNhap));
}
void updatesoluongsp(string type, ChiTietNhap chitietnhap)
{
SanPhams sp = db.SanPhams.SingleOrDefault(p => p.MaSanPham == chitietnhap.MaSanPham);
if (type == "insert")
{
sp.SoLuong = sp.SoLuong + Convert.ToInt16(txtSoLuong.Text);
db.SubmitChanges();
}
if (type == "update")
{
sp.SoLuong = sp.SoLuong - chitietnhap.SoLuongNhap + Convert.ToInt32(txtSoLuong.Text);
db.SubmitChanges();
}
if (type == "delete")
{
sp.SoLuong = sp.SoLuong - chitietnhap.SoLuongNhap;
db.SubmitChanges();
}
}
public ActionResult Edit([Bind(Include = "MaCTNhap,MaPN,SerialNumber,GiaNhap")] ChiTietNhap chiTietNhap)
{
if (Common.MaNV != "")
{
if (ModelState.IsValid)
{
db.Entry(chiTietNhap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
Common.Alert = "Đăng nhập trước khi chỉnh sữa !";
return(RedirectToAction("Index", "Logins"));
}
ViewBag.MaPN = new SelectList(db.PhieuNhapSP, "MaPN", "MaNCC", chiTietNhap.MaPN);
ViewBag.SerialNumber = new SelectList(db.SanPham, "SerialNumber", "SerialNumber", chiTietNhap.SerialNumber);
return(View(chiTietNhap));
}
public void ThemChiTietNhap(ChiTietNhap chitietnhap)
{
_conText.chitietnhap.Add(chitietnhap);
_conText.SaveChanges();
}
public void SuaChiTietNhap(ChiTietNhap chitietnhap)
{
_conText.chitietnhap.Update(chitietnhap);
_conText.SaveChanges();
}
//xoa
public static int xoa_CTN(ChiTietNhap a)
{
return(DAO.xoa_CTN(a));
}
public bool Insert(ChiTietNhap entity)
{
db.ChiTietNhaps.Add(entity);
db.SaveChanges();
return(true);
}
protected void btnNhap_Click(object sender, EventArgs e)
{
if (kiemtra() == true)
{
NhaCungCap nhacungcap = db.NhaCungCaps.SingleOrDefault(p => p.TenNhaCungCap == txtNhaCungCap.Text);
SanPhams Sanpham = db.SanPhams.SingleOrDefault(p => p.TenSP == txtTenSP.Text);
if (Sanpham != null)
{
ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.MaSanPham == Sanpham.MaSanPham && p.SoHoaDon.ToString() == txtSoHD.Text);
if (chitietnhap != null)
{
chitietnhap.SoLuongNhap = chitietnhap.SoLuongNhap + Convert.ToInt16(txtSoLuong.Text);
chitietnhap.GiaNhap = chitietnhap.GiaNhap + Convert.ToDouble(txtGiaNhap.Text);
db.SubmitChanges();
updatesoluongsp("insert", chitietnhap);
}
else
{
ChiTietNhap Chitietnhap = new ChiTietNhap();
Chitietnhap.SoLuongNhap = Convert.ToInt16(txtSoLuong.Text);
Chitietnhap.SoHoaDon = Convert.ToInt16(txtSoHD.Text);
Chitietnhap.GhiChu = txtGhichu.Text;
Chitietnhap.GiaNhap = Convert.ToDouble(txtGiaNhap.Text);
if (nhacungcap != null)
{
Chitietnhap.MaNhaCungCap = nhacungcap.MaNhaCungCap;
}
Chitietnhap.MaSanPham = Sanpham.MaSanPham;
Chitietnhap.NgayNhap = DateTime.Now.ToShortDateString();
db.ChiTietNhaps.InsertOnSubmit(Chitietnhap);
db.SubmitChanges();
updatesoluongsp("insert", Chitietnhap);
}
}
else
{
SanPhams sanpham = new SanPhams();
sanpham.TenSP = txtTenSP.Text;
sanpham.ThongSoKyThuat = txtThongSoKyThuat.Text;
sanpham.NhaSanXuat = txtNhaSanXuat.Text;
sanpham.LoaiSP = txtLoaiSP.Text;
sanpham.HinhAnh = hinhanh.ImageUrl;
sanpham.BaoHanh = txtBaoHanh.Text;
sanpham.SoLuong = Convert.ToInt16(txtSoLuong.Text);
db.SanPhams.InsertOnSubmit(sanpham);
db.SubmitChanges();
ChiTietNhap chitietnhap = new ChiTietNhap();
chitietnhap.SoLuongNhap = Convert.ToInt16(txtSoLuong.Text);
chitietnhap.SoHoaDon = Convert.ToInt16(txtSoHD.Text);
chitietnhap.GhiChu = txtGhichu.Text;
chitietnhap.GiaNhap = Convert.ToDouble(txtGiaNhap.Text);
if (nhacungcap != null)
{
chitietnhap.MaNhaCungCap = nhacungcap.MaNhaCungCap;
}
chitietnhap.MaSanPham = sanpham.MaSanPham;
chitietnhap.NgayNhap = DateTime.Now.ToShortDateString();
db.ChiTietNhaps.InsertOnSubmit(chitietnhap);
db.SubmitChanges();
}
}
LoadTatCaSP();
}
public ActionResult Edit(string id)
{
ChiTietNhap ctn = db.ChiTietNhaps.Find(id);
return(View());
}
