void LoadThongTin() { ChiTietMuonTra temp = MTBLL.LayThongTinChiTiet(MaMuonTra); lbMaMuonTra.Text = temp.MaMuonTra + ""; lbNgayMuon.Text = temp.NgayMuon.ToString("dd/MM/yyyy"); txbHanMuon.Text = temp.HanMuon.ToString("dd/MM/yyyy"); lbTinhTrang.Text = temp.TinhTrang; if (temp.NgayQuaHan < 0) { lbNgayQuaHan.Text = "Chưa quá hạn"; } else { lbNgayQuaHan.Text = temp.NgayQuaHan + " ngày"; } lbMaNV.Text = temp.MaNV + ""; lbMaDG.Text = temp.MaDocGia + ""; lbTenDG.Text = temp.TenDocGia; lbDonVi.Text = temp.DonVi; lbSoCuon.Text = temp.SoCuonDangMuon + ""; txbMaSach.Text = temp.MaSach; lbTenSach.Text = temp.TenSach; lbTap.Text = temp.Tap + ""; lbLanTB.Text = temp.LanTB + ""; }
public ChiTietMuonTra LayCTMT(string Ma) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAQUATRINHTRASACH, SqlDbType.Int), new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30), new SqlParameter(PARM_TINHTRANG, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MASOCABIET, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MUONHAYTRA, SqlDbType.Bit) }; parm[0].Value = Ma; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_Lay1", parm); ChiTietMuonTra CTMT = new ChiTietMuonTra(); if (d.Read()) { CTMT.MaQuaTrinhTraSach = d[0].ToString(); CTMT.MaSach = d[1].ToString(); CTMT.TinhTrang = d[2].ToString(); CTMT.MaSoCaBiet = d[3].ToString(); CTMT.MuonHayTra = short.Parse(d[4].ToString()); CTMT.SoNgayMuon = int.Parse(d[5].ToString()); } return(CTMT); }
protected void grvSachMuon_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvr; try { gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); } catch { return; } int index = gvr.RowIndex; DataTable no = (DataTable)ViewState["SachNo"]; DataTable xoa = (DataTable)ViewState["Xoa"]; List <ChiTietMuonTra> tb = (List <ChiTietMuonTra>)ViewState["table"]; if (e.CommandName == "BaoMat" || e.CommandName == "Tra") { DataRow r = no.NewRow(); r = no.Rows[index]; short t = 1; if (e.CommandName == "BaoMat") { t = 2; } ChiTietMuonTra ct = new ChiTietMuonTra("", r["MaSach"].ToString(), "", r["MaSoCaBiet"].ToString(), t, 0); xoa.Rows.Add(r.ItemArray); no.Rows.RemoveAt(index); tb.Add(ct); ViewState["SachNo"] = no; ViewState["Xoa"] = xoa; ViewState["table"] = tb; loadsno(); } }
public async Task <ActionResult> CreateOrUpdate(string userId, string[] array, DateTime ngayTra) { var muontra = new MuonTra(); var autoList = AutoCompleteTextHoSos(_taiLieuVanBanService.Gets(p => p.TrangThai == true, p => p.OrderBy(x => x.Ten)).ToList()); var users = await _userService.GetAllAsync(); var muonTras = new List <MuonTra>(); var model = Users(users, muonTras); muontra.UserId = model.FirstOrDefault(m => m.UserName == userId).Id; muontra.VanThu = User.Identity.GetUserName(); muontra.NgayMuon = DateTime.Now; muontra.NgayKetThuc = ngayTra; muontra.TinhTrang = EnumTinhTrang.DangMuon; _muonTraService.Insert(muontra); for (int i = 0; i < array.Length; i++) { var chitietmuontra = new ChiTietMuonTra(); var b = array[i]; var a = autoList.FirstOrDefault(p => p.Text == b).Id; chitietmuontra.TaiLieuVanBanId = a; chitietmuontra.MuonTraID = muontra.Id; _chiTietMuonTraService.Insert(chitietmuontra); var chiTietMuonTras = _chiTietMuonTraService.GetAll(); muontra.SoLuong = chiTietMuonTras.Count(m => m.MuonTraID == muontra.Id); _muonTraService.Update(muontra); var vanBan = _taiLieuVanBanService.Get(m => m.Id == a); vanBan.TinhTrang = EnumTinhTrang.DangMuon; _taiLieuVanBanService.Update(vanBan); } TempData["AlertMessage"] = "Tạo Mới Thành Công"; return(RedirectToAction("Index")); }
public ChiTietMuonTra LayThongTinMuonTra(int MaMuonTra) { ChiTietMuonTra kq = new ChiTietMuonTra(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from dbo.ThongTinChiTietMuonTra(@mamuontra)"; command.Connection = conn; command.Parameters.Add("@mamuontra", SqlDbType.Int).Value = MaMuonTra; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { kq.MaMuonTra = reader.GetInt32(0); kq.MaSach = reader.GetString(1); kq.TenSach = reader.GetString(2); kq.Tap = reader.GetInt32(3); kq.LanTB = reader.GetInt32(4); kq.NgayMuon = reader.GetDateTime(5); kq.HanMuon = reader.GetDateTime(6); int datra = reader.GetInt32(7); if (!reader.IsDBNull(9)) { datra = reader.GetInt32(7); kq.NgayQuaHan = reader.GetInt32(9); if (kq.NgayQuaHan < 0) { kq.NgayQuaHan = 0; } if (datra == 0) { kq.TinhTrang = "Chưa trả"; } else { kq.TinhTrang = "Đã trả"; } } else { kq.TinhTrang = "Chưa trả"; kq.NgayQuaHan = 0; } kq.MaNV = reader.GetInt32(8); kq.MaDocGia = reader.GetInt32(10); kq.TenDocGia = reader.GetString(11); kq.DonVi = reader.GetString(12); kq.SoCuonDangMuon = reader.GetInt32(13); } reader.Close(); return(kq); }
public void GiveBackOneOrTwo(List <ChiTietMuonTraViewModel> chiTietMuons) { if (chiTietMuons.Count() <= 0) { return; } string muontraId = ""; var muontraNew = new MuonTra { Id = Guid.NewGuid().ToString(), VanThu = User.Identity.GetUserName(), }; var chiTietMuonTras = new List <ChiTietMuonTra>(); foreach (var item in chiTietMuons) { var ctmt = _chiTietMuonTraService.GetById(item.Id); muontraId = item.MuonTraId; if (item.Checkbox) { ctmt.TrangThai = false; UpdateVanBan(ctmt.TaiLieuVanBanId); var chtmtNew = new ChiTietMuonTra { Id = Guid.NewGuid().ToString(), MuonTraID = muontraNew.Id, TaiLieuVanBanId = item.TaiLieuVanBanId, NgayTao = DateTime.Now, TrangThai = true }; chiTietMuonTras.Add(chtmtNew); } } var muonTraOld = _muonTraService.GetById(muontraId); _muonTraService.Update(muonTraOld); muontraNew.UserId = muonTraOld.UserId; muontraNew.NgayMuon = muonTraOld.NgayMuon; muontraNew.NgayKetThuc = muonTraOld.NgayKetThuc; muontraNew.SoLuong = chiTietMuons.Count(m => m.Checkbox == true); _muonTraService.Insert(muontraNew); _chiTietMuonTraService.Insert(chiTietMuonTras); UpdateMuonTra(muontraNew.Id); }
public List <ChiTietMuonTra> DSCTMT() { SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_LayDS", null); List <ChiTietMuonTra> mylist = new List <ChiTietMuonTra>(); while (d.Read()) { ChiTietMuonTra CTMT = new ChiTietMuonTra(); CTMT.MaQuaTrinhTraSach = d[0].ToString(); CTMT.MaSach = d[1].ToString(); CTMT.TinhTrang = d[2].ToString(); CTMT.MaSoCaBiet = d[3].ToString(); CTMT.MuonHayTra = short.Parse(d[4].ToString()); CTMT.SoNgayMuon = int.Parse(d[5].ToString()); mylist.Add(CTMT); } d.Dispose(); return(mylist); }
public int Sua(ChiTietMuonTra CTMT) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAQUATRINHTRASACH, SqlDbType.Int), new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30), new SqlParameter(PARM_TINHTRANG, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MASOCABIET, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MUONHAYTRA, SqlDbType.Bit), new SqlParameter(PARM_SONGAYMUON, SqlDbType.Int) }; parm[0].Value = CTMT.MaQuaTrinhTraSach; parm[1].Value = CTMT.MaSach; parm[2].Value = CTMT.TinhTrang; parm[3].Value = CTMT.MaSoCaBiet; parm[4].Value = CTMT.MuonHayTra; parm[5].Value = CTMT.SoNgayMuon; return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_Sua", parm)); }
public int Sua(ChiTietMuonTra ctmt) { return(ctmtdal.Sua(ctmt)); }
public int Them(ChiTietMuonTra ctmt) { return(ctmtdal.Them(ctmt)); }