private void bt_OK_Click(object sender, EventArgs e) { if (cb_db_Type.SelectedItem == cb_db_Type.Items[0]) { if (this.tx_db_IP.Text.Trim() != "") { ConnectString = @"Data Source = " + this.tx_db_IP.Text + ",1433; Initial Catalog = " + this.tb_DBName.Text + ";"; } else { ConnectString = @"Server = " + this.tb_DBServer.Text + "; Database = " + this.tb_DBName.Text + "; Trusted_Connection = false;"; } } else { ConnectString = "Data Source = .\\SQLEXPRESS; AttachDbFilename =\"" + tx_db_FilePath.Text + "\"; Integrated Security = True; Connect Timeout = 30;"; } if (tx_db_UserName.Text != "" && tx_db_Password.Text != "") { ConnectString += "User ID = " + tx_db_UserName.Text + "; Password = "******";"; } if (DBHelper.GetDBHelper(DatabaseType).TestDBConnect(ConnectString)) { CommonConfigurationManager.UpdateAppConfig("ConnectString", AES.GetEncryptConnectString(ConnectString)); this.DialogResult = DialogResult.OK; } else { MessageBox.Show(DBHelper.GetDBHelper().GetErrorMesasge()); } }
private void cb_db_Type_SelectedIndexChanged(object sender, EventArgs e) { ConnectString = AES.GetDecryptConnectString(CommonConfigurationManager.GetAppConfig("ConnectString")); string[] sqlStrArray = null; if (ConnectString != null && ConnectString.Contains(";")) { sqlStrArray = ConnectString.Split(';'); } if (cb_db_Type.Text == cb_db_Type.Items[0].ToString()) { tlp_SQL_File.Visible = false; tlp_SQL_Server.Visible = true; DatabaseType = EnumDatabaseType.SqlServer; if (sqlStrArray != null && sqlStrArray.All(str => !str.Contains("AttachDbFilename"))) { string serverName = sqlStrArray.Where(cs => cs.Contains("Data Source")).FirstOrDefault(); if (serverName != null) { serverName = serverName.Substring(serverName.IndexOf('=') + 1); tx_db_IP.Text = serverName.Trim(); } } } else { tlp_SQL_File.Visible = true; tlp_SQL_Server.Visible = false; DatabaseType = EnumDatabaseType.SqlFile; if (sqlStrArray != null) { string filePath = sqlStrArray.Where(cs => cs.Contains("AttachDbFilename")).FirstOrDefault(); if (filePath != null) { filePath = filePath.Substring(filePath.IndexOf('=') + 1); tx_db_FilePath.Text = filePath.Trim(); } } } if (sqlStrArray != null) { string userId = sqlStrArray.Where(cs => cs.Contains("User ID")).FirstOrDefault(); if (userId != null) { userId = userId.Substring(userId.IndexOf('=') + 1); tx_db_UserName.Text = userId.Trim(); } string password = sqlStrArray.Where(cs => cs.Contains("Password")).FirstOrDefault(); if (password != null) { password = password.Substring(password.IndexOf('=') + 1); tx_db_Password.Text = password.Trim(); } } }
public NewDataForm() { InitializeComponent(); tableLayoutPanel1.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); tableLayoutPanel2.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); tableLayoutPanel3.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); tableLayoutPanel4.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); flowLayoutPanel1.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); this.pictureBox1.Click += (sender, e) => { if (this.pictureBox1.Image != null) { Form frm = new Form(); frm.AutoSize = true; frm.AutoSizeMode = AutoSizeMode.GrowAndShrink; frm.ShowIcon = false; frm.StartPosition = FormStartPosition.CenterScreen; PictureBox pictureBox = new PictureBox(); pictureBox.Image = (Image)pictureBox1.Image.Clone(); pictureBox.SizeMode = PictureBoxSizeMode.AutoSize; frm.Controls.Add(pictureBox); frm.ShowDialog(); } }; this.Load += (sender, e) => { this.bt_CreateDetail.Text = this.Text + "详细"; if (GoalTables.Contains(TableName) && RecordID != "") { this.bt_CreateDetail.Visible = true; } }; #region 读取报表配置 string GoalTableString = Common.CommonConfigurationManager.GetAppConfig("评价报表"); if (GoalTableString == "") { GoalTables = new string[] { "施工单位安全生产条件核查表", "施工单位平安工地考核评价表" }; GoalTableString = string.Join(",", GoalTables); CommonConfigurationManager.UpdateAppConfig("评价报表", GoalTableString); } else { GoalTables = GoalTableString.Split(','); } #endregion }
public static bool CheckSystemCode() { string systemCode = CommonConfigurationManager.GetAppConfig("SystemCode"); if (systemCode.Trim() == "") { return(false); } try { return(AES.AESDecrypt(systemCode).Equals(SystemInformationCode.GetCpuID() + "zhangdahang")); } catch (Exception ex) { } return(false); }
private void bt_OK_Click(object sender, EventArgs e) { try { //string mechineCode = "BFEBFBFF000806EA"; string mechineCode = SystemInformationCode.GetCpuID(); if (AES.AESDecrypt(textBox2.Text).Equals(mechineCode + "zhangdahang")) { CommonConfigurationManager.UpdateAppConfig("SystemCode", textBox2.Text); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("您输入的注册码不正确,请重新输入!"); } } catch { MessageBox.Show("您输入的注册码不正确,请重新输入!"); } }
private void UserLogin_Load(object sender, EventArgs e) { SystemSettingForm.DatabaseType = EnumDatabaseType.SqlServer; //string connectString = Properties.Settings.Default["DocMngDBConnectionString"].ToString(); string connectString = AES.GetDecryptConnectString(CommonConfigurationManager.GetAppConfig("ConnectString")); if (connectString == null || !DatabaseHelper.DBHelper.GetDBHelper(SystemSettingForm.DatabaseType).TestDBConnect(connectString)) { SystemSettingForm ssf = new SystemSettingForm(); if (ssf.ShowDialog() == DialogResult.OK) { connectString = AES.GetEncryptConnectString(ssf.ConnectString); var str = AES.GetDecryptConnectString(connectString); CommonConfigurationManager.UpdateAppConfig("ConnectString", connectString); Application.Restart(); } else { Application.Exit(); } } else { DatabaseHelper.DBHelper.GetDBHelper(SystemSettingForm.DatabaseType).SetDBConnectString(connectString); } if (!File.Exists("userData.bin")) { return; } cmb_UserName.SelectedIndexChanged += (obj, ee) => { if (UserDatas.ContainsKey(cmb_UserName.Text)) { tb_Password.Text = UserDatas[cmb_UserName.Text]; } }; try { //读取文件流对象 FileStream fs = new FileStream("userData.bin", FileMode.OpenOrCreate); if (fs.Length > 0) { BinaryFormatter bf = new BinaryFormatter(); //读出存在Data.bin 里的用户信息 UserDatas = bf.Deserialize(fs) as Dictionary <string, string>; if (UserDatas != null) { cmb_UserName.DataSource = UserDatas.Keys.ToList(); if (cmb_UserName.Items.Count > 0) { cmb_UserName.SelectedIndex = 0; } } else { File.Delete("userData.bin"); cb_Remember.Checked = false; } } else { UserDatas = new Dictionary <string, string>(); } fs.Close(); fs.Dispose(); fs = null; } catch (Exception ex) { Debug.Assert(false, ex.Message); } }
private void SystemSettingForm_Load(object sender, EventArgs e) { ConnectString = AES.GetDecryptConnectString(CommonConfigurationManager.GetAppConfig("ConnectString")); cb_db_Type.SelectedIndex = 0; }
private void DataEditPanel_Load(object sender, EventArgs e) { dataGridView1.Visible = false; dataGridView1.DataSourceChanged += (obj, ee) => { foreach (DataGridViewColumn col in dataGridView1.Columns) { if (col.ValueType == typeof(DateTime)) { if (col.HeaderText == "修改时间") { col.DefaultCellStyle.Format = "yyyy/MM/dd HH:mm:ss"; } else { col.DefaultCellStyle.Format = "yyyy/MM/dd"; } } } if (dataGridView1.Columns.Contains("ID")) { dataGridView1.Columns["ID"].Visible = false; } if (dataGridView1.Columns.Contains("ShowDoc")) { dataGridView1.Columns.Remove("ShowDoc"); } DataGridViewTextBoxColumn colDefault = new DataGridViewTextBoxColumn(); colDefault.Name = "ShowDoc"; colDefault.HeaderText = " "; colDefault.DefaultCellStyle.Font = new Font(dataGridView1.Font, FontStyle.Underline); colDefault.DefaultCellStyle.ForeColor = Color.Blue; int colIndex = dataGridView1.Columns.Add(colDefault); dataGridView1.Visible = true; }; dataGridView1.CellFormatting += (obj, ee) => { if (ee.RowIndex < 0) { return; } if (ee.ColumnIndex >= 0 && dataGridView1.Columns[ee.ColumnIndex].Name == "ShowDoc") { dataGridView1.Rows[ee.RowIndex].Cells[ee.ColumnIndex].Value = "浏览"; } }; dataGridView1.CellContentClick += (obj, ee) => { if (ee.ColumnIndex < 0 || ee.RowIndex < 0) { return; } if (dataGridView1.Columns[ee.ColumnIndex].Name == "ShowDoc") { DataWorkingState = WorkingStateEnum.Creating; IFieldTable table = GetFieldTable(dataGridView1.Rows[ee.RowIndex]); ShowDocForm ndf = new ShowDocForm(); if (ndf.CreateFromFieldTable(table, DataWorkingState, false)) { ndf.TableName = table.TableName; if (ndf.ShowDialog() == DialogResult.OK) { DataSource = DBHelper.GetDBHelper().GetDataFromTable(0, 0, TableName, ""); } } this.DataWorkingState = WorkingStateEnum.Search; } }; dataGridView1.CellMouseDoubleClick += (obj, ee) => { if (ee.RowIndex < 0) { return; } if (!RowReportTables.Contains(this.TableName)) { if (CreateFromField(dataGridView1.DataSource as DataTable, dataGridView1.Rows[ee.RowIndex], WorkingStateEnum.View, false)) { return; } } dataGridView1.Rows[ee.RowIndex].Selected = true; IFieldTable table = GetFieldTable(dataGridView1.SelectedRows[0]); CreateFromField(table, dataGridView1.Rows[ee.RowIndex], WorkingStateEnum.View, false); }; tableLayoutPanel1.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel1, true, null); tableLayoutPanel2.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(tableLayoutPanel2, true, null); this.flp_SearchField.GetType().GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).SetValue(flp_SearchField, true, null); #region 读取报表配置文件 string RowReportTableString = Common.CommonConfigurationManager.GetAppConfig("单行报表"); if (RowReportTableString == "") { RowReportTables = new string[] { "安全技术交底表", "安全检查记录表", "安全生产会议记录", "安全生产奖励通知单", "安全教育培训记录表", "安全生产违约处理通知单", "安全隐患整改回复单", "安全隐患整改通知单", "应急救援预案演练记录表", "三级安全教育登记卡", "生产管理制度", "设备安全检查记录表" }; RowReportTableString = string.Join(",", RowReportTables); CommonConfigurationManager.UpdateAppConfig("单行报表", RowReportTableString); } else { RowReportTables = RowReportTableString.Split(','); } string GoalTableString = Common.CommonConfigurationManager.GetAppConfig("评价报表"); if (GoalTableString == "") { GoalTables = new string[] { "施工单位安全生产条件核查表", "施工单位平安工地考核评价表" }; GoalTableString = string.Join(",", GoalTables); CommonConfigurationManager.UpdateAppConfig("评价报表", GoalTableString); } else { GoalTables = GoalTableString.Split(','); } string RegulationTableString = Common.CommonConfigurationManager.GetAppConfig("制度方案报表"); if (RegulationTableString == "") { RegulationTables = new string[] { "生产管理制度", "工程专项施工方案", "临时用电方案" }; RegulationTableString = string.Join(",", RegulationTables); CommonConfigurationManager.UpdateAppConfig("制度方案报表", RegulationTableString); } else { RegulationTables = RegulationTableString.Split(','); } #endregion }