public int Delete(int id)
{
string sqlText = "DELETE FROM `custom_db_config` WHERE `Id` = @Id;";
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
{
Value = id
}
};
return(MySqlDbHelper.ExecuteNonQuery(sqlText, parameters));
}
public int Delete(int jobId, string jobName)
{
string sqlText = "DELETE FROM custom_job_details WHERE JobId = @JobId AND JobName = @JobName;";
MySqlParameter[] parameters =
{
new MySqlParameter("@JobId", MySqlDbType.Int32)
{
Value = jobId
},
new MySqlParameter("@JobName", MySqlDbType.VarChar, 100)
{
Value = jobName
}
};
return(MySqlDbHelper.ExecuteNonQuery(sqlText, parameters));
}
public int Update(CustomJobDetail jobDetail)
{
jobDetail.UpdatedDate = DateTime.Now;
string sqlText = @"UPDATE custom_job_details
SET `JobName` = @JobName,
`JobGroup` = @JobGroup,
`JobChineseName` = @JobChineseName,
`JobServiceURL` = @JobServiceURL,
`CreatedDate` = @CreatedDate,
`UpdatedDate` = @UpdatedDate,
`StartDate` = @StartDate,
`EndDate` = @EndDate,
`PageSize` = @PageSize,
`Interval` = @Interval,
`IntervalType`=@IntervalType,
`State` = @State,
`Description` = @Description,
`ExecutedFreq`=@ExecutedFreq
WHERE `JobId` = @JobId;";
MySqlParameter[] parameters =
{
new MySqlParameter("@JobId", MySqlDbType.Int32)
{
Value = jobDetail.JobId
},
new MySqlParameter("@JobName", MySqlDbType.VarChar, 100)
{
Value = jobDetail.JobName
},
new MySqlParameter("@JobGroup", MySqlDbType.VarChar, 50)
{
Value = jobDetail.JobGroup
},
new MySqlParameter("@JobChineseName", MySqlDbType.VarChar, 100)
{
Value = jobDetail.JobChineseName
},
new MySqlParameter("@JobServiceURL", MySqlDbType.VarChar, 200)
{
Value = jobDetail.JobServiceURL
},
new MySqlParameter("@CreatedDate", MySqlDbType.DateTime)
{
Value = jobDetail.CreatedDate
},
new MySqlParameter("@UpdatedDate", MySqlDbType.DateTime)
{
Value = jobDetail.UpdatedDate
},
new MySqlParameter("@StartDate", MySqlDbType.DateTime)
{
Value = jobDetail.StartDate
},
new MySqlParameter("@EndDate", MySqlDbType.DateTime)
{
Value = jobDetail.EndDate
},
new MySqlParameter("@PageSize", MySqlDbType.Int32)
{
Value = jobDetail.PageSize
},
new MySqlParameter("@Interval", MySqlDbType.Int32)
{
Value = jobDetail.Interval
},
new MySqlParameter("@IntervalType", MySqlDbType.Byte)
{
Value = jobDetail.IntervalType
},
new MySqlParameter("@State", MySqlDbType.Byte)
{
Value = jobDetail.State
},
new MySqlParameter("@Description", MySqlDbType.VarChar, 255)
{
Value = jobDetail.Description
},
new MySqlParameter("@ExecutedFreq", MySqlDbType.Byte)
{
Value = jobDetail.ExecutedFreq
}
};
return(MySqlDbHelper.ExecuteNonQuery(sqlText, parameters));
}
public int Update(SqlServerConfigInfo dbConfigInfo)
{
dbConfigInfo.UpdatedDate = DateTime.Now;
string sqlText = @"UPDATE `custom_db_config`
SET
`ServerAddress` = @ServerAddress,
`DBName` = @DBName,
`UserName` = @UserName,
`Password` = @Password,
`UpdatedDate` = @UpdatedDate,
`CreatedDate` = @CreatedDate,
`EquipmentNum`=@EquipmentNum,
`PageSize`=@PageSize,
`MaxCapacity`=@MaxCapacity,
`StoredType`=@StoredType,
`DBType`=@DBType,
`ServerState`=@ServerState,
`AuthenticatedType`=@AuthenticatedType
WHERE `Id` = @Id;";
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
{
Value = dbConfigInfo.Id
},
new MySqlParameter("@DBName", MySqlDbType.VarChar, 45)
{
Value = dbConfigInfo.DBName
},
new MySqlParameter("@ServerAddress", MySqlDbType.VarChar, 30)
{
Value = dbConfigInfo.ServerAddress
},
new MySqlParameter("@UserName", MySqlDbType.VarChar, 45)
{
Value = dbConfigInfo.UserName
},
new MySqlParameter("@Password", MySqlDbType.VarChar, 45)
{
Value = dbConfigInfo.Password
},
new MySqlParameter("@UpdatedDate", MySqlDbType.DateTime)
{
Value = dbConfigInfo.UpdatedDate
},
new MySqlParameter("@CreatedDate", MySqlDbType.DateTime)
{
Value = dbConfigInfo.CreatedDate
},
new MySqlParameter("@EquipmentNum", MySqlDbType.VarChar, 25)
{
Value = dbConfigInfo.EquipmentNum
},
new MySqlParameter("@PageSize", MySqlDbType.Int32)
{
Value = dbConfigInfo.PageSize
},
new MySqlParameter("@MaxCapacity", MySqlDbType.Int32)
{
Value = dbConfigInfo.MaxCapacity
},
new MySqlParameter("@StoredType", MySqlDbType.Byte)
{
Value = dbConfigInfo.StoredType
},
new MySqlParameter("@DBType", MySqlDbType.Byte)
{
Value = dbConfigInfo.DBType
},
new MySqlParameter("@ServerState", MySqlDbType.Byte)
{
Value = dbConfigInfo.ServerState
},
new MySqlParameter("@AuthenticatedType", MySqlDbType.Byte)
{
Value = dbConfigInfo.AuthenticatedType
}
};
return(MySqlDbHelper.ExecuteNonQuery(sqlText, parameters));
}