private void btnDelete_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
object value = dataGridView1.Rows[i].Cells["selectedRow"].Value;
if (value != null && value.Equals(true))
{
StudentForQuery student = m_stuList[i];
//删除 2中方式删除，可根据ID删除，DB.Remove<Student>(student.UserID);
DB.Remove <Student>(student.Id);
}
}
refreshData();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)//当单击复选框，同时处于组合编辑状态时
{
DataGridViewCell cell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
bool ifcheck1 = Convert.ToBoolean(cell.FormattedValue);
bool ifcheck2 = Convert.ToBoolean(cell.EditedFormattedValue);
if (ifcheck1 != ifcheck2)
{
StudentForQuery student = m_stuList[e.RowIndex];
txtName.Text = student.Name;
txtAge.Text = student.Age.ToString();
txtGender.Text = student.Gender;
txtAddress.Text = student.Address;
updateStudent.Id = student.Id;
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
int pageIndex = Convert.ToInt32(txtPageIndex.Text);
int pageSize = Convert.ToInt32(txtPageSize.Text);
/*string sql = "SELECT * FROM student where age < 20";
* m_stuList = DB.FindBySql<Student>(sql, pageIndex, pageSize);
* dataGridView1.DataSource = m_stuList;*/
//string sql = "SELECT * FROM student where age < @age or address= @address";
string sql = "SELECT * FROM (select * from student where age < @age or address= @address order by id desc) as v";
ParamMap param = ParamMap.newMap();
param.setParameter("age", 500);
param.setParameter("address", "上海市");
param.setPageIndex(pageIndex);
param.setPageSize(pageSize);
m_stuList = DB.FindBySql <StudentForQuery>(sql, param);
dataGridView1.DataSource = m_stuList;
return;
//=================================================================================================================
//=========下面为查询的多种使用案例================================================================================
//=================================================================================================================
//查询所有学员信息
List <StudentForQuery> list = DB.FindAll <StudentForQuery>();
//根据ID查询
StudentForQuery student = DB.FindById <StudentForQuery>(5);
//自定义SQL查询
pageIndex = 1;
pageSize = 3;
List <StudentForQuery> list1 = DB.FindBySql <StudentForQuery>("SELECT * FROM student WHERE age < 28", pageIndex, pageSize, "id", true);
//按某个列查询
List <StudentForQuery> list2 = DB.FindByProperty <StudentForQuery>("name", "张三");
//按精确条件查询，这里是SELECT xxx FROM U_Student WHERE U_Name LIKE '%张%' OR U_Age < 28
DbCondition cond1 = new DbCondition().Where().Like("name", "张").OrLessThan("age", 28);
List <StudentForQuery> list3 = DB.Find <StudentForQuery>(cond1);
//关联查询，这个不用多说了，会SQL的都知道，查询条件是 WHERE U_Name LIKE '张%'
DbCondition cond2 = new DbCondition("SELECT s.*,c.teacher,c.class_name FROM student s INNER JOIN class c ON s.class_id = c.id").Where().RightLike("name", "张");
List <StudentForQuery> list4 = DB.Find <StudentForQuery>(cond2);
//这里是查询 SELECT count(0) FROM U_Student WHERE U_Name = '张三' AND U_Age = 28
DbCondition cond3 = new DbCondition().Where("name", "张三").And("age", 28);
int count = DB.FindCount <StudentForQuery>(cond3);
//查询并排序
DbCondition condition = new DbCondition();
condition.Where("name", "张三").OrderByDESC("id");
m_stuList = DB.Find <StudentForQuery>(condition);
//=================================================================================================================
}
