public static void ThemNhatKy(Log_DTO nk)
{
DataProvider p = new DataProvider();
p.Connect();
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@tennd", SqlDbType.VarChar, 50)
{
Value = nk.TenND
},
new SqlParameter("@chucnang", SqlDbType.NVarChar, 255)
{
Value = nk.ChucNang
},
new SqlParameter("@hanhdong", SqlDbType.NVarChar, 255)
{
Value = nk.HanhDong
},
new SqlParameter("@thoigian", SqlDbType.VarChar, 50)
{
Value = nk.ThoiGian
}
};
int n = p.ExecuteNonQuery("sp_ThemNhatKy", CommandType.StoredProcedure, para);
p.Disconnect();
}
public static List <Log_DTO> LoadNhatKyHoatDong()
{
DataProvider p = new DataProvider();
p.Connect();
List <Log_DTO> lnk = new List <Log_DTO>();
Log_DTO nk = null;
SqlDataReader r = p.GetReader("sp_LoadLog", CommandType.StoredProcedure);
while (r.Read())
{
nk = new Log_DTO();
nk.Ma = Convert.ToInt32(r[0]);
nk.TenND = r[1].ToString();
nk.ChucNang = r[2].ToString();
nk.HanhDong = r[3].ToString();
nk.ThoiGian = r[4].ToString();
lnk.Add(nk);
}
p.Disconnect();
return(lnk);
}
