public static QuyTac getFromReader(IDataReader rd)
{
QuyTac Item = new QuyTac();
if (rd.FieldExists("QT_ID"))
{
Item.ID = (Int32)(rd["QT_ID"]);
}
if (rd.FieldExists("QT_Host"))
{
Item.Host = (String)(rd["QT_Host"]);
}
if (rd.FieldExists("QT_Loai"))
{
Item.Loai = (Int32)(rd["QT_Loai"]);
}
if (rd.FieldExists("QT_Xpath"))
{
Item.Xpath = (String)(rd["QT_Xpath"]);
}
if (rd.FieldExists("QT_ThuTu"))
{
Item.ThuTu = (Int32)(rd["QT_ThuTu"]);
}
if (rd.FieldExists("QT_Xoa"))
{
Item.Xoa = (Boolean)(rd["QT_Xoa"]);
}
return(Item);
}
public static QuyTac SelectById(Int32 QT_ID)
{
QuyTac Item = new QuyTac();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("QT_ID", QT_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblQuyTac_Select_SelectById_hoangda", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static QuyTac Insert(QuyTac Inserted)
{
QuyTac Item = new QuyTac();
SqlParameter[] obj = new SqlParameter[5];
obj[0] = new SqlParameter("QT_Host", Inserted.Host);
obj[1] = new SqlParameter("QT_Loai", Inserted.Loai);
obj[2] = new SqlParameter("QT_Xpath", Inserted.Xpath);
obj[3] = new SqlParameter("QT_ThuTu", Inserted.ThuTu);
obj[4] = new SqlParameter("QT_Xoa", Inserted.Xoa);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblQuyTac_Insert_InsertNormal_hoangda", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
