（安全生產(chǎn)）安全檔案管理軟件

∨(蓋章)素。人的不安全行為往往是造成各類安全事故的直接原因。企業(yè)員工越多，安全管理的難度就越大。使用流行的MicrosoftVisualStudio5集成開發(fā)環(huán)境，C#語言，有效措施，杜絕各類事故的發(fā)生，從而實現(xiàn)安全生產(chǎn)。建立安全檔案的必要性：采取有效措施，杜絕各類事故的發(fā)生，從而實現(xiàn)安全生產(chǎn)。合適的推薦代碼等等太多的強(qiáng)大功能。壯等優(yōu)點。他是一個網(wǎng)絡(luò)數(shù)據(jù)庫服務(wù)器，而且還是一個數(shù)據(jù)分析的平臺。以及安全性。由于本安全檔案數(shù)據(jù)庫中的數(shù)據(jù)表眾多，現(xiàn)只對安全考試信息表的結(jié)構(gòu)截圖如下。usingSystem.Collections.Generic;usingSystem.Data.SqlClient;{{publicstaticstringLogin_ID="";//定義全局變量，記錄當(dāng)前登錄的用戶編號publicstaticstringLogin_Name="";//定義全局變量，記錄當(dāng)前登錄的用戶名publicstaticstringAllSql="Select*fromtb_Stuffbusic";//存儲職工基本信///建立數(shù)據(jù)庫連接.publicstaticSqlConnectiongetcon(){}///測試數(shù)據(jù)庫是否賦加{getcon();//con_close();}///關(guān)閉于數(shù)據(jù)庫的連接.publicvoidcon_close(){{My_con.Close();//關(guān)閉數(shù)據(jù)庫的連接}}///讀取指定表中的信息.{getcon();//打開與數(shù)據(jù)庫的連接}{getcon();//打開與數(shù)據(jù)庫的連接con_close();//調(diào)用con_close()方法，關(guān)閉與數(shù)據(jù)庫的連接}{getcon();//打開與數(shù)據(jù)庫的連接SQLda.Fill(My_DataSet,tableName);//通過SqlDataAdapter對象的Fill()方法，con_close();//關(guān)閉數(shù)據(jù)庫的連接//WritePrivateProfileString(stringsection,stringkey,stringval,stringfilePath);}}}usingSystem.Collections.Generic;usingSystem.Data.SqlClient;{{publicstaticstringFindValue="";//存儲查詢條件publicstaticstringAddress_ID="";//存儲通訊錄添加修改時的ID編號publicstaticstringUser_ID="";//存儲用戶的ID編號publicstaticstringUser_Name="";//存儲用戶名///窗體的調(diào)用.{{{}{}{FrmAddressList.Text="通訊錄";FrmAddressList.Dispose();}{}{FrmClearData.Dispose(}{System.Diagnostics.Process.Start("calc.exe");}{System.Diagnostics.Process.Start("notepad.exe");}}{StringFrmStr="";//記錄窗體名稱{}{}{}{}{}{}{}{}{}{}FrmBasic.ShowDialog()FrmBasic.Dispose();}}///在添加信息時自動計算編號.{//查找指定表中ID號為最大的記錄{if(MyDR[0].ToString()=="")return"0001";Num=Convert.ToInt32(MyDR[0].ToString());//將當(dāng)前找到的最大編號轉(zhuǎn)換成strings=string.Format("{0:0000}",Num);//將整數(shù)值轉(zhuǎn)換成指定格式的字符串returns;//返回自動生成的編號}else{return"0001";//當(dāng)數(shù)據(jù)表沒有記錄時，返回}}{cobox.Items.Clear();{{}}}{cobox.Items.Clear();{{}}}{stringsm,sd;inty,m,d;try{}{return"";}return"";elseif(d<10)else}{stringsh,sm,se;try{}{return"";}if(sh.Length<2)se=Convert.ToString(ss);if(se.Length<2)}{}///設(shè)置按鈕是否可用.intn3,intn4){}///清空所有控件下的所有控件.publicvoidClear_Control(Control.ControlCollectionCon){foreach(ControlCinCon){//遍歷if(((TextBox)C).Visible==true)//判斷當(dāng)前控件是否為顯示狀態(tài)((TextBox)C).Clear();//清空當(dāng)前控件if(((MaskedTextBox)C).Visible==true)//判斷當(dāng)前控件是否為顯示狀態(tài)((MaskedTextBox)C).Clear();//清空當(dāng)前控件if(((ComboBox)C).Visible==true)//判斷當(dāng)前控件是否為顯示狀態(tài)if(((PictureBox)C).Visible==true)//判斷當(dāng)前控件是否為顯示狀態(tài)}}///保存添加或修改的信息.publicvoidPart_SaveClass(stringSarr,stringID1,stringID2,Control.Contr{}else{tem_Field="Sut_id,ID";}}else}else}if(m>0){//生成部份添加、修改語句string[]Parr=Sarr.Split(Convert.ToChar(','));for(inti=p;i<n;i++){foreach(ControlCinContr){//遍歷控件集中的相關(guān)控件stringCtext=C.Text;Ctext=Date_Format(C.Textem_Field=tem_Field+","+Parr[i];if(Ctext=="")else}if(Ctext=="")else}}}}if(ID2=="")//根據(jù)ID2參數(shù)，判斷修改語句的條件else}}{stringsID="";{{{{C.Text=DGrid[i,DGrid.CurrentCell.RowIndex].Value.ToString();elsex].Value).Trim());}}}}}publicvoidClear_Grids(intn,Control.ControlCollectionGBox,stringTName){stringsID="";for(inti=2;i<n;i++){{{C.Text="";}}}}{DGrid.Columns[0].Visible=false;DGrid.Columns[1].Visible=false;}///將字符型日期轉(zhuǎn)換成日期進(jìn)行判斷.{try{returntrue;}{returnfalse;}}///文本框只能輸入數(shù)字型和單精度型的字符串.publicvoidEstimate_Key(KeyPressEventArgse,strings,intn){if(n==0)//只能輸入整型'){}if(n==1)//可以輸入整型或單精度型{{}else{if(e.KeyChar=='.')//如果輸入“.”if(s=="")//當(dāng)前文本框為空else{if(s.Length>0)//當(dāng)文本框不為空時{if(s.IndexOf(".")>-1)//查找是否已輸入過“.”}}}}}///清空數(shù)據(jù)庫中的所有數(shù)據(jù)表.{stringsID="";{{{{string[]Astr=sID.Split(Convert.ToChar('_'));if(Astr[1].ToUpper()==("Clew").ToUpper()){");}else{if(Astr[1].ToUpper()==("Login").ToUpper()){001','TSoft','111')");}}}}}}}///以二進(jìn)制的形式將圖片存儲到數(shù)據(jù)庫中.{StringBuilderstrSql=newStringBuilder();n);}}}現(xiàn)就最復(fù)雜的安全檔案瀏覽窗體中的部分代碼進(jìn)行說明。usingSystem.Collections.Generic;usingSystem.Data.SqlClient;{publicpartialclassF_ManFile:Form{publicF_ManFile(){InitializeComponent();}publicstaticstringtem_Field="";publicstaticstringtem_Value="";publicstaticstringtem_ID="";publicstaticinthold_n=0;publicstaticbyte[]imgBytesIn;//用來存儲圖片的二進(jìn)制數(shù)publicstaticintIma_n=0;//判斷是否對圖片進(jìn)行了操作publicstaticstringPart_ID="";//存儲數(shù)據(jù)表的ID信息{byte[]buffer=DI;}///動態(tài)讀取指定的記錄行，并進(jìn)行顯示.{byte[]pic;//定義一個字節(jié)數(shù)組{S_0.Text=DGrid[0,DGrid.CurrentCell.RowIndex].Value.ToString();S_1.Text=DGrid[1,DGrid.CurrentCell.RowIndex].Value.ToString();S_2.Text=Convert.ToString(DGrid[2,DGrid.CurrentCell.RowIndex].Value).Trim();RowIndex].Value).Trim());S_4.Text=Convert.ToString(DGrid[4,DGrid.CurrentCell.RowIndex].Value).Trim();S_5.Text=DGrid[5,DGrid.CurrentCell.RowIndex].Value.ToString();S_6.Text=DGrid[6,DGrid.CurrentCell.RowIndex].Value.ToString();S_7.Text=DGrid[7,DGrid.CurrentCell.RowIndex].Value.ToString();S_8.Text=DGrid[8,DGrid.CurrentCell.RowIndex].Value.ToString();S_9.Text=DGrid[9,DGrid.CurrentCell.RowIndex].Value.ToString();l.RowIndex].Value).Trim());S_11.Text=Convert.ToString(DGrid[11,DGrid.CurrentCell.RowIndeTrim();S_12.Text=DGrid[12,DGrid.CurrentCell.RowIndex].Value.ToString();S_13.Text=DGrid[13,DGrid.CurrentCell.RowIndex].Value.ToString();//S_14.Text=DGrid[14,DGrid.CurrentCell.RowIndex].Value.ToString();S_14.Text=DGrid[14,DGrid.CurrentCell.RowIndex].Value.ToString();S_15.Text=DGrid[15,DGrid.CurrentCell.RowIndex].Value.ToString();S_16.Text=DGrid[16,DGrid.CurrentCell.RowIndex].Value.ToString();S_17.Text=DGrid[17,DGrid.CurrentCell.RowIndex].Value.ToString();S_18.Text=DGrid[18,DGrid.CurrentCell.RowIndex].Value.ToString();S_19.Text=DGrid[19,DGrid.CurrentCell.RowIndex].Value.ToString();l.RowIndex].Value).Trim());S_21.Text=DGrid[21,DGrid.CurrentCell.RowIndex].Value.ToString();S_22.Text=DGrid[23,DGrid.CurrentCell.RowIndex].Value.ToString();S_23.Text=DGrid[24,DGrid.CurrentCell.RowIndex].Value.ToString();S_24.Text=Convert.ToString(DGrid[25,DGrid.CurrentCell.RowIndeTrim();S_25.Text=DGrid[26,DGrid.CurrentCell.RowIndex].Value.ToString();try{//將數(shù)據(jù)庫中的圖片存入到字節(jié)數(shù)組中pic=(byte[])(MyDS_Grid.Tables[0].Rows[DGrid.CurrentCell.RowIndex][22]);}tem_ID=S_0.Text.Trim();//獲取當(dāng)前職伯編號returnDGrid[1,DGrid.CurrentCell.RowIndex].Value.ToString();//返回當(dāng)前}else{return"";}}///通過公共變量動態(tài)進(jìn)行查詢.{Field+"='"+tem_Value+"'","tb_Stuffbusic");textBox1.Text=Grid_Inof(dataGridV}{openF.Filter="*.jpg|*.jpg|*.bmp|*.bmp";//指定OpenFileDialog控件打開的{try{stringstrimg=openF.FileName.ToString();//記錄圖片的所在路徑imgBytesIn=br.ReadBytes((int)fs.Length);//將流讀入到字節(jié)數(shù)組中}{}}}{sic");{dataGridView1.Columns[i].Visible=false;}息MyMC.CityInfo(S_22,"selectdistinctbeawarefromtb_City",0);textBox1.Text=Grid_Inof(dataGrid}privatevoidSut_Add_Cl{MyMC.Clear_Control(tabControl1.TabPages[0].Controls);//清空職工基本信}{S_23.Items.Clear();ext.Trim()+"'",1);}privatevoidtabControl1_Click(objectsender,EventArgse){{Img_Clear.Enabled=false;//使按鈕為不可用狀態(tài)}){//Sub_Table.Enabled=false;{}{}{}{}{}}{}}{{case0:{//職工姓名break;case4:}case1://性別{break;}case2:{tem_Field="Folk";break;}case3:{tem_Field="Kultur";break;}{break;}case5:{break;}case6:{break;}case7:{break;}case8:{tem_Field="Duthcall";break;}case9:{break;}{break;}}}privatevoidN_First_Click(objectsender,EventArgse){try{elseif((((Button)sender).Name)=="N_First"){dataGridView1.CurrentCell=this.dataGridView1[ColInd,0];}{{}else{rentCell.RowIndex-1];}}{{}else{}}{}}catch{}}privatevoidN_Previous_Click(objectsender,EventArgse){N_First_Click(sender,e);}{N_First_Click(sender,e);}{N_First_Click(sender,e);}{try{{textBox1.Text=Grid_Inof(dataGridV//獲取工作簡歷表中的信息//清空相應(yīng)的控件rd_");//獲取家庭關(guān)系表中的信息