subsonic增删改查

//直接执行sql语句查询数据，返回DataTable 

 DataTable dt;
                            QueryCommand qc = new QueryCommand(strSql.ToString(), null);
                            dt =DataService.GetDataSet(qc).Tables[0];

                            gvwzh.DataSource = dt;
                            gvwzh.DataBind();    

 

 //查询

        //第一种方法
        BaseUserController items = new BaseUserController();
        grw.DataSource = items.FetchAll();
        grw.DataBind();

        //第二种方法
        grw.DataSource = DB.Select().From(BaseUser.Schema).ExecuteDataSet().Tables[0];
        grw.DataBind();



        //增加
        BaseUser bu = new BaseUser();
        bu.MarkNew();
        bu.Jmsfzh = "ggggggggg";
        bu.Dlid = "eeee";
        bu.Xm = "eeeee";
        bu.Pwd = "eeeeee==";//默认密码“111111”
        bu.Sfdy = true;
        bu.Bmid = "eeeeeeee";
        bu.Save();


        //修改
        int result = new Update(BaseUser.Schema)
        .Set(BaseUser.Columns.Jmsfzh).EqualTo("55555555555")
        .Where(BaseUser.Columns.Dlid).IsEqualTo("eeee")
        .Execute();


        //删除
        DB.Delete().From(BaseUser.Schema).Where(BaseUser.Columns.Dlid).IsEqualTo("aaaaa").Execute();