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