public static TuVanTinhTrang getFromReader(IDataReader rd)
{
var Item = new TuVanTinhTrang();
if (rd.FieldExists("TTDV_ID"))
{
Item.ID = (Guid)(rd["TTDV_ID"]);
}
if (rd.FieldExists("TTDV_TV_ID"))
{
Item.TV_ID = (Guid)(rd["TTDV_TV_ID"]);
}
if (rd.FieldExists("TTDV_TT_ID"))
{
Item.TT_ID = (Guid)(rd["TTDV_TT_ID"]);
}
if (rd.FieldExists("TTDV_ThuTu"))
{
Item.ThuTu = (Int32)(rd["TTDV_ThuTu"]);
}
if (rd.FieldExists("TTDV_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["TTDV_NgayTao"]);
}
Item._DanhMuc = DanhMucDal.getFromReader(rd);
return(Item);
}
public static TuVanTinhTrang Update(TuVanTinhTrang item)
{
var Item = new TuVanTinhTrang();
var obj = new SqlParameter[5];
obj[0] = new SqlParameter("TTDV_ID", item.ID);
obj[1] = new SqlParameter("TTDV_TV_ID", item.TV_ID);
obj[2] = new SqlParameter("TTDV_TT_ID", item.TT_ID);
obj[3] = new SqlParameter("TTDV_ThuTu", item.ThuTu);
if (item.NgayTao > DateTime.MinValue)
{
obj[4] = new SqlParameter("TTDV_NgayTao", item.NgayTao);
}
else
{
obj[4] = new SqlParameter("TTDV_NgayTao", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanTinhTrang_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static TuVanTinhTrang SelectById(Guid TTDV_ID)
{
var Item = new TuVanTinhTrang();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("TTDV_ID", TTDV_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanTinhTrang_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
