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);
}
