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