📄 selectinfos.cs
字号:
//显示以有的查询
private void linlblSelect_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
if(this.flag == true)
{
this.Size = new Size(496, 224);
this.flag = false;
}
else
{
this.Size = new Size(496, 144);
this.flag = true;
}
}
//选择时发生
private void cboTitle_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.cboInsert.Items.Clear();
ShowMoreStuinfo smsform = new ShowMoreStuinfo();
if(this.cboTitle.SelectedIndex != 3 && this.cboTitle.SelectedIndex != 4 && this.cboTitle.SelectedIndex != 6 && this.cboTitle.SelectedIndex != 7)
{
return;
}
if(this.cboTitle.SelectedIndex == 3)
{
for(int i=0;i<smsform.Stu_Race.Items.Count;i++)
{
this.cboInsert.Items.Add(smsform.Stu_Race.Items[i]);
}
}
if(this.cboTitle.SelectedIndex == 4)
{
for(int i=1;i<smsform.Stu_educational.Items.Count;i++)
{
this.cboInsert.Items.Add(smsform.Stu_educational.Items[i]);
}
}
if(this.cboTitle.SelectedIndex == 6)
{
for(int i=1;i<smsform.Stu_Love.Items.Count;i++)
{
this.cboInsert.Items.Add(smsform.Stu_Love.Items[i]);
}
}
if(this.cboTitle.SelectedIndex == 7)
{
for(int i=1;i<smsform.Stu_Special.Items.Count;i++)
{
this.cboInsert.Items.Add(smsform.Stu_Special.Items[i]);
}
}
}
//开始查询
private void btnSelect_Click(object sender, System.EventArgs e)
{
if(this.cboInsert.Text.ToString() == "")
{
MessageBox.Show("请填写查询的条件！");
this.cboInsert.Focus();
return;
}
//连接数据库
db.Server = "Microsoft.Jet.OLEDB.4.0";
db.Database = FormMain.path+"\\StuInfoMgr.mdb";
db.createConn();
db.openConn();
String filed = String.Empty; //字段
this.btnSaveSelect.Enabled = true;
switch(this.cboTitle.SelectedIndex)
{
case 0:
{
filed = "Stu_Id";
break;
}
case 1:
{
filed = "Stu_Name";
break;
}
case 2:
{
filed = "Stu_Idcard";
break;
}
case 3:
{
filed = "Stu_Race";
break;
}
case 4:
{
filed = "Stu_educational";
break;
}
case 5:
{
filed = "Stu_NativePlace";
break;
}
case 6:
{
filed = "Stu_Love";
break;
}
case 7:
{
filed = "Stu_Special";
break;
}
}
//条件
if(this.cboEques.SelectedIndex == 0)
{
sql = "select * from stuinfo where "+filed+"='"+this.cboInsert.Text.ToString()+"'";
}
else
{
sql = "select * from stuinfo where "+filed+" like '%"+this.cboInsert.Text.ToString()+"%'";
}
try
{
this.ds = new DataSet("Stu");
this.adapter = new OleDbDataAdapter();
this.adapter.SelectCommand = new OleDbCommand(sql,db.Conn);
this.adapter.Fill(this.ds,"stuinfo");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
Console.WriteLine(ex);
}
//取得子form
Form[] forms = this.Owner.MdiChildren;
for(int i=0;i<forms.Length;i++)
{
if(forms[i].Text.Equals("查询学员信息"))
{
SelStuinfo form = ((SelStuinfo)forms[i]);
form.ds = this.ds;
form.LvwStuInfo.Items.Clear();
form.LvwStuInfo.Columns.Clear();
form.LvwStuInfo.Columns.Add("学号",200,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("姓名",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("性别",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("身份证号码",150,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("民族",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("最高学历",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("籍贯",150,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("家庭住址",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("固定电话",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("手机",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("爱好",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("特长",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("最近照片",0,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("备注",150,System.Windows.Forms.HorizontalAlignment.Left);
int count = 0;
foreach(DataRow dr in this.ds.Tables["stuinfo"].Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.ImageIndex = 1;
lvi.Text = dr[0].ToString();
lvi.Font = new Font("宋体",10);
if(count%2 == 0)
{
lvi.BackColor = Color.Pink; //设置BackColor
}
for(int j=1;j<=13;j++)
{
lvi.SubItems.Add(dr[j].ToString());
}
form.LvwStuInfo.Items.Add(lvi);
count++;
}
form.Update();
form.Refresh();
if(this.ds.Tables["stuinfo"].Rows.Count == 0)
{
this.btnSaveSelect.Enabled = false;
}
break;
}
}
}
private void cboYiyouSelect_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
//查询
private void btnYiyouSelect_Click(object sender, System.EventArgs e)
{
//连接数据库
db.Server = "Microsoft.Jet.OLEDB.4.0";
db.Database = FormMain.path+"\\StuInfoMgr.mdb";
db.createConn();
db.openConn();
OleDbCommand cmd = new OleDbCommand("select Sel_Content from selector where Sel_Name='"+this.cboYiyouSelect.Text.ToString()+"'",db.Conn);
OleDbDataReader drs = cmd.ExecuteReader();
drs.Read();
String sql = drs.GetValue(0).ToString();
sql = sql.Replace("\\","'");
drs.Close();
this.ds = new DataSet("Stu");
this.adapter = new OleDbDataAdapter();
this.adapter.SelectCommand = new OleDbCommand(sql,db.Conn);
this.adapter.Fill(this.ds,"stuinfo");
//取得子form
Form[] forms = this.Owner.MdiChildren;
for(int i=0;i<forms.Length;i++)
{
if(forms[i].Text.Equals("查询学员信息"))
{
SelStuinfo form = ((SelStuinfo)forms[i]);
form.ds = this.ds;
form.LvwStuInfo.Items.Clear();
form.LvwStuInfo.Columns.Clear();
form.LvwStuInfo.Columns.Add("学号",200,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("姓名",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("性别",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("身份证号码",150,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("民族",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("最高学历",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("籍贯",150,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("家庭住址",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("固定电话",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("手机",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("爱好",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("特长",100,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("最近照片",0,System.Windows.Forms.HorizontalAlignment.Left);
form.LvwStuInfo.Columns.Add("备注",150,System.Windows.Forms.HorizontalAlignment.Left);
int count = 0;
foreach(DataRow dr in this.ds.Tables["stuinfo"].Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.ImageIndex = 0;
lvi.Text = dr[0].ToString();
lvi.Font = new Font("宋体",10);
if(count%2 == 0)
{
lvi.BackColor = Color.Pink; //设置BackColor
}
for(int j=1;j<=13;j++)
{
lvi.SubItems.Add(dr[j].ToString());
}
form.LvwStuInfo.Items.Add(lvi);
count++;
}
form.Update();
form.Refresh();
break;
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -