private void btOk_Click(object sender, EventArgs e)
{
if (enGroupQuery == null)
{
return;
}
else
{
//调用子类的查询，返回不同的查询结果
//IList<Entity.GroupQuery> LgroupQuery = new BindingList<Entity.GroupQuery>();
DataTable LgroupQuery = new DataTable();
Facade.GroupQueryFacade GroupQuery = new Facade.GroupQueryFacade();
LgroupQuery = GroupQuery.GroupQuery(enGroupQuery);
//dataGridView1.AutoGenerateColumns = false;
if (LgroupQuery.Rows.Count > 0)
{
dataGridView1.DataSource = LgroupQuery;
dataGridView1.Columns[0].HeaderText = "学号";
dataGridView1.Columns[1].HeaderText = "姓名";
dataGridView1.Columns[2].HeaderText = "性别";
dataGridView1.Columns[3].HeaderText = "专业";
dataGridView1.Columns[4].HeaderText = "年级";
dataGridView1.Columns[5].HeaderText = "班级";
dataGridView1.Columns[6].HeaderText = "备注";
}
else
{
MessageBox.Show("没有记录", "提示");
}
}
}
private void btOk_Click(object sender, EventArgs e)
{
if (enGroupQuery == null)
{
return;
}
else
{
//调用子类的查询，返回不同的查询结果
//IList<Entity.GroupQuery> LgroupQuery = new BindingList<Entity.GroupQuery>();
DataTable LgroupQuery = new DataTable();
Facade.GroupQueryFacade GroupQuery = new Facade.GroupQueryFacade();
LgroupQuery = GroupQuery.GroupQuery(enGroupQuery);
//dataGridView1.AutoGenerateColumns = false;
if (LgroupQuery.Rows.Count > 0)
{
dataGridView1.DataSource = LgroupQuery;
//绑定数据库的列名称
//dataGridView1.AutoGenerateColumns = false;
//dataGridView1.Columns[0].DataPropertyName = "cardno";
//dataGridView1.Columns[1].DataPropertyName = "studentNo";
//dataGridView1.Columns[2].DataPropertyName = "StudentName";
//dataGridView1.Columns[3].DataPropertyName = "loginDate";
//dataGridView1.Columns[4].DataPropertyName = "loginTime";
//dataGridView1.Columns[5].DataPropertyName = "offDate";
//dataGridView1.Columns[6].DataPropertyName = "offtime";
//dataGridView1.Columns[7].DataPropertyName = "ConsumeTime";
//dataGridView1.Columns[8].DataPropertyName = "Money";
dataGridView1.Columns[0].HeaderText = "序列号";
dataGridView1.Columns[1].HeaderText = "卡号";
dataGridView1.Columns[2].HeaderText = "类型";
dataGridView1.Columns[3].HeaderText = "学号";
dataGridView1.Columns[4].HeaderText = "姓名";
dataGridView1.Columns[5].HeaderText = "性别";
dataGridView1.Columns[6].HeaderText = "上机日期";
dataGridView1.Columns[7].HeaderText = "上机时间";
dataGridView1.Columns[8].HeaderText = "下机日期";
dataGridView1.Columns[9].HeaderText = "下机时间";
dataGridView1.Columns[10].HeaderText = "消费时间";
dataGridView1.Columns[11].HeaderText = "消费金额";
dataGridView1.Columns[12].HeaderText = "余额";
dataGridView1.Columns[13].HeaderText = "状态";
dataGridView1.Columns[14].HeaderText = "机器号";
}
else
{
MessageBox.Show("没有记录", "提示");
}
}
}
//在dategridview中显示查询的结果
protected override void toDateGridView(Entity.GroupQuery Groupquery)
{
// base.toDateGridView(Groupquery);
//IList <Entity.GroupQuery > lgroupQuery = new List<Entity.GroupQuery >();
DataTable lgroupQuery = new DataTable();
Facade.GroupQueryFacade GroupQuery = new Facade.GroupQueryFacade();
lgroupQuery = GroupQuery.GroupQuery(Groupquery);
dataGridView1.DataSource = lgroupQuery;
dataGridView1.Columns[0].HeaderText = "教师";
dataGridView1.Columns[1].HeaderText = "上班日期";
dataGridView1.Columns[2].HeaderText = "上班时间";
dataGridView1.Columns[3].HeaderText = "下班日期";
dataGridView1.Columns[4].HeaderText = "下班时间";
dataGridView1.Columns[5].HeaderText = "机器号";
dataGridView1.Columns[6].HeaderText = "权限";
dataGridView1.Columns[7].HeaderText = "备注";
//dataGridView1.Columns[7].HeaderText = "";
}
