📄 frmmanager.cs
字号:
this.label24.Name = "label24";
this.label24.Size = new System.Drawing.Size(72, 24);
this.label24.TabIndex = 0;
this.label24.Text = "查询条件：";
this.label24.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// groupBox5
//
this.groupBox5.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(255)), ((System.Byte)(192)));
this.groupBox5.Controls.Add(this.label26);
this.groupBox5.Controls.Add(this.btnSelect);
this.groupBox5.Controls.Add(this.txtSelectName);
this.groupBox5.Controls.Add(this.rad2);
this.groupBox5.Controls.Add(this.rad1);
this.groupBox5.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.groupBox5.ForeColor = System.Drawing.Color.Magenta;
this.groupBox5.Location = new System.Drawing.Point(432, 8);
this.groupBox5.Name = "groupBox5";
this.groupBox5.Size = new System.Drawing.Size(368, 48);
this.groupBox5.TabIndex = 4;
this.groupBox5.TabStop = false;
this.groupBox5.Text = "姓名搜索";
//
// label26
//
this.label26.Location = new System.Drawing.Point(104, 16);
this.label26.Name = "label26";
this.label26.Size = new System.Drawing.Size(80, 24);
this.label26.TabIndex = 4;
this.label26.Text = "请输入姓名：";
this.label26.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// btnSelect
//
this.btnSelect.ForeColor = System.Drawing.Color.Red;
this.btnSelect.Location = new System.Drawing.Point(304, 17);
this.btnSelect.Name = "btnSelect";
this.btnSelect.Size = new System.Drawing.Size(56, 24);
this.btnSelect.TabIndex = 3;
this.btnSelect.Text = "搜索";
this.btnSelect.Click += new System.EventHandler(this.btnSelect_Click);
//
// txtSelectName
//
this.txtSelectName.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.txtSelectName.ForeColor = System.Drawing.Color.BlueViolet;
this.txtSelectName.Location = new System.Drawing.Point(184, 17);
this.txtSelectName.MaxLength = 6;
this.txtSelectName.Name = "txtSelectName";
this.txtSelectName.Size = new System.Drawing.Size(112, 21);
this.txtSelectName.TabIndex = 2;
this.txtSelectName.Text = "";
//
// rad2
//
this.rad2.Location = new System.Drawing.Point(56, 16);
this.rad2.Name = "rad2";
this.rad2.Size = new System.Drawing.Size(64, 24);
this.rad2.TabIndex = 1;
this.rad2.Text = "精确";
//
// rad1
//
this.rad1.Checked = true;
this.rad1.Location = new System.Drawing.Point(8, 17);
this.rad1.Name = "rad1";
this.rad1.Size = new System.Drawing.Size(64, 24);
this.rad1.TabIndex = 0;
this.rad1.TabStop = true;
this.rad1.Text = "模糊";
//
// pageSetupDialog1
//
this.pageSetupDialog1.Document = this.printDocument1;
//
// printDocument1
//
this.printDocument1.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.printDocument1_PrintPage);
//
// printPreviewDialog1
//
this.printPreviewDialog1.AutoScrollMargin = new System.Drawing.Size(0, 0);
this.printPreviewDialog1.AutoScrollMinSize = new System.Drawing.Size(0, 0);
this.printPreviewDialog1.ClientSize = new System.Drawing.Size(400, 300);
this.printPreviewDialog1.Document = this.printDocument1;
this.printPreviewDialog1.Enabled = true;
this.printPreviewDialog1.Icon = ((System.Drawing.Icon)(resources.GetObject("printPreviewDialog1.Icon")));
this.printPreviewDialog1.Location = new System.Drawing.Point(142, 194);
this.printPreviewDialog1.MinimumSize = new System.Drawing.Size(375, 250);
this.printPreviewDialog1.Name = "printPreviewDialog1";
this.printPreviewDialog1.TransparencyKey = System.Drawing.Color.Empty;
this.printPreviewDialog1.Visible = false;
//
// printPreviewDialog2
//
this.printPreviewDialog2.AutoScrollMargin = new System.Drawing.Size(0, 0);
this.printPreviewDialog2.AutoScrollMinSize = new System.Drawing.Size(0, 0);
this.printPreviewDialog2.ClientSize = new System.Drawing.Size(400, 300);
this.printPreviewDialog2.Enabled = true;
this.printPreviewDialog2.Icon = ((System.Drawing.Icon)(resources.GetObject("printPreviewDialog2.Icon")));
this.printPreviewDialog2.Location = new System.Drawing.Point(305, 17);
this.printPreviewDialog2.MinimumSize = new System.Drawing.Size(375, 250);
this.printPreviewDialog2.Name = "printPreviewDialog2";
this.printPreviewDialog2.TransparencyKey = System.Drawing.Color.Empty;
this.printPreviewDialog2.Visible = false;
//
// frmManager
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(255)), ((System.Byte)(192)));
this.ClientSize = new System.Drawing.Size(808, 544);
this.Controls.Add(this.groupBox5);
this.Controls.Add(this.groupBox4);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.ForeColor = System.Drawing.Color.Black;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximumSize = new System.Drawing.Size(816, 576);
this.MinimumSize = new System.Drawing.Size(816, 576);
this.Name = "frmManager";
this.Text = "毕业生信息记录";
this.Load += new System.EventHandler(this.frmManager_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dbgBooksDt)).EndInit();
this.groupBox2.ResumeLayout(false);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
this.groupBox3.ResumeLayout(false);
this.groupBox4.ResumeLayout(false);
this.groupBox5.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private void DataShow()
{
this.dbgBooksDt.DataSource=null;//清空数据源
objSqlConn.Open();
objSqlDataAdapter=new OleDbDataAdapter();
objSqlDataAdapter.SelectCommand=new OleDbCommand("select * from Message",objSqlConn);
objDataSet=new DataSet();
objSqlDataAdapter.Fill(objDataSet,"Message");
this.dbgBooksDt.SetDataBinding(objDataSet,"Message");
this.objSqlConn.Close();
if(this.objDataSet.Tables["Message"].Rows.Count==0)
{
this.btnDelete.Enabled=false;this.button1.Enabled=false;
this.btnSave.Enabled=false;
}
else
{
this.btnDelete.Enabled=true;this.button1.Enabled=true;
this.btnSave.Enabled=true;
}
}
private void MinzuShow()
{
objSqlConn.Open();
objDataSet2=new DataSet();
objDataAdapter=new OleDbDataAdapter("select * from MinZu",objSqlConn);
objDataAdapter.Fill(objDataSet2,"MinZu");
foreach(DataRow objRow in objDataSet2.Tables["MinZu"].Rows)
{
this.cboMinZu.Items.Add(objRow["民族"]);
}
objSqlConn.Close();
}
private void ZhuanyeShow()
{
objSqlConn.Open();
DataSet objDataSet4=new DataSet();
objDataAdapter=new OleDbDataAdapter("select * from Zhuanye",objSqlConn);
objDataAdapter.Fill(objDataSet4,"Zhuanye");
foreach(DataRow objRow in objDataSet4.Tables["Zhuanye"].Rows)
{
this.cboZhuanYe.Items.Add(objRow["所学专业"]);
}
objSqlConn.Close();
}
private void WenhuaShow() //文化程度的方法
{
objSqlConn.Open();
DataSet objDataSet3=new DataSet();
objDataAdapter=new OleDbDataAdapter("select * from Wenhua",objSqlConn);
objDataAdapter.Fill(objDataSet3,"Wenhua");
foreach(DataRow objRow in objDataSet3.Tables["Wenhua"].Rows)
{
this.cboWenHua.Items.Add(objRow["文化程度"]);
}
objSqlConn.Close();
}
private void BoxClear() //清空控件
{
this.txtStuNum.Clear();this.txtStuNum.Clear();this.txtAge.Clear();this.txtShenNumber.Clear();
this.txtGuanJi.Clear();this.txtZhuanChang.Clear();this.txtQuXiang.Clear();
this.txtYaoQiu.Clear();this.txtPhoto.Clear();this.txtEmail.Clear();
this.txtYouZheng.Clear();this.txtBiYeTime.Clear();this.txtAddress.Clear();this.cboMinZu.SelectedIndex=0;
this.cboWenHua.SelectedIndex=0;this.cboZhuanYe.SelectedIndex=0;
}
private void ShowDataGrid() //显示DataGird样式
{
objSqlConn.Open();
objSqlDataAdapter=new OleDbDataAdapter();
objSqlDataAdapter.SelectCommand=new OleDbCommand("select * from Message",objSqlConn);
objDataSet=new DataSet();
objSqlDataAdapter.Fill(objDataSet,"Message");
this.dbgBooksDt.SetDataBinding(objDataSet,"Message");
this.objSqlConn.Close();
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dbgBooksDt.DataMember;
dbgBooksDt.TableStyles.Add(ts);
dbgBooksDt.TableStyles["Message"].GridColumnStyles[2].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[6].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[3].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[7].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[4].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[8].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[5].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[9].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[10].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[11].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[12].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[13].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[14].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[15].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[16].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[17].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[18].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[19].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[20].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[21].Width=0;
dbgBooksDt.TableStyles["Message"].GridColumnStyles[22].Width=0;dbgBooksDt.TableStyles["Message"].GridColumnStyles[23].Width=0;
}
private void frmManager_Load(object sender, System.EventArgs e)
{
this.comboBox2.Enabled=false;
string strConnection="Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection+=@"Data Source=Student.mdb";
objSqlConn=new OleDbConnection(strConnection);
ShowDataGrid(); MinzuShow();WenhuaShow();ZhuanyeShow();
user myUser = user.InitUser(); //权限设置
if(myUser.isPublicUser == false)
{
this.btnDataOut.Enabled=false;this.btnFile.Enabled=false;
this.btnDelete.Enabled=false;this.btnSave.Enabled=false;
this.btnReset.Enabled=false;this.button1.Enabled=false;
this.btnChoose.Enabled=false;this.btnClear.Enabled=false;
}
else//if(myUser.isPublicUser==true)
{
this.btnDataOut.Enabled=true;this.btnFile.Enabled=true;
this.btnDelete.Enabled=true;this.btnSave.Enabled=true;
this.btnReset.Enabled=true;this.button1.Enabled=true;
this.btnChoose.Enabled=true;this.btnClear.Enabled=true;
}
}
private void btnExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void btnChoose_Click(object sender, System.EventArgs e)//选择并保存图片
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.InitialDirectory = "c:\\";
openFileDialog1.Filter = "JPG 文件(*.jpg)|*.jpg|GIF 文件(*.gif)|*.gif|WMF 文件(*.wmf)|*.wmf";
openFileDialog1.FilterIndex = 1;
openFileDialog1.Title = "打开图象文件";
openFileDialog1.RestoreDirectory = true;
if (openFileDialog1.ShowDialog( ) == DialogResult.OK)
{
string strFileName = openFileDialog1.FileName;
Bitmap m_bitmap = new Bitmap(strFileName);
this.pictureBox1.Image = m_bitmap;
FileStream fs = File.OpenRead(strFileName);
b⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -