private void button1_Click(object sender, EventArgs e)
{
try
{
UpFile u = new UpFile();
u.SetFileNumber(comboBox2.Text);
u.SetFileTitle(textBox3.Text);
u.SetFileContent(textBox2.Text);
u.SetFileStatus("0");
if (u.UpfdateFileInfo(u))
{
MessageBox.Show("更新公文編號:" + comboBox2.Text + "成功");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
else
{
MessageBox.Show("更新公文編號:" + comboBox2.Text + " 失敗");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
UpFile u2 = new UpFile();
u2 = u2.Retrieveq(comboBox2.Text);
textBox1.Text = u2.GetFileContent();
label1.Text = "公文標題:" + u2.GetFileTitle();
label6.Text = "需修改內容:" + u2.GetFFixContent();
comboBox1.Text = "";
comboBox2.Text = "";
}
public bool UpfdateFileInfo(UpFile objUpFile)
{
Boolean tf = false;
DBConnect dbconn = new DBConnect();
dbconn.ConnectDB();
try
{
// 注意 : 字串要用單引號 ' ', 數字欄位不需要單引號
dbconn.getCmd().CommandText = "Update FileData SET Content='" + objUpFile.GetFileContent() + "',Title='" + objUpFile.GetFileTitle() + "',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);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
UpFile objsh2 = new UpFile();
objsh2 = objsh2.Retrieveq(comboBox1.Text);
label3.Text = "公文標題:" + objsh2.GetFileTitle();
textBox2.Text = objsh2.GetFileContent();
}
private void button1_Click(object sender, EventArgs e)
{
UpFile objsh = new UpFile();
objsh = objsh.Retrieveq(comboBox1.Text);
MessageBox.Show(objsh.GetFileContent(), "公文內容",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
UpFile u = new UpFile();
u = u.Retrieveq(comboBox2.Text);
textBox1.Text = u.GetFileContent();
label1.Text = "公文標題:" + u.GetFileTitle();
label6.Text = "需修改內容:" + u.GetFFixContent();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
UpFile u = new UpFile();
u = u.Retrieveq(comboBox1.Text);
comboBox1.DataSource = u.retrieveAllFile();
label1.Text = "公文標題:" + u.GetFileTitle();
label2.Text = "上傳日期:" + u.GetUpD();
label3.Text = "上傳時間:" + u.GetUpT();
textBox1.Text = u.GetFileContent();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex.Equals(0))
{
UpFile u = new UpFile();
u.SetFileStatus("0");
comboBox2.DataSource = u.retrieveAllFile();
u = u.Retrieveq(comboBox2.Text);
textBox1.Text = u.GetFileContent();
}
else
{
UpFile u = new UpFile();
u.SetFileStatus("1");
comboBox2.DataSource = u.retrieveAllFile();
u = u.Retrieveq(comboBox2.Text);
textBox1.Text = u.GetFileContent();
}
}
public bool InsertUpFile(UpFile objUpFile)
{
Boolean tf = false;
DBConnect dbconn = new DBConnect();
dbconn.ConnectDB();
try
{
Random r1 = new Random();
// 注意 : 字串要用單引號 ' ', 數字欄位不需要單引號
dbconn.getCmd().CommandText = "INSERT INTO FileData(FileNumber,Title,Content,FixContent,FileDate,UpTime,Status) VALUES('" + r1.Next(100000, 999999) + "','" + objUpFile.GetFileTitle() + "','" + objUpFile.GetFileContent() + "','無" + "','" + objUpFile.GetUpD() + "','" + objUpFile.GetUpT() + "','0" + "')";
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);
}
