public int Sua(QuaTrinhMuonTra QTMT) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAQUATRINHMUONTRA, SqlDbType.Int), new SqlParameter(PARM_MACANBO, SqlDbType.NVarChar, 30), new SqlParameter(PARM_MATHUTHU, SqlDbType.NVarChar, 30), new SqlParameter(PARM_THOIGIANMUONTRA, SqlDbType.Date), new SqlParameter(PARM_XUPHATNEUCO, SqlDbType.NVarChar, -1), new SqlParameter(PARM_GHICHU, SqlDbType.NVarChar, -1) }; parm[0].Value = QTMT.MaQuaTrinhMuonTra; parm[1].Value = QTMT.MaCanBo_HSSV; parm[2].Value = QTMT.MaThuThu; parm[3].Value = QTMT.ThoiGianMuonTra; parm[4].Value = QTMT.XuPhatNeuCo; parm[5].Value = QTMT.GhiChu; return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblQuaTrinhMuonTra_Sua", parm)); }
public QuaTrinhMuonTra LayQTMT(string Ma) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAQUATRINHMUONTRA, SqlDbType.NVarChar, 30), }; parm[0].Value = Ma; SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblQuaTrinhMuonTra_Lay1", parm); QuaTrinhMuonTra QTMT = new QuaTrinhMuonTra(); if (d.Read()) { QTMT.MaQuaTrinhMuonTra = d[0].ToString(); QTMT.MaCanBo_HSSV = d[1].ToString(); QTMT.MaThuThu = d[2].ToString(); QTMT.ThoiGianMuonTra = DateTime.Parse(d[3].ToString()); QTMT.XuPhatNeuCo = d[4].ToString(); QTMT.GhiChu = d[5].ToString(); } return(QTMT); }
public List <QuaTrinhMuonTra> DSQTMT() { SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblQuaTrinhMuonTra_DS", null); List <QuaTrinhMuonTra> mylist = new List <QuaTrinhMuonTra>(); while (d.Read()) { QuaTrinhMuonTra QTMT = new QuaTrinhMuonTra(); QTMT.MaQuaTrinhMuonTra = d[0].ToString(); QTMT.MaCanBo_HSSV = d["Ten"].ToString(); QTMT.MaThuThu = d["TT"].ToString(); QTMT.ThoiGianMuonTra = DateTime.Parse(d[3].ToString()); QTMT.XuPhatNeuCo = d[4].ToString(); QTMT.GhiChu = d[5].ToString(); QTMT.Muon = int.Parse(d[7].ToString()); QTMT.Tra = int.Parse(d[6].ToString()); mylist.Add(QTMT); } d.Dispose(); return(mylist); }
public int Sua(QuaTrinhMuonTra qtmt) { return(qtmtdal.Sua(qtmt)); }
public int Them(QuaTrinhMuonTra qtmt) { return(qtmtdal.Them(qtmt)); }