空軍維該項(xiàng)目管理系統(tǒng)詳細(xì)方案設(shè)計(jì)報(bào)告_第1頁
空軍維該項(xiàng)目管理系統(tǒng)詳細(xì)方案設(shè)計(jì)報(bào)告_第2頁
空軍維該項(xiàng)目管理系統(tǒng)詳細(xì)方案設(shè)計(jì)報(bào)告_第3頁
空軍維該項(xiàng)目管理系統(tǒng)詳細(xì)方案設(shè)計(jì)報(bào)告_第4頁
空軍維該項(xiàng)目管理系統(tǒng)詳細(xì)方案設(shè)計(jì)報(bào)告_第5頁
免費(fèi)預(yù)覽已結(jié)束,剩余66頁可下載查看

下載本文檔

版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

編 維該項(xiàng)目管理系 詳細(xì)方案設(shè)計(jì)報(bào)引 背 系統(tǒng)概 總體設(shè) 接口設(shè) 運(yùn)行設(shè) 設(shè) 約 安全設(shè) 背文檔概設(shè)計(jì)依裝備指定的需求規(guī)格說明書和模板文檔項(xiàng)目開題評(píng)審(方案評(píng)審、技術(shù)鑒定)系統(tǒng)功能目項(xiàng)目申請(qǐng):將申請(qǐng) 入系統(tǒng),并保存至數(shù)據(jù)庫中系統(tǒng)性能目可以輸出Word,Excel軟件要求能夠在WindowsXP運(yùn)行環(huán)PC最低配置:CPU是Pentium1.8G或者相等的產(chǎn)品,1GB內(nèi)存;操作系統(tǒng):WindowsXP操作系統(tǒng)。輔助軟件:安裝SQLServe2005,支持?jǐn)?shù)據(jù)設(shè)計(jì)約軟件的開發(fā)采用VisualStudio2005開發(fā)工具,開發(fā)語言采用C#;數(shù)據(jù)采用SQLServe2005。設(shè)計(jì)原Word模板進(jìn)行填寫,而不在系統(tǒng)界面上進(jìn)行錄對(duì)于數(shù)據(jù)庫中,以及誤操作進(jìn)行檢查和報(bào)錯(cuò),使得系統(tǒng)具有良好的允許允許立系統(tǒng)運(yùn)行流系統(tǒng)總體運(yùn)行項(xiàng)目評(píng)生成項(xiàng)目評(píng)生成專家項(xiàng)目項(xiàng)目申專家?guī)熹洺晒瞥晒平o下達(dá)文件項(xiàng)目歸檔管數(shù)據(jù)庫備數(shù)據(jù)庫恢1軟件典型操作流填寫項(xiàng)新建項(xiàng)項(xiàng)目申請(qǐng)→彈出頁面→點(diǎn)擊新建按填寫項(xiàng)新建項(xiàng)保存項(xiàng)2 入→項(xiàng)目簡(jiǎn)介→保存→項(xiàng)目主要→保存→經(jīng)費(fèi)預(yù)算表→新建保存→預(yù)算明細(xì)表→新建→保存→項(xiàng)目?jī)?nèi)容(Word模板)→保存(.doc)→結(jié)保保項(xiàng)目簡(jiǎn)項(xiàng)保經(jīng)費(fèi)預(yù)算預(yù)算明細(xì)項(xiàng)目?jī)?nèi)3錄入專家?guī)欤▓D立項(xiàng)評(píng)保填新專家?guī)旃芰㈨?xiàng)評(píng)審→專家?guī)旃芾怼陆ā㈨?xiàng)評(píng)保填新專家?guī)旃苌蓪<?專家評(píng)審(圖立項(xiàng)評(píng)保評(píng)選擇主審家新專家評(píng)選立項(xiàng)評(píng)保評(píng)選擇主審家新專家評(píng)選擇主審目專家評(píng)生成評(píng)審5過程管理(圖目→補(bǔ)充完整任務(wù)書所需信息→錄入任務(wù)書→簡(jiǎn)介→保存→項(xiàng)目主要過程管保新預(yù)算明細(xì)保新經(jīng)費(fèi)預(yù)算過程管保新預(yù)算明細(xì)保新經(jīng)費(fèi)預(yù)算保新項(xiàng)目組成保項(xiàng)目主要責(zé)保簡(jiǎn)項(xiàng)目任務(wù)任務(wù)書內(nèi)6項(xiàng)目歸檔(圖項(xiàng)目歸檔→選擇項(xiàng)目→選擇歸檔文件→提交→創(chuàng)建項(xiàng)目文件夾,歸檔項(xiàng)目項(xiàng)目項(xiàng)目歸上傳文選擇歸檔件選擇項(xiàng)創(chuàng)建項(xiàng)目件項(xiàng)目管理(圖

7項(xiàng)目管理→輸入查詢條件→查詢→樹形結(jié)構(gòu)顯示符合您文件項(xiàng)目→展開指彈出歸檔文件項(xiàng)目管選項(xiàng)目管選擇歸檔文展開項(xiàng)樹形顯示項(xiàng)查輸入查詢條系統(tǒng)總體劃參照節(jié)“2.1系統(tǒng)功能目標(biāo)”,軟件按可以分為項(xiàng)目申請(qǐng)、立項(xiàng)評(píng)審、過程系統(tǒng)版本說系統(tǒng)版本說單位部門設(shè)系統(tǒng)管理模單位信息設(shè)修改用專家評(píng)立項(xiàng)評(píng)審模專家?guī)旃茼?xiàng)目任務(wù)項(xiàng)目申項(xiàng)目管項(xiàng)目項(xiàng)目管項(xiàng)目管理模項(xiàng)目歸數(shù)據(jù)庫恢?jǐn)?shù)據(jù)庫管理模數(shù)據(jù)庫備用戶界軟件接運(yùn)行于WindowsXP硬件接支持一般x86系列電腦,CPU是Pentium1.8G或者相等的產(chǎn)品,1GB出錯(cuò)設(shè)采用框形式為用戶提供警告信息安全設(shè)設(shè)外部設(shè)約避免使用常用的名稱空間[Namespace]中的類型名稱[Class避免使用與常用 ]有的標(biāo)識(shí)符邏輯結(jié)構(gòu)設(shè)NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot與項(xiàng)目NotNotNotNotNot通信地址及NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot主要戰(zhàn)術(shù)技術(shù)指標(biāo)NotNotNotNot項(xiàng)目承擔(dān)單位意見項(xiàng)目承擔(dān)單位負(fù)NotNot2NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot2NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot研制任務(wù)來源Not產(chǎn)品概述及Not關(guān)鍵技術(shù)及NotNot經(jīng)費(fèi)使用情況Not主要配套元器件部件的質(zhì)量及供貨Not標(biāo)準(zhǔn)化Not產(chǎn)品工藝性Not產(chǎn)品尚存在問題及解決NotNotNotNotNotNotNotNotNotNotNot想NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot徑Not估NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot專家Not2NotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNotNot題關(guān)系通過建立主外鍵關(guān)系,由SQL安全性設(shè)安全設(shè)業(yè)務(wù)部(局機(jī)數(shù)據(jù)數(shù)業(yè)務(wù)部(局機(jī)數(shù)據(jù)數(shù)據(jù)庫接口軟實(shí)實(shí)施單用戶登項(xiàng)過成專統(tǒng)目程果家計(jì)申管管庫分報(bào)理理管析子子子理子系系系子系統(tǒng)統(tǒng)統(tǒng)系統(tǒng)統(tǒng)管理、節(jié)點(diǎn)控制、專家?guī)旃芾?、統(tǒng)計(jì)分析(效益評(píng)估)namespace{publicpartialclassMainForm:{public{}publicstringglobalname;privatestringMyBgPhoto;privatestringMyAddress;privatestringMy;privatestringMyCode;privatestringMyWeb;privatestringMySlogan;privatestringMyBgPhotoShow;privatestringMyOperator;privatestring privatevoidMainForm_Load(objectsender,EventArgs{Application.ThreadException+=MyThreadException;//顯示登錄LoginFormMyDlg=newLoginForm();MyDlg.Text用MySlogan;this.MyOperatorMyDlg.用戶名稱if(MyOperator.Length>{this.WindowState=FormWindowState.}this.BackgroundImage=newBitmap(this.MyBgPhotoShow,this.Text=MySlogan;}{stringMyInfoe.Exception.SourceMessageBox.Show(MyInfo,MessageBoxButtons.OK,}protectedoverridevoidWndProc(refMessage{switch{caseif(((int)SystemMessage.ram)=={退出系統(tǒng)EToolStripItem_Click(null,}{base.WndProc(ref}base.WndProc(refSystemMessage);}}public {StringMySQLConnectionString=stringMySQL="Select*From公司信息Where顯示優(yōu)先級(jí)=1";SqlConnectionMyConnectionnewSqlConnection(MySQLConnectionString);DataTableMyTable=newSqlDataAdapterMyAdapter=newSqlDataAdapter(MySQL,MyConnection);MyBgPhotoApplication.StartupPath\Data\String)MyTable.Rows[0]["管理系統(tǒng)背景"];MySloganString)MyTable.Rows[0]["管理系統(tǒng)顯示名稱"];pany=(String)MyTable.Rows[0]["公司名稱"];if(MyConnection.State=={}MyBgPhotoShowApplication.StartupPath"\\Data\\Show(String)MyTable.Rows[0]["管理系統(tǒng)背景"];}publicvoidSetUserOperate{StringMySQLConnectionString=stringMySQL"Select*FromWherethis.MyOperatorSqlConnectionMyConnection=newSqlConnection(MySQLConnectionString);DataTableMyTable=newSqlDataAdapterMyAdapter=newSqlDataAdapter(MySQL,MyConnection);if(MyConnection.State=={}}privatevoid公司信息設(shè)置ToolStripItem_Click(objectsender,EventArgs{CompanyFormMyDlg=newCompanyForm();StringBuilderMyTempPath=newStringBuilder(this.MyBgPhotoShow);if{ImageMyImage=newBitmap(MyBgPhoto,true);intPosX=10;intPosY=MyImage.Height/2+200;intMyFont=150;boolbMyFound=intMyWidth=MyImage.Width;intMyHeight=MyImage.Height;intMySize=MyWidth*MyHeight;BitmapMyPattern=newBitmap(MyWidth,MyHeight);BitmapMyBitmap=newBitmap(MyImage);Graphicsg=Graphics.FromImage(MyPattern);GraphicsMyGraphics=Graphics.FromImage(MyImage);while(bMyFound=={FontNewFontnewFont(MyFont,FontStyle.Bold);SizeFMyString=newSizeF(MyWidth,MyHeight);MyString=g.MeasureString(MySlogan,NewFont);if(MyString.Width<MyPattern.Width){if(MyString.Height<{

bMyFound=}}MyFont=MyFont-}for(intx=1;x<MyPattern.Width;{for(inty=1;y<MyPattern.Height;{inta,re,gr,bl,x1,y1,if(MyPattern.GetPixel(x,y).ToArgb()=={a=MyBitmap.GetPixel(x,y).A;re=MyBitmap.GetPixel(x,y).R;gr=MyBitmap.GetPixel(x,y).G;bl=MyBitmap.GetPixel(x,y).B;x1=re;y1=gr;z1=+<=++<=++<=+->=-->=-->=-MyGraphics.DrawEllipse(newPen(newSolidBrush(Color.Black)),x,+1,3,MyGraphics.DrawEllipse(newPen(newx1,y1,z1))),x,y,1,}}}MyImage.Save(MyBgPhotoShow,}this.BackgroundImage=newBitmap(this.MyBgPhotoShow,true);this.Text=MySlogan;}privatevoid退出系統(tǒng)EToolStripItem_Click(objectsender,EventArgs{ifMessageBox.Show("您確定現(xiàn)在退出本系統(tǒng)嗎MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.Yes){}}privatevoid公司部門設(shè)置ToolStripItem_Click(objectsender,EventArgs{DepartmentFormMyDlg=newDepartmentForm();}privatevoid系統(tǒng)幫助信息ToolStripItem_Click(objectsender,EventArgs{VersionFormMyDlg=newVersionForm();MyDlg.label1.Text=this.MySlogan;}privatevoid操作權(quán)限設(shè)置ToolStripItem_Click(objectsender,EventArgs{OperatorFormMyDlg=newOperatorForm();}privatevoid修改用戶ToolStripItem_Click(objectsender,EventArgs{ChangeUserPasswordFormMyDlgnewChangeUserPasswordForm();MyDlg.用戶名稱TextBox.Text=this.MyOperator;}privatevoid數(shù)據(jù)錄入ToolStripItem_Click_1(objectsender,EventArgs{InsertDataMyDlg=newInsertData();MyDlg.CustomerName=this.MyOperator;}privatevoidtoolStripButton1_Click(objectsender,EventArgs{ExpertCheckupFormMyDlg=newExpertCheckupForm();}privatevoid理toolStripLabel_Click(objectsenderEventArgs{ExpertDetailsFormMyDly=newExpertDetailsForm();}privatevoidtoolStripButton2_Click(objectsender,EventArgs{AchievementFormMyDly=newAchievementForm();}privatevoidtoolStripButton3_Click(objectsenderEventArgs{AssignmentFormMyDly=newAssignmentForm();}privatevoid系統(tǒng)版本說明ToolStripItem_Click(objectsender,EventArgs{AboutBox1MyDlg=newAboutBox1();}privatevoid申請(qǐng)數(shù)據(jù)上報(bào)ToolStripItem_Click(objectsender,EventArgs{DataShangBaoMyDlg=newDataShangBao();}privatevoid項(xiàng)目任務(wù)書ToolStripItem_Click(objectsender,EventArgs{AssignmentFormMyDlg=newAssignmentForm();}privatevoidtoolStripButton4_Click(objectsenderEventArgs{DataJieShouMyDlg=newDataJieShou();}privatevoidtoolStripButton4_Click(objectsenderEventArgs{PSresultMyDlg=newPSresult();}privatevoid項(xiàng)目方案錄入toolStripItem1_Click(objectsender,EventArgs{//DevelopFormMyDlg=newProManagementForm1MyDlg=newProManagementForm1();}privatevoid項(xiàng)目總結(jié)錄入ToolStripItem_Click(objectsender,EventArgs{//SumUpListFormMyDlg=newProSumUpFormMyDlg=newProSumUpForm();}privatevoid數(shù)據(jù)接收ToolStripItem1_Click(objectsender,EventArgs{DataJieShouMyDlg=newDataJieShou();}privatevoid項(xiàng)目數(shù)據(jù)上報(bào)ToolStripItem_Click(objectsender,EventArgs{ProDataShangBaoMyDlg=newProDataShangBao();}privatevoidtoolStripButton5_Click(objectsender,EventArgs{databaseManagerMyDlg=newdatabaseManager();}privatevoid數(shù)據(jù)庫管理ToolStripItem_Click(objectsender,EventArgs{}privatevoid數(shù)據(jù)庫備份ToolStripItem_Click(objectsender,EventArgs{databaseManagerMyDlg=newdatabaseManager();}privatevoid數(shù)據(jù)庫恢復(fù)ToolStripItem_Click(objectsender,EventArgs{OpenFileDialogopenFileDialogDSKnewOpenFileDialog();openFileDialogDSK.Title="請(qǐng)選擇恢復(fù)的數(shù)據(jù)庫文件";stringMyFileName=openFileDialogDSK.FileName.ToString();if(MyFileName==""){MessageBox.Show("請(qǐng)選擇要恢復(fù)的數(shù)據(jù)庫文件MessageBoxButtons.OK,}{stringfileNAME=fileNAME=fileNAME.Substring(fileNAME.LastIndexOf("\\")+1);fileNAME=fileNAME.Substring(0,fileNAME.LastIndexOf("."));stringMyDatabase=fileNAME;stringMySQL="usemaster;Restoredatabase@MyDatabaseFromdisk=;IntegratedSecurity= mand=new mand(MySQL,MyConnection);mand.Parameters.Add("@MyDatabase",SqlDbType.Char);mand.Parameters["@MyDatabase"].Value=MyDatabase;mand.Parameters.Add("@MyFileName",SqlDbType.Char);mand.Parameters["@MyFileName"].Value=MyFileName;{

MessageBox.Show("成功恢復(fù)指定數(shù)據(jù)庫}catch(Exception{MessageBox.Show(ex.Message,提示MessageBoxButtons.OK,}{}}}privatevoid中期匯報(bào)ToolStripItem_Click(objectsender,EventArgs{MediumCheckFormMyDlg=newMediumCheckForm();}privatevoid項(xiàng)目數(shù)據(jù)接收ToolStripItem_Click(objectsender,EventArgs{ProDataJieShouMyDlg=newProDataJieShou();}}privatevoidtoolStripButton查詢_Click(objectsender,EventArgs{CheckAllForm1MyDlg=newCheckAllForm1();}privatevoid書_Click(objectsenderEventArgs{}}}namespace{publicpartialclass{publicstringProName;publicstringProNumber;//publicstringProNumberChanged;publicstringleibie;publicstringshengqingdanwei;public錄入申請(qǐng)書(){}SqlDataAdapterMyAdapter;DataTableMytable;BindingSourceMyBinding;privatevoid書_Load(objectsenderEventArgs{TODO:ThislineofcodeloadsdataintothemyAssetsDataSetYoucanmove,orremoveit,asthis.錄入申請(qǐng)書TableAdapter.FillBythis.myAssetsDataSet.錄入申請(qǐng)書,ProName);this.項(xiàng)目編號(hào)Label8.Text=ProNumber;this.項(xiàng)目名稱Label2.Text//privateSystem.Data.DataTableprivatevoidbutton1_Click(objectsender,EventArgs{stringAddtime=DateTime.Now.ToString().Substring(0,8);stringMySQLConnectionString=SqlConnectionMyConnection=newSqlConnection(MySQLConnectionString); mand= stringMySQLSELECTFROMWHERE編號(hào)

mandText=objecttest //stringtest1=if {this.錄入申請(qǐng)書TableAdapter.UpdateQuery(ProName,Addtime,this.項(xiàng)目簡(jiǎn)介TextBox.Text,this.軍事需求TextBox.Text,this.應(yīng)用前景TextBox1.Text,this.先進(jìn)程度TextBox.Text,ProNumber);MessageBoxShow功","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);}{this.錄入申請(qǐng)書TableAdapter.InsertQuery(ProNameProNumber,Addtimethis.項(xiàng)目簡(jiǎn)介TextBox.Text,this.軍事需求TextBox.Text,this.應(yīng)用前景TextBox1.Text);MessageBox.Show(MessageBoxButtons.OK,}if(MyConnection.State=={}}privatevoidbutton2_Click(objectsenderEventArgs{privatevoidbindingNavigatorAddNewItem1_Click(objectsender,EventArgs{this.項(xiàng)目編號(hào)Label2.Text}privatevoidtabControl1_Click(objectsenderEventArgse){stringCurTabthis.tabControl1.SelectedTab.Text.ToString();if(CurTab=="設(shè)備費(fèi)明細(xì)預(yù)算"){this.bindingNavigator1.Visible=objecttest=this.設(shè)備費(fèi)預(yù)算明細(xì)表TableAdapter.FillBy(this.myAssetsDataSet.設(shè)備費(fèi)預(yù)算明細(xì)表,ProNumber);}ifCurTab=="材料費(fèi)明細(xì)預(yù)算{this.bindingNavigator3.Visible=objecttestthis.材料費(fèi)預(yù)算明細(xì)表材料費(fèi)預(yù)算明細(xì)表}ifCurTab=="業(yè)務(wù)費(fèi)明細(xì)預(yù)算{表,}

this.bindingNavigator4.Visible=ifCurTab=="外協(xié)費(fèi)明細(xì)預(yù)算{表,}

this.bindingNavigator5.Visible=}privatevoidtabControl_Click(objectsender,EventArgs{stringCurTab=if(CurTab=="項(xiàng)目主要{}

this.bindingNavigator6.Visible= ifCurTab=="經(jīng)費(fèi)預(yù)算表{}}

this.bindingNavigator7.Visible=privatevoidsaveToolStripButton_Click(objectsender,EventArgs{}privatevoidbindingNavigatorAddNewItem_Click(objectsender,EventArgs{this.項(xiàng)目名稱Label4.Text}privatevoidsaveToolStripButton1_Click(objectsender,EventArgs{}privatevoidsaveToolStripButton_Click_1(objectsender,EventArgs{}privatevoidbindingNavigatorAddNewItem3_Click(objectsender,EventArgs{this.項(xiàng)目名稱Label6.Text}privatevoidsaveToolStripButton2_Click(objectsender,EventArgs{}privatevoidbindingNavigatorAddNewItem4_Click(objectsender,EventArgs{this.項(xiàng)目名稱Label8.Text}privatevoidsaveToolStripButton3_Click(objectsender,EventArgs{}privatevoidbindingNavigatorAddNewItem5_Click(objectsender,EventArgs{this.項(xiàng)目編號(hào)Label4.Text}privatevoidsaveToolStripButton4_Click(objectsender,EventArgs{this.項(xiàng)目主要this.項(xiàng)目主要TableAdapter.Update(this.myAssetsDataSet.項(xiàng)目主要);}privatevoidbindingNavigatorAddNewItem6_Click(objectsender,EventArgs{this.項(xiàng)目編號(hào)Label6.TextProNumber;inta=0;this.設(shè)備費(fèi)TextBox1.Texta.ToString();this.材料費(fèi)TextBox1.Text="0";this.外協(xié)費(fèi)TextBox1.Textthis.業(yè)務(wù)費(fèi)TextBox1.Textthis.合計(jì)TextBox1.Text}privatevoidsaveToolStripButton5_Click(objectsender,EventArgs{decimalshebei=Convert.ToDecimal(Double.Parse(this.設(shè)備費(fèi)TextBox1.Text));decimalcailiaoConvert.ToDecimal(Double.Parse(this.材料費(fèi)TextBox1.Text));decimalwaixie=Convert.ToDecimal(Double.Parse(this.外協(xié)費(fèi)TextBox1.Text));decimalyewu=Convert.ToDecimal(Double.Parse(this.業(yè)務(wù)費(fèi)TextBox1.Text));decimalAddall=shebei+cailiao+waixie+yewu;ifthis.合計(jì)TextBox1.Text{}{

this.合計(jì)TextBox1.TextdecimalCheckAllConvert.ToDecimal(Double.Parse(this.合計(jì)TextBox1.Text));if(CheckAll!=Addall){MessageBox.Show("合計(jì)金額錯(cuò)誤,系統(tǒng)自動(dòng)計(jì)算總金額MessageBoxButtons.OK,MessageBoxIcon.Error);this.合計(jì)TextBox1.TextAddall.ToString}}stringMySQLConnectionString=stringMySQLjingfei"select*fromwhereProNumber

SqlConnectionMyconnet=newSqlConnection(MySQLConnectionString);mandcommand= mand(MySQLjingfei,stringMySQLSelect設(shè)備費(fèi)from經(jīng)費(fèi)預(yù)算表where編號(hào)ProNumberSqlConnectionMyConnection=newSqlConnection(MySQLConnectionString); mand=new mand(MySQL,MyConnection);SqlDataReaderreader= if(reader=={}decimal[]temp={0};decimalAllshebei=0;while(reader.Read()){inti=temp[i]=Convert.ToDecimal(Double.Parse(reader[i].ToString()));Allshebei=temp[i]+Allshebei;}MySQL="Select材料費(fèi)from經(jīng)費(fèi)預(yù)算表where項(xiàng)目編號(hào)='"+ProNumber+"'"; mand1=new mand(MySQL,MyConnection);SqlDataReaderreader1= if(reader1==null){}decimal[]temp1={0};decimalAllcailiao=0;while(reader1.Read()){inti=temp1[i]=Convert.ToDecimal(Double.Parse(reader1[i].ToString()));Allcailiao=Allcailiao+temp1[i];}MySQL="Select業(yè)務(wù)費(fèi)from經(jīng)費(fèi)預(yù)算表where項(xiàng)目編號(hào)='"+ProNumber+"'"; mand2=new mand(MySQL,MyConnection);SqlDataReaderreader2= if(reader2==null){}decimal[]temp2={0};decimalAllyewu=0;while(reader2.Read()){inti=temp2[i]=Convert.ToDecimal(Double.Parse(reader2[i].ToString()));Allyewu=temp2[i]+Allyewu;}MySQL="Select外協(xié)費(fèi)from經(jīng)費(fèi)預(yù)算表where項(xiàng)目編號(hào)='"+ProNumber+"'"; mand3=new mand(MySQL,MyConnection);SqlDataReaderreader3= if(reader3==null){}decimalAllwaixie=0;decimal[]temp3={0};while(reader3.Read()){inti=temp3[i]=Convert.ToDecimal(Double.Parse(reader3[i].ToString()));Allwaixie=temp3[i]+Allwaixie;}decimalALLheji=Allshebei+Allcailiao+Allwaixie+Allyewu;if(command.ExecuteScalar()!=null){this.經(jīng)費(fèi)預(yù)算合計(jì)TableAdapter.UpdateQuery(AllshebeiAllcailiaoAllwaixie,Allyewu,ALLheji,ProNumber);

}{

this.經(jīng)費(fèi)預(yù)算合計(jì)TableAdapter.Insert(Allshebei,Allcailiao,Allyewu,ALLheji,

}if{}if{}}privateintshebeifeinum=0;privateintcailiaofeinum=0;privateintwaixiefeinum=0;privateintyewufeinum=0;privateintallcount=0;privateintSETshebeifeinum=0;privateintSETcailiaofeinum=0;privateintSETwaixiefeinum=0;privateintSETyewufeinum=0;publicvoid{ObjectNothing=//objectfilenamesavepath請(qǐng)書+""+DateTime.Now.ToShortTimeString().Substring(0,DateTime.Now.ToShortTimeString().IndexOf(":"))+":"+DateTime.Now.ToShortTimeString().Substring(DateTime.Now.ToShortTimeString().IndexOf(":")+.Office.Interop.Word.ApplicationWordApp=newWordApp.Visible=.Office.Interop.Word.WordDoc=WordApp.s.Add(refNothing,refNothing,refNothing,refNothing);WordApp.Active.PageSetup.Orientation=.Office.Interop.Word.WdOrientation.wdOrientPortrait;WordApp.Active.PageSetup.PageWidth=WordApp.Active.PageSetup.PageHeight=WordApp.CentimetersToPoints(float.Parse("25.7"));//紙度WordApp.Active.PageSetup.TopMargin=WordApp.Active.PageSetup.BottomMargin=WordApp.Active.PageSetup.LeftMargin=WordApp.Active.PageSetup.RightMargin=WordApp.Active.PageSetup.Gutter=WordApp.Selection.Font.Bold=WordApp.Selection.Font.Size=16;WordApp.Selection.Font.Name="黑體";WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.Font.Bold=0;WordApp.Selection.Font.Size=26;WordApp.Selection.Font.Name="華文新魏";WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.Font.Bold=0;WordApp.Selection.Font.Size=26;WordApp.Selection.Font.NameWordApp.Selection.ParagraphFormat.Alignment=WordApp.Selection.Font.Size=22;WordApp.Selection.Font.Bold=0;WordApp.Selection.Font.Size=36;WordApp.Selection.Font.Name="黑體";WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.TypeText("項(xiàng)目申請(qǐng)書");WordApp.Selection.Font.Size=16;WordApp.Selection.ParagraphFormat.Alignment=WordApp.Selection.Font.Name體objectauto1=.Office.Interop.Word.TableTable4=WordDoc.Tables.Add(WordApp.Selection.Range,4,2,refNothing,refauto1);Table4.Borders.OutsideLineStyle=Table4.Borders.InsideLineStyle=Table4.Columns[1].Borders.OutsideLineStyle=Table4.Columns[1].Borders.InsideLineStyle=Table4.Range.ParagraphFormat.Alignment=Table4.Range.Cells.VerticalAlignmentTable4.Columns[1].Width=65f;Table4.Columns[2].Width=280f;Table4.Range.Font.Size=12;Table4.Range.Font.NameTable4.Cell(1,1).Range.Text="項(xiàng)目名稱:";Table4.Cell(12).Range.Textthis.項(xiàng)目名稱Label2.Text;Table4.Cell(2,1).Range.Text="類 Table4.Cell(2,2).Range.Text=leibie;Table4.Cell(3,1).Range.Text="申請(qǐng)單位:";Table4.Cell(3,2).Range.Text=shengqingdanwei;Table4.Cell(4,1).Range.Text="申請(qǐng)時(shí)間:";Table4.Cell(4,1).Range.Font.Name="仿宋_GB2312";Table4.Cell(42).Range.TextDateTime.Now.ToLongDateString();Table4.Cell(4,2).Range.Font.Name="仿宋_GB2312";objectcount11=objectUnit11=.Office.Interop.Word.WdUnits.wdLine;WordApp.Selection.MoveDown(refUnit11,refcount11,refNothing);WordApp.Selection.Font.Bold=WordApp.Selection.Font.Size=18;WordApp.Selection.Font.Name="黑體";WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.TypeText("填寫說明");WordApp.Selection.Font.Bold=WordApp.Selection.Font.Size=16;WordApp.Selection.Font.Name_GB2312";WordApp.Selection.ParagraphFormat.SpaceBeforefloat.Parse("5");//段前間距WordApp.Selection.ParagraphFormat.SpaceAfter=float.Parse("5");//段后間距WordApp.Selection.ParagraphFormat.LineSpacingRule=WordApp.Selection.ParagraphFormat.FirstLineIndent=WordApp.CentimetersToPoints(float.Parse("1.2"));//首行縮進(jìn)1.2厘米寫。

WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.TypeText("一、本申請(qǐng)書由申報(bào)裝備維修科學(xué)研究與項(xiàng)目的單位填

WordApp.Selection.TypeText("五、本申請(qǐng)書的格式,橫寬:18.2厘米,豎高:25.7厘

WordApp.Selection.Font.Size=12;WordApp.Selection.Font.Name_GB2312";WordApp.Selection.ParagraphFormat.SpaceBeforefloat.Parse("5");//段前間距WordApp.Selection.ParagraphFormat.SpaceAfter=float.Parse("5");//段后間距WordApp.Selection.ParagraphFormat.LineSpacingRule=objectib=.Office.Interop.Word.WdBreakType.wdPageBreak;WordApp.Selection.InsertBreak(refib);intnum=this.項(xiàng)目主 objectautoFitBehavior=.Office.Interop.Word.TablenewTable=WordDoc.Tables.Add(WordApp.Selection.Range,6,4,refNothing,refautoFitBehavior);objectstyle="網(wǎng)格型";newTable.set_Style(refstyle);newTable.Rows.Borders.InsideLineStylenewTable.Borders.Shadow=false;newTable.Borders.OutsideColor=newTable.Borders.OutsideLineStyle=newTable.Columns[1].Width=50f;newTable.Columns[2].Width=90f;newTable.Columns[3].Width=90f;newTable.Columns[4].Width=newTable.Cell(1,1).Range.Text="項(xiàng)目主要(必須填寫二人)";newTable.Cell(1,1).Merge(newTable.Cell(1,4));newTable.Cell(1,1).Range.ParagraphFormat.Alignment=newTable.Cell(1,1).Range.Font.Size=14;newTable.Cell(1,1).Range.Font.Name_GB2312";=距newTable.Cell(1,1).Range.ParagraphFormat.SpaceAfterfloat.Parse("5"距newTable.Cell(1,1).Range.ParagraphFormat.LineSpacingRule=newTable.Cell(2,1).Range.Text="";newTable.Cell(2,1).Range.ParagraphFormat.Alignment=newTable.Cell(2,2).Range.Text="職務(wù)()";newTable.Cell(2,2).Range.ParagraphFormat.Alignment=newTable.Cell(2,3).Range.Text="(地方)";newTable.Cell(2,3).Range.ParagraphFormat.Alignment=newTable.Cell(2,4).Range.Text="通信地址及";newTable.Cell(2,4).Range.ParagraphFormat.Alignmentfor(inti=1;i<num;{for(intj=0;j<this.項(xiàng)目主要DataGridView.ColumnCount;{newTable.Cell(i+2,j).Range.Text=this.項(xiàng)目主要DataGridView[j,-}}newTable.Cell(5,1).Range.Text="項(xiàng)目簡(jiǎn)介(60~80字,描述針對(duì)什么問題,采取什么手段,達(dá)到什么目的)"+"\n"+" "+this.項(xiàng)目簡(jiǎn)介TextBox.Text;newTable.Cell(5,1).Range.ParagraphFormat.Alignment=WordApp.Selection.Font.NameWordApp.Selection.Font.Size=14;objectunit2=1;objectcount2=1;unit2=.Office.Interop.Word.WdUnits.wdStory;WordApp.Selection.EndKey(refunit2,refNothing);WordApp.Selection.Font.Bold=0;WordApp.Selection.Font.Size=14;WordApp.Selection.Font.Name="黑體";WordApp.Selection.ParagraphFormat.AlignmentnewTable.Cell(5,1).Merge(newTable.Cell(5,//stringtest=this.曾經(jīng)承擔(dān)裝備維修科學(xué)研究與項(xiàng)目的鑒定情況TextBox.Text;n"2、應(yīng)用前景n"+"\n"3、技術(shù)途徑\n"\n""4、先進(jìn)程度\n"5n""\n"6、研究進(jìn)度\n""\n"7、成果形式\n"\n""8、可行性分析(包括科研能力、科研設(shè)施)"+"\n"+"\n"+"9、曾經(jīng)承擔(dān)科學(xué)研究與項(xiàng)目的鑒定情況"+"\n"+"\n" newTable.Cell(6,1).Merge(newTable.Cell(6,.Office.Interop.Word.Paragraphpara=WordDoc.Content.Paragraphs.Add(refNothing);objectpBreak=para.Range.InsertBreak(refpBreak);objectunit1=1;objectcount1=1;unit1=.Office.Interop.Word.WdUnits.wdStory;WordApp.Selection.EndKey(refunit1,refNothing);WordApp.Selection.Font.Name_GB2312";WordApp.Selection.Font.Size=12;intjingfeinum=jingfeinumthis.經(jīng)費(fèi)預(yù)算表.Office.Interop.Word.TablenewTable1=WordDoc.Tables.Add(WordApp.Selection.Range,jingfeinum+1,7,refNothing,refNothing);newTable1.Borders.OutsideLineStylenewTable1.Borders.InsideLineStyle=newTable1.Rows.Height=WordApp.CentimetersToPoints(float.Parse("0.6"));newTable1.Columns[1].Width=50f;newTable1.Columns[2].Width=50f;newTable1.Columns[3].Width=50f;newTable1.Columns[4].Width=50f;newTable1.Columns[5].Width=50f;newTable1.Columns[6].Width=50f;newTable1.Columns[7].Width=newTable1.Cell(1,1).Range.Text度newTable1.Cell(1,2).Range.Text費(fèi)";newTable1.Cell(1,3).Range.Text費(fèi)";newTable1.Cell(1,4).Range.Text費(fèi)";newTable1.Cell(1,5).Range.Text費(fèi)";newTable1.Cell(1,6).Range.Text="合計(jì)";newTable1.Cell(1,7).Range.Text="備注";for(inti=1;i<jingfeinum;{forintj0;jthis.經(jīng)費(fèi)預(yù)算表DataGridView1.ColumnCount1;{newTable1.Cell(i1,j).Range.Textthis.經(jīng)費(fèi)預(yù)算表DataGridView1[ji}}newTable1.Cell(jingfeinum11).Range.Text計(jì)";objectunit5=1;objectcount5=unit5=.Office.Interop.Word.WdUnits.wdStory;WordApp.Selection.EndKey(refunit5,refNothing);objectib2=.Office.Interop.Word.WdBreakType.wdPageBreak;WordApp.Selection.InsertBreak(refib2);allcount=SETshebeifeinum+SETcailiaofeinum+SETwaixiefeinum+objectunit3=1;objectcount3=1;unit3=.Office.Interop.Word.WdUnits.wdStory;WordApp.Selection.EndKey(refunit3,refNothing);WordApp.Selection.Font.Bold=0;WordApp.Selection.Font.Size=14;WordApp.Selection.Font.Name="黑體";WordApp.Selection.ParagraphFormat.AlignmentWordApp.Selection.Font.Name宋WordApp.Selection.Font.Size=.Office.Interop.Word.TablenewTable2=WordDoc.Tables.Add(WordApp.Selection.Range,allcount-3,7,refNothing,refNothing);newTable2.Borders.OutsideLineStylenewTable2.Borders.InsideLineStyle=newTable2.Columns[1].Width=50f;newTable2.Columns[2].Width=50f;newTable2.Columns[3].Width=50f;newTable2.Columns[4].Width=50f;newTable2.Columns[5].Width=50f;newTable2.Columns[6].Width=50f;newTable2.Columns[7].Width=newTable2.Cell(2,1).Select();//選中一objectmoveUnit3=.Office.Interop.Word.WdUnits.wdLine;objectmoveCount3=SETshebeifeinum-2;objectmoveExtend3=.Office.Interop.Word.WdMovementType.wdExtend;WordApp.Selection.MoveDown(refmoveUnit3,refmoveCount3,refmoveExtend3);newTable2.Cell(SETshebeifeinum+1,1).Select();//選中一行objectmoveUnit4=.Office.Interop.Word.WdUnits.wdLine;objectmoveCount4=SETcailiaofeinum-2;objectmoveExtend4=.Office.Interop.Word.WdMovementType.wdExtend;WordApp.Selection.MoveDown(refmoveUnit4,refmoveCount4,refmoveExtend4);newTable2.Cell(SETshebeifeinumSETcailiaofeinum,1).Select();//選中一行objectmoveUnit5=.Office.Interop.Word.WdUnits.wdLine;objectmoveCount5=SETwaixiefeinum-objectmoveExtend5=.Office.Interop.Word.WdMovementType.wdExtend;WordApp.Selection.MoveDown(refmoveUnit5,refmoveCount5,refmoveExtend5);newTable2.Cell(SETshebeifeinumSETcailiaofeinumSETwaixiefeinum1,objectmoveUnit6=.Office.Interop.Word.WdUnits.wdLine;objectmoveCount6=SETyewufeinum-2;objectmoveExtend6=.Office.Interop.Word.WdMovementType.wdExtend;WordApp.Selection.MoveDown(refmoveUnit6,refmoveCount6,refmoveExtend6);newTable2.Cell(1,2).Range.TextnewTable2.Cell(1,3).Range.TextnewTable2.Cell(1,4).Range.TextnewTable2.Cell(1,5).Range.TextnewTable2.Cell(1,6).Range.TextnewTable2.Cell(1,7).Range.TextnewTable2.Cell(2,1).Range.Text費(fèi)newTable2.Cell(SETshebeifeinum+1,1).Range.Text="材料費(fèi)";newTable2.Cell(SETshebeifeinumSETcailiaofeinum,1).Range.Text協(xié)費(fèi)";newTable2.Cell(SETshebeifeinum+SETcail

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論