private void txtTimKiem_KeyUp(object sender, KeyEventArgs e)
{
clsFunction f1 = new clsFunction();
sql = "SELECT * FROM BH_HS WHERE Gioitinh like '" + txtTimKiem.Text + "'";
dgvHocSinh.DataSource = f1.GetData(sql);
}
public List <clsFunction> getByModuleId(int modileid)
{
try
{
List <clsFunction> objList = new List <clsFunction>();
SqlCommand com = new SqlCommand("iBet_tblFunction_GetByModuleId", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@ModileId", modileid);
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsFunction obj = new clsFunction();
if (dr["Id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["Id"]);
}
if (dr["ModileId"] != DBNull.Value)
{
obj.ModuleId = Convert.ToInt32(dr["ModileId"]);
}
if (dr["FunctionName"] != DBNull.Value)
{
obj.FunctionName = Convert.ToString(dr["FunctionName"]);
}
if (dr["FunctionTitle"] != DBNull.Value)
{
obj.FunctionTitle = Convert.ToString(dr["FunctionTitle"]);
}
if (dr["FunctionDescription"] != DBNull.Value)
{
obj.FunctionDescription = Convert.ToString(dr["FunctionDescription"]);
}
if (dr["FuncrionURL"] != DBNull.Value)
{
obj.FuncrionURL = Convert.ToString(dr["FuncrionURL"]);
}
if (dr["IsVisible"] != DBNull.Value)
{
obj.IsVisible = Convert.ToBoolean(dr["IsVisible"]);
}
if (dr["Priority"] != DBNull.Value)
{
obj.Priority = Convert.ToInt32(dr["Priority"]);
}
objList.Add(obj);
}
return(objList);
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
