private void SaveBtn_Click(object sender, EventArgs e) { try { CodeProjectDbConfigInfo saveItem = FormHelp.GetEntityByControls <CodeProjectDbConfigInfo>(this.panel1); saveItem.ID = codeProjectDbConfigInfo.ID; saveItem.ProjectId = codeProjectInfo.ID; VerifyMessage verifyMessage = VerifyUtil.Verify(saveItem); if (verifyMessage.ExistError) { MessageBox.Show(verifyMessage.ErrorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } R r = codeProjectDbConfigInfoBLL.SaveOrUpdate(saveItem, null, false, null); if (r.Successful) { string msg = saveItem.ID <= 0 ? "新增" : "修改"; MessageBox.Show($"{msg}成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); } else { MessageBox.Show(r.ResultHint, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <TableFieldInfo> SelectTableFields(CodeProjectDbConfigInfo codeProjectDbConfigInfo, string tableName) { if (codeProjectDbConfigInfo.DbType == "Mysql") { return(DbAdapter.SelectTableFieldsByMySql(codeProjectDbConfigInfo.DbConnect, codeProjectDbConfigInfo.DbName, tableName)); } else if (codeProjectDbConfigInfo.DbType == "Oracle") { return(DbAdapter.SelectTableFieldsByOracle(codeProjectDbConfigInfo.DbConnect, codeProjectDbConfigInfo.DbName, tableName)); } else if (codeProjectDbConfigInfo.DbType == "Sqlite") { return(DbAdapter.SelectTableFieldsBySqlite(codeProjectDbConfigInfo.DbConnect, codeProjectDbConfigInfo.DbName, tableName)); } return(null); }
private void LoadData() { try { codeProjectDbConfigInfo.ProjectId = codeProjectInfo.ID; List <CodeProjectDbConfigInfo> lists = codeProjectDbConfigInfoBLL.SelectList(codeProjectDbConfigInfo, null, "ProjectId", WhereType.Columns); if (lists != null && lists.Count > 0) { codeProjectDbConfigInfo = lists[0]; } //CacheHelper.RemoveCacheByKey(CacheConstant.DBCONFIG); //缓存7天 CacheHelper.SetCache(CacheConstant.DBCONFIG, codeProjectDbConfigInfo, 60 * 60 * 24 * 7); FormHelp.SetControlsByEntity(codeProjectDbConfigInfo, this.panel1); } catch (Exception ex) { MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadData() { try { object obj = CacheHelper.GetCache(CacheConstant.DBCONFIG); if (obj != null) { codeProjectDbConfigInfo = (CodeProjectDbConfigInfo)obj; } if (codeProjectDbConfigInfo.DbType == "Sqlite") { SetPannelTablesBySqlite(); } else { SetPannelTables(keyWord.Text); } } catch (Exception ex) { MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }