/// <summary> /// 增加一条数据 /// </summary> internal static int Create(ComponentConfiguration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ComponentConfiguration("); strSql.Append("CreateBy,ModifyTime,ModifyBy,IsDelete,ComponentId,IsDebug,Environment,Content,Enable,Signature,Version,CreateTime"); strSql.Append(") values ("); strSql.Append("@CreateBy,@ModifyTime,@ModifyBy,@IsDelete,@ComponentId,@IsDebug,@Environment,@Content,@Enable,@Signature,@Version,@CreateTime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); List<DbParameter> parameters = new List<DbParameter>(); parameters.Add(new MdsDbParameter("@CreateBy", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@ModifyTime", DbType.DateTime)); parameters.Add(new MdsDbParameter("@ModifyBy", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@ComponentId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsDebug", DbType.Boolean)); parameters.Add(new MdsDbParameter("@Environment", DbType.Int32, 10)); parameters.Add(new MdsDbParameter("@Content", DbType.String)); parameters.Add(new MdsDbParameter("@Enable", DbType.Boolean)); parameters.Add(new MdsDbParameter("@Signature", DbType.String, 300)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters[0].Value = model.CreateBy; parameters[1].Value =DateTime.Now; parameters[2].Value = model.CreateBy; parameters[3].Value = false; parameters[4].Value = model.ComponentId; parameters[5].Value = false; parameters[6].Value = model.Environment; parameters[7].Value = model.Content; parameters[8].Value = model.Enable; parameters[9].Value = model.Signature; parameters[10].Value = 1; parameters[11].Value = DateTime.Now; return _dalService.GetPrimarykey(parameters, strSql.ToString()); }
static ConfigHelper() { _configService = ConfigClientFactory.Instance.GetConfigClient(); _compoentConfig = _configService.GetComponentConfig(DefineTable.ComponentID);//不进行null检查保证配置初始化出现问题时爆出异常 _config = XmlConfigSerializer.Instance.FromXml<ServiceFactoryServerConfig>(_compoentConfig.Content);//不进行null检查保证配置初始化出现问题时爆出异常 }
/// <summary> /// 更新一条数据 /// </summary> internal static int Edit(ComponentConfiguration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ComponentConfiguration set "); strSql.Append(" CreateBy = @CreateBy , "); strSql.Append(" ModifyTime = @ModifyTime , "); strSql.Append(" ModifyBy = @ModifyBy , "); strSql.Append(" IsDelete = @IsDelete , "); strSql.Append(" ComponentId = @ComponentId , "); strSql.Append(" IsDebug = @IsDebug , "); strSql.Append(" Environment = @Environment , "); strSql.Append(" Content = @Content , "); strSql.Append(" Enable = @Enable , "); strSql.Append(" Signature = @Signature , "); strSql.Append(" Version = @Version , "); strSql.Append(" CreateTime = @CreateTime "); strSql.Append(" where ComponentConfigId=@ComponentConfigId "); List<DbParameter> parameters = new List<DbParameter>(); parameters.Add(new MdsDbParameter("@ComponentConfigId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@CreateBy", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@ModifyTime", DbType.DateTime)); parameters.Add(new MdsDbParameter("@ModifyBy", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@ComponentId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsDebug", DbType.Boolean)); parameters.Add(new MdsDbParameter("@Environment", DbType.Int32, 10)); parameters.Add(new MdsDbParameter("@Content", DbType.String)); parameters.Add(new MdsDbParameter("@Enable", DbType.Boolean)); parameters.Add(new MdsDbParameter("@Signature", DbType.String, 300)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters[0].Value = model.ComponentConfigId; parameters[1].Value = model.CreateBy; parameters[2].Value = model.ModifyTime; parameters[3].Value = model.ModifyBy; parameters[4].Value = model.IsDelete; parameters[5].Value = model.ComponentId; parameters[6].Value = model.IsDebug; parameters[7].Value = model.Environment; parameters[8].Value = model.Content; parameters[9].Value = model.Enable; parameters[10].Value = model.Signature; parameters[11].Value = model.Version; parameters[12].Value = model.CreateTime; return _dalService.ExecuteNonQuery(parameters, strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> internal static ComponentConfiguration Get(int ComponentConfigId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ComponentConfigId, CreateBy, ModifyTime, ModifyBy, IsDelete, ComponentId, IsDebug, Environment, Content, Enable, Signature, Version, CreateTime "); strSql.Append(" from ComponentConfiguration "); strSql.Append(" where ComponentConfigId=@ComponentConfigId"); List<DbParameter> parameters = new List<DbParameter>(); ComponentConfiguration r = new ComponentConfiguration(); r = _dalService.GetDataByReader<ComponentConfiguration>(parameters, strSql.ToString(), delegate (DbDataReader dr) { r = null; if (dr.Read()) { r = new ComponentConfiguration() { ComponentConfigId = int.Parse(dr["ComponentConfigId"].ToString()), CreateBy = int.Parse(dr["CreateBy"].ToString()), ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString()), ModifyBy = int.Parse(dr["ModifyBy"].ToString()), IsDelete = Boolean.Parse(dr["IsDelete"].ToString()), ComponentId = int.Parse(dr["ComponentId"].ToString()), IsDebug = Boolean.Parse(dr["IsDebug"].ToString()), Environment = int.Parse(dr["Environment"].ToString()), Content = dr["Content"].ToString(), Enable = Boolean.Parse(dr["Enable"].ToString()), Signature = dr["Signature"].ToString(), Version = int.Parse(dr["Version"].ToString()), CreateTime = DateTime.Parse(dr["CreateTime"].ToString()), }; } return r; }); return r; }