【正文】 ，終止程序。 ：錯誤存在的時候，終止程序。取得的數(shù)據(jù)輸出到積分更新日志 csv 中 ,并清除。 。 會員狀態(tài)表添加數(shù)據(jù)：積分表中的本月交易金額項數(shù)據(jù)大于 0時：按積分表中的會員代碼為主鍵，在會員狀態(tài)表中檢索。如果匹配數(shù)據(jù)存在的話，從會員表往會員狀態(tài)表中添加匹配數(shù)據(jù)。 4 輸出結束日志 表 10月購買額清除及處理數(shù)據(jù)移動表 移動目的名稱 移動元表名稱 A FSPTB_POINT FSPTB_POINT B C D 移動項目名稱 原項目名稱 A B C D 移動方式 本月交易金額 y 0 上月交易金額 本月交易金額 y 同項目 表 11月購買額清除及處理數(shù)據(jù)移動表 移動目的名稱 移動元表名稱 A FSPTB_MEMBER FSPTB_MEMBER_STATUS B FSPTB_TENPO C FSPTB_POINT D 移動項目名稱 原項目名稱 A B C D 移動方式 會員編碼 會員編碼 y 同項目 舊會員編碼 y null 優(yōu)先級別編碼 優(yōu)先級別編碼 y 以會員表中入會店鋪編碼為主鍵 ,在 店鋪表中檢索 ,匹配優(yōu)先級別編碼 舊優(yōu)先級別編碼 y null 店鋪編碼 入會店鋪編碼 y 同項目 舊店鋪編碼 y null 更新區(qū)分 y 2(修正 ) 模塊實現(xiàn)關鍵代碼： DataSet ds1=(select*from FSPTB_POINT where MUKOU_KBN1)。 foreach (DataRow dr in )//遍歷表 tb1 的每行數(shù)據(jù) { (update FSPTB_POINT set TUKI_KAIAGE_M=0,BEFORE_TUKI_KAIAGE_M=TUKI_KAIAGE_M where MEMBER_CODE=39。)。 string temp3=dr[MEMBER_CODE].ToString()。+ dr[MEMBER_CODE].ToString()+39。//按積分表中的會員代碼為主鍵，在會員狀態(tài)表中檢索 DataTable tb2=[0]。+ dr[MEMBER_CODE].ToString()+39。//按積分表中的會員代碼為主鍵，在會員表中檢索 DataTable tb3=[0]。 if ([0].0)//匹 配數(shù)據(jù)存在 { DataSet ds4=(SELECT TENPO_CODE from FROM FSPTB_MEMBER WHERE where MEMBER_CODE=39。)。 DataRow row2=[0]。//匹配的店鋪編碼放到 temp1 中 DataSet ds5=(SELECT DOMINANT_CODE FROM FSPTB_TENPO WHERE TENPO_CODE =+temp1)。 DataRow row3=[0]。//將優(yōu)先級別編碼存放到temp2 中 。{0}39。{1}39。{2}39。{3}39。{4}39。{5}39。{6}39。{7}39。 string sql = (sqlFormat,39。,NULL,39。, 39。,NULL,NULL,2,)。//執(zhí)行數(shù)據(jù)庫將匹配數(shù)據(jù)保存到會員狀態(tài)表中 } 6 測試工程 本系 統(tǒng)屬 于一款商務應用型軟件，因此，對各種可能出現(xiàn)的錯誤情況要有很高的檢測能力，并進行響應處理。在進行測試前，應針對上述各情況填寫一份全面的單元測試檢測清單。 測試截圖 : 共通文件不存在的情況： 共通文件不存在的情況下（圖 4），程序會顯示相應的錯誤信息（圖 5）。 圖 6 INI文件關鍵字不足 圖 7 顯示出錯信息 程序結束時的情況： 程序正常運行完成時 ,顯示“終了”信息（ 圖 8） ,并將程序信息輸入到日志表中（ 圖 9）。 圖 8 測試顯示信息 圖 9 日志表中信息 積分履歷表中數(shù)據(jù)日期項（圖 10）大于設置更新日期 2021/03/03（圖 11） ,故檢索不到匹配數(shù)據(jù) ,測試顯示記錄為 0的信息。 圖 12測試顯示信息 輸入表日期 20215/05/05大于輸入的指 定日期 2021/03/03時 ,不符合輸入要求 ,顯示日期錯誤的信息（圖 13）。 圖 14測試顯示信息 圖 15日志表中信息 備份文件 不存在的情況 ： 履歷表備份 CSV 文件不存在時（圖 16） ,顯示相應出錯信息（圖 17）。 圖 18備分文件更新前圖 圖 19更新前履歷表數(shù)據(jù)圖 圖 20 程序運行圖 圖 21 更新后履歷表數(shù)據(jù)圖 圖 22更新后備份文件 CSV數(shù)據(jù)圖 以上是模塊部分測試結果。 結 論 經(jīng)過這段時間的緊張工作，我已經(jīng)完成了模塊功能的設計和實現(xiàn)。由于是日文操作系統(tǒng)下，所用到的相關工具都是日文：如 Visual Studio .NET 2021， WORD,EXCEL 等工具，這對開發(fā)增加了一定的難度，在熟悉工具上花了很多精力。 系統(tǒng)的實現(xiàn)過程中，本人對日文操作系統(tǒng)、日文 OFFICE 工具、 SQL Server 2021 數(shù)據(jù)庫、 Subversion 及軟件開發(fā)流程、進度控制等有了更深地了解和認識，本人相信這對以后工作將會大有益處的。 [2] 侯捷 ,陳碩 .C Primer中文版 [M].武漢：華中科技大學出版社 ,2021。 [4] 杜斌 ,幸利 .軟件設計工程 [M].成都：電子科技大學出版社 ,2021。 [6] 莊成三等 .微軟 .NET平臺軟件技術 [M].成都：電子科技大學出版社 ,2021。 致 謝 本文是在陳運老師的熱情關心和指導下完成的，她淵博的知識和嚴謹?shù)闹螌W作風使我受益匪淺。文中除了特別加以標注地方外，不包含他人已經(jīng)發(fā)表或撰寫過的研究成果，也不包含為獲得成都信息工程學院或其他教學機構的學位或 證書而使用過的材料。 關于學位論文使用權和研究成果知識產(chǎn)權的說明 本人完全了解成都信息工程學院有關保管使用學位論文的規(guī)定，其中包括： （ 1）學校有權保管并向有關部門遞交學位論文的原件與復印件。 （ 3）學?？梢詫W術交流為目的復制、贈送和交換學位論文。 （ 5）學?？梢怨紝W位論文的全部或部分內(nèi)容（保密學位論文在解密后遵守此規(guī)定）。 特此聲明！ 作者簽名： 2021 年 6 月 4 日 168。 He knows weˇ ll be happier if we donˇ t get too good a look at these skins,〃 another pic answered. 168。 Well, theyˇ re horses.〃 168。 Whatˇ s your name, kid?〃 he asked the gypsy. 168。 and was conse quently resolved not to be out of sight of the inn the whole of that morning. But her conclusion was false。 and the embarrassment of her manner as she spoke, joined to the circumstance itself, and many of the circumstances of the preceding day, opened to them a new idea on the business. Nothing had ever suggested it before, but they now felt that there was no other way of accounting for such attentions from such a quarter than by supposing a partiality for their niece. While these newly born notions were passing in their heads, the perturbation of Elizabeth39。 but amongst other causes of disquiet, she dreaded lest the partiality of the brother should have said too much in her favour。 and as she walked up and dow n the room, ende avouring to pose herself, saw such looks of enquiring surprise in her uncle and aunt as made every thing worse. Miss Darcy and her brother appeared, and this formidable introduction took place. With astonishment did E lizabeth see that he r new acquaintance was at least as much embarrassed as herself. Since her being at Lambton, she had heard that Miss Darcy was exceedingly proud。Nell One. The differences were movement and origin. A spaceship would have an engine, and it would be at the hub. A colony would have been built by somebody close at hand. Cirocco had heard theories that included inhabitants of Saturn or Titan, Martiansthough no one had found so much as a flint arrowhead on Marsand ancient space faring races from the Earth. She didn39。s window. At regular intervals one of the solar panels would sweep by like the wing of a monstrous bat. Some details could now be seen on the outer surface. There were long, puc kered ridges that converged on the solar panels, pre sumably covering huge pipes to carry a fluid or gas to be warmed by the sun. Scattered widely in the darkness were a few craters, some of them 400 meters deep. There was no rubble scattered around them. Nothing could stay on the outer surface of The mis that wasn39。ve got a strange reading here. We39。s getting closer to us. I39。s still attached to Themis. It39。s opening out. Would it have done any good if Ior a human doctorhad told them not to? Wh Thed back to something like me, to an idealized natural setting, it helps them. Come on, Nicholas told the girl. He took her arm, acutely conscious of being so much shorter than she. A question, murmured the waves. If Diane39。 hissing and slapping ceased to be speech. Gulls w heeled overhead, and once a redandyellow parrot fluttered from one palm to another. A monkey running on all fours like a little dog app