public void Update()
{
//获取一个Student方便修改
TB_Student student = dbm.Query.SelectRelyOnKey <TB_Student>("RRRRRRRR");
student.Name = "改周x";
//修改 立即执行 返回受影响行数
//会根据实体类注解[Table]中的Key作为主键来更新其他属性
int ret = dbm.Operate.Update <TB_Student>(student);
//Result: 1
//批量修改 自己结合新增的批量看
//执行Sql 神器ExecuteSql! 立即执行 返回受影响行数
ret = dbm.Operate.ExecuteSql($"update tb_Student set Name = '改'+Name where name like '王%'");
//Result:5
}
//初始化一些数据
public void InitData()
{
//创建一个老师
TB_Teacher teacher = new TB_Teacher();
teacher.Name = "李老师";
teacher.ID = teacher.GetAutoID(); //设置一个UUID 方便等会使用
dbm.Multi.AddInsert(teacher); //给操作队列增加一条记录
//创建一个班级
TB_Class class1 = new TB_Class();
class1.TeacherID = teacher.ID;//刚才给Teacher设置的ID在这里起到作用
class1.Name = "三年级";
class1.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
dbm.Multi.AddInsert(class1);
//创建一堆学生
for (int i = 0; i < 5; i++)
{
dbm.Multi.AddInsert(new TB_Student()
{
ClassID = 1,//看 这个时候 自增ID的弊端就出现了
Name = $"王{i}"
});
}
//再创建一个学生
TB_Student student = new TB_Student()
{
ClassID = 1,
ID = "RRRRRRRR",
Name = "周x"
};
dbm.Multi.AddInsert(student);
//最后提交 这些队列中的东西会存放在一个事物里进行 返回受影响行数
int line = dbm.Multi.Commit();
}
public void Query()
{
//根据主键查一个
TB_Student s1 = dbm.Query.SelectRelyOnKey <TB_Student>("RRRRRRRR");
//Result:
//s1.ID = "RRRRRRRR"
//s1.Name = "周x"
//s1.ClassID = 1
//根据Sql查询一个
s1 = dbm.Query.SelectOne <TB_Student>(@"
select * from tb_Student where id = 'RRRRRRRR'
");
//Result:
//s1.ID = "RRRRRRRR"
//s1.Name = "周x"
//s1.ClassID = 1
//根据sql查一行
IDictionary <string, object> dics1 = dbm.Query.SelectOneData("select * from tb_Student where id = 'RRRRRRRR'");
//Result:
//dics1["ID"] = "RRRRRRRR"
//dics1["Name"] = "周x"
//dics1["ClassID"] = 1
//根据sql查多个
IList <TB_Student> students = dbm.Query.Select <TB_Student>("select * from tb_Student where name like '王%'");
//Result:
//students[0] = Result:
// ID = "XXXXXXXXXXXXXXXXXX"//表示不确定
// Name = "王1"
// ClassID = 1
//students[1] = Result:
// ID = "XXXXXXXXXXXXXXXXXX"//表示不确定
// Name = "王2"
// ClassID = 1
//..................
//查询一行一列
int allStudents = dbm.Query.SelectValue <Int32>("select count(ID) from tb_student");
//Result: 6
//查询一列多行
IList <string> studentids = dbm.Query.SelectValueList <string>("select ID from tb_Student");
//Result:
//studentids[0]="XXXXXXXXXXXXXXXXX"//表示不确定
//studentids[1]="XXXXXXXXXXXXXXXXX"//表示不确定
//studentids[2]="XXXXXXXXXXXXXXXXX"//表示不确定
//.....................
//查询多Result 支持多表
DataSet ds = dbm.Query.SelectWithDataSet("select * from tb_Student;select * from tb_Teacher", "StudentTable", "TeacherTable");
//Result:
//DataTable studentTable = ds.Tables["StudentTable"]
//DataTable teacherTable = ds.Tables["TeacherTable"]
//动态查询
IList <dynamic> dynStudents = dbm.Query.SelectWithDynamic(@"
select stu.*,class.Name as ClassName from tb_Student stu
left join tb_Class class on class.ID = stu.ClassID
");
//Result:
//dynStudents[0] = Result:
// ID = "XXXXXXXXXXXXXXXXXX" //表示不确定
// Name = "王1"
// ClassID = 1
// ClassName = "三年级"
//......................
//注意 这个将会根据你查询的列名作为动态类型的属性
//例如 sql为 select stu.id,stu.name,stu.classid,class.Name as classname from tb_Student stu
// left join tb_Class class on class.ID = stu.ClassID 那么结果将会如下
//Result:
//dynStudents[0] = Result:
// id = "XXXXXXXXXXXXXXXXXX" //表示不确定
// name = "王1""
// classid = 1
// classname = "三年级"
//............................
//动态查询基于泛型
IList <dynamic> dynStudents2 = dbm.Query.SelectWithDynamic <TB_Student>($@"
select stu.id,stu.name,stu.classid,class.Name as classname from tb_Student stu
left join tb_Class class on class.ID = stu.ClassID
");
//Result:
//dynStudents2[0] = Result:
// ID = "XXXXXXXXXXXXXXXXXX" //表示不确定
// Name = "王1""
// ClassID = 1
// classname = "三年级" //由于该列名"classname"不存在在TB_Student的TableField中 所以无法对应
//............................
//查询为json
string stuJson = dbm.Query.SelectWithJSON("select * from tb_Student");
//[{"ID":"39175a56-0147-4f0b-bfd2-b3135981af77","Name":"王4","ClassID":1},{"ID":"4fa3bbab-14aa-48bb-bf91-78d55b902c2b","Name":"王0","ClassID":1},{"ID":"9b54d386-e1cf-468d-99b6-5bb9d9bb7ace","Name":"王2","ClassID":1},{"ID":"c3e47fed-4807-41fe-bf44-02f4444f2652","Name":"王3","ClassID":1},{"ID":"de2fe44a-0135-4976-86a7-99f5913c9bb4","Name":"王1","ClassID":1},{"ID":"RRRRRRRR","Name":"周x","ClassID":1}]
//嗯。。我直接把查询的搬过来了 反正就是这么个样子
}