📄 frmmain_gj.cs
字号:
DataSet ds=new DataSet();
da.Fill(ds,"jsxxb");
this.datag_js.SetDataBinding(ds,"jsxxb");
}
if(e.Button.Text=="删除")
{
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
this.txt_js.Focus();
string delCmd="delete from jsxxb where jsbh like'"+this.txt_js.Text +"'";
MessageBox.Show (delCmd);
SqlCommand comm=new SqlCommand (delCmd,conn);
try
{
conn.Open();
DialogResult dr=MessageBox.Show ("确定要删除记录吗？","确认",MessageBoxButtons .YesNo );
if(dr==DialogResult.Yes)
{
comm.ExecuteNonQuery ();
MessageBox.Show ("删除成功！");
}
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message );
}
finally
{
conn.Close();
}
SqlDataAdapter da=new SqlDataAdapter("select * from jsxxb",conn);
DataSet ds=new DataSet();
da.Fill(ds,"jsxxb");
this.datag_js.SetDataBinding(ds,"jsxxb");
}
if(e.Button.Text=="查询")
{
if(txt_js.Text.Trim()=="")//检查非空字段
{
MessageBox.Show("查询编号不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
string sql="select * from jsxxb where jsbh='"+this.txt_js.Text+"'";
SqlDataAdapter da=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"jsxxb");
this.datag_js.SetDataBinding(ds,"jsxxb");
}
if (e.Button.Text == "刷新")
{
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
SqlDataAdapter da=new SqlDataAdapter("select * from jsxxb",conn);
DataSet ds=new DataSet();
da.Fill(ds,"jsxxb");
this.datag_js.SetDataBinding(ds,"jsxxb");
}
if(e.Button.Text=="退出")
{
this.Close();
}
}
private void ClearFields()
{
}
private void SetModifyMode()
{
}
private void datag_js_Click(object sender, System.EventArgs e)
{
this.txt_js.Text=this.datag_js[this.datag_js.CurrentRowIndex,0].ToString();
}
private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void tabp_dz_Click(object sender, System.EventArgs e)
{
}
private void dataGrid3_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void groupBox3_Enter(object sender, System.EventArgs e)
{
}
private void txt12_TextChanged(object sender, System.EventArgs e)
{
}
private void label3_Click(object sender, System.EventArgs e)
{
}
private void tabPage1_Click(object sender, System.EventArgs e)
{
}
private void groupBox4_Enter(object sender, System.EventArgs e)
{
}
private void txt_yhrq_TextChanged(object sender, System.EventArgs e)
{
}
private void txt_jsrq_TextChanged(object sender, System.EventArgs e)
{
}
private void txt_jsbh_TextChanged(object sender, System.EventArgs e)
{
}
private void label7_Click(object sender, System.EventArgs e)
{
}
private void label5_Click(object sender, System.EventArgs e)
{
}
private void label6_Click(object sender, System.EventArgs e)
{
}
private void label8_Click(object sender, System.EventArgs e)
{
}
private void txt_dzbh_TextChanged(object sender, System.EventArgs e)
{
}
private void lbl_lx_Click(object sender, System.EventArgs e)
{
}
private void txt_bz_TextChanged(object sender, System.EventArgs e)
{
}
private void groupBox5_Enter(object sender, System.EventArgs e)
{
}
private void datag_js_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void label4_Click(object sender, System.EventArgs e)
{
}
private void txt_js_TextChanged(object sender, System.EventArgs e)
{
}
private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void label1_Click(object sender, System.EventArgs e)
{
}
private void txt1_TextChanged(object sender, System.EventArgs e)
{
}
private void groupBox1_Enter(object sender, System.EventArgs e)
{
}
private void tabp_sj_Click(object sender, System.EventArgs e)
{
}
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
}
private void dataGrid2_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void groupBox2_Enter(object sender, System.EventArgs e)
{
}
private void label2_Click(object sender, System.EventArgs e)
{
}
private void txt2_TextChanged(object sender, System.EventArgs e)
{
}
private void dataGrid2_Click(object sender, System.EventArgs e)
{
this.txt2.Text=this.dataGrid2[this.dataGrid2.CurrentRowIndex,0].ToString();
}
private void dataGrid3_Click(object sender, System.EventArgs e)
{
this.txt12.Text=this.dataGrid3[this.dataGrid3.CurrentRowIndex,0].ToString();
}
private void toolBar5_ButtonClick_1(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
if(e.Button.Text=="新增")
{
insert_hsbook f=new insert_hsbook();
f.ShowDialog();
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
SqlDataAdapter da=new SqlDataAdapter("select * from hsxxb",conn);
DataSet ds=new DataSet();
da.Fill(ds,"hsxxb");
this.dataG_hs.SetDataBinding(ds,"hsxxb");
}
if(e.Button.Text=="删除")
{
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
this.txt_hs.Focus();
string delCmd="delete from hsxxb where hsbh like'"+this.txt_hs.Text +"'";
MessageBox.Show (delCmd);
SqlCommand comm=new SqlCommand (delCmd,conn);
try
{
conn.Open();
DialogResult dr=MessageBox.Show ("确定要删除记录吗？","确认",MessageBoxButtons .YesNo );
if(dr==DialogResult.Yes)
{
comm.ExecuteNonQuery ();
MessageBox.Show ("删除成功！");
}
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message );
}
finally
{
conn.Close();
}
SqlDataAdapter da=new SqlDataAdapter("select * from hsxxb",conn);
DataSet ds=new DataSet();
da.Fill(ds,"hsxxb");
this.dataG_hs.SetDataBinding(ds,"hsxxb");
}
if(e.Button.Text=="查询")
{
if(txt_hs.Text.Trim()=="")//检查非空字段
{
MessageBox.Show("查询编号不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
this.txt_hs.Focus();
string sql="select * from hsxxb where hsbh='"+this.txt_hs.Text+"'";
SqlDataAdapter da=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"hsxxb");
this.dataG_hs.SetDataBinding(ds,"hsxxb");
}
if (e.Button.Text == "刷新")
{
StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
string sn=sr.ReadLine();
SqlConnection conn=new SqlConnection(sn);
SqlDataAdapter da=new SqlDataAdapter("select * from hsxxb",conn);
DataSet ds=new DataSet();
da.Fill(ds,"hsxxb");
this.dataG_hs.SetDataBinding(ds,"hsxxb");
}
if(e.Button.Text=="退出")
{
this.Close();
}
}
private void dataG_hs_Click(object sender, System.EventArgs e)
{
this.txt_hs.Text=this.dataG_hs[this.dataG_hs.CurrentRowIndex,0].ToString();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -