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