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);
}
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 = "";
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
UpFile objsh2 = new UpFile();
objsh2 = objsh2.Retrieveq(comboBox1.Text);
label1.Text = "公文標題:" + objsh2.GetFileTitle();
progressBar1.Maximum = 4;
progressBar1.Value = Convert.ToInt32(objsh2.GetFileStatus()) + 1;
ModifyProgressBarColor.SetState(progressBar1, 1);
if (objsh2.GetFileStatus().Equals("0"))
{
label2.Text = "目前狀態:公文以上傳審核中";
}
else if (objsh2.GetFileStatus().Equals("1"))
{
ModifyProgressBarColor.SetState(progressBar1, 2);
label2.Text = "目前狀態:公文被退件請修正";
}
else if (objsh2.GetFileStatus().Equals("2"))
{
label2.Text = "目前狀態:公文已通過待歸檔";
}
else if (objsh2.GetFileStatus().Equals("3"))
{
label2.Text = "目前狀態:公文已歸檔";
}
}
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);
}
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());
}
}
}
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 objsh2 = new UpFile();
objsh2 = objsh2.Retrieveq(comboBox1.Text);
label3.Text = "公文標題:" + objsh2.GetFileTitle();
textBox2.Text = objsh2.GetFileContent();
}
private void button2_Click(object sender, EventArgs e)
{
UpFile u = new UpFile();
u.DeleteFile(comboBox2.Text);
MessageBox.Show("刪除 " + comboBox2.Text + "成功");
textBox1.Text = "";
comboBox1.Text = "";
comboBox2.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
UpFile u = new UpFile();
u.DeleteFile(comboBox1.Text);
MessageBox.Show("刪除 " + comboBox1.Text + "成功");
textBox1.Text = "";
comboBox1.Text = "";
u.SetFileStatus("3");
comboBox1.DataSource = u.retrieveAllFile();
}
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();
}
public Sign1()
{
InitializeComponent();
textBox2.AutoSize = false;
textBox2.Height = 100;
textBox2.ReadOnly = true;
UpFile objsh = new UpFile();
objsh.SetFileStatus("0");
comboBox1.DataSource = objsh.retrieveAllFile();
System.ComponentModel.ComponentResourceManager resources = new
System.ComponentModel.ComponentResourceManager(typeof(Login));
this.skinEngine = new
Sunisoft.IrisSkin.SkinEngine(((System.ComponentModel.Component)(this)));
}
public Clear()
{
InitializeComponent();
textBox1.AutoSize = false;
textBox1.Height = 150;
textBox1.ReadOnly = true;
UpFile u = new UpFile();
u.SetFileStatus("3");
comboBox1.DataSource = u.retrieveAllFile();
System.ComponentModel.ComponentResourceManager resources = new
System.ComponentModel.ComponentResourceManager(typeof(Login));
this.skinEngine = new
Sunisoft.IrisSkin.SkinEngine(((System.ComponentModel.Component)(this)));
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals("") || textBox2.Text.Equals(""))
{
MessageBox.Show("標題或內容不可為空", "錯誤");
}
else
{
DialogResult result = MessageBox.Show("請仔細檢查內容決定是否送出", "送出確認",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
UpFile objfile = new UpFile();
objfile.SetFileTitle(textBox1.Text);
objfile.SetFileContent(textBox2.Text);
objfile.SetUpD(Convert.ToString(DateTime.Today));
objfile.SetUpT(DateTime.Now.ToString("HH:mm ss tt"));
if (objfile.InsertUpFile(objfile))
{
MessageBox.Show("已成功送出公文:" + textBox1.Text + "\n" + "送出時間:" + Convert.ToString(DateTime.Now), "送出結果"
);
textBox1.Text = "";
textBox2.Text = "";
}
else
{
MessageBox.Show("送出公文:" + textBox1.Text + "失敗");
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
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 List <string> retrieveAllFile()
{
List <string> lstSSN = new List <string>();
/**********************************************************************************/
DBConnect dbconn = new DBConnect();
dbconn.ConnectDB();
/***********************************************************************************/
UpFile q = new UpFile();
try
{
dbconn.getCmd().CommandText = "SELECT FileNumber from FileData WHERE Status='" + GetFileStatus() + "'" + " order by FileNumber";
dbconn.getCmd().CommandType = System.Data.CommandType.Text;
dbconn.getConn().Open();
OleDbDataReader reader = dbconn.getCmd().ExecuteReader();
while (reader.Read())
{
lstSSN.Add(reader["FileNumber"].ToString());
}
return(lstSSN);
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbconn.getConn() != null)
{
dbconn.getConn().Close();
}
}
}
public UpFile Retrieveq(string num)
{
DBConnect dbconn = new DBConnect();
dbconn.ConnectDB();
UpFile objq = new UpFile();
try
{
dbconn.getCmd().CommandText = "SELECT * from FileData WHERE FileNumber = '" + num + "'";
dbconn.getCmd().CommandType = System.Data.CommandType.Text;
dbconn.getConn().Open();
OleDbDataReader reader = dbconn.getCmd().ExecuteReader();
while (reader.Read())
{
objq.SetFileNumber(reader["FileNumber"].ToString());
objq.SetFileTitle(reader["Title"].ToString());
objq.SetFileContent(reader["Content"].ToString());
objq.SetFileStatus(reader["Status"].ToString());
objq.SetFFixContent(reader["FixContent"].ToString());
objq.SetUpD(reader["FileDate"].ToString());
objq.SetUpT(reader["UpTime"].ToString());
}
}
catch (Exception e)
{
System.Console.WriteLine("Error message :" + e.ToString());
}
finally
{
if (dbconn.getConn() != null)
{
dbconn.getConn().Close();
}
}
return(objq);
}
