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));
}
