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