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