private void button2_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("是否確定歸檔此公文?", "歸檔確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question); UpFile set = new UpFile(); set.SetFFixContent("無"); set.SetFileStatus("3"); set.SetFileNumber(comboBox1.Text); if (result == DialogResult.Yes) { try { if (set.UpfdateUpFile(set)) { MessageBox.Show("已成功歸檔公文:" + set.GetFileNumber() + "\n" + "歸檔時間:" + Convert.ToString(DateTime.Now), "送出結果" ); textBox2.Text = ""; } else { MessageBox.Show("退件公文:" + set.GetFileNumber() + "失敗"); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
public bool UpfdateUpFile(UpFile objUpFile) { Boolean tf = false; DBConnect dbconn = new DBConnect(); dbconn.ConnectDB(); try { // 注意 : 字串要用單引號 ' ', 數字欄位不需要單引號 dbconn.getCmd().CommandText = "Update FileData SET FixContent='" + objUpFile.GetFFixContent() + "',Status='" + objUpFile.GetFileStatus() + "' WHERE FileNumber= '" + objUpFile.GetFileNumber() + "'"; dbconn.getCmd().CommandType = System.Data.CommandType.Text; dbconn.getConn().Open(); dbconn.getCmd().ExecuteNonQuery(); tf = true; } catch (Exception e) { System.Console.WriteLine("Error message :" + e.ToString()); } finally { if (dbconn.getConn() != null) { dbconn.getConn().Close(); } }; return(tf); }