使用 ID NO 亚音速搜索

Question

public List<EmployeeDirectory> employee = new Health_Scheme_SystemDB.Select
    .From<EmployeeDirectory>()
    .Where(EmployeeDirectoryTable.ID_NOColumn).Contains(1005)
    .ExecuteTypedList<EmployeeDirectory>();

.Select 给我带来了问题。它说“Health_Scheme_System.Health_Scheme_SystemDB.Select”是一个“属性”，但像“类型”一样使用

Answer 1

删除 new - 您不是在创建新实例，因此不应使用 new。

Answer 2

public List<EmployeesX> GetID(string IDNO)
    {
        Health_Scheme_System.Health_Scheme_SystemDB db = new Health_Scheme_System.Health_Scheme_SystemDB();

        var d = (from c in db.EmployeeDirectories
                 where c.ID_NO.Contains(IDNO)
                 select new EmployeesX { ID_NO = c.ID_NO, FIRST_NAME = c.FIRST_NAME, LAST_NAME = c.LAST_NAME, EMPLOYMENT_DATE = ((DateTime)c.EMPLOYMENT_DATE).Date, TERMINATION_DATE = ((DateTime)c.TERMINATION_DATE).Date, LOCATION_CODE = c.LOCATION_CODE });

        return d.ToList<EmployeesX>();

    }

然后用这段代码绑定网格视图。显然，文本框中输入的数据只会显示在网格视图中。

 gvView.DataSource = da.GetID(txtIDNO.Text);
        gvView.DataBind();