/// <summary> /// 增加一条数据 /// </summary> internal static int Create(Solution_Component_Relation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Solution_Component_Relation("); strSql.Append("SolutionId,ComponentConfigId,Version,IsActive,IsDelete,CreateTime,CreateBy"); strSql.Append(") values ("); strSql.Append("@SolutionId,@ComponentConfigId,@Version,@IsActive,@IsDelete,@CreateTime,@CreateBy"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); List<DbParameter> parameters = new List<DbParameter>(); parameters.Add(new MdsDbParameter("@SolutionId", DbType.String, 64)); parameters.Add(new MdsDbParameter("@ComponentConfigId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsActive", DbType.Boolean)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters.Add(new MdsDbParameter("@CreateBy", DbType.Int32, 11)); parameters[0].Value = model.SolutionId; parameters[1].Value = model.ComponentConfigId; parameters[2].Value = model.Version; parameters[3].Value = model.IsActive; parameters[4].Value = model.IsDelete; parameters[5].Value =DateTime.Now; parameters[6].Value = model.CreateBy; return _dalService.GetPrimarykey(parameters, strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> internal static int Edit(Solution_Component_Relation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Solution_Component_Relation set "); strSql.Append(" SolutionId = @SolutionId , "); strSql.Append(" ComponentConfigId = @ComponentConfigId , "); strSql.Append(" Version = @Version , "); strSql.Append(" IsActive = @IsActive , "); strSql.Append(" IsDelete = @IsDelete , "); strSql.Append(" CreateTime = @CreateTime "); strSql.Append(" where ID=@ID "); List<DbParameter> parameters = new List<DbParameter>(); parameters.Add(new MdsDbParameter("@ID", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@SolutionId", DbType.String, 64)); parameters.Add(new MdsDbParameter("@ComponentConfigId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsActive", DbType.Boolean)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters[0].Value = model.ID; parameters[1].Value = model.SolutionId; parameters[2].Value = model.ComponentConfigId; parameters[3].Value = model.Version; parameters[4].Value = model.IsActive; parameters[5].Value = model.IsDelete; parameters[6].Value = model.CreateTime; return _dalService.ExecuteNonQuery(parameters, strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> internal static int Edit(Solution_Component_Relation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Solution_Component_Relation set "); strSql.Append(" SolutionId = @SolutionId , "); strSql.Append(" ComponentConfigId = @ComponentConfigId , "); strSql.Append(" Version = @Version , "); strSql.Append(" IsActive = @IsActive , "); strSql.Append(" IsDelete = @IsDelete , "); strSql.Append(" CreateTime = @CreateTime "); strSql.Append(" where ID=@ID "); List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(new MdsDbParameter("@ID", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@SolutionId", DbType.String, 64)); parameters.Add(new MdsDbParameter("@ComponentConfigId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsActive", DbType.Boolean)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters[0].Value = model.ID; parameters[1].Value = model.SolutionId; parameters[2].Value = model.ComponentConfigId; parameters[3].Value = model.Version; parameters[4].Value = model.IsActive; parameters[5].Value = model.IsDelete; parameters[6].Value = model.CreateTime; return(_dalService.ExecuteNonQuery(parameters, strSql.ToString())); }
/// <summary> /// 增加一条数据 /// </summary> internal static int Create(Solution_Component_Relation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Solution_Component_Relation("); strSql.Append("SolutionId,ComponentConfigId,Version,IsActive,IsDelete,CreateTime,CreateBy"); strSql.Append(") values ("); strSql.Append("@SolutionId,@ComponentConfigId,@Version,@IsActive,@IsDelete,@CreateTime,@CreateBy"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(new MdsDbParameter("@SolutionId", DbType.String, 64)); parameters.Add(new MdsDbParameter("@ComponentConfigId", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@Version", DbType.Int32, 11)); parameters.Add(new MdsDbParameter("@IsActive", DbType.Boolean)); parameters.Add(new MdsDbParameter("@IsDelete", DbType.Boolean)); parameters.Add(new MdsDbParameter("@CreateTime", DbType.DateTime)); parameters.Add(new MdsDbParameter("@CreateBy", DbType.Int32, 11)); parameters[0].Value = model.SolutionId; parameters[1].Value = model.ComponentConfigId; parameters[2].Value = model.Version; parameters[3].Value = model.IsActive; parameters[4].Value = model.IsDelete; parameters[5].Value = DateTime.Now; parameters[6].Value = model.CreateBy; return(_dalService.GetPrimarykey(parameters, strSql.ToString())); }
public BaseModel.OperationResult <int> AddComponentConfigForSolution(Solution_Component_Relation info) { return(FunctionResultProxy.GetResult <OperationResult <int> >(delegate(OperationResult <int> r) { r.Data = SolutionComponentRelationDal.Create(info); r.ActionResult = (r.Data > 0); return r; })); }
public BaseModel.OperationResult<int> AddComponentConfigForSolution(Solution_Component_Relation info) { return FunctionResultProxy.GetResult<OperationResult<int>>(delegate (OperationResult<int> r) { r.Data = SolutionComponentRelationDal.Create(info); r.ActionResult = (r.Data > 0); return r; }); }
/// <summary> /// 得到一个对象实体 /// </summary> internal static Solution_Component_Relation Get(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, SolutionId, ComponentConfigId, Version, IsActive, IsDelete, CreateTime "); strSql.Append(" from Solution_Component_Relation "); strSql.Append(" where ID=@ID"); List <DbParameter> parameters = new List <DbParameter>(); Solution_Component_Relation r = new Solution_Component_Relation(); r = _dalService.GetDataByReader <Solution_Component_Relation>(parameters, strSql.ToString(), delegate(DbDataReader dr) { r = null; if (dr.Read()) { r = new Solution_Component_Relation() { ID = int.Parse(dr["ID"].ToString()), SolutionId = dr["SolutionId"].ToString(), ComponentConfigId = int.Parse(dr["ComponentConfigId"].ToString()), Version = int.Parse(dr["Version"].ToString()), IsActive = Boolean.Parse(dr["IsActive"].ToString()), IsDelete = Boolean.Parse(dr["IsDelete"].ToString()), CreateTime = DateTime.Parse(dr["CreateTime"].ToString()), }; } return(r); }); return(r); }
/// <summary> /// 得到一个对象实体 /// </summary> internal static Solution_Component_Relation Get(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, SolutionId, ComponentConfigId, Version, IsActive, IsDelete, CreateTime "); strSql.Append(" from Solution_Component_Relation "); strSql.Append(" where ID=@ID"); List<DbParameter> parameters = new List<DbParameter>(); Solution_Component_Relation r = new Solution_Component_Relation(); r = _dalService.GetDataByReader<Solution_Component_Relation>(parameters, strSql.ToString(), delegate (DbDataReader dr) { r = null; if (dr.Read()) { r = new Solution_Component_Relation() { ID = int.Parse(dr["ID"].ToString()), SolutionId = dr["SolutionId"].ToString(), ComponentConfigId = int.Parse(dr["ComponentConfigId"].ToString()), Version = int.Parse(dr["Version"].ToString()), IsActive = Boolean.Parse(dr["IsActive"].ToString()), IsDelete = Boolean.Parse(dr["IsDelete"].ToString()), CreateTime = DateTime.Parse(dr["CreateTime"].ToString()), }; } return r; }); return r; }