private void btn_sure_Click(object sender, EventArgs e) { String adminName = this.tbox_username.Text.Trim(); String adminPwd = this.tbox_password.Text.Trim(); if ("".Equals(adminName) || "".Equals(adminPwd)) { MessageBox.Show("请填写完整!"); } else { System.Security.Cryptography.MD5 md5 = new MD5CryptoServiceProvider(); byte[] output = md5.ComputeHash(Encoding.Default.GetBytes(adminPwd)); string md5Pwd = BitConverter.ToString(output).Replace("-", "").ToLower(); String commandText_count = string.Format("SELECT count(*) count FROM FileAdmin where admin_name ='{0}' and admin_pwd='{1}'", adminName, md5Pwd); dBHelper helper = new dBHelper(DBSource.ConnectionStringPBox); if (helper.Load(commandText_count, "") == true) { DataTable dt_count = helper.DataSet.Tables[0]; int count = int.Parse(dt_count.Rows[0]["count"].ToString()); if (count > 0) { isAdmin = true; DBSource.ISAdmin = isAdmin; DBSource.AdminName = adminName; } else { isAdmin = false; } this.DialogResult = DialogResult.OK; } } }
private void loadData() { if (DBSource.ISAdmin) { this.Invoke(new MethodInvoker(delegate { refreshTreeView(); })); System.Threading.ThreadPool.QueueUserWorkItem((s) => refreshDataGridView()); } else { //查询是否有密码设置,如果有弹出用户密码输入框,没有直接刷新显示 String commandText_count = string.Format("SELECT count(*) count FROM FileAdmin"); helperPBox = new dBHelper(DBSource.ConnectionStringPBox); if (helperPBox.Load(commandText_count, "") == true) { DataTable dt_count = helperPBox.DataSet.Tables[0]; int count = int.Parse(dt_count.Rows[0]["count"].ToString()); if (count > 0) { //弹出用户密码输入框 FrmLoginAdmin frmInputPwd = new FrmLoginAdmin(); if (frmInputPwd.ShowDialog() == DialogResult.OK) { if (frmInputPwd.ISAdmin) { this.Invoke(new MethodInvoker(delegate { refreshTreeView(); })); System.Threading.ThreadPool.QueueUserWorkItem((s) => refreshDataGridView()); } else { initDefDbPath(); MessageBoxEx.Show("非正确用户无法打开此箱子! ", "解锁箱子"); } } else { MessageBoxEx.Show("非正确用户无法打开此箱子! ", "解锁箱子"); } } else { DBSource.ISAdmin = true; DBSource.AdminName = "匿名用户"; this.Invoke(new MethodInvoker(delegate { refreshTreeView(); })); System.Threading.ThreadPool.QueueUserWorkItem((s) => refreshDataGridView()); } } } this.Text = "【私密箱:" + DBSource.AdminName + "】" + DBSource.ConnectionStringPBox.Replace("Data Source=", ""); }
private void Dbgc() { this.Invoke(new MethodInvoker(delegate { imgLoadding.Visible = true; })); helperPBox = new dBHelper(DBSource.ConnectionStringPBox); helperPData = new dBHelper(DBSource.ConnectionStringPData); helperPBox.Dbgc(); helperPData.Dbgc(); this.Invoke(new MethodInvoker(delegate { imgLoadding.Visible = false; })); }
private void refreshTreeView() { TreeNodeCollection nodes = this.treeView_nav.Nodes; nodes[0].Nodes.Clear(); FileDBHelper imgHelper = new FileDBHelper(); string connectionString = DBSource.ConnectionStringPBox; string commandText = @"SELECT * FROM FileNode ORDER BY disporder"; helperPBox = new dBHelper(connectionString); if (helperPBox.Load(commandText, "") == true) { DataTable dataSource = helperPBox.DataSet.Tables[0]; CreateTreeViewRecursive(nodes[0].Nodes, dataSource, 0); } this.treeView_nav.ExpandAll(); }
private void buttonRight_Click_1(object sender, EventArgs e) { // button Delete // Determin the ConnectionString string connectionString = dBFunctions.ConnectionStringSQLite; // Determin the DataAdapter = CommandText + Connection string commandText = "SELECT * FROM Contact WHERE contact_id=" + contactId; // Make a new object helper = new dBHelper(connectionString); { // Load Data if (helper.Load(commandText, "contact_id") == true) { // Determin if the row was found if (helper.DataSet.Tables[0].Rows.Count == 1) { // Found, delete row helper.DataSet.Tables[0].Rows[0].Delete(); try { // Save -> determin succes if (helper.Save() == true) { deleteSucces = true; MessageBox.Show("Delete succesfull"); this.Close(); } else { deleteSucces = false; MessageBox.Show("Delete failed"); } } catch (Exception ex) { // Show the Exception --> Dubbel ContactId/Name ? MessageBox.Show(ex.Message); } } } } }
private void refreshDataGridView() { try { int nodeID = -1; this.Invoke(new MethodInvoker(delegate { //loadding加载 imgLoadding.Visible = true; if (treeView_nav.SelectedNode != null && int.Parse(treeView_nav.SelectedNode.Tag.ToString()) != 0) { nodeID = int.Parse("" + treeView_nav.SelectedNode.Tag); } })); string connectionString = DBSource.ConnectionStringPBox; string whereSql = ("".Equals(this.textBox_search.Text.Trim())) ? "" : "and file_name like '%" + this.textBox_search.Text.Trim() + "%'"; string commandText = string.Format("select file_id,file_name,file_type,file_size,file_nodeid from FileMemo where 1=1 " + whereSql + " order by disporder limit {0},{1}", (pagerControl1.PageIndex - 1) * pagerControl1.PageSize, pagerControl1.PageSize); string commandText_count = "select count(*) totalCount from FileMemo where 1=1 " + whereSql; if (nodeID != -1) { commandText = string.Format("SELECT file_id,file_name,file_type,file_size,file_nodeid FROM FileMemo where file_nodeid='" + nodeID + "' " + whereSql + " order by disporder limit {0},{1}", (pagerControl1.PageIndex - 1) * pagerControl1.PageSize, pagerControl1.PageSize); commandText_count = "select count(*) totalCount from FileMemo where file_nodeid='" + nodeID + "' " + whereSql; } helperPBox = new dBHelper(connectionString); if (helperPBox.Load(commandText_count, "") == true) { DataTable dt_count = helperPBox.DataSet.Tables[0]; this.Invoke(new MethodInvoker(delegate { pagerControl1.DrawControl(int.Parse(dt_count.Rows[0]["totalCount"].ToString())); })); } if (helperPBox.Load(commandText, "") == true) { this.Invoke(new MethodInvoker(delegate { dataGridView_FileList.DataSource = helperPBox.DataSet.Tables[0]; })); } this.Invoke(new MethodInvoker(delegate { imgLoadding.Visible = false; })); } catch (Exception exp) { } }
private void GetData() { // Determin the ConnectionString string connectionString = dBFunctions.ConnectionStringSQLite; // Determin the DataAdapter = CommandText + Connection string commandText = @"SELECT * FROM Contact WHERE contact_id =" + contactId; // Make a new object helper = new dBHelper(connectionString); // Load the data if (helper.Load(commandText, "") == true) { // Show the data in the datagridview dataRow = helper.DataSet.Tables[0].Rows[0]; base.textBoxId.Text = dataRow[0].ToString(); base.textBoxFName.Text = dataRow[1].ToString(); base.textBoxLName.Text = dataRow[2].ToString(); } }
private void GetData() { // Determin the ConnectionString string connectionString = dBFunctions.ConnectionStringSQLite; // Determin the DataAdapter = CommandText + Connection string commandText = @"SELECT * FROM Contact ORDER BY contact_id"; // Make a new object helper = new dBHelper(connectionString); // Load the data if (helper.Load(commandText, "") == true) { // Show the data in the datagridview dataGridViewContactList.DataSource = helper.DataSet.Tables[0]; listBox1.ValueMember = "FirstName"; listBox1.DisplayMember = "FirstName"; listBox1.DataSource = helper.DataSet; } }
private void saveAsToolStripMenuItem_Click(object sender, EventArgs e) { Int32 fid = Convert.ToInt32(dataGridView_FileList.CurrentRow.Cells["file_id"].Value); string connectionStringPBox = DBSource.ConnectionStringPBox; string connectionStringPData = DBSource.ConnectionStringPData; string commandText = @"SELECT file_id,file_name,file_type,file_size,file_nodeid FROM FileMemo where file_id = " + fid; helperPBox = new dBHelper(connectionStringPBox); FileStream fs; if (helperPBox.Load(commandText, "") == true) { if (fid > 0 && helperPBox.DataSet.Tables[0].Rows.Count > 0) { DataRow dataRow = helperPBox.DataSet.Tables[0].Select("file_id=" + fid)[0]; string filename = dataRow["file_name"].ToString(); string filetype = dataRow["file_type"].ToString(); List <Byte[]> l_fileData = new FileDBHelper().getFileData(fid); this.saveFileDialog_File.Title = "另存" + filename; this.saveFileDialog_File.Filter = filetype + "|" + filetype; this.saveFileDialog_File.DefaultExt = filetype; this.saveFileDialog_File.FileName = filename; if (this.saveFileDialog_File.ShowDialog() == DialogResult.OK) { FileInfo fi = new FileInfo(saveFileDialog_File.FileName); fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); } } } }
private void openFileViewer(Int32 fileID) { string connectionStringPBox = DBSource.ConnectionStringPBox; string connectionStringPData = DBSource.ConnectionStringPData; string commandText = @"SELECT file_id,file_name,file_type,file_size,file_nodeid FROM FileMemo where file_id = " + fileID; helperPBox = new dBHelper(connectionStringPBox); if (helperPBox.Load(commandText, "") == true) { if (fileID > 0 && helperPBox.DataSet.Tables[0].Rows.Count > 0) { DataRow dataRow = helperPBox.DataSet.Tables[0].Select("file_id=" + fileID)[0]; string filename = dataRow["file_name"].ToString(); string filetype = dataRow["file_type"].ToString(); List <Byte[]> l_fileData = new FileDBHelper().getFileData(fileID); if (l_fileData.Count == 0) { MessageBoxEx.Show("找不到对应数据文件!"); return; } SkinTabPage tp = new SkinTabPage(); tp.Text = filename; switch (filetype) { case ".jpg": case ".png": case ".bmp": case ".gif": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); try { Bitmap bmap = new Bitmap(Application.StartupPath + "\\temp\\" + filename + filetype); PicViewer uc_picviewer = new PicViewer(); uc_picviewer.showPic(filename, bmap); uc_picviewer.Dock = DockStyle.Fill; tp.Controls.Add(uc_picviewer); tabControl_Viewer.TabPages.Add(tp); } catch (Exception exp) { } } break; } case ".doc": case ".docx": case ".xls": case ".xlsx": case ".ppt": case ".pptx": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); DocViewer uc_docviewer = new DocViewer(); tp.Tag = uc_docviewer; uc_docviewer.Dock = DockStyle.Fill; tp.Controls.Add(uc_docviewer); tabControl_Viewer.TabPages.Add(tp); uc_docviewer.openFile(Application.StartupPath + "\\temp\\" + filename + filetype); } break; } case ".txt": case ".sql": case ".log": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); StreamReader sr = new StreamReader(Application.StartupPath + "\\temp\\" + filename + filetype, Encoding.Default); TxtViewer txtViewer = new TxtViewer(); txtViewer.Dock = DockStyle.Fill; tp.Controls.Add(txtViewer); tabControl_Viewer.TabPages.Add(tp); txtViewer.showTxt(sr.ReadToEnd()); sr.Close(); } break; } case ".htm": case ".html": case ".mht": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); WebViewer webViewer = new WebViewer(); webViewer.Dock = DockStyle.Fill; tp.Controls.Add(webViewer); tabControl_Viewer.TabPages.Add(tp); webViewer.openFile(Application.StartupPath + "\\temp\\" + filename + filetype); } break; } case ".pdf": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); PDFViewer pdfViewer = new PDFViewer(); pdfViewer.Dock = DockStyle.Fill; tp.Controls.Add(pdfViewer); tabControl_Viewer.TabPages.Add(tp); pdfViewer.openFile(Application.StartupPath + "\\temp\\" + filename + filetype); } break; } case ".mp4": case ".avi": case ".rm": case ".rmvb": case ".flv": case ".xr": case ".wmv": { if (Directory.Exists(Application.StartupPath + "\\temp") == false) { Directory.CreateDirectory(Application.StartupPath + "\\temp"); } FileStream fs; FileInfo fi = new FileInfo(Application.StartupPath + "\\temp\\" + filename + filetype); if (!fi.Exists || !IsFileInUse(fi.FullName)) { fs = fi.OpenWrite(); for (int i = 0; i < l_fileData.Count; i++) { fs.Write(l_fileData[i], 0, l_fileData[i].Length); } fs.Close(); } FrmPlayer aplayer = new FrmPlayer(); aplayer.Text = filename; aplayer.Show(); aplayer.openFile(Application.StartupPath + "\\temp\\" + filename + filetype); break; } } tabControl_Viewer.SelectedTab = tp; } } }
private void buttonRight_Click_1(object sender, EventArgs e) { if (base.textBoxFName.Text == string.Empty && base.textBoxLName.Text == string.Empty) { base.errorProviderBaseId.SetError(textBoxFName, "First Name required !"); return; } else { base.errorProviderBaseId.SetError(textBoxId, string.Empty); } // Determin the ConnectionString string connectionString = dBFunctions.ConnectionStringSQLite; // Determin the DataAdapter = CommandText + Connection string commandText = "SELECT * FROM Contact WHERE contact_id=" + contactId; // Make a new object helper = new dBHelper(connectionString); { // Load Data if (helper.Load(commandText, "contact_id") == true) { // Determin if the row was found if (helper.DataSet.Tables[0].Rows.Count == 1) { // Determin the found row DataRow dataRow = helper.DataSet.Tables[0].Rows[0]; // Modify the row dataRow["FirstName"] = textBoxFName.Text; dataRow["LastName"] = textBoxLName.Text; string updateText = "UPDATE contact SET FirstName ='" + textBoxFName.Text + "' WHERE contact_id='" + contactId + "'"; helper.setSqlCommand(updateText); try { // Save -> determin succes if (helper.Save() == true) { editSucces = true; MessageBox.Show("Modification succesfull"); this.Close(); } else { editSucces = false; MessageBox.Show("Modification failed"); } } catch (Exception ex) { // Show the Exception --> Dubbel ContactId/Name ? MessageBox.Show(ex.Message); } } }//END IF } }
private void buttonRight_Click_1(object sender, EventArgs e) { int i = 0; if (textBoxId.Text != string.Empty) { i = Convert.ToInt32(textBoxId.Text); } if (i > 0) { base.errorProviderBaseId.SetError(textBoxId, "Contact_Id already exists"); return; } else { base.errorProviderBaseId.SetError(textBoxId, string.Empty); } if (base.textBoxFName.Text == string.Empty && base.textBoxLName.Text == string.Empty) { base.errorProviderBaseId.SetError(textBoxFName, "First Name required !"); return; } else { base.errorProviderBaseId.SetError(textBoxId, string.Empty); } // Determin the ConnectionString string connectionString = dBFunctions.ConnectionStringSQLite; // Determin the DataAdapter = CommandText + Connection string commandText = "SELECT * FROM Contact WHERE 1=0"; // Make a new object helper = new dBHelper(connectionString); { // Load Data if (helper.Load(commandText, "contact_id") == true) { // Add a row and determin the row helper.DataSet.Tables[0].Rows.Add(helper.DataSet.Tables[0].NewRow()); DataRow dataRow = helper.DataSet.Tables[0].Rows[0]; // Enter the given values dataRow["FirstName"] = textBoxFName.Text; dataRow["LastName"] = textBoxLName.Text; try { // Save -> determin succes if (helper.Save() == true) { textBoxId.Text = dataRow["contact_id"].ToString(); insertSucces = true; this.Close(); } else { insertSucces = false; MessageBox.Show("Error during Insertion"); } } catch (Exception ex) { // Show the Exception --> Dubbel ContactId/Name ? MessageBox.Show(ex.Message); } }//END IF } }