public static bool writeDefaultDBInfo(CsharpCodeGenConfig config) { bool status = false; try { string deleteSql = "delete from db_plugin_Csharp_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_Csharp_defaultConfig(DisplayName) values(@DisplayName)"; result = db.ExecuteNonQuery(insertSql, dic); status = true; } } catch (Exception e) { LogHelper.Error(e.Message); } return(status); }
public CsharpCodeGenConfig getConfigObject() { CsharpCodeGenConfig cmc = new CsharpCodeGenConfig(); cmc.Id = ""; cmc.DisplayName = cbObject.Text; cmc.ModelNameSpace = tbModelNameSpace.Text; cmc.IDALNameSpace = tbIDALNameSpace.Text; cmc.DALNameSpace = tbDALNameSpace.Text; cmc.DALDllName = tbDALDLLName.Text; cmc.BLLDllName = tbBLLDLLName.Text; cmc.BLLNameSpace = tbBLLNameSpace.Text; cmc.DisplayName = cbObject.Text; cmc.IsDelete = false; cmc.PluginName = tbPluginName.Text; cmc.OutPut = tbOutPut.Text; cmc.TableFilter = tbTableFilter.Text; cmc.IsShowGenCode = cbShowForm.Checked; cmc.IsShowComment = cbShowComment.Checked; if (rbtnDefault.Checked) { cmc.CodeRule = rbtnDefault.Text; } else { cmc.CodeRule = rbtnIbatis.Text; } cmc.Ibatis = tbIbatis.Text; return(cmc); }
public static bool WriteDBInfo(CsharpCodeGenConfig 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_Csharp_config where Id = @Id"; dic.Add("@Id", config.Id); } else { dic.Add("@ModelNameSpace", config.ModelNameSpace); dic.Add("@DALNameSpace", config.DALNameSpace); dic.Add("@IDALNameSpace", config.IDALNameSpace); dic.Add("@BLLNameSpace", config.BLLNameSpace); dic.Add("@PluginName", config.PluginName); dic.Add("@OutPut", config.OutPut); dic.Add("@TableFilter", config.TableFilter); dic.Add("@IsShowGenCode", config.IsShowGenCode.ToString()); dic.Add("@IsShowComment", config.IsShowComment.ToString()); dic.Add("@CodeRule", config.CodeRule); dic.Add("@Ibatis", config.Ibatis); dic.Add("@DALDLLName", config.DALDllName); dic.Add("@BLLDLLName", config.BLLDllName); dic.Add("@DisplayName", config.DisplayName); if (string.IsNullOrEmpty(config.Id)) { dic.Add("@Id", Guid.NewGuid().ToString()); sql = "insert into db_plugin_Csharp_config(Id, ModelNameSpace, DALNameSpace, IDALNameSpace, BLLNameSpace, PluginName, OutPut, TableFilter" + ", IsShowGenCode, IsShowComment, CodeRule, Ibatis, DALDLLName, BLLDLLName, DisplayName) values(@Id, @ModelNameSpace, @DALNameSpace, @IDALNameSpace, @BLLNameSpace, @PluginName, @OutPut, @TableFilter" + ", @IsShowGenCode, @IsShowComment, @CodeRule, @Ibatis, @DALDLLName, @BLLDLLName, @DisplayName)"; } else { dic.Add("@Id", config.Id); sql = "update db_plugin_Csharp_config set ModelNameSpace=@ModelNameSpace, DALNameSpace=@DALNameSpace, IDALNameSpace=@IDALNameSpace, BLLNameSpace=@BLLNameSpace, PluginName=@PluginName, OutPut=@OutPut, TableFilter=@TableFilter" + ", IsShowGenCode=@IsShowGenCode, IsShowComment=@IsShowComment, CodeRule=@CodeRule, Ibatis=@Ibatis, DALDLLName=@DALDLLName, BLLDLLName=@BLLDLLName, DisplayName=@DisplayName where Id=@Id"; } } db.ExecuteNonQuery(sql, dic); status = true; } catch (Exception ex) { LogHelper.Error(ex); message = ex.Message; } } return(status); }
public void Save() { bool status = false; string msg = ""; CsharpCodeGenConfig tem = getConfigObject(); IniConfigHelper.writeDefaultDBInfo(tem); if (CsharpCodeGenConfig.Count > 0) { if (CsharpCodeGenConfig.ContainsKey(cbObject.Text)) { string id = CsharpCodeGenConfig[cbObject.Text].Id; bool isDelete = CsharpCodeGenConfig[cbObject.Text].IsDelete; CsharpCodeGenConfig[cbObject.Text] = null; CsharpCodeGenConfig[cbObject.Text] = tem; CsharpCodeGenConfig[cbObject.Text].Id = id; CsharpCodeGenConfig[cbObject.Text].IsDelete = isDelete; } else if (!string.IsNullOrEmpty(cbObject.Text)) { CsharpCodeGenConfig.Add(cbObject.Text, tem); addItem(cbObject.Text); } foreach (string key in CsharpCodeGenConfig.Keys) { status = IniConfigHelper.WriteDBInfo(CsharpCodeGenConfig[key], ref msg); if (!status) { throw new Exception(msg); } else { status = false; msg = ""; } } } else { if (!string.IsNullOrEmpty(tem.DisplayName)) { status = IniConfigHelper.WriteDBInfo(tem, ref msg); if (!status) { throw new Exception(msg); } else { CsharpCodeGenConfig.Add(tem.DisplayName, tem); addItem(tem.DisplayName); } } } }
private void btnAdd_Click(object sender, EventArgs e) { if (checkData()) { CsharpCodeGenConfig tem = getConfigObject(); if (CsharpCodeGenConfig.ContainsKey(cbObject.Text)) { string id = CsharpCodeGenConfig[cbObject.Text].Id; CsharpCodeGenConfig[cbObject.Text] = null; CsharpCodeGenConfig[cbObject.Text] = tem; CsharpCodeGenConfig[cbObject.Text].Id = id; } else if (!string.IsNullOrEmpty(cbObject.Text)) { CsharpCodeGenConfig.Add(cbObject.Text, tem); addItem(tem.DisplayName); } } }
public static CsharpCodeGenConfig getDefaultObject() { CsharpCodeGenConfig config = new CsharpCodeGenConfig(); string str = ReadDefaultDBInfo(); IList <CsharpCodeGenConfig> configList = ReadDBInfo(); if (string.IsNullOrEmpty(str)) { config.BLLDllName = ""; config.BLLNameSpace = ""; config.CodeRule = ""; config.DALDllName = ""; config.DALNameSpace = ""; config.DisplayName = ""; config.Ibatis = ""; config.Id = ""; config.IDALNameSpace = ""; config.IsDelete = false; config.IsShowComment = false; config.IsShowGenCode = true; config.ModelNameSpace = ""; config.OutPut = ""; config.PluginName = ""; config.TableFilter = ""; return(config); } else { foreach (CsharpCodeGenConfig tem in configList) { if (!string.IsNullOrEmpty(tem.DisplayName)) { if (str.Equals(tem.DisplayName)) { config = tem; } } } } return(config); }
private void setUI(CsharpCodeGenConfig config) { if (this.InvokeRequired) { this.Invoke(new delegateObject(setUI), new object[] { config }); } else { tbModelNameSpace.Text = config.ModelNameSpace; //cbObject.Text = config.DisplayName; tbIDALNameSpace.Text = config.IDALNameSpace; tbDALNameSpace.Text = config.DALNameSpace; tbDALDLLName.Text = config.DALDllName; tbBLLDLLName.Text = config.BLLDllName; cbObject.Text = config.DisplayName; tbBLLNameSpace.Text = config.BLLNameSpace; tbPluginName.Text = config.PluginName; tbOutPut.Text = config.OutPut; tbTableFilter.Text = config.TableFilter; cbShowForm.Checked = config.IsShowGenCode; cbShowComment.Checked = config.IsShowComment; if (rbtnDefault.Text == config.CodeRule) { rbtnDefault.Checked = true; } else { rbtnIbatis.Checked = true; } tbIbatis.Text = config.Ibatis; } }
public static IList <CsharpCodeGenConfig> ReadDBInfo() { IList <CsharpCodeGenConfig> configList = new List <CsharpCodeGenConfig>(); try { var dataSet = new DataSet(); db.Fill("select * from db_plugin_Csharp_config", dataSet); foreach (DataRow row in dataSet.Tables[0].Rows) { CsharpCodeGenConfig config = new CsharpCodeGenConfig(); config.BLLDllName = row["BLLDllName"] + ""; config.BLLNameSpace = row["BLLNameSpace"] + ""; config.CodeRule = row["CodeRule"] + ""; config.DALDllName = row["DALDllName"] + ""; config.DALNameSpace = row["DALNameSpace"] + ""; config.DisplayName = row["DisplayName"] + ""; config.Ibatis = row["Ibatis"] + ""; config.IDALNameSpace = row["IDALNameSpace"] + ""; config.IsShowComment = bool.Parse(row["IsShowComment"] + ""); config.IsShowGenCode = bool.Parse(row["IsShowGenCode"] + ""); config.ModelNameSpace = row["ModelNameSpace"] + ""; config.OutPut = row["OutPut"] + ""; config.PluginName = row["PluginName"] + ""; config.TableFilter = row["TableFilter"] + ""; config.Id = row["Id"] + ""; configList.Add(config); } } catch (Exception ex) { LogHelper.Error(ex); } return(configList); }