public static Capgui getFromReaderTiny(IDataReader rd)
{
Capgui Item = new Capgui();
Item.ID = (Int32)(rd["CG_ID"]);
Item.Ten = (String)(rd["CG_Ten"]);
Item.Ma = (String)(rd["CG_Ma"]);
return(Item);
}
public static Capgui getFromReader(IDataReader rd)
{
Capgui Item = new Capgui();
Item.ID = (Int32)(rd["CG_ID"]);
Item.Ten = (String)(rd["CG_Ten"]);
Item.Ma = (String)(rd["CG_Ma"]);
Item.NgayTao = (DateTime)(rd["CG_NgayTao"]);
Item.NgayCapNhat = (DateTime)(rd["CG_NgayCapNhat"]);
Item.NguoiTao = (String)(rd["CG_NguoiTao"]);
return(Item);
}
public static Capgui SelectById(Int32 CG_ID)
{
Capgui Item = new Capgui();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("CG_ID", CG_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblCapgui_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static Capgui Insert(Capgui Inserted)
{
Capgui Item = new Capgui();
SqlParameter[] obj = new SqlParameter[5];
obj[0] = new SqlParameter("CG_Ten", Inserted.Ten);
obj[1] = new SqlParameter("CG_Ma", Inserted.Ma);
obj[2] = new SqlParameter("CG_NgayTao", Inserted.NgayTao);
obj[3] = new SqlParameter("CG_NgayCapNhat", Inserted.NgayCapNhat);
obj[4] = new SqlParameter("CG_NguoiTao", Inserted.NguoiTao);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblCapgui_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
