public static bool writeDefaultDBInfo(JavaCodeGenConfig config)
{
bool status = false;
try
{
string deleteSql = "delete from db_plugin_Java_defaultConfig";
int result = db.ExecuteNonQuery(deleteSql);
status = true;
if (config != null)
{
status = false;
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@DisplayName", config.DisplayName);
string insertSql = "insert into db_plugin_Java_defaultConfig(DisplayName) values(@DisplayName)";
result = db.ExecuteNonQuery(insertSql, dic);
status = true;
}
}
catch (Exception e)
{
LogHelper.Error(e.Message);
}
return(status);
}
public static IList <JavaCodeGenConfig> ReadDBInfo()
{
IList <JavaCodeGenConfig> configList = new List <JavaCodeGenConfig>();
try
{
var dataSet = new DataSet();
db.Fill("select * from db_plugin_Java_config", dataSet);
foreach (DataRow row in dataSet.Tables[0].Rows)
{
JavaCodeGenConfig config = new JavaCodeGenConfig();
config.BSPackage = row["BSPackage"] + "";
config.CodeRule = row["CodeRule"] + "";
config.DisplayName = row["DisplayName"] + "";
config.Ibatis = row["Ibatis"] + "";
config.Id = row["Id"] + "";
config.IsShowGenCode = bool.Parse(row["IsShowGenCode"] + "");
config.OutPut = row["OutPut"] + "";
config.TableFilter = row["TableFilter"] + "";
config.WSPackage = row["WSPackage"] + "";
configList.Add(config);
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(configList);
}
public static JavaCodeGenConfig getDefaultObject()
{
JavaCodeGenConfig config = new JavaCodeGenConfig();
string str = ReadDefaultDBInfo();
IList <JavaCodeGenConfig> configList = ReadDBInfo();
if (string.IsNullOrEmpty(str))
{
config.BSPackage = "";
config.CodeRule = "";
config.DisplayName = "";
config.Ibatis = "";
config.Id = "";
config.IsDelete = false;
config.IsShowGenCode = true;
config.OutPut = "";
config.TableFilter = "";
config.WSPackage = "";
return(config);
}
else
{
foreach (JavaCodeGenConfig tem in configList)
{
if (!string.IsNullOrEmpty(tem.DisplayName))
{
if (str.Equals(tem.DisplayName))
{
config = tem;
}
}
}
}
return(config);
}
private void setUI(JavaCodeGenConfig cmc)
{
if (this.InvokeRequired)
{
this.Invoke(new delegateObject(setUI), new object[] { cmc });
}
else
{
setCbText(cmc.DisplayName);
tbBSPackage.Text = cmc.BSPackage;
tbWSPackage.Text = cmc.WSPackage;
tbOutPut.Text = cmc.OutPut;
tbTableFilter.Text = cmc.TableFilter;
cbShowForm.Checked = cmc.IsShowGenCode;
if (rbtnDefault.Text == cmc.CodeRule)
{
rbtnDefault.Checked = true;
}
else
{
rbtnIbatis.Checked = true;
}
tbIbatis.Text = cmc.Ibatis;
}
}
private void init()
{
isInit = true;
clear();
javaCodeGenConfigs.Clear();
clearCbUI();
addItem("");
JavaCodeGenConfig config = IniConfigHelper.getDefaultObject();
if (config != null)
{
setUI(config);
setCbText(config.DisplayName);
}
IList <JavaCodeGenConfig> configs = IniConfigHelper.ReadDBInfo();
foreach (JavaCodeGenConfig jcc in configs)
{
if (!javaCodeGenConfigs.ContainsKey(jcc.DisplayName))
{
javaCodeGenConfigs.Add(jcc.DisplayName, jcc);
addItem(jcc.DisplayName);
}
}
isInit = false;
}
public static bool WriteDBInfo(JavaCodeGenConfig config, ref string message)
{
bool status = false;
if (config != null)
{
try
{
var dic = new Dictionary <string, string>();
string sql = "";
if (config.IsDelete)
{
sql = "delete from db_plugin_Java_config where Id = @Id";
dic.Add("@Id", config.Id);
}
else
{
dic.Add("@BSPackage", config.BSPackage);
dic.Add("@CodeRule", config.CodeRule);
dic.Add("@DisplayName", config.DisplayName);
dic.Add("@Ibatis", config.Ibatis);
dic.Add("@IsShowGenCode", config.IsShowGenCode.ToString());
dic.Add("@OutPut", config.OutPut);
dic.Add("@TableFilter", config.TableFilter);
dic.Add("@WSPackage", config.WSPackage);
if (string.IsNullOrEmpty(config.Id))
{
dic.Add("@Id", Guid.NewGuid().ToString());
sql = "insert into db_plugin_Java_config(BSPackage, CodeRule, DisplayName, Ibatis, Id, IsShowGenCode, OutPut, TableFilter, WSPackage)"
+ " values(@BSPackage, @CodeRule, @DisplayName, @Ibatis, @Id, @IsShowGenCode, @OutPut, @TableFilter, @WSPackage)";
}
else
{
dic.Add("@Id", config.Id);
sql = "update db_plugin_Java_config set BSPackage=@BSPackage, CodeRule=@CodeRule, DisplayName=@DisplayName, Ibatis=@Ibatis, Id=@Id, IsShowGenCode=@IsShowGenCode, OutPut=@OutPut"
+ ", TableFilter=@TableFilter, WSPackage=@WSPackage where Id=@Id";
}
}
db.ExecuteNonQuery(sql, dic);
status = true;
}
catch (Exception ex)
{
LogHelper.Error(ex);
message = ex.Message;
}
}
return(status);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (checkData())
{
JavaCodeGenConfig config = getConfigObject();
if (javaCodeGenConfigs.ContainsKey(cbObject.Text))
{
string id = javaCodeGenConfigs[cbObject.Text].Id;
config.Id = id;
javaCodeGenConfigs[cbObject.Text] = null;
javaCodeGenConfigs[cbObject.Text] = config;
}
else if (!string.IsNullOrEmpty(cbObject.Text))
{
javaCodeGenConfigs.Add(cbObject.Text, config);
addItem(cbObject.Text);
}
}
}
private JavaCodeGenConfig getConfigObject()
{
JavaCodeGenConfig cmc = new JavaCodeGenConfig();
cmc.Id = "";
cmc.IsDelete = false;
cmc.DisplayName = cbObject.Text;
cmc.BSPackage = tbBSPackage.Text;
cmc.WSPackage = tbWSPackage.Text;
cmc.OutPut = tbOutPut.Text;
cmc.TableFilter = tbTableFilter.Text;
cmc.IsShowGenCode = cbShowForm.Checked;
if (rbtnDefault.Checked)
{
cmc.CodeRule = rbtnDefault.Text;
}
else
{
cmc.CodeRule = rbtnIbatis.Text;
}
cmc.Ibatis = tbIbatis.Text;
return(cmc);
}
public void Save()
{
bool status = false;
string msg = "";
JavaCodeGenConfig temp = getConfigObject();
status = IniConfigHelper.writeDefaultDBInfo(temp);
if (!status)
{
throw new Exception(msg);
}
else
{
status = false;
msg = "";
}
if (javaCodeGenConfigs.Count > 0)
{
if (javaCodeGenConfigs.ContainsKey(cbObject.Text))
{
string id = javaCodeGenConfigs[cbObject.Text].Id;
bool isDelete = javaCodeGenConfigs[cbObject.Text].IsDelete;
javaCodeGenConfigs[cbObject.Text] = null;
temp.Id = id;
temp.IsDelete = isDelete;
javaCodeGenConfigs[cbObject.Text] = temp;
}
else if (!string.IsNullOrEmpty(cbObject.Text))
{
javaCodeGenConfigs.Add(cbObject.Text, temp);
addItem(cbObject.Text);
}
foreach (string key in javaCodeGenConfigs.Keys)
{
status = IniConfigHelper.WriteDBInfo(javaCodeGenConfigs[key], ref msg);
if (!status)
{
throw new Exception(msg);
}
else
{
status = false;
msg = "";
}
}
}
else
{
if (!string.IsNullOrEmpty(temp.DisplayName))
{
status = IniConfigHelper.WriteDBInfo(temp, ref msg);
if (!status)
{
throw new Exception(msg);
}
else
{
javaCodeGenConfigs.Add(temp.DisplayName, temp);
addItem(temp.DisplayName);
}
}
}
}
