public static TaiLieuThuTuc getFromReader(IDataReader rd)
{
TaiLieuThuTuc Item = new TaiLieuThuTuc();
if (rd.FieldExists("TLTT_ID"))
{
Item.ID = (Int32)(rd["TLTT_ID"]);
}
if (rd.FieldExists("TLTT_Ten"))
{
Item.Ten = (String)(rd["TLTT_Ten"]);
}
if (rd.FieldExists("TLTT_CID"))
{
Item.CID = (Guid)(rd["TLTT_CID"]);
}
if (rd.FieldExists("TLTT_PID"))
{
Item.PID = (Guid)(rd["TLTT_PID"]);
}
if (rd.FieldExists("TLTT_RowId"))
{
Item.RowId = (Guid)(rd["TLTT_RowId"]);
}
if (rd.FieldExists("TLTT_Kieu"))
{
Item.Kieu = (Int32)(rd["TLTT_Kieu"]);
}
if (rd.FieldExists("TLTT_SoLuong"))
{
Item.SoLuong = (Int32)(rd["TLTT_SoLuong"]);
}
return(Item);
}
public static TaiLieuThuTuc SelectById(Int32 TLTT_ID)
{
TaiLieuThuTuc Item = new TaiLieuThuTuc();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("TLTT_ID", TLTT_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTaiLieuThuTuc_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static TaiLieuThuTuc Insert(TaiLieuThuTuc Inserted)
{
TaiLieuThuTuc Item = new TaiLieuThuTuc();
SqlParameter[] obj = new SqlParameter[6];
obj[0] = new SqlParameter("TLTT_Ten", Inserted.Ten);
obj[1] = new SqlParameter("TLTT_CID", Inserted.CID);
obj[2] = new SqlParameter("TLTT_PID", Inserted.PID);
obj[3] = new SqlParameter("TLTT_RowId", Inserted.RowId);
obj[4] = new SqlParameter("TLTT_Kieu", Inserted.Kieu);
obj[5] = new SqlParameter("TLTT_SoLuong", Inserted.SoLuong);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTaiLieuThuTuc_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}